SELECT P.Body, P.Id AS [Post Link], P.Score FROM Posts P ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity Meta

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

SELECT P.Body, P.Id AS [Post Link], P.Score
FROM Posts P 
WHERE (
   P.PostTypeId = 2 AND
   len(P.Body) <= 250 AND 
   lower(P.Body) like '%http%' and
   (
   lower(P.Body) like '%find this link%' or 
   lower(P.Body) like '%this link may%' or
   lower(P.Body) like '%check%this link%' or 
   lower(P.Body) like '%refer this link%' or
   lower(P.Body) like '%the following link %' 
      
   
   ))
   
   ORDER BY len(P.Body) ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results