SELECT *
FROM jon_session
WHERE session_id = '69a4c9e39296cfdb23aabeff19975a1f'
DELETE
FROM jon_session
WHERE ( TIME < '1713559537' )
SELECT *
FROM jon_session
WHERE session_id = '69a4c9e39296cfdb23aabeff19975a1f'
INSERT INTO `jon_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '69a4c9e39296cfdb23aabeff19975a1f','1713560437','','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 = 0)
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 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-04-19 21:00:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 21:00:37' )
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-04-19 21:00:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 21:00:37' )
ORDER BY a.created DESC
LIMIT 0, 29
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-04-19 21:00:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 21:00:37' )
ORDER BY a.created DESC
LIMIT 0, 29
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
