Declare @Tag VARCHAR(255); Set @Tag = '<angular>'; /* Cha...

0

Please login or register to vote for this query.

(click on this box to dismiss)

CiviCRM

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

Declare @Tag VARCHAR(255);
Set @Tag = '<angular>'; /* Change tag */

Select Top(50000) @Tag As Tags, Body, ViewCount From Posts
Where ViewCount > 1000
  And CHARINDEX(@Tag, Tags) > 0
  And (CHARINDEX('<code>', Body) > 0 Or CHARINDEX('<pre>', Body) > 0)
Order By ViewCount Desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results