0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

declare @question int = 1;
declare @reTag int = 3;
declare @tagToSearch nvarchar(35) = ##tag:string?google-apps-script##;
declare @textToSearch nvarchar(35) = ##text:string?gas##;


select
cast(Posts.CreationDate as date),
Posts.Tags,
Posts.Id as [Post Link]
from
Posts
where
Posts.PostTypeId = @question
and
Posts.Tags like ('%<' + @tagToSearch + '>%' )
and
( 

LOWER(Posts.Title) like ('%' + @textToSearch + '%' )
or
LOWER(Posts.Body) like ('%' + @textToSearch + '%' )
)
group by
Posts.Tags,Posts.Id, cast(Posts.CreationDate as date)
order by
cast(Posts.CreationDate as date) desc

fork query

edited jul 14

created jul 14 anonymous