SELECT COUNT(*) FROM Users u, PostsWithDeleted p--, PostT...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(*)
--  p.Id,
--  CONCAT('https://stackoverflow.com/q/',p.Id) AS 'post link',
--  u.Id,
--  u.DisplayName,
--  CONCAT('https://stackoverflow.com/users/',u.Id) AS 'user link',
--  p.CreationDate
FROM Users u, PostsWithDeleted p--, PostTags pt
LEFT JOIN Posts pn ON p.Id=pn.Id
WHERE
  pn.Id IS NULL AND
  p.OwnerUserId=u.Id
  --AND p.Tags LIKE '%javascript%'
  --AND pt.PostId=p.Id
  --AND pt.TagId=3 -- JS
  AND (u.Location LIKE '%Lovely Professional University%'
  OR u.Location LIKE '%LPU%'
  OR u.AboutMe LIKE '%Lovely Professional University%'
  OR u.AboutMe LIKE '%LPU%')

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results