SELECT *
FROM jos7_session
WHERE session_id = 'a36288bd22cee3382283f6339fc0b861'
DELETE
FROM jos7_session
WHERE ( time < '1328477745' )
SELECT *
FROM jos7_session
WHERE session_id = 'a36288bd22cee3382283f6339fc0b861'
UPDATE `jos7_session`
SET `time`='1328478645',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:215;s:19:\"session.timer.start\";i:1328469514;s:18:\"session.timer.last\";i:1328478602;s:17:\"session.timer.now\";i:1328478623;s:24:\"session.client.forwarded\";s:14:\"38.107.179.243\";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:\"47b708bf68de92f8649a3143edc163d5\";}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:1328470235;}'
WHERE session_id='a36288bd22cee3382283f6339fc0b861'
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 ) = "дней"
UPDATE jos7_core_log_searches
SET hits = ( hits + 1 )
WHERE LOWER( search_term ) = "дней"
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-05 21:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 21:50:45' )
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-05 21:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 21:50:45' )
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-05 21:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 21:50:45' )
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-05 21:50:45' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 21:50:45' )
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
