Questions on multiple tags by views

1

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

SELECT TOP 30 Id as [Post Link], Score, ViewCount, Tags
FROM Posts 
WHERE Tags LIKE CONCAT('%<', '##TAGNAME1##', '>%')
  OR Tags LIKE CONCAT('%<', '##TAGNAME2##', '>%')
  OR Tags LIKE CONCAT('%<', '##TAGNAME3##', '>%')
ORDER BY ViewCount DESC

Enter Parameters

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