Counting posts by tagname

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT count(*)
FROM Posts
WHERE 
(
  Tags LIKE 'api' OR
  Tags LIKE '%-api-%' OR
  Tags LIKE '%-api' OR
  Tags LIKE 'api-%' OR

  Tags LIKE 'framework' OR
  Tags LIKE 'framework-%' OR
  Tags LIKE '%-framework-%' OR
  Tags LIKE '%-framework' OR
 
 Tags LIKE 'frameworks' OR
  Tags LIKE 'frameworks-%' OR
  Tags LIKE '%-frameworks-%' OR
  Tags LIKE '%-frameworks' OR
  
  Tags LIKE 'library' OR
  Tags LIKE '%-library-%' OR
  Tags LIKE 'library-%' OR
  Tags LIKE '%-library' OR
  
  Tags LIKE 'libraries' OR
  Tags LIKE '%-libraries-%' OR
  Tags LIKE 'libraries-%' OR
  Tags LIKE '%-libraries'
 
)

Enter Parameters

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