title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

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

SELECT TOP 50000
    Id,Body,Tags,ViewCount,CreationDate
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE ('%javascript%')
AND CreationDate
BETWEEN'01-01-2009' and '01-01-2010'
    ORDER BY
    [ViewCount] DESC

Enter Parameters

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