0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators, end users, developers and designers for Craft CMS

SELECT
 questao.Id as [Post Link],
 questao.Score,
 questao.Title,
 questao.Body,
 questao.Tags,
 questao.ViewCount,
 comentario.Id,
 comentario.Score as socre_comentario,
 comentario.ViewCount as views_comentario
FROM
 Posts questao
 JOIN Posts comentario ON questao.id = comentario.ParentId
WHERE
 questao.Tags like '%<windows-phone%'
 AND questao.CreationDate >= '01/01/2018'
 AND questao.ParentId is null
ORDER BY
 comentario.Score DESC, questao.ViewCount ASC

fork query

created apr 6 20 daniel.teruya