SELECT *
FROM jos_session
WHERE session_id = '63o1gulip7fgkqq2c2f48ctbl2'
DELETE
FROM jos_session
WHERE ( time < '1369401889' )
SELECT *
FROM jos_session
WHERE session_id = '63o1gulip7fgkqq2c2f48ctbl2'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '63o1gulip7fgkqq2c2f48ctbl2','1369405489','','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&catid=18&Itemid=2&limitstart=64%' OR sefurl LIKE 'option=com\_sobi2&catid=18&Itemid=2&limitstart=64%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_sobi2&catid=18&Itemid=2&limitstart=64%' OR sefurl LIKE 'index.php?option=com\_sobi2&catid=18&Itemid=2&limitstart=64%'
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 *
FROM `jos_sobi2_categories`
WHERE `catid` = 18
LIMIT 1
UPDATE `jos_sobi2_categories`
SET `count` = count + 1
WHERE `catid` = 18
LIMIT 1
SELECT html, schecksum
FROM `jos_sobi2_cache`
WHERE ( validtime > 1368973489
AND task ='-9'
AND sid = -9
AND cid = -9
AND uid = -9
AND limitstart = -9
AND limitall = -9
AND Itemid = -9
AND params = '/sitecatid=18'
AND section = 'catdescription'
AND slang = 'english')
ORDER BY validtime
LIMIT 1
SELECT html, schecksum
FROM `jos_sobi2_cache`
WHERE ( validtime > 1368973489
AND task ='-9'
AND sid = -9
AND cid = -9
AND uid = -9
AND limitstart = -9
AND limitall = -9
AND Itemid = -9
AND params = '/sitecatid=18'
AND section = 'catlist'
AND slang = 'english')
ORDER BY validtime
LIMIT 1
SELECT html, schecksum
FROM `jos_sobi2_cache`
WHERE ( validtime > 1368973489
AND task ='-9'
AND sid = -9
AND cid = -9
AND uid = -9
AND limitstart = 64
AND limitall = -9
AND Itemid = -9
AND params = '/sitecatid=18'
AND section = 'entrieslist'
AND slang = 'english')
ORDER BY validtime
LIMIT 1
SELECT DISTINCT relation.itemid
FROM `jos_sobi2_cat_items_relations` AS relation
LEFT JOIN `jos_sobi2_item` AS items
ON relation.itemid = items.itemid
WHERE ((`catid` = 18 )
AND `published` = 1
AND (`publish_down` > '2013-05-24 15:24:49' OR `publish_down` = '0000-00-00 00:00:00' ) )
SELECT DISTINCT relation.itemid, title, owner, image, background, icon
FROM `jos_sobi2_cat_items_relations` AS relation
LEFT JOIN `jos_sobi2_item` AS items
ON relation.itemid = items.itemid
WHERE ((`catid` = 18 )
AND `published` = '1'
AND (`publish_down` > '2013-05-24 15:24:49' OR `publish_down` = '0000-00-00 00:00:00' )
AND items.itemid IN(SELECT DISTINCT relation.itemid
FROM `jos_sobi2_cat_items_relations` AS relation
LEFT JOIN `jos_sobi2_item` AS items
ON relation.itemid = items.itemid
WHERE ((`catid` = 18 )
AND `published` = 1
AND (`publish_down` > '2013-05-24 15:24:49' OR `publish_down` = '0000-00-00 00:00:00' ) )) )
ORDER BY items.title ASC
LIMIT 64, 8
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 27
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 = 27
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 = 27
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 = 27
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 = 27
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 = 27
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 = 27
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 = 27
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '27'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 27
AND `published` = 1
AND NOT (`review` = '') )
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 466
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 = 466
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 = 466
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 = 466
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 = 466
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 = 466
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 = 466
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 = 466
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '466'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 466
AND `published` = 1
AND NOT (`review` = '') )
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 193
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 = 193
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 = 193
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 = 193
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 = 193
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 = 193
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 = 193
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 = 193
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '193'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 193
AND `published` = 1
AND NOT (`review` = '') )
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 491
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 = 491
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 = 491
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 = 491
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 = 491
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 = 491
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 = 491
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 = 491
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '491'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 491
AND `published` = 1
AND NOT (`review` = '') )
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 203
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 = 203
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 = 203
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 = 203
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 = 203
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 = 203
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 = 203
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 = 203
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '203'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 203
AND `published` = 1
AND NOT (`review` = '') )
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 101
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 = 101
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 = 101
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 = 101
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 = 101
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 = 101
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 = 101
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 = 101
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '101'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 101
AND `published` = 1
AND NOT (`review` = '') )
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 159
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 = 159
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 = 159
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 = 159
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 = 159
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 = 159
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 = 159
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 = 159
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '159'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 159
AND `published` = 1
AND NOT (`review` = '') )
SELECT `fieldid`
FROM `jos_sobi2_fields`
WHERE `in_vcard`= 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 = 304
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 = 304
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 = 304
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 = 304
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 = 304
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 = 304
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 = 304
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 = 304
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '304'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 304
AND `published` = 1
AND NOT (`review` = '') )
INSERT INTO `jos_sobi2_cache` ( `validtime` , `task` , `sid` , `cid` , `uid` , `limitstart` , `limitall` , `Itemid` , `section`, `params` , `html` , `opt`, `slang`, `schecksum` )
VALUES (1369405489, '-9', -9, -9, -9, 64, -9, -9, 'entrieslist', '/sitecatid=18', 'XG4JCTx0YWJsZSBjbGFzcz1cInNvYmkyTGlzdGluZ1wiPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlOyBib3JkZXItc3R5bGU6IHNvbGlkOyBib3JkZXItY29sb3I6ICM1NTU1NVwnPlxuCQkJCQk8YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0yN1wiID48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2ltYWdlcy9jb21fc29iaTIvY2xpZW50cy8yN19pY28uanBnXCIgYWx0PVwiRmVsdG9uIEZlbmNlIEZpc2hlcnlcIiB0aXRsZT1cIkZlbHRvbiBGZW5jZSBGaXNoZXJ5XCIgLz48L2E+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0yN1wiICB0aXRsZT1cIkZlbHRvbiBGZW5jZSBGaXNoZXJ5XCIgPkZlbHRvbiBGZW5jZSBGaXNoZXJ5PC9hPjwvcD5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9zdHJlZXRcIj5GZWx0b24gRmVuY2UgRmFybTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+TW9ycGV0aDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHlcIj5Ob3J0aHVtYmVybGFuZDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHJ5XCI+VUs8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfcG9zdGNvZGVcIj5ORTY1IDlIWTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF93ZWJzaXRlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuZmVsdG9uZmVuY2VmaXNoZXJpZXMuY29tXCIgdGl0bGU9XCJGZWx0b24gRmVuY2UgRmlzaGVyeVwiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuCTxsaT5UYWNrbGUgU2hvcDwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wNS0wLXN0YXIucG5nXCIgYWx0PVwiMTBcIiAgIC8+PC9zcGFuPlJldmlld3M6IDA8L3NwYW4+PC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7IGJvcmRlci1zdHlsZTogc29saWQ7IGJvcmRlci1jb2xvcjogIzU1NTU1XCc+XG4JCQkJCTxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTQ2NlwiID48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2ltYWdlcy9jb21fc29iaTIvY2xpZW50cy80NjZfaWNvLmpwZ1wiIGFsdD1cIkZpZWxkcyBGYXJtIEZpc2hlcmllc1wiIHRpdGxlPVwiRmllbGRzIEZhcm0gRmlzaGVyaWVzXCIgLz48L2E+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD00NjZcIiAgdGl0bGU9XCJGaWVsZHMgRmFybSBGaXNoZXJpZXNcIiA+RmllbGRzIEZhcm0gRmlzaGVyaWVzPC9hPjwvcD5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9zdHJlZXRcIj5Db25nbGV0b24gUm9hZDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+U2FuZGJhdGNoPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50eVwiPkNoZXNoaXJlPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50cnlcIj5FbmdsYW5kPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3Bvc3Rjb2RlXCI+Q1cxMSA0VEU8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfd2Vic2l0ZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZpZWxkc2Zhcm1maXNoZXJpZXMuY28udWtcIiB0aXRsZT1cIkZpZWxkcyBGYXJtIEZpc2hlcmllc1wiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuPC91bD5cbgkJPHRhYmxlIGNsYXNzPVwnc29iaTJMaXN0aW5nX3BsdWdpbnNcJz5cbgkJCTx0cj48dGQgY2xhc3M9XCdzb2JpX2dhbGxlcnlfVkNcJz48L3RkPjx0ZCBjbGFzcz1cJ3NvYmlfcmV2aWV3c19WQ1wnPjxzcGFuIGNsYXNzPVwic29iaTJSYXRpbmdcIj48c3BhbiBjbGFzcz1cJ3NvYmlSYXRpbmdcJz48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudHMvY29tX3NvYmkyL3BsdWdpbnMvcmV2aWV3cy9pbWFnZXMvU3Rhci1SYXRpbmcvMDAtMC1zdGFyLnBuZ1wiIGFsdD1cIjBcIiAgIC8+PC9zcGFuPlJldmlld3M6IDA8L3NwYW4+PC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7IGJvcmRlci1zdHlsZTogc29saWQ7IGJvcmRlci1jb2xvcjogIzU1NTU1XCc+XG4JCQkJCTxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTE5M1wiID48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2ltYWdlcy9jb21fc29iaTIvY2xpZW50cy8xOTNfaWNvLmpwZ1wiIGFsdD1cIkZpciBUcmVlIEZpc2hlcnlcIiB0aXRsZT1cIkZpciBUcmVlIEZpc2hlcnlcIiAvPjwvYT5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkl0ZW1UaXRsZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTE5M1wiICB0aXRsZT1cIkZpciBUcmVlIEZpc2hlcnlcIiA+RmlyIFRyZWUgRmlzaGVyeTwvYT48L3A+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfc3RyZWV0XCI+RmlyIFRyZWUgRmFybTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+QXBwbGV5IEJyaWRnZSwgV2lnYW48L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnR5XCI+TGFuY2FzaGlyZTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHJ5XCI+VUs8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfcG9zdGNvZGVcIj5XTjYgOUpCPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuPC91bD5cbgkJPHRhYmxlIGNsYXNzPVwnc29iaTJMaXN0aW5nX3BsdWdpbnNcJz5cbgkJCTx0cj48dGQgY2xhc3M9XCdzb2JpX2dhbGxlcnlfVkNcJz48L3RkPjx0ZCBjbGFzcz1cJ3NvYmlfcmV2aWV3c19WQ1wnPjxzcGFuIGNsYXNzPVwic29iaTJSYXRpbmdcIj48c3BhbiBjbGFzcz1cJ3NvYmlSYXRpbmdcJz48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudHMvY29tX3NvYmkyL3BsdWdpbnMvcmV2aWV3cy9pbWFnZXMvU3Rhci1SYXRpbmcvMDAtMC1zdGFyLnBuZ1wiIGFsdD1cIjBcIiAgIC8+PC9zcGFuPlJldmlld3M6IDA8L3NwYW4+PC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7IGJvcmRlci1zdHlsZTogc29saWQ7IGJvcmRlci1jb2xvcjogIzU1NTU1XCc+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD00OTFcIiAgdGl0bGU9XCJGbHVzaGluZyBNZWFkb3dzIEZpc2hlcmllc1wiID5GbHVzaGluZyBNZWFkb3dzIEZpc2hlcmllczwvYT48L3A+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfc3RyZWV0XCI+QWN0b24gQnJpZGdlPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NpdHlcIj5Ob3J0aHdpY2g8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnR5XCI+Q2hlc2hpcmU8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnRyeVwiPkVuZ2xhbmQ8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfdHlwZV9sYWJlbFwiPlR5cGU6PC9zcGFuPiBcbjx1bCBjbGFzcyA9IFwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVcIj5cbgk8bGk+RmlzaGVyeTwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wMC0wLXN0YXIucG5nXCIgYWx0PVwiMFwiICAgLz48L3NwYW4+UmV2aWV3czogMDwvc3Bhbj48L3RkPlxuCQkJPC90cj5cbgkJPC90YWJsZT5cbgkJCQk8L3RkPlxuCQkJPC90cj5cbgkJCTx0cj5cbgkJCQk8dGQgc3R5bGU9XCd3aWR0aDogMTAwJTsgYm9yZGVyLXN0eWxlOiBzb2xpZDsgYm9yZGVyLWNvbG9yOiAjNTU1NTVcJz5cbgkJCQkJPGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9MjAzXCIgPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvaW1hZ2VzL2NvbV9zb2JpMi9jbGllbnRzLzIwM19pY28uanBnXCIgYWx0PVwiRm9sbHkgRm9vdCBGaXNoZXJ5XCIgdGl0bGU9XCJGb2xseSBGb290IEZpc2hlcnlcIiAvPjwvYT5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkl0ZW1UaXRsZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTIwM1wiICB0aXRsZT1cIkZvbGx5IEZvb3QgRmlzaGVyeVwiID5Gb2xseSBGb290IEZpc2hlcnk8L2E+PC9wPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3N0cmVldFwiPlRhdW50b24gUm9hZDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+Tm9ydGggUGV0aGVydG9uPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50eVwiPlNvbWVyc2V0PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50cnlcIj5VSzwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9wb3N0Y29kZVwiPlRBNiA2Tlc8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfd2Vic2l0ZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZvbGx5Zm9vdGZpc2hlcnkuY28udWtcIiB0aXRsZT1cIkZvbGx5IEZvb3QgRmlzaGVyeVwiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuCTxsaT5UYWNrbGUgU2hvcDwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wMC0wLXN0YXIucG5nXCIgYWx0PVwiMFwiICAgLz48L3NwYW4+UmV2aWV3czogMDwvc3Bhbj48L3RkPlxuCQkJPC90cj5cbgkJPC90YWJsZT5cbgkJCQk8L3RkPlxuCQkJPC90cj5cbgkJCTx0cj5cbgkJCQk8dGQgc3R5bGU9XCd3aWR0aDogMTAwJTsgYm9yZGVyLXN0eWxlOiBzb2xpZDsgYm9yZGVyLWNvbG9yOiAjNTU1NTVcJz5cbgkJCQkJPGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9MTAxXCIgPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvaW1hZ2VzL2NvbV9zb2JpMi9jbGllbnRzLzEwMV9pY28uanBnXCIgYWx0PVwiRm91ciBPYWtzIEZhcm0gRmlzaGVyeVwiIHRpdGxlPVwiRm91ciBPYWtzIEZhcm0gRmlzaGVyeVwiIC8+PC9hPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkySXRlbVRpdGxlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9MTAxXCIgIHRpdGxlPVwiRm91ciBPYWtzIEZhcm0gRmlzaGVyeVwiID5Gb3VyIE9ha3MgRmFybSBGaXNoZXJ5PC9hPjwvcD5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9zdHJlZXRcIj5Qb3dleSBMYW5lPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NpdHlcIj5Nb2xsaW5ndG9uPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50eVwiPkNoZXNoaXJlPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50cnlcIj5VSzwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9wb3N0Y29kZVwiPkNIMSA2TEg8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfd2Vic2l0ZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZvdXJvYWtzZmFybS5jby51a1wiIHRpdGxlPVwiRm91ciBPYWtzIEZhcm0gRmlzaGVyeVwiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuPC91bD5cbgkJPHRhYmxlIGNsYXNzPVwnc29iaTJMaXN0aW5nX3BsdWdpbnNcJz5cbgkJCTx0cj48dGQgY2xhc3M9XCdzb2JpX2dhbGxlcnlfVkNcJz48L3RkPjx0ZCBjbGFzcz1cJ3NvYmlfcmV2aWV3c19WQ1wnPjxzcGFuIGNsYXNzPVwic29iaTJSYXRpbmdcIj48c3BhbiBjbGFzcz1cJ3NvYmlSYXRpbmdcJz48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudHMvY29tX3NvYmkyL3BsdWdpbnMvcmV2aWV3cy9pbWFnZXMvU3Rhci1SYXRpbmcvMDUtMC1zdGFyLnBuZ1wiIGFsdD1cIjEwXCIgICAvPjwvc3Bhbj5SZXZpZXdzOiAwPC9zcGFuPjwvdGQ+XG4JCQk8L3RyPlxuCQk8L3RhYmxlPlxuCQkJCTwvdGQ+XG4JCQk8L3RyPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlOyBib3JkZXItc3R5bGU6IHNvbGlkOyBib3JkZXItY29sb3I6ICM1NTU1NVwnPlxuCQkJCQk8YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNTlcIiA+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9pbWFnZXMvY29tX3NvYmkyL2NsaWVudHMvMTU5X2ljby5qcGdcIiBhbHQ9XCJGb3VyIFBvbmRzIEZpc2hlcnlcIiB0aXRsZT1cIkZvdXIgUG9uZHMgRmlzaGVyeVwiIC8+PC9hPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkySXRlbVRpdGxlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9MTU5XCIgIHRpdGxlPVwiRm91ciBQb25kcyBGaXNoZXJ5XCIgPkZvdXIgUG9uZHMgRmlzaGVyeTwvYT48L3A+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfc3RyZWV0XCI+Qm93ZGVucyBMYW5lPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NpdHlcIj5TaGlsbGluZ2ZvcmQ8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnR5XCI+RGV2b248L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnRyeVwiPlVLPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3Bvc3Rjb2RlXCI+RVgxNiA5QlU8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfd2Vic2l0ZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZvdXJwb25kcy5jb21cIiB0aXRsZT1cIkZvdXIgUG9uZHMgRmlzaGVyeVwiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuCTxsaT5UYWNrbGUgU2hvcDwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wMC0wLXN0YXIucG5nXCIgYWx0PVwiMFwiICAgLz48L3NwYW4+UmV2aWV3czogMDwvc3Bhbj48L3RkPlxuCQkJPC90cj5cbgkJPC90YWJsZT5cbgkJCQk8L3RkPlxuCQkJPC90cj5cbgkJCTx0cj5cbgkJCQk8dGQgc3R5bGU9XCd3aWR0aDogMTAwJTsgYm9yZGVyLXN0eWxlOiBzb2xpZDsgYm9yZGVyLWNvbG9yOiAjNTU1NTVcJz5cbgkJCQkJPGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9MzA0XCIgPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvaW1hZ2VzL2NvbV9zb2JpMi9jbGllbnRzLzMwNF9pY28uZ2lmXCIgYWx0PVwiRm91ciBTZWFzb25zIEZpc2hlcnlcIiB0aXRsZT1cIkZvdXIgU2Vhc29ucyBGaXNoZXJ5XCIgLz48L2E+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0zMDRcIiAgdGl0bGU9XCJGb3VyIFNlYXNvbnMgRmlzaGVyeVwiID5Gb3VyIFNlYXNvbnMgRmlzaGVyeTwvYT48L3A+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfc3RyZWV0XCI+U3RhaW5pbmcgUm9hZDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+QmxhY2twb29sPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50eVwiPkxhbmNhc2hpcmU8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnRyeVwiPlVLPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3Bvc3Rjb2RlXCI+RlkzIDBBWTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF93ZWJzaXRlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuZm91cnNlYXNvbnNmaXNoZXJpZXMuY28udWsvXCIgdGl0bGU9XCJGb3VyIFNlYXNvbnMgRmlzaGVyeVwiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuPC91bD5cbgkJPHRhYmxlIGNsYXNzPVwnc29iaTJMaXN0aW5nX3BsdWdpbnNcJz5cbgkJCTx0cj48dGQgY2xhc3M9XCdzb2JpX2dhbGxlcnlfVkNcJz48L3RkPjx0ZCBjbGFzcz1cJ3NvYmlfcmV2aWV3c19WQ1wnPjxzcGFuIGNsYXNzPVwic29iaTJSYXRpbmdcIj48c3BhbiBjbGFzcz1cJ3NvYmlSYXRpbmdcJz48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudHMvY29tX3NvYmkyL3BsdWdpbnMvcmV2aWV3cy9pbWFnZXMvU3Rhci1SYXRpbmcvMDAtMC1zdGFyLnBuZ1wiIGFsdD1cIjBcIiAgIC8+PC9zcGFuPlJldmlld3M6IDA8L3NwYW4+PC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4=', '', 'english', '16368' );
INSERT INTO `jos_sobi2_cache` ( `validtime` , `task` , `sid` , `cid` , `uid` , `limitstart` , `limitall` , `Itemid` , `section`, `params` , `html` , `opt`, `slang`, `schecksum` )
VALUES (1369405489, '-9', -9, -9, -9, 64, -9, -9, 'pagenav', '/sitecatid=18', 'PGRpdiBpZD1cInNvYmkyUGFnZU5hdlwiPiZsdDsmbHQ7IDxhIHRpdGxlPVwiU3RhcnRcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOFwiIGNsYXNzPVwicGFnZW5hdlwiPlN0YXJ0PC9hPiAmbHQ7IDxhIHRpdGxlPVwiUHJldlwiIGhyZWY9XCIvc2l0ZS9jb21wb25lbnQvc29iaTIvP2NhdGlkPTE4JmFtcDtzdGFydD01NlwiIGNsYXNzPVwicGFnZW5hdlwiPlByZXY8L2E+IDxhIHRpdGxlPVwiMVwiIGhyZWY9XCIvc2l0ZS9jb21wb25lbnQvc29iaTIvP2NhdGlkPTE4XCIgY2xhc3M9XCJwYWdlbmF2XCI+MTwvYT4gPGEgdGl0bGU9XCIyXCIgaHJlZj1cIi9zaXRlL2NvbXBvbmVudC9zb2JpMi8/Y2F0aWQ9MTgmYW1wO3N0YXJ0PThcIiBjbGFzcz1cInBhZ2VuYXZcIj4yPC9hPiA8YSB0aXRsZT1cIjNcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9MTZcIiBjbGFzcz1cInBhZ2VuYXZcIj4zPC9hPiA8YSB0aXRsZT1cIjRcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9MjRcIiBjbGFzcz1cInBhZ2VuYXZcIj40PC9hPiA8YSB0aXRsZT1cIjVcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9MzJcIiBjbGFzcz1cInBhZ2VuYXZcIj41PC9hPiA8YSB0aXRsZT1cIjZcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9NDBcIiBjbGFzcz1cInBhZ2VuYXZcIj42PC9hPiA8YSB0aXRsZT1cIjdcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9NDhcIiBjbGFzcz1cInBhZ2VuYXZcIj43PC9hPiA8YSB0aXRsZT1cIjhcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9NTZcIiBjbGFzcz1cInBhZ2VuYXZcIj44PC9hPiA8c3BhbiBjbGFzcz1cInBhZ2VuYXZcIj45PC9zcGFuPiA8YSB0aXRsZT1cIjEwXCIgaHJlZj1cIi9zaXRlL2NvbXBvbmVudC9zb2JpMi8/Y2F0aWQ9MTgmYW1wO3N0YXJ0PTcyXCIgY2xhc3M9XCJwYWdlbmF2XCI+MTA8L2E+IDxhIHRpdGxlPVwiTmV4dFwiIGhyZWY9XCIvc2l0ZS9jb21wb25lbnQvc29iaTIvP2NhdGlkPTE4JmFtcDtzdGFydD03MlwiIGNsYXNzPVwicGFnZW5hdlwiPk5leHQ8L2E+ICZndDsgPGEgdGl0bGU9XCJFbmRcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9MTg0XCIgY2xhc3M9XCJwYWdlbmF2XCI+RW5kPC9hPiAmZ3Q7Jmd0OzwvZGl2Pg==', '', 'english', '1736' );
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