SELECT *
FROM jos7_session
WHERE session_id = '5a00125ca615786d06df11a138bbfa5d'
DELETE
FROM jos7_session
WHERE ( time < '1328787868' )
SELECT *
FROM jos7_session
WHERE session_id = '5a00125ca615786d06df11a138bbfa5d'
UPDATE `jos7_session`
SET `time`='1328788768',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:10;s:19:\"session.timer.start\";i:1328788492;s:18:\"session.timer.last\";i:1328788719;s:17:\"session.timer.now\";i:1328788742;s:24:\"session.client.forwarded\";s:14:\"38.107.179.240\";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:{}}}'
WHERE session_id='5a00125ca615786d06df11a138bbfa5d'
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-09 11:59:28' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 11:59:28' )
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-09 11:59:28' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 11:59:28' )
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-09 11:59:28' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 11:59:28' )
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-09 11:59:28' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 11:59:28' )
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