Search by tag wiki

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arqade

Q&A for passionate videogamers on all platforms

Select (SELECT T.tagname FROM Tags T WHERE T.wikiPostId = Posts.Id), id as [Post Link], body from posts 
where lower(body) like lower('%##SearchTerm##%') and 0<(SELECT [count] FROM Tags T WHERE T.wikiPostId = Posts.Id) and
postTypeID = 5 /*wiki*/

union

Select (SELECT T.tagname FROM Tags T WHERE T.excerptPostId = Posts.Id), id as [Post Link], body from posts 
where lower(body) like lower('%##SearchTerm##%') and 0<(SELECT [count] FROM Tags T WHERE T.excerptPostId = Posts.Id) and
postTypeID = 4 /*excerpt*/

Enter Parameters

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