SELECT *
FROM jos_session
WHERE session_id = 'pd1cu34b0pvhm2vv4l802p7cr2'
DELETE
FROM jos_session
WHERE ( time < '1371673874' )
SELECT *
FROM jos_session
WHERE session_id = 'pd1cu34b0pvhm2vv4l802p7cr2'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'pd1cu34b0pvhm2vv4l802p7cr2','1371677474','','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&Itemid=2%' OR sefurl LIKE 'option=com\_sobi2&Itemid=2%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_sobi2&Itemid=2%' OR sefurl LIKE 'index.php?option=com\_sobi2&Itemid=2%'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT `configValue`, `configKey`
FROM `jos_sobi2_config`
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%index.php?option=com_sobi2%'
AND `type` = 'component'
AND `published` = '1'
LIMIT 1
SELECT *
FROM `jos_sobi2_language`
ORDER BY `sobi2Lang`
SELECT `configValue`
FROM `jos_sobi2_config`
WHERE (`configKey` = 'checkReferer'
AND `sobi2Section` = 'editForm')
SELECT `configValue`
FROM `jos_sobi2_config`
WHERE (`configKey` = 'needToConfirmNew'
AND `sobi2Section` = 'editForm')
SELECT `init_file`, `name_id`
FROM `jos_sobi2_plugins`
WHERE `enabled` = 1
ORDER BY `position` ASC
SELECT `configValue`
FROM `jos_sobi2_config`
WHERE (`configKey` = 'RtextLimit'
AND `sobi2Section` = 'sobi_reviews')
SELECT catid, name, introtext, description
FROM `jos_sobi2_categories`
WHERE `catid`=1
SELECT parentid
FROM `jos_sobi2_cats_relations`
WHERE `catid`=1
SELECT html, schecksum
FROM `jos_sobi2_cache`
WHERE ( validtime > 1371245474
AND task ='-9'
AND sid = -9
AND cid = -9
AND uid = -9
AND limitstart = -9
AND limitall = -9
AND Itemid = -9
AND params = '/siteItemid=2'
AND section = 'componentdescr'
AND slang = 'english')
ORDER BY validtime
LIMIT 1
SELECT *
FROM `jos_sobi2_categories`
WHERE `catid` = 1
LIMIT 1
SELECT *
FROM jos_rereplacer
WHERE published = 1
ORDER BY ordering
INSERT INTO `jos_sobi2_cache` ( `validtime` , `task` , `sid` , `cid` , `uid` , `limitstart` , `limitall` , `Itemid` , `section`, `params` , `html` , `opt`, `slang`, `schecksum` )
VALUES (1371677475, '-9', -9, -9, -9, -9, -9, -9, 'componentdescr', '/siteItemid=2', 'XG5cblxuPHRhYmxlIGNsYXNzPVwic29iaTJDb21wRGVzY1wiPlxuCTx0cj5cbgkJPHRkPjxwPkVuam95IGJyb3dzaW5nIHRoZSBmaXNoaW5nIGRpcmVjdG9yeSBvciB0eXBlIHdoYXQgeW91IGFyZSBsb29raW5nIGZvciBzdHJhaWdodCAgIGludG8gdGhlIFwnS2V5ICBXb3JkICBTZWFyY2hcJy48L3A+XHJcbjxiciAvPiBcclxuPHRhYmxlIGFsaWduPVwiY2VudGVyXCIgYm9yZGVyPVwiMFwiPlxyXG48dGJvZHk+XHJcbjx0cj5cclxuPHRkPjxhIHRhcmdldD1cIl9zZWxmXCIgaHJlZj1cImluZGV4LnBocD9vcHRpb249Y29tX3NvYmkyJmNhdGlkPTE4Jkl0ZW1pZD0yXCI+PGltZyBzdHlsZT1cImJvcmRlcjogMXB4IHNvbGlkICMwMDAwMDA7XCIgc3JjPVwiaW1hZ2VzL3N0b3JpZXMvbGluZ21lcmVfZmlzaGVyaWVzLmpwZ1wiIC8+PC9hPjwvdGQ+XHJcbjx0ZD48YSB0YXJnZXQ9XCJfc2VsZlwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0xOSZJdGVtaWQ9MlwiPjxpbWcgc3R5bGU9XCJib3JkZXI6IDFweCBzb2xpZCAjMDAwMDAwO1wiIHNyYz1cImltYWdlcy9zdG9yaWVzL3RhY2tsZV9zaG9wLmpwZ1wiIC8+PC9hPjwvdGQ+XHJcbjx0ZD48YSB0YXJnZXQ9XCJfc2VsZlwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0yMyZJdGVtaWQ9MlwiPjxpbWcgc3R5bGU9XCJib3JkZXI6IDFweCBzb2xpZCAjMDAwMDAwO1wiIHNyYz1cImltYWdlcy9zdG9yaWVzL2JlZCBhbmQgYnJlYWtmYXN0Mi5qcGdcIiAvPjwvYT48L3RkPlxyXG48L3RyPlxyXG48dHI+XHJcbjx0ZCBzdHlsZT1cInRleHQtYWxpZ246IGNlbnRlcjtcIj48YSB0YXJnZXQ9XCJfc2VsZlwiIGhyZWY9XCJodHRwOi8vZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2luZGV4LnBocD9vcHRpb249Y29tX3NvYmkyJmNhdGlkPTE4Jkl0ZW1pZD0yXCI+RmlzaGVyaWVzPC9hPjwvdGQ+XHJcbjx0ZCBzdHlsZT1cInRleHQtYWxpZ246IGNlbnRlcjtcIj48YSB0YXJnZXQ9XCJfc2VsZlwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0xOSZJdGVtaWQ9MlwiPlRhY2tsZSBTaG9wczwvYT48L3RkPlxyXG48dGQgc3R5bGU9XCJ0ZXh0LWFsaWduOiBjZW50ZXI7XCI+PGEgdGFyZ2V0PVwiX3NlbGZcIiBocmVmPVwiaW5kZXgucGhwP29wdGlvbj1jb21fc29iaTImY2F0aWQ9MjMmSXRlbWlkPTJcIj5CJkJcJ3M8L2E+PC90ZD5cclxuPC90cj5cclxuPHRyPlxyXG48dGQgc3R5bGU9XCJ0ZXh0LWFsaWduOiBjZW50ZXI7XCI+PGEgdGFyZ2V0PVwiX3BhcmVudFwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0xOCZJdGVtaWQ9MlwiPjwvYT48L3RkPlxyXG48dGQgc3R5bGU9XCJ0ZXh0LWFsaWduOiBjZW50ZXI7XCI+PGEgdGFyZ2V0PVwiX3BhcmVudFwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0xOCZJdGVtaWQ9MlwiPjwvYT48L3RkPlxyXG48dGQgc3R5bGU9XCJ0ZXh0LWFsaWduOiBjZW50ZXI7XCI+PGEgdGFyZ2V0PVwiX3NlbGZcIiBocmVmPVwiaW5kZXgucGhwP29wdGlvbj1jb21fc29iaTImY2F0aWQ9MjMmSXRlbWlkPTJcIj48L2E+PC90ZD5cclxuPC90cj5cclxuPHRyPlxyXG48dGQgc3R5bGU9XCJ0ZXh0LWFsaWduOiBjZW50ZXI7XCI+PGEgdGFyZ2V0PVwiX3BhcmVudFwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0yMiZJdGVtaWQ9MlwiPjxpbWcgc3R5bGU9XCJib3JkZXI6IDFweCBzb2xpZCAjMDAwMDAwO1wiIHNyYz1cImltYWdlcy9zdG9yaWVzL2Zpc2hlcmllc19hY2NvbW0uanBnXCIgLz48L2E+PC90ZD5cclxuPHRkIHN0eWxlPVwidGV4dC1hbGlnbjogY2VudGVyO1wiPjxhIHRhcmdldD1cIl9zZWxmXCIgaHJlZj1cImluZGV4LnBocD9vcHRpb249Y29tX3NvYmkyJmNhdGlkPTI0Jkl0ZW1pZD0yXCI+PGltZyBzdHlsZT1cImJvcmRlcjogMXB4IHNvbGlkICMwMDAwMDA7XCIgc3JjPVwiaW1hZ2VzL3N0b3JpZXMvZmlzaGluZ3dpdGhjYW1waW5nLmpwZ1wiIC8+PC9hPjwvdGQ+XHJcbjx0ZCBzdHlsZT1cInRleHQtYWxpZ246IGNlbnRlcjtcIj48YSB0YXJnZXQ9XCJfc2VsZlwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0yMSZJdGVtaWQ9MlwiPjxpbWcgc3R5bGU9XCJib3JkZXI6IDFweCBzb2xpZCAjMDAwMDAwO1wiIHNyYz1cImltYWdlcy9zdG9yaWVzL2Zpc2hlcmllc2ZvcnNhbGUuanBnXCIgLz48L2E+PC90ZD5cclxuPC90cj5cclxuPHRyPlxyXG48dGQgc3R5bGU9XCJ0ZXh0LWFsaWduOiBjZW50ZXI7XCI+PGEgdGFyZ2V0PVwiX3NlbGZcIiBocmVmPVwiaW5kZXgucGhwP29wdGlvbj1jb21fc29iaTImY2F0aWQ9MjImSXRlbWlkPTJcIj5GaXNoZXJpZXMgd2l0aCBhY2NvbW1vZGF0aW9uPC9hPjwvdGQ+XHJcbjx0ZCBzdHlsZT1cInRleHQtYWxpZ246IGNlbnRlcjtcIj48YSB0YXJnZXQ9XCJfc2VsZlwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0yNCZJdGVtaWQ9MlwiPkZpc2hpbmcgd2l0aCBjYW1waW5nPC9hPjxiciAvPjwvdGQ+XHJcbjx0ZCBzdHlsZT1cInRleHQtYWxpZ246IGNlbnRlcjtcIj48YSB0YXJnZXQ9XCJfc2VsZlwiIGhyZWY9XCJpbmRleC5waHA/b3B0aW9uPWNvbV9zb2JpMiZjYXRpZD0yMSZJdGVtaWQ9MlwiPkZpc2hlcmllcyBmb3Igc2FsZTwvYT48L3RkPlxyXG48L3RyPlxyXG48L3Rib2R5PlxyXG48L3RhYmxlPlxuCQk8L3RkPlxuCTwvdHI+XG5cblxuPC90YWJsZT4=', '', 'english', '3688' );
SELECT html, schecksum
FROM `jos_sobi2_cache`
WHERE ( validtime > 1371245475
AND task ='-9'
AND sid = -9
AND cid = -9
AND uid = -9
AND limitstart = -9
AND limitall = -9
AND Itemid = -9
AND params = '/siteItemid=2'
AND section = 'catlist'
AND slang = 'english')
ORDER BY validtime
LIMIT 1
SELECT relations.catid
FROM `jos_sobi2_categories`
LEFT JOIN `jos_sobi2_cats_relations` AS relations
ON `jos_sobi2_categories`.catid = relations.catid
WHERE `parentid` = 1
AND `published` = 1
ORDER BY ordering ASC
SELECT *
FROM jos_sobi2_categories
WHERE catid IN(18 , 19 , 22 , 24 , 23 , 21 , 25)
AND published = 1
ORDER BY ordering ASC
INSERT INTO `jos_sobi2_cache` ( `validtime` , `task` , `sid` , `cid` , `uid` , `limitstart` , `limitall` , `Itemid` , `section`, `params` , `html` , `opt`, `slang`, `schecksum` )
VALUES (1371677475, '-9', -9, -9, -9, -9, -9, -9, 'catlist', '/siteItemid=2', 'XG4JPHRhYmxlIGlkPVwnc29iaTJDYXRMaXN0U3ltYm9sc1wnPlxuCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7XCc+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJDYXROYW1lXCI+PGEgaHJlZj1cImh0dHA6Ly9maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOFwiPkZpc2hlcmllczwvYT48L3A+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJDYXRzTGlzdFN5bWJvbHNJbnRyb3RleHRcIj48L3A+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7XCc+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJDYXROYW1lXCI+PGEgaHJlZj1cImh0dHA6Ly9maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0xOVwiPlRhY2tsZSBTaG9wczwvYT48L3A+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJDYXRzTGlzdFN5bWJvbHNJbnRyb3RleHRcIj48L3A+XG4JCQkJPC90ZD5cbgkJCTwvdHI+XG4JCQk8dHI+XG4JCQkJPHRkIHN0eWxlPVwnd2lkdGg6IDEwMCU7XCc+XG4JCQkJCTxwIGNsYXNzPVwic29iaTJDYXROYW1lXCI+PGEgaHJlZj1cImh0dHA6Ly9maXNoZXJpZXNkaXJlY3QuY29tL3NpdGUvY29tcG9uZW50L3NvYmkyLz9jYXRpZD0yMlwiPkZpc2hpbmcgd2l0aCBhY2NvbW1vZGF0aW9uPC9hPjwvcD5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkNhdHNMaXN0U3ltYm9sc0ludHJvdGV4dFwiPjwvcD5cbgkJCQk8L3RkPlxuCQkJPC90cj5cbgkJCTx0cj5cbgkJCQk8dGQgc3R5bGU9XCd3aWR0aDogMTAwJTtcJz5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkNhdE5hbWVcIj48YSBocmVmPVwiaHR0cDovL2Zpc2hlcmllc2RpcmVjdC5jb20vc2l0ZS9jb21wb25lbnQvc29iaTIvP2NhdGlkPTI0XCI+RmlzaGluZyB3aXRoIGNhbXBpbmc8L2E+PC9wPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkyQ2F0c0xpc3RTeW1ib2xzSW50cm90ZXh0XCI+PC9wPlxuCQkJCTwvdGQ+XG4JCQk8L3RyPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlO1wnPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkyQ2F0TmFtZVwiPjxhIGhyZWY9XCJodHRwOi8vZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/Y2F0aWQ9MjNcIj5CJkJcJ3M8L2E+PC9wPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkyQ2F0c0xpc3RTeW1ib2xzSW50cm90ZXh0XCI+PC9wPlxuCQkJCTwvdGQ+XG4JCQk8L3RyPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlO1wnPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkyQ2F0TmFtZVwiPjxhIGhyZWY9XCJodHRwOi8vZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/Y2F0aWQ9MjFcIj5GaXNoZXJpZXMgRm9yIFNhbGU8L2E+PC9wPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkyQ2F0c0xpc3RTeW1ib2xzSW50cm90ZXh0XCI+PC9wPlxuCQkJCTwvdGQ+XG4JCQk8L3RyPlxuCQkJPHRyPlxuCQkJCTx0ZCBzdHlsZT1cJ3dpZHRoOiAxMDAlO1wnPlxuCQkJCQk8cCBjbGFzcz1cInNvYmkyQ2F0TmFtZVwiPjxhIGhyZWY9XCJodHRwOi8vZmlzaGVyaWVzZGlyZWN0LmNvbS9zaXRlL2NvbXBvbmVudC9zb2JpMi8/Y2F0aWQ9MjVcIj5GaXNoaW5nIENsdWJzPC9hPjwvcD5cbgkJCQkJPHAgY2xhc3M9XCJzb2JpMkNhdHNMaXN0U3ltYm9sc0ludHJvdGV4dFwiPjwvcD5cbgkJCQk8L3RkPlxuCQk8L3RyPlxuCTwvdGFibGU+XG4=', '', 'english', '2332' );
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
