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.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%' 
or P.Tags LIKE'%django%'
or P.Tags LIKE'%numpy%'
or P.Tags LIKE'%matplotlib%'
or P.Tags LIKE'%pandas%'
or P.Tags LIKE'%pygame%'
or P.Tags LIKE'%flask%'
or P.Tags LIKE'%tensorflow%'
or P.Tags LIKE'%pyqt%'
or P.Tags LIKE'%keras%'
or P.Tags LIKE'%scikit-learn%'
or P.Tags LIKE'%tkinter%'
or P.Tags LIKE'%beautifulsoup%'
or P.Tags LIKE'%sqlalchemy%'
or P.Tags LIKE'%scrapy%'
or P.Tags LIKE'%pyspark%'
or P.Tags LIKE'%subprocess%'
or P.Tags LIKE'%anaconda%'
or P.Tags LIKE'%pycharm%'
or P.Tags LIKE'%kivy%'
or P.Tags LIKE'%nltk%'
or P.Tags LIKE'%scipy%')
AND P.CreationDate
BETWEEN'01-01-2013' and '01-01-2014'
AND
(
U.Location LIKE '%United Kingdom%'
OR U.Location LIKE '%UK%'
OR U.Location LIKE '%Paris%'
OR U.Location LIKE '%France%'
OR U.Location LIKE '%Berlin%'
OR U.Location LIKE '%Netherlands%'
OR U.Location LIKE '%Russia%'
OR U.Location LIKE '%Italy %'
OR U.Location LIKE '%Sweden%'
OR U.Location LIKE '%Poland%'
OR U.Location LIKE '%Munich%'
OR U.Location LIKE '%Belgium%'
OR U.Location LIKE '%Amsterdam%'
OR U.Location LIKE '%Switzerland%'
OR U.Location LIKE '%Spain%'
OR U.Location LIKE '%Dublin%'
OR U.Location LIKE '%Ireland%'
OR U.Location LIKE '%Stockholm%'
OR U.Location LIKE '%Denmark%'
OR U.Location LIKE '%Europe%'
OR U.Location LIKE '%Ukraine%'
OR U.Location LIKE '%Norway%'
OR U.Location LIKE '%Portugal%'
OR U.Location LIKE '%München%'
OR U.Location LIKE '%Deutschland%'
OR U.Location LIKE '%England%'
)
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%' 
or P.Tags LIKE'%django%'
or P.Tags LIKE'%numpy%'
or P.Tags LIKE'%matplotlib%'
or P.Tags LIKE'%pandas%'
or P.Tags LIKE'%pygame%'
or P.Tags LIKE'%flask%'
or P.Tags LIKE'%tensorflow%'
or P.Tags LIKE'%pyqt%'
or P.Tags LIKE'%keras%'
or P.Tags LIKE'%scikit-learn%'
or P.Tags LIKE'%tkinter%'
or P.Tags LIKE'%beautifulsoup%'
or P.Tags LIKE'%sqlalchemy%'
or P.Tags LIKE'%scrapy%'
or P.Tags LIKE'%pyspark%'
or P.Tags LIKE'%subprocess%'
or P.Tags LIKE'%anaconda%'
or P.Tags LIKE'%pycharm%'
or P.Tags LIKE'%kivy%'
or P.Tags LIKE'%nltk%'
or P.Tags LIKE'%scipy%')
AND P.CreationDate
BETWEEN'01-01-2013' and '01-01-2014'
AND
(
U.Location LIKE '%United Kingdom%'
OR U.Location LIKE '%UK%'
OR U.Location LIKE '%Paris%'
OR U.Location LIKE '%France%'
OR U.Location LIKE '%Berlin%'
OR U.Location LIKE '%Netherlands%'
OR U.Location LIKE '%Russia%'
OR U.Location LIKE '%Italy %'
OR U.Location LIKE '%Sweden%'
OR U.Location LIKE '%Poland%'
OR U.Location LIKE '%Munich%'
OR U.Location LIKE '%Belgium%'
OR U.Location LIKE '%Amsterdam%'
OR U.Location LIKE '%Switzerland%'
OR U.Location LIKE '%Spain%'
OR U.Location LIKE '%Dublin%'
OR U.Location LIKE '%Ireland%'
OR U.Location LIKE '%Stockholm%'
OR U.Location LIKE '%Denmark%'
OR U.Location LIKE '%Europe%'
OR U.Location LIKE '%Ukraine%'
OR U.Location LIKE '%Norway%'
OR U.Location LIKE '%Portugal%'
OR U.Location LIKE '%München%'
OR U.Location LIKE '%Deutschland%'
OR U.Location LIKE '%England%'
))

AND
(
U.Location LIKE '%United Kingdom%'
OR U.Location LIKE '%UK%'
OR U.Location LIKE '%Paris%'
OR U.Location LIKE '%France%'
OR U.Location LIKE '%Berlin%'
OR U.Location LIKE '%Netherlands%'
OR U.Location LIKE '%Russia%'
OR U.Location LIKE '%Italy %'
OR U.Location LIKE '%Sweden%'
OR U.Location LIKE '%Poland%'
OR U.Location LIKE '%Munich%'
OR U.Location LIKE '%Belgium%'
OR U.Location LIKE '%Amsterdam%'
OR U.Location LIKE '%Switzerland%'
OR U.Location LIKE '%Spain%'
OR U.Location LIKE '%Dublin%'
OR U.Location LIKE '%Ireland%'
OR U.Location LIKE '%Stockholm%'
OR U.Location LIKE '%Denmark%'
OR U.Location LIKE '%Europe%'
OR U.Location LIKE '%Ukraine%'
OR U.Location LIKE '%Norway%'
OR U.Location LIKE '%Portugal%'
OR U.Location LIKE '%München%'
OR U.Location LIKE '%Deutschland%'
OR U.Location LIKE '%England%'
)

Enter Parameters

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