SELECT u.Id, u.DisplayName as [User Link], COUNT(u.Id) FR...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

SELECT  
u.Id,  
u.DisplayName as [User Link], 
COUNT(u.Id)
FROM  Posts AS p  
JOIN Users AS U  
ON p.OwnerUserId = u.Id
WHERE  p.PostTypeId = 2 
AND  (p.Body LIKE '%http:%' OR p.Body LIKE '%Google%') 
AND  u.Reputation = 1
GROUP BY  u.Id,  u.DisplayName
HAVING  COUNT(u.Id) > 2
ORDER BY  u.DisplayName ASC

Enter Parameters

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