SELECT *
FROM jos_session
WHERE session_id = '2ope5gu6fniepisa1hugq3f0l5'
DELETE
FROM jos_session
WHERE ( time < '1371620509' )
SELECT *
FROM jos_session
WHERE session_id = '2ope5gu6fniepisa1hugq3f0l5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '2ope5gu6fniepisa1hugq3f0l5','1371624109','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'option=com\_sobi2&sobi2Task=sobi2Details&catid=18&sobi2Id=504&Itemid=2%' OR sefurl LIKE 'option=com\_sobi2&sobi2Task=sobi2Details&catid=18&sobi2Id=504&Itemid=2%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_sobi2&sobi2Task=sobi2Details&catid=18&sobi2Id=504&Itemid=2%' OR sefurl LIKE 'index.php?option=com\_sobi2&sobi2Task=sobi2Details&catid=18&sobi2Id=504&Itemid=2%'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT `configValue`, `configKey`
FROM `jos_sobi2_config`
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%index.php?option=com_sobi2%'
AND `type` = 'component'
AND `published` = '1'
LIMIT 1
SELECT *
FROM `jos_sobi2_language`
ORDER BY `sobi2Lang`
SELECT `configValue`
FROM `jos_sobi2_config`
WHERE (`configKey` = 'checkReferer'
AND `sobi2Section` = 'editForm')
SELECT `configValue`
FROM `jos_sobi2_config`
WHERE (`configKey` = 'needToConfirmNew'
AND `sobi2Section` = 'editForm')
SELECT `init_file`, `name_id`
FROM `jos_sobi2_plugins`
WHERE `enabled` = 1
ORDER BY `position` ASC
SELECT `configValue`
FROM `jos_sobi2_config`
WHERE (`configKey` = 'RtextLimit'
AND `sobi2Section` = 'sobi_reviews')
SELECT catid, name, introtext, description
FROM `jos_sobi2_categories`
WHERE `catid`=18
SELECT parentid
FROM `jos_sobi2_cats_relations`
WHERE `catid`=18
SELECT parentid
FROM `jos_sobi2_cats_relations`
WHERE `catid`=18
SELECT parentid
FROM `jos_sobi2_cats_relations`
WHERE `catid`=1
SELECT catid, name, introtext
FROM `jos_sobi2_categories`
WHERE (`catid`=18
AND `published` = 1)
SELECT *, params AS parameters
FROM jos_sobi2_item
WHERE (`itemid` = 504
AND `published` = 1
AND (`publish_down` > '2013-06-19 07:41:49' OR `publish_down` = '0000-00-00 00:00:00' ) )
SELECT svars, schecksum
FROM `jos_sobi2_cobj`
WHERE ( sid = 504
AND cid = 0
AND cl = 0
AND slang = 'english'
AND oid = 0 );
SELECT html, schecksum
FROM `jos_sobi2_cache`
WHERE ( validtime > 1371192109
AND task ='-9'
AND sid = 504
AND cid = 18
AND uid = -9
AND limitstart = -9
AND limitall = -9
AND Itemid = -9
AND params = '/sitesobi2Task=sobi2Details'
AND section = 'entrydetails'
AND slang = 'english')
ORDER BY validtime
LIMIT 1
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_details`= 1
AND `enabled` = 1
ORDER BY position
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '9')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '1')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '3')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '4')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '6')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '2')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '10')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '14')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '8')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '21')
AND labels.sobi2Section != 'field_opt'
SELECT langKey, langValue, description + 0 AS ordering
FROM jos_sobi2_language
WHERE sobi2Section = 'field_opt'
AND fieldid = 21
AND sobi2Lang = 'english'
ORDER BY ordering
SELECT langKey, langValue, description + 0 AS ordering
FROM jos_sobi2_language
WHERE sobi2Section = 'field_opt'
AND fieldid = 21
ORDER BY ordering
SELECT data_txt
FROM jos_sobi2_fields_data
WHERE fieldid = 21
AND itemid = 504
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '17')
AND labels.sobi2Section != 'field_opt'
SELECT langKey, langValue, description + 0 AS ordering
FROM jos_sobi2_language
WHERE sobi2Section = 'field_opt'
AND fieldid = 17
AND sobi2Lang = 'english'
ORDER BY ordering
SELECT langKey, langValue, description + 0 AS ordering
FROM jos_sobi2_language
WHERE sobi2Section = 'field_opt'
AND fieldid = 17
ORDER BY ordering
SELECT data_txt
FROM jos_sobi2_fields_data
WHERE fieldid = 17
AND itemid = 504
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '15')
AND labels.sobi2Section != 'field_opt'
SELECT langKey, langValue, description + 0 AS ordering
FROM jos_sobi2_language
WHERE sobi2Section = 'field_opt'
AND fieldid = 15
AND sobi2Lang = 'english'
ORDER BY ordering
SELECT langKey, langValue, description + 0 AS ordering
FROM jos_sobi2_language
WHERE sobi2Section = 'field_opt'
AND fieldid = 15
ORDER BY ordering
SELECT data_txt
FROM jos_sobi2_fields_data
WHERE fieldid = 15
AND itemid = 504
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '13')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '20')
AND labels.sobi2Section != 'field_opt'
SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows, fieldColumns, isUrl, with_label, in_newline, fieldType, position
FROM `jos_sobi2_fields_data` AS fdata
LEFT JOIN `jos_sobi2_fields` AS sfield
ON fdata.fieldid = sfield.fieldid
LEFT JOIN `jos_sobi2_language` AS labels
ON sfield.fieldid = labels.fieldid
WHERE (fdata.itemid = 504
AND `sobi2Lang` = 'english'
AND sfield.fieldid = '19')
AND labels.sobi2Section != 'field_opt'
SELECT *
FROM `jos_sobi2_plugin_gallery`
WHERE `itemid` = '504'
ORDER BY `position` ASC
SELECT *
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 504
AND `published` = 1
AND (`review` != '' OR `updateInfo` = 1) )
ORDER BY `added` DESC
LIMIT 0 , 5
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 504
AND `published` = 1
AND NOT (`review` = '') )
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '504'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT `data_txt`
FROM `jos_sobi2_fields_data`
WHERE `fieldid` = '24'
AND `itemid` = '504'
SELECT `data_txt`
FROM `jos_sobi2_fields_data`
WHERE `fieldid` = '23'
AND `itemid` = '504'
INSERT INTO `jos_sobi2_cache` ( `validtime` , `task` , `sid` , `cid` , `uid` , `limitstart` , `limitall` , `Itemid` , `section`, `params` , `html` , `opt`, `slang`, `schecksum` )
VALUES (1371624110, '-9', 504, 18, -9, -9, -9, -9, 'entrydetails', '/sitesobi2Task=sobi2Details', 'PGxpbmsgaHJlZj1cIi4uLy4uL2luY2x1ZGVzL2NvbV9zb2JpMi5jc3NcIiByZWw9XCJzdHlsZXNoZWV0XCIgdHlwZT1cInRleHQvY3NzXCIgLz5cblxuPHRhYmxlIHdpZHRoPVwiNTUwXCIgY2xhc3M9XCJzb2JpMkRldGFpbHNcIiBzdHlsZT1cJ2JvcmRlci1zdHlsZTogc29saWQ7IGJvcmRlci10b3Atd2lkdGg6IHRoaW47Ym9yZGVyLXJpZ2h0LXdpZHRoOiB0aGluO2JvcmRlci1ib3R0b20td2lkdGg6IHRoaW47Ym9yZGVyLWxlZnQtd2lkdGg6IHRoaW47IC1tb3otYm9yZGVyLXJhZGl1czogMTBweDsgYm9yZGVyLWNvbG9yOiAjNTU1NTVcJyA+XG48dHI+XG4JCTx0ZD48aDE+V2hpc3RvbiBGaXNoZXJpZXM8c3BhbiBjbGFzcz1cJ3NvYmlSYXRpbmdcJz48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudHMvY29tX3NvYmkyL3BsdWdpbnMvcmV2aWV3cy9pbWFnZXMvU3Rhci1SYXRpbmcvMDAtMC1zdGFyLnBuZ1wiIGFsdD1cIjBcIiAgIC8+PC9zcGFuPjwvaDE+XG4gICAgICAgIFxuICAgICAgICAgICAgIDwvdGQ+XG4JPC90cj5cbgk8dHI+XG4JCTx0ZD48L3RkPlxuCTwvdHI+XG4JPHRyPlxuCQk8dGQ+PC90ZD5cbgk8L3RyPlxuICAgXG4JPHRyPlxuCQk8dGQ+PGRpdiBpZD1cInNvYmkyb3V0ZXJcIj4JXG4JCSAgPHA+PGJyLz5cbgkJPHNwYW4gaWQ9XCJzb2JpMkRldGFpbHNfZmllbGRfY29udGFjdF9wZXJzb25cIiA+PHNwYW4gaWQ9XCJzb2JpMkxpc3RpbmdfZmllbGRfY29udGFjdF9wZXJzb25fbGFiZWxcIj5Db250YWN0IERldGFpbHM6PC9zcGFuPiBKb2huIFBvaW50b248L3NwYW4+PGJyLz5cbgkJPHNwYW4gIGlkPVwic29iaTJEZXRhaWxzX2ZpZWxkX3N0cmVldFwiPkJsYWtlbGV5IExhbmU8L3NwYW4+PGJyLz5cbgkJPHNwYW4gIGlkPVwic29iaTJEZXRhaWxzX2ZpZWxkX2NpdHlcIj5XaGlzdG9uPC9zcGFuPjxici8+XG4JCTxzcGFuICBpZD1cInNvYmkyRGV0YWlsc19maWVsZF9jb3VudHlcIj5TdGFmZm9yZHNoaXJlPC9zcGFuPjxici8+XG4JCTxzcGFuICBpZD1cInNvYmkyRGV0YWlsc19maWVsZF9jb3VudHJ5XCI+RW5nbGFuZDwvc3Bhbj48YnIvPlxuCQk8c3BhbiAgaWQ9XCJzb2JpMkRldGFpbHNfZmllbGRfcG9zdGNvZGVcIj5TVDEwIDJIWjwvc3Bhbj48YnIvPlxuCQk8c3BhbiBpZD1cInNvYmkyRGV0YWlsc19maWVsZF9waG9uZVwiID48c3BhbiBpZD1cInNvYmkyTGlzdGluZ19maWVsZF9waG9uZV9sYWJlbFwiPlBob25lOjwvc3Bhbj4gMDc5NjM2NzI1NTA8L3NwYW4+PGJyLz5cbgkJPHNwYW4gaWQ9XCJzb2JpMkRldGFpbHNfZmllbGRfdHlwZVwiID48c3BhbiBpZD1cInNvYmkyTGlzdGluZ19maWVsZF90eXBlX2xhYmVsXCI+VHlwZTo8L3NwYW4+IFxuPHVsIGNsYXNzID0gXCJzb2JpMkxpc3RpbmdfZmllbGRfdHlwZVwiPlxuCTxsaT5GaXNoZXJ5PC9saT5cbjwvdWw+PC9zcGFuPjxici8+XG4JCTxzcGFuIGlkPVwic29iaTJEZXRhaWxzX2ZpZWxkX3RhcmdldGFuZ2xlclwiID48c3BhbiBpZD1cInNvYmkyTGlzdGluZ19maWVsZF90YXJnZXRhbmdsZXJfbGFiZWxcIj5UYXJnZXQgQW5nbGVyOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90YXJnZXRhbmdsZXJcIj5cbgk8bGk+Q2FycDwvbGk+XG4JPGxpPkNvYXJzZTwvbGk+XG48L3VsPjwvc3Bhbj48YnIvPlxuCQk8c3BhbiBpZD1cInNvYmkyRGV0YWlsc19maWVsZF9sYWtlc1wiID48c3BhbiBpZD1cInNvYmkyTGlzdGluZ19maWVsZF9sYWtlc19sYWJlbFwiPk51bWJlciBvZiBMYWtlczo8L3NwYW4+IDM8L3NwYW4+CSAgICAgCSAgICAgIDwvcD5cbgkJICA8ZGl2IGNsYXNzPVwiZ29vZ2xlbWFwXCIgaWQ9XCJnb29nbGVtYXBcIj4gR29vbGdsZSBtYXAgdG8gY29tZSBcbgkJICAgIAkJICA8L2Rpdj5cbgkJICA8cD48YnIgLz5cbgkgICAgICA8L3A+XG4JCTwvZGl2PgkJPC90ZD5cbiAgPC90cj5cbgk8dHI+XG4JICA8dGQ+Jm5ic3A7PC90ZD5cbiAgPC90cj5cbjwvdGFibGU+XG48dGFibGUgY2xhc3M9XCJzb2JpMkRldGFpbHNGb290ZXJcIiB3aWR0aD1cIjEwMCVcIj5cbgk8dHI+XG4JICA8dGQ+XG4JCQkJCSZuYnNwOyZuYnNwO1xuCQlIaXRzOiAgMjEJICA8L3RkPlxuCSAgPHRkPjwvdGQ+XG4JPC90cj5cbjwvdGFibGU+XG5cbjxkaXYgaWQ9XCdyZXZzQm94XCc+XG5cbjxkaXYgaWQgPSBcJ3NyUmVzcENvbnRNc2dcJz48L2Rpdj5cblxuPGRpdiBpZD1cInJldmlld3NDb250XCI+PGRpdiBpZD1cInNyUmVzcENvbnRcIj48L2Rpdj5cbgkJPC9kaXY+PC9kaXY+', '', 'english', '3036' );
SELECT *
FROM jos_rereplacer
WHERE published = 1
ORDER BY ordering
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 2 OR mm.menuid = 0 )
ORDER BY position, ordering
