title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT 
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-2018' and '04-01-2019'
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.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-2018' and '04-01-2019'
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%'))

Enter Parameters

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