title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A 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-2011' and '01-01-2012')
AND U.Reputation >= 10000

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-2011' and '01-01-2012')
AND U.Reputation >= 10000
)

Enter Parameters

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