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 )