test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

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

-- Enter Query Title
-- Enter Query Description
-- select * from PostTypes;
/*
select count(*) 
from PostsWithDeleted inner join
*/

--select * from Tags order by Count desc;

select top(50) p.Id, p.Score, p.ViewCount, p.AnswerCount, COALESCE(FavoriteCount, 0) as FavoriteCount, CommentCount, Reputation,
    p.Title, p.Body, c.Text, c.Score 
from Posts p inner join Users u on u.Id = p.OwnerUserId
INNER JOIN Comments c ON c.PostId = p.Id

WHERE PostTypeId = 1 AND 
CommunityOwnedDate IS NULL AND 
YEAR(p.CreationDate) = 2018 AND
p.Tags LIKE '%python%' AND
c.text LIKE '%def %'

Enter Parameters

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