SELECT *
FROM jos7_session
WHERE session_id = '096fea52bcf239bc11bbb1cb4a706cfb'
DELETE
FROM jos7_session
WHERE ( time < '1328705736' )
SELECT *
FROM jos7_session
WHERE session_id = '096fea52bcf239bc11bbb1cb4a706cfb'
UPDATE `jos7_session`
SET `time`='1328706636',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:179;s:19:\"session.timer.start\";i:1328702035;s:18:\"session.timer.last\";i:1328706590;s:17:\"session.timer.now\";i:1328706613;s:24:\"session.client.forwarded\";s:14:\"38.107.179.210\";s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:74:\"/home/accent6/data/www/accent6.com/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"6e89940b4b3e5cd7a73accc736acf962\";}aliro_auth|a:5:{s:10:\"subj_found\";a:0:{}s:11:\"permissions\";a:0:{}s:12:\"access_found\";a:0:{}s:12:\"access_roles\";a:0:{}s:5:\"timer\";i:1328702239;}'
WHERE session_id='096fea52bcf239bc11bbb1cb4a706cfb'
SELECT *
FROM jos7_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos7_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos7_menu AS m
LEFT JOIN jos7_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos7_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT hits
FROM jos7_core_log_searches
WHERE LOWER( search_term ) = "СФÐ"
INSERT INTO jos7_core_log_searches
VALUES ( "СФÐ", 1 )
SELECT a.title AS title, a.created AS created, CONCAT(a.introtext, a.`fulltext`) AS text, CONCAT_WS( "/", u.title, b.title ) AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END AS catslug, u.id AS sectionid, "2" AS browsernav
FROM jos7_content AS a
INNER JOIN jos7_categories AS b
ON b.id=a.catid
INNER JOIN jos7_sections AS u
ON u.id = a.sectionid
WHERE ( (LOWER(a.title) LIKE '%СФÐ%' OR LOWER(a.introtext) LIKE '%СФÐ%' OR LOWER(a.`fulltext`) LIKE '%СФÐ%' OR LOWER(a.metakey) LIKE '%СФÐ%' OR LOWER(a.metadesc) LIKE '%СФÐ%') )
AND a.state = 1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 13:10:36' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 13:10:36' )
GROUP BY a.id
ORDER BY a.created DESC
LIMIT 0, 50
SELECT id, a.title AS title, a.created AS created, a.introtext AS text, "2" AS browsernav, "'Материалы без категорий'" AS section
FROM jos7_content AS a
WHERE ((LOWER(a.title) LIKE '%СФÐ%' OR LOWER(a.introtext) LIKE '%СФÐ%' OR LOWER(a.`fulltext`) LIKE '%СФÐ%' OR LOWER(a.metakey) LIKE '%СФÐ%' OR LOWER(a.metadesc) LIKE '%СФÐ%'))
AND a.state = 1
AND a.access <= 0
AND a.sectionid = 0
AND a.catid = 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 13:10:36' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 13:10:36' )
ORDER BY a.created DESC
LIMIT 0, 50
SELECT a.title AS title, a.created AS created, a.introtext AS text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END AS catslug, u.id AS sectionid, "2" AS browsernav
FROM jos7_content AS a
INNER JOIN jos7_categories AS b
ON b.id=a.catid
AND b.access <= 0
INNER JOIN jos7_sections AS u
ON u.id = a.sectionid
WHERE ( (LOWER(a.title) LIKE '%СФÐ%' OR LOWER(a.introtext) LIKE '%СФÐ%' OR LOWER(a.`fulltext`) LIKE '%СФÐ%' OR LOWER(a.metakey) LIKE '%СФÐ%' OR LOWER(a.metadesc) LIKE '%СФÐ%') )
AND a.state = -1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 13:10:36' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 13:10:36' )
ORDER BY a.created DESC
LIMIT 0, 50
SELECT a.title AS title, a.description AS text, a.date AS created, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END AS catslug, CONCAT_WS( " / ", 'Ссылки', b.title ) AS section, "1" AS browsernav
FROM jos7_weblinks AS a
INNER JOIN jos7_categories AS b
ON b.id = a.catid
WHERE ((LOWER(a.url) LIKE '%СФÐ%' OR LOWER(a.description) LIKE '%СФÐ%' OR LOWER(a.title) LIKE '%СФÐ%'))
AND a.published = 1
AND b.published = 1
AND b.access <= 0
ORDER BY a.date DESC
LIMIT 0, 50
SELECT a.name AS title, "" AS created, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END AS catslug, CONCAT_WS( ", ", a.name, a.con_position, a.misc ) AS text, CONCAT_WS( " / ", 'Контакт', b.title ) AS section, "2" AS browsernav
FROM jos7_contact_details AS a
INNER JOIN jos7_categories AS b
ON b.id = a.catid
WHERE ( a.name LIKE '%СФÐ%' OR a.misc LIKE '%СФÐ%' OR a.con_position LIKE '%СФÐ%' OR a.address LIKE '%СФÐ%' OR a.suburb LIKE '%СФÐ%' OR a.state LIKE '%СФÐ%' OR a.country LIKE '%СФÐ%' OR a.postcode LIKE '%СФÐ%' OR a.telephone LIKE '%СФÐ%' OR a.fax LIKE '%СФÐ%' )
AND a.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 0, 50
SELECT a.title, a.description AS text, "" AS created, "2" AS browsernav, s.id AS secid, a.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
FROM jos7_categories AS a
INNER JOIN jos7_sections AS s
ON s.id = a.section
WHERE ( a.name LIKE '%СФÐ%' OR a.title LIKE '%СФÐ%' OR a.description LIKE '%СФÐ%' )
AND a.published = 1
AND s.published = 1
AND a.access <= 0
AND s.access <= 0
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 0, 50
SELECT a.title AS title, a.description AS text, "" AS created, "2" AS browsernav, a.id AS secid
FROM jos7_sections AS a
WHERE ( a.name LIKE '%СФÐ%' OR a.title LIKE '%СФÐ%' OR a.description LIKE '%СФÐ%' )
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 0, 50
SELECT a.name AS title, "" AS created, a.link AS text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END AS catslug, CONCAT_WS( " / ", 'Ленты новостей', b.title )AS section, "1" AS browsernav
FROM jos7_newsfeeds AS a
INNER JOIN jos7_categories AS b
ON b.id = a.catid
WHERE ( (LOWER(a.name) LIKE '%СФÐ%' OR LOWER(a.link) LIKE '%СФÐ%') )
AND a.published = 1
AND b.published = 1
AND b.access <= 0
ORDER BY a.name ASC
LIMIT 0, 50
SELECT id, title, module, position, content, showtitle, control, params
FROM jos7_modules AS m
LEFT JOIN jos7_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 = 0 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT parent, menutype, ordering
FROM jos7_menu
WHERE id = 0
LIMIT 1
SELECT count(*)
FROM jos7_menu AS m
WHERE menutype='mainmenu'
AND published='1'
AND access <= '0'
AND parent=0
AND ordering < 0
SELECT `title` , `introtext` , `fulltext`
FROM jos7_content
WHERE state = 1
LIMIT 0,100
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos7_content AS a
INNER JOIN jos7_categories AS cc
ON cc.id = a.catid
INNER JOIN jos7_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 13:10:36' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 13:10:36' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (s.id=11)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
SELECT bid, imageurl, custombannercode
FROM jos7_banner
WHERE showBanner = '1'
AND (catid IN (70))
ORDER BY bid
SELECT bid, imageurl, custombannercode
FROM jos7_banner
WHERE showBanner = '1'
AND (catid IN (66))
ORDER BY bid