SELECT *
FROM jos_session
WHERE session_id = 'jl1rpbi15up42qmfdsbeh0q9m0'
DELETE
FROM jos_session
WHERE ( time < '1369443967' )
SELECT *
FROM jos_session
WHERE session_id = 'jl1rpbi15up42qmfdsbeh0q9m0'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'jl1rpbi15up42qmfdsbeh0q9m0','1369447567','','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=48%' OR sefurl LIKE 'option=com\_sobi2&catid=18&Itemid=2&limitstart=48%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_sobi2&catid=18&Itemid=2&limitstart=48%' OR sefurl LIKE 'index.php?option=com\_sobi2&catid=18&Itemid=2&limitstart=48%'
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 > 1369015568
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 > 1369015568
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 > 1369015568
AND task ='-9'
AND sid = -9
AND cid = -9
AND uid = -9
AND limitstart = 48
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-25 03:06:08' 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-25 03:06:08' 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-25 03:06:08' OR `publish_down` = '0000-00-00 00:00:00' ) )) )
ORDER BY items.title ASC
LIMIT 48, 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 = 154
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 = 154
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 = 154
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 = 154
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 = 154
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 = 154
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 = 154
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 = 154
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '154'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 154
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 = 155
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 = 155
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 = 155
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 = 155
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 = 155
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 = 155
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 = 155
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 = 155
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '155'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 155
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 = 156
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 = 156
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 = 156
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 = 156
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 = 156
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 = 156
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 = 156
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 = 156
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '156'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 156
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 = 126
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 = 126
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 = 126
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 = 126
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 = 126
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 = 126
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 = 126
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 = 126
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '126'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 126
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 = 475
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 = 475
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 = 475
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 = 475
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 = 475
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 = 475
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 = 475
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 = 475
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '475'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 475
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 = 146
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 = 146
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 = 146
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 = 146
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 = 146
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 = 146
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 = 146
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 = 146
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '146'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 146
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 = 157
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 = 157
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 = 157
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 = 157
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 = 157
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 = 157
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 = 157
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 = 157
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '157'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 157
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 = 83
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 = 83
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 = 83
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 = 83
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 = 83
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 = 83
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 = 83
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 = 83
SELECT COUNT(vote) AS votes, SUM(vote) AS vres
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = '83'
AND NOT (`vote` = 0)
AND `published` = 1)
SELECT COUNT(*)
FROM `jos_sobi2_plugin_reviews`
WHERE (`itemid` = 83
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 (1369447568, '-9', -9, -9, -9, 48, -9, -9, 'entrieslist', '/sitecatid=18', 'XG4JCTx0YWJsZSBjbGFzcz1cInNvYmkyTGlzdGluZ1wiPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlOyBib3JkZXItc3R5bGU6IHNvbGlkOyBib3JkZXItY29sb3I6ICM1NTU1NVwnPlxuCQkJCQk8YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNTRcIiA+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9pbWFnZXMvY29tX3NvYmkyL2NsaWVudHMvMTU0X2ljby5qcGdcIiBhbHQ9XCJDcm9td2VsbCBGaXNoZXJ5XCIgdGl0bGU9XCJDcm9td2VsbCBGaXNoZXJ5XCIgLz48L2E+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNTRcIiAgdGl0bGU9XCJDcm9td2VsbCBGaXNoZXJ5XCIgPkNyb213ZWxsIEZpc2hlcnk8L2E+PC9wPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3N0cmVldFwiPkNyb213ZWxsIE5ld2Fyazwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+Tm90dGluZ2hhbTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHlcIj5Ob3R0aW5naGFtc2hpcmU8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnRyeVwiPlVLPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3Bvc3Rjb2RlXCI+TkcyMyA2SkU8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfd2Vic2l0ZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmNyb213ZWxsbGFrZS5jb21cIiB0aXRsZT1cIkNyb213ZWxsIEZpc2hlcnlcIiB0YXJnZXQ9XCJfYmxhbmtcIj5XZWJzaXRlPC9hPjwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF90eXBlX2xhYmVsXCI+VHlwZTo8L3NwYW4+IFxuPHVsIGNsYXNzID0gXCJzb2JpMkxpc3RpbmdfZmllbGRfdHlwZVwiPlxuCTxsaT5GaXNoZXJ5PC9saT5cbjwvdWw+XG4JCTx0YWJsZSBjbGFzcz1cJ3NvYmkyTGlzdGluZ19wbHVnaW5zXCc+XG4JCQk8dHI+PHRkIGNsYXNzPVwnc29iaV9nYWxsZXJ5X1ZDXCc+PC90ZD48dGQgY2xhc3M9XCdzb2JpX3Jldmlld3NfVkNcJz48c3BhbiBjbGFzcz1cInNvYmkyUmF0aW5nXCI+PHNwYW4gY2xhc3M9XCdzb2JpUmF0aW5nXCc+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnRzL2NvbV9zb2JpMi9wbHVnaW5zL3Jldmlld3MvaW1hZ2VzL1N0YXItUmF0aW5nLzAwLTAtc3Rhci5wbmdcIiBhbHQ9XCIwXCIgICAvPjwvc3Bhbj5SZXZpZXdzOiAwPC9zcGFuPjwvdGQ+XG4JCQk8L3RyPlxuCQk8L3RhYmxlPlxuCQkJCTwvdGQ+XG4JCQk8L3RyPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlOyBib3JkZXItc3R5bGU6IHNvbGlkOyBib3JkZXItY29sb3I6ICM1NTU1NVwnPlxuCQkJCQk8YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNTVcIiA+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9pbWFnZXMvY29tX3NvYmkyL2NsaWVudHMvMTU1X2ljby5qcGdcIiBhbHQ9XCJDcm9zcyBEcm92ZSBGaXNoZXJ5XCIgdGl0bGU9XCJDcm9zcyBEcm92ZSBGaXNoZXJ5XCIgLz48L2E+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNTVcIiAgdGl0bGU9XCJDcm9zcyBEcm92ZSBGaXNoZXJ5XCIgPkNyb3NzIERyb3ZlIEZpc2hlcnk8L2E+PC9wPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3N0cmVldFwiPkNvd2xlcyBEcml2ZTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+SG9ja3dvbGQ8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnR5XCI+Tm9yZm9sazwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHJ5XCI+VUs8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfcG9zdGNvZGVcIj5JUDI2IDRKUTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF90eXBlX2xhYmVsXCI+VHlwZTo8L3NwYW4+IFxuPHVsIGNsYXNzID0gXCJzb2JpMkxpc3RpbmdfZmllbGRfdHlwZVwiPlxuCTxsaT5GaXNoZXJ5PC9saT5cbjwvdWw+XG4JCTx0YWJsZSBjbGFzcz1cJ3NvYmkyTGlzdGluZ19wbHVnaW5zXCc+XG4JCQk8dHI+PHRkIGNsYXNzPVwnc29iaV9nYWxsZXJ5X1ZDXCc+PC90ZD48dGQgY2xhc3M9XCdzb2JpX3Jldmlld3NfVkNcJz48c3BhbiBjbGFzcz1cInNvYmkyUmF0aW5nXCI+PHNwYW4gY2xhc3M9XCdzb2JpUmF0aW5nXCc+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnRzL2NvbV9zb2JpMi9wbHVnaW5zL3Jldmlld3MvaW1hZ2VzL1N0YXItUmF0aW5nLzAwLTAtc3Rhci5wbmdcIiBhbHQ9XCIwXCIgICAvPjwvc3Bhbj5SZXZpZXdzOiAwPC9zcGFuPjwvdGQ+XG4JCQk8L3RyPlxuCQk8L3RhYmxlPlxuCQkJCTwvdGQ+XG4JCQk8L3RyPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlOyBib3JkZXItc3R5bGU6IHNvbGlkOyBib3JkZXItY29sb3I6ICM1NTU1NVwnPlxuCQkJCQk8YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNTZcIiA+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9pbWFnZXMvY29tX3NvYmkyL2NsaWVudHMvMTU2X2ljby5qcGdcIiBhbHQ9XCJDcm9zc3dvb2QgRmlzaGVyeVwiIHRpdGxlPVwiQ3Jvc3N3b29kIEZpc2hlcnlcIiAvPjwvYT5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkl0ZW1UaXRsZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTE1NlwiICB0aXRsZT1cIkNyb3Nzd29vZCBGaXNoZXJ5XCIgPkNyb3Nzd29vZCBGaXNoZXJ5PC9hPjwvcD5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9zdHJlZXRcIj5Dcm9zc3dvb2QgSGlsbDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+V2VzdCBDYWxkZXI8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnR5XCI+V2VzdCBMb3RoaWFuPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50cnlcIj5TY290bGFuZDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9wb3N0Y29kZVwiPkVINTUgOExSPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3dlYnNpdGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoY3Jvc3N3b29kLmNvLnVrXCIgdGl0bGU9XCJDcm9zc3dvb2QgRmlzaGVyeVwiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuPC91bD5cbgkJPHRhYmxlIGNsYXNzPVwnc29iaTJMaXN0aW5nX3BsdWdpbnNcJz5cbgkJCTx0cj48dGQgY2xhc3M9XCdzb2JpX2dhbGxlcnlfVkNcJz48L3RkPjx0ZCBjbGFzcz1cJ3NvYmlfcmV2aWV3c19WQ1wnPjxzcGFuIGNsYXNzPVwic29iaTJSYXRpbmdcIj48c3BhbiBjbGFzcz1cJ3NvYmlSYXRpbmdcJz48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudHMvY29tX3NvYmkyL3BsdWdpbnMvcmV2aWV3cy9pbWFnZXMvU3Rhci1SYXRpbmcvMDAtMC1zdGFyLnBuZ1wiIGFsdD1cIjBcIiAgIC8+PC9zcGFuPlJldmlld3M6IDA8L3NwYW4+PC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7IGJvcmRlci1zdHlsZTogc29saWQ7IGJvcmRlci1jb2xvcjogIzU1NTU1XCc+XG4JCQkJCTxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTEyNlwiID48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2ltYWdlcy9jb21fc29iaTIvY2xpZW50cy8xMjZfaWNvLmpwZ1wiIGFsdD1cIkN1ZG1vcmUgRmlzaGVyaWVzXCIgdGl0bGU9XCJDdWRtb3JlIEZpc2hlcmllc1wiIC8+PC9hPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkySXRlbVRpdGxlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9MTI2XCIgIHRpdGxlPVwiQ3VkbW9yZSBGaXNoZXJpZXNcIiA+Q3VkbW9yZSBGaXNoZXJpZXM8L2E+PC9wPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3N0cmVldFwiPlBsZWNrIExhbmU8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY2l0eVwiPldoaXRtb3JlLCBOZXdjYXN0bGUtdW5kZXItTHltZTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHlcIj5TdGFmZm9yZHNoaXJlPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50cnlcIj5VSzwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9wb3N0Y29kZVwiPlNUNSA1SFc8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfd2Vic2l0ZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmN1ZG1vcmVmaXNoZXJ5LmNvLnVrXCIgdGl0bGU9XCJDdWRtb3JlIEZpc2hlcmllc1wiIHRhcmdldD1cIl9ibGFua1wiPldlYnNpdGU8L2E+PC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuCTxsaT5UYWNrbGUgU2hvcDwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wNS0wLXN0YXIucG5nXCIgYWx0PVwiMTBcIiAgIC8+PC9zcGFuPlJldmlld3M6IDA8L3NwYW4+PC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7IGJvcmRlci1zdHlsZTogc29saWQ7IGJvcmRlci1jb2xvcjogIzU1NTU1XCc+XG4JCQkJCTxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTQ3NVwiID48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2ltYWdlcy9jb21fc29iaTIvY2xpZW50cy80NzVfaWNvLmpwZ1wiIGFsdD1cIkN1ZXJkZW4gVmFsbGV5IFBhcmtcIiB0aXRsZT1cIkN1ZXJkZW4gVmFsbGV5IFBhcmtcIiAvPjwvYT5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkl0ZW1UaXRsZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTQ3NVwiICB0aXRsZT1cIkN1ZXJkZW4gVmFsbGV5IFBhcmtcIiA+Q3VlcmRlbiBWYWxsZXkgUGFyazwvYT48L3A+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfc3RyZWV0XCI+QmFtYmVyIEJyaWRnZTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+U291dGggUHJlc3Rvbjwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHlcIj5MYW5jYXNoaXJlPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50cnlcIj5FbmdsYW5kPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3Bvc3Rjb2RlXCI+UFI1IDZCWTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF93ZWJzaXRlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuY3VlcmRlbnZhbGxleXBhcmsub3JnLnVrXCIgdGl0bGU9XCJDdWVyZGVuIFZhbGxleSBQYXJrXCIgdGFyZ2V0PVwiX2JsYW5rXCI+V2Vic2l0ZTwvYT48L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfdHlwZV9sYWJlbFwiPlR5cGU6PC9zcGFuPiBcbjx1bCBjbGFzcyA9IFwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVcIj5cbgk8bGk+RmlzaGVyeTwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wMC0wLXN0YXIucG5nXCIgYWx0PVwiMFwiICAgLz48L3NwYW4+UmV2aWV3czogMDwvc3Bhbj48L3RkPlxuCQkJPC90cj5cbgkJPC90YWJsZT5cbgkJCQk8L3RkPlxuCQkJPC90cj5cbgkJCTx0cj5cbgkJCQk8dGQgc3R5bGU9XCd3aWR0aDogMTAwJTsgYm9yZGVyLXN0eWxlOiBzb2xpZDsgYm9yZGVyLWNvbG9yOiAjNTU1NTVcJz5cbgkJCQkJPGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9MTQ2XCIgPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvaW1hZ2VzL2NvbV9zb2JpMi9jbGllbnRzLzE0Nl9pY28uanBnXCIgYWx0PVwiRGFuZWJyaWRnZSBGaXNoZXJpZXNcIiB0aXRsZT1cIkRhbmVicmlkZ2UgRmlzaGVyaWVzXCIgLz48L2E+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNDZcIiAgdGl0bGU9XCJEYW5lYnJpZGdlIEZpc2hlcmllc1wiID5EYW5lYnJpZGdlIEZpc2hlcmllczwvYT48L3A+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfc3RyZWV0XCI+UGluZ2xlIENvdHRhZ2U8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY2l0eVwiPk1hY2NsZXNmaWVsZDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHlcIj5DaGVzaGlyZTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jb3VudHJ5XCI+VUs8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfcG9zdGNvZGVcIj5TSzExIDBRRTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF93ZWJzaXRlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuZGFuZWJyaWRnZWZpc2hlcmllcy5jb21cIiB0aXRsZT1cIkRhbmVicmlkZ2UgRmlzaGVyaWVzXCIgdGFyZ2V0PVwiX2JsYW5rXCI+V2Vic2l0ZTwvYT48L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfdHlwZV9sYWJlbFwiPlR5cGU6PC9zcGFuPiBcbjx1bCBjbGFzcyA9IFwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVcIj5cbgk8bGk+RmlzaGVyeTwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wNS0wLXN0YXIucG5nXCIgYWx0PVwiMTBcIiAgIC8+PC9zcGFuPlJldmlld3M6IDA8L3NwYW4+PC90ZD5cbgkJCTwvdHI+XG4JCTwvdGFibGU+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7IGJvcmRlci1zdHlsZTogc29saWQ7IGJvcmRlci1jb2xvcjogIzU1NTU1XCc+XG4JCQkJCTxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTE1N1wiID48aW1nIHNyYz1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2ltYWdlcy9jb21fc29iaTIvY2xpZW50cy8xNTdfaWNvLmpwZ1wiIGFsdD1cIkRhbmVzIENhc3QgRmlzaGVyeVwiIHRpdGxlPVwiRGFuZXMgQ2FzdCBGaXNoZXJ5XCIgLz48L2E+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJJdGVtVGl0bGVcIj48YSBocmVmPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9zb2JpMlRhc2s9c29iaTJEZXRhaWxzJmFtcDtjYXRpZD0xOCZhbXA7c29iaTJJZD0xNTdcIiAgdGl0bGU9XCJEYW5lcyBDYXN0IEZpc2hlcnlcIiA+RGFuZXMgQ2FzdCBGaXNoZXJ5PC9hPjwvcD5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9zdHJlZXRcIj4xMjFUYW5kcmFnZWUgUm9hZDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+SmVycmV0dHNwYXNzPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50eVwiPk5vcnRoZXJuIElyZWxhbmQ8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnRyeVwiPk5vcnRoZXJuIElyZWxhbmQ8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfcG9zdGNvZGVcIj4uPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3R5cGVfbGFiZWxcIj5UeXBlOjwvc3Bhbj4gXG48dWwgY2xhc3MgPSBcInNvYmkyTGlzdGluZ19maWVsZF90eXBlXCI+XG4JPGxpPkZpc2hlcnk8L2xpPlxuCTxsaT5UYWNrbGUgU2hvcDwvbGk+XG48L3VsPlxuCQk8dGFibGUgY2xhc3M9XCdzb2JpMkxpc3RpbmdfcGx1Z2luc1wnPlxuCQkJPHRyPjx0ZCBjbGFzcz1cJ3NvYmlfZ2FsbGVyeV9WQ1wnPjwvdGQ+PHRkIGNsYXNzPVwnc29iaV9yZXZpZXdzX1ZDXCc+PHNwYW4gY2xhc3M9XCJzb2JpMlJhdGluZ1wiPjxzcGFuIGNsYXNzPVwnc29iaVJhdGluZ1wnPjxpbWcgc3JjPVwiaHR0cDovL3d3dy5maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50cy9jb21fc29iaTIvcGx1Z2lucy9yZXZpZXdzL2ltYWdlcy9TdGFyLVJhdGluZy8wMC0wLXN0YXIucG5nXCIgYWx0PVwiMFwiICAgLz48L3NwYW4+UmV2aWV3czogMDwvc3Bhbj48L3RkPlxuCQkJPC90cj5cbgkJPC90YWJsZT5cbgkJCQk8L3RkPlxuCQkJPC90cj5cbgkJCTx0cj5cbgkJCQk8dGQgc3R5bGU9XCd3aWR0aDogMTAwJTsgYm9yZGVyLXN0eWxlOiBzb2xpZDsgYm9yZGVyLWNvbG9yOiAjNTU1NTVcJz5cbgkJCQkJPGEgaHJlZj1cImh0dHA6Ly93d3cuZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/c29iaTJUYXNrPXNvYmkyRGV0YWlscyZhbXA7Y2F0aWQ9MTgmYW1wO3NvYmkySWQ9ODNcIiA+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9pbWFnZXMvY29tX3NvYmkyL2NsaWVudHMvODNfaWNvLmpwZ1wiIGFsdD1cIkRheSBIb3VzZSBGYXJtIEZpc2hlcnlcIiB0aXRsZT1cIkRheSBIb3VzZSBGYXJtIEZpc2hlcnlcIiAvPjwvYT5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkl0ZW1UaXRsZVwiPjxhIGhyZWY9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP3NvYmkyVGFzaz1zb2JpMkRldGFpbHMmYW1wO2NhdGlkPTE4JmFtcDtzb2JpMklkPTgzXCIgIHRpdGxlPVwiRGF5IEhvdXNlIEZhcm0gRmlzaGVyeVwiID5EYXkgSG91c2UgRmFybSBGaXNoZXJ5PC9hPjwvcD5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9zdHJlZXRcIj5PbGQgSG91c2UgTGFuZTwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF9jaXR5XCI+SGFsZXNvd2VuPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX2NvdW50eVwiPldlc3QgTWlkbGFuZHM8L3NwYW4+XG4JCQkJCTxici8+PHNwYW4gY2xhc3M9XCJzb2JpMkxpc3RpbmdfZmllbGRfY291bnRyeVwiPlVLPC9zcGFuPlxuCQkJCQk8YnIvPjxzcGFuIGNsYXNzPVwic29iaTJMaXN0aW5nX2ZpZWxkX3Bvc3Rjb2RlXCI+QjYyIDBFWDwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF93ZWJzaXRlXCI+PGEgaHJlZj1cImh0dHA6Ly93d3cuZGF5aG91c2VmYXJtZmlzaGVyeS5jb21cIiB0aXRsZT1cIkRheSBIb3VzZSBGYXJtIEZpc2hlcnlcIiB0YXJnZXQ9XCJfYmxhbmtcIj5XZWJzaXRlPC9hPjwvc3Bhbj5cbgkJCQkJPGJyLz48c3BhbiBjbGFzcz1cInNvYmkyTGlzdGluZ19maWVsZF90eXBlX2xhYmVsXCI+VHlwZTo8L3NwYW4+IFxuPHVsIGNsYXNzID0gXCJzb2JpMkxpc3RpbmdfZmllbGRfdHlwZVwiPlxuCTxsaT5GaXNoZXJ5PC9saT5cbjwvdWw+XG4JCTx0YWJsZSBjbGFzcz1cJ3NvYmkyTGlzdGluZ19wbHVnaW5zXCc+XG4JCQk8dHI+PHRkIGNsYXNzPVwnc29iaV9nYWxsZXJ5X1ZDXCc+PC90ZD48dGQgY2xhc3M9XCdzb2JpX3Jldmlld3NfVkNcJz48c3BhbiBjbGFzcz1cInNvYmkyUmF0aW5nXCI+PHNwYW4gY2xhc3M9XCdzb2JpUmF0aW5nXCc+PGltZyBzcmM9XCJodHRwOi8vd3d3LmZpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnRzL2NvbV9zb2JpMi9wbHVnaW5zL3Jldmlld3MvaW1hZ2VzL1N0YXItUmF0aW5nLzAwLTAtc3Rhci5wbmdcIiBhbHQ9XCIwXCIgICAvPjwvc3Bhbj5SZXZpZXdzOiAwPC9zcGFuPjwvdGQ+XG4JCQk8L3RyPlxuCQk8L3RhYmxlPlxuCQkJCTwvdGQ+XG4JCQk8L3RyPlxuCQk8L3RhYmxlPlxu', '', 'english', '16800' );
INSERT INTO `jos_sobi2_cache` ( `validtime` , `task` , `sid` , `cid` , `uid` , `limitstart` , `limitall` , `Itemid` , `section`, `params` , `html` , `opt`, `slang`, `schecksum` )
VALUES (1369447568, '-9', -9, -9, -9, 48, -9, -9, 'pagenav', '/sitecatid=18', 'PGRpdiBpZD1cInNvYmkyUGFnZU5hdlwiPiZsdDsmbHQ7IDxhIHRpdGxlPVwiU3RhcnRcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOFwiIGNsYXNzPVwicGFnZW5hdlwiPlN0YXJ0PC9hPiAmbHQ7IDxhIHRpdGxlPVwiUHJldlwiIGhyZWY9XCIvc2l0ZS9jb21wb25lbnQvc29iaTIvP2NhdGlkPTE4JmFtcDtzdGFydD00MFwiIGNsYXNzPVwicGFnZW5hdlwiPlByZXY8L2E+IDxhIHRpdGxlPVwiMVwiIGhyZWY9XCIvc2l0ZS9jb21wb25lbnQvc29iaTIvP2NhdGlkPTE4XCIgY2xhc3M9XCJwYWdlbmF2XCI+MTwvYT4gPGEgdGl0bGU9XCIyXCIgaHJlZj1cIi9zaXRlL2NvbXBvbmVudC9zb2JpMi8/Y2F0aWQ9MTgmYW1wO3N0YXJ0PThcIiBjbGFzcz1cInBhZ2VuYXZcIj4yPC9hPiA8YSB0aXRsZT1cIjNcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9MTZcIiBjbGFzcz1cInBhZ2VuYXZcIj4zPC9hPiA8YSB0aXRsZT1cIjRcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9MjRcIiBjbGFzcz1cInBhZ2VuYXZcIj40PC9hPiA8YSB0aXRsZT1cIjVcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9MzJcIiBjbGFzcz1cInBhZ2VuYXZcIj41PC9hPiA8YSB0aXRsZT1cIjZcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9NDBcIiBjbGFzcz1cInBhZ2VuYXZcIj42PC9hPiA8c3BhbiBjbGFzcz1cInBhZ2VuYXZcIj43PC9zcGFuPiA8YSB0aXRsZT1cIjhcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9NTZcIiBjbGFzcz1cInBhZ2VuYXZcIj44PC9hPiA8YSB0aXRsZT1cIjlcIiBocmVmPVwiL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOCZhbXA7c3RhcnQ9NjRcIiBjbGFzcz1cInBhZ2VuYXZcIj45PC9hPiA8YSB0aXRsZT1cIjEwXCIgaHJlZj1cIi9zaXRlL2NvbXBvbmVudC9zb2JpMi8/Y2F0aWQ9MTgmYW1wO3N0YXJ0PTcyXCIgY2xhc3M9XCJwYWdlbmF2XCI+MTA8L2E+IDxhIHRpdGxlPVwiTmV4dFwiIGhyZWY9XCIvc2l0ZS9jb21wb25lbnQvc29iaTIvP2NhdGlkPTE4JmFtcDtzdGFydD01NlwiIGNsYXNzPVwicGFnZW5hdlwiPk5leHQ8L2E+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