0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT P.Id,P.Tags,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-2012' and '01-01-2013')
AND (U.Reputation < 10000 AND U.Reputation >=1000)

UNION ALL
SELECT P.Id,P.Tags,P.Body
FROM Posts as P
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-2012' and '01-01-2013')
AND U.Reputation >= 10000
)

fork query

edited jun 15 19

created feb 4 19 anonymous