SELECT COUNT(*) Posts FROM Posts p WHERE p.OwnerUserId IN (

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(*) Posts FROM Posts p
WHERE p.OwnerUserId IN (
  SELECT Id FROM Users
  WHERE Location LIKE '%Iraq%'
  OR Location LIKE '%Syria%'
  OR Location LIKE '%Iran%'
  OR Location LIKE '%Libya%'
  OR Location LIKE '%Somalia%'
  OR Location LIKE '%Sudan%'
  OR Location LIKE '%Yemen%'
)

Enter Parameters

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