SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle,
m.params, mm.menuid FROM jhost_modules AS m LEFT JOIN jhost_modules_menu
AS mm ON mm.moduleid = m.id LEFT JOIN jhost_extensions AS e ON e.element
= m.module AND e.client_id = m.client_id WHERE m.published = 1 AND
e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up
<= '2012-01-05 09:22:34') AND (m.publish_down = '0000-00-00 00:00:00' OR
m.publish_down >= '2012-01-05 09:22:34') AND m.access IN (1,1,2,3) AND
m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY
m.position, m.ordering