0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

--Encontrar el título y fecha de las 5 preguntas con mayor 
--score que contienen el tag ‘python’

SELECT Posts.Title, Posts.CreationDate, Tags.TagName, Posts.Score
FROM Posts, PostTags, Tags
WHERE PostTags.PostId = Posts.Id AND Posts.ParentId IS NULL AND PostTags.PostId = Tags.Id AND Tags.TagName = 'python'
ORDER BY Posts.Score DESC

fork query

edited mar 21

created mar 21 anonymous