Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
select top 500 Posts.Id, ViewCount,Title,AnswerCount,Tags,Score, Body, OwnerUserId, Reputation from Posts, Users where PostTypeId=1 and OwnerUserId = Users.Id and AcceptedAnswerId Is not null and AnswerCount>0 and Score >10 and YEAR(Posts.CreationDate)= 2018 and Tags like '%<python>%' order by AnswerCount desc;