0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT 
P.Id,P.Tags, P.CreationDate,U.Location, P.Body

 
FROM Posts as P
JOIN 
Users as U ON P.OwnerUserId =U.Id

WHERE
P.PostTypeId=1 AND P.Tags LIKE '%python%' AND P.CreationDate
BETWEEN'04-01-2017' and '04-01-2018'
AND
(U.Location LIKE '%India%' 
OR U.Location LIKE '%Israel%'
OR U.Location LIKE '%Singapore%'
OR U.Location LIKE '%Japan%'
OR U.Location LIKE '%Hong Kong%'
OR U.Location LIKE '%Egypt%'
OR U.Location LIKE '%Pakistan%'
OR U.Location LIKE '%Taiwan%'
OR U.Location LIKE '%Iran%'
OR U.Location LIKE '%Korea%'
OR U.Location LIKE '%Turkey%')
UNION 
SELECT 
P.Id,P.Tags, P.CreationDate,U.Location, P.Body

FROM Posts as P
JOIN 
Users as U ON P.OwnerUserId =U.Id

WHERE P.ParentId
IN (
SELECT 
P.Id
 
FROM Posts as P
JOIN 
Users as U ON P.OwnerUserId =U.Id

WHERE
P.PostTypeId=1 AND P.Tags LIKE '%python%' AND P.CreationDate
BETWEEN'04-01-2017' and '04-01-2018'
AND
(U.Location LIKE '%India%' 
OR U.Location LIKE '%Israel%'
OR U.Location LIKE '%Singapore%'
OR U.Location LIKE '%Japan%'
OR U.Location LIKE '%Hong Kong%'
OR U.Location LIKE '%Egypt%'
OR U.Location LIKE '%Pakistan%'
OR U.Location LIKE '%Taiwan%'
OR U.Location LIKE '%Iran%'
OR U.Location LIKE '%Korea%'
OR U.Location LIKE '%Turkey%'))

fork query

edited may 19 19

created feb 4 19 anonymous