0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for contractors and serious DIYers

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'04-01-2017' and '04-01-2018'

fork query

edited jul 17 19

created feb 4 19 anonymous