• March, 2007
• February, 2007
• January, 2007
• December, 2006
• November, 2006
• October, 2006
• September, 2006
• August, 2006
• July, 2006
• June, 2006

SELECT p.*
FROM jos_pollxt_menu AS pm, jos_pollsxt AS p
WHERE (pm.menuid='2' OR pm.menuid='0') AND p.id=pm.pollid 
AND p.published=1
AND (p.datefrom < '2008-12-04' OR p.datefrom='0000-00-00' OR (p.datefrom = '2008-12-04' AND p.timefrom <= '23:49:39') )
AND (p.dateto > '2008-12-04' OR p.dateto='0000-00-00' OR (p.dateto = '2008-12-04' AND p.timeto >= '23:49:39') ) 
AND p.logon=0
AND (p.type = '1'
OR p.type = '0')
ORDER BY p.ordering