SELECT *
FROM jon_session
WHERE session_id = '341b1b61af36e184da8a0317ef6d4867'
DELETE
FROM jon_session
WHERE ( TIME < '1711666519' )
SELECT *
FROM jon_session
WHERE session_id = '341b1b61af36e184da8a0317ef6d4867'
INSERT INTO `jon_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '341b1b61af36e184da8a0317ef6d4867','1711667419','','0','1','0' )
SELECT *
FROM jon_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jon_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT name,player_id,ripper_id,postreplace
FROM jon_avr_tags
SELECT name,player_id,ripper_id,postreplace
FROM jon_avr_tags
SELECT template
FROM jon_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 64)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jon_kunena_config
SELECT DISTINCT g2.id
FROM jon_core_acl_aro AS o
INNER JOIN jon_core_acl_groups_aro_map AS gm
ON gm.aro_id=o.id
INNER JOIN jon_core_acl_aro_groups AS g1
ON g1.id = gm.group_id
INNER JOIN jon_core_acl_aro_groups AS g2
ON (g2.lft <= g1.lft
AND g2.rgt >= g1.rgt)
WHERE (o.section_value='users'
AND o.VALUE='0')
SELECT c.*
FROM jon_kunena_categories AS c
SELECT m.id, m.subject AS title, m.catid, m.thread, m.name, m.TIME AS created, t.mesid, t.message AS text, m.ordering, mm.hits, c.name AS SECTION, 1 AS browsernav
FROM jon_kunena_messages_text AS t
INNER JOIN jon_kunena_messages AS m
ON m.id=t.mesid
INNER JOIN jon_kunena_messages AS mm
ON mm.id=m.thread
INNER JOIN jon_kunena_categories AS c
ON m.catid = c.id
WHERE (m.subject LIKE '%поиск%' OR t.message LIKE '%поиск%')
AND (m.subject LIKE '%сайту%' OR t.message LIKE '%сайту%')
AND m.moved=0
AND m.hold=0
AND mm.hold=0
AND mm.catid IN (1,4,5,6,7)
GROUP BY m.thread
ORDER BY m.subject ASC, created DESC
LIMIT 0, 50
SELECT a.title AS title, a.metadesc, a.metakey, 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 jon_content AS a
INNER JOIN jon_categories AS b
ON b.id=a.catid
INNER JOIN jon_sections AS u
ON u.id = a.sectionid
WHERE ( (a.title LIKE '%поиск%' OR a.introtext LIKE '%поиск%' OR a.fulltext LIKE '%поиск%' OR a.metakey LIKE '%поиск%' OR a.metadesc LIKE '%поиск%')
AND (a.title LIKE '%сайту%' OR a.introtext LIKE '%сайту%' OR a.fulltext LIKE '%сайту%' OR a.metakey LIKE '%сайту%' OR 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 <= '2024-03-28 23:10:20' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 23:10:20' )
GROUP BY a.id
ORDER BY a.created DESC
LIMIT 0, 50
SELECT id, a.title AS title, a.created AS created, a.metadesc, a.metakey, CONCAT(a.introtext, a.fulltext) AS text, "2" AS browsernav, "•Содержимое без категорий•" AS SECTION
FROM jon_content AS a
WHERE ((a.title LIKE '%поиск%' OR a.introtext LIKE '%поиск%' OR a.fulltext LIKE '%поиск%' OR a.metakey LIKE '%поиск%' OR a.metadesc LIKE '%поиск%')
AND (a.title LIKE '%сайту%' OR a.introtext LIKE '%сайту%' OR a.fulltext LIKE '%сайту%' OR a.metakey LIKE '%сайту%' OR 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 <= '2024-03-28 23:10:20' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 23:10:20' )
ORDER BY a.created DESC
LIMIT 0, 50
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext, a.fulltext) 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, CONCAT_WS( "/", u.title, b.title ) AS SECTION, "2" AS browsernav
FROM jon_content AS a
INNER JOIN jon_categories AS b
ON b.id=a.catid
AND b.access <= 0
INNER JOIN jon_sections AS u
ON u.id = a.sectionid
WHERE ( (a.title LIKE '%поиск%' OR a.introtext LIKE '%поиск%' OR a.fulltext LIKE '%поиск%' OR a.metakey LIKE '%поиск%' OR a.metadesc LIKE '%поиск%')
AND (a.title LIKE '%сайту%' OR a.introtext LIKE '%сайту%' OR a.fulltext LIKE '%сайту%' OR a.metakey LIKE '%сайту%' OR 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 <= '2024-03-28 23:10:20' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 23:10:20' )
ORDER BY a.created DESC
LIMIT 0, 50
SELECT a.title AS title, a.description AS text, a.DATE AS created, a.url, 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 jon_weblinks AS a
INNER JOIN jon_categories AS b
ON b.id = a.catid
WHERE ((a.url LIKE '%поиск%' OR a.description LIKE '%поиск%' OR a.title LIKE '%поиск%')
AND (a.url LIKE '%сайту%' OR a.description LIKE '%сайту%' OR 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 jon_contact_details AS a
INNER JOIN jon_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, a.name, "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 jon_categories AS a
INNER JOIN jon_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, a.name, "" AS created, "2" AS browsernav, a.id AS secid
FROM jon_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 jon_newsfeeds AS a
INNER JOIN jon_categories AS b
ON b.id = a.catid
WHERE ( (a.name LIKE '%поиск%' OR a.link LIKE '%поиск%')
AND (a.name LIKE '%сайту%' OR a.link LIKE '%сайту%') )
AND a.published = 1
AND b.published = 1
AND b.access <= 0
ORDER BY a.name ASC
LIMIT 0, 50