0

Please login or register to vote for this query.

(click on this box to dismiss)

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

Declare @keyword varchar(100)='python'

select top 10 
  Posts.Id,
  Posts.CreationDate,
  Posts.ViewCount,
  Posts.Body,
  Posts.Title,
  Posts.OwnerUserId,
  Users.Id as UserID,
  Users.DisplayName as UserName
from Posts , Users

where 
 Posts.OwnerUserID = Users.Id
 and
AnswerCount = 0 and (Title like '%python%' or Tags like '%python%')
order by ViewCount Desc

;

fork query

edited mar 29

created mar 29 thepac