SELECT TOP 200, ViewCount, CreationDate FROM Posts WHERE PostTypeId =1 AND CreationDate BETWEEN '201

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 Year=Year(CreationDate), 
Month=Month(CreationDate),
count(Title)
FROM Posts
WHERE PostTypeId ='1'
AND ((Tags LIKE '%python%') OR (Tags LIKE '%javascript%'))
AND (Month(CreationDate)='1' OR Month(CreationDate)='2')
AND (Year(CreationDate)='2019')
GROUP BY Year(CreationDate), Month(CreationDate)
ORDER BY Year,Month

Enter Parameters

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