SELECT *
FROM jon_session
WHERE session_id = '4b4dfa0c402bbb42a2e18dbf93ed0726'
DELETE
FROM jon_session
WHERE ( TIME < '1711696755' )
SELECT *
FROM jon_session
WHERE session_id = '4b4dfa0c402bbb42a2e18dbf93ed0726'
INSERT INTO `jon_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '4b4dfa0c402bbb42a2e18dbf93ed0726','1711697655','','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 *
FROM jon_kunena_config
SELECT template
FROM jon_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 54)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT COUNT(*)
FROM jon_kunena_whoisonline
WHERE userip='35.170.54.171'
AND userid='0'
DELETE
FROM jon_kunena_whoisonline
WHERE TIME < '1711685055'
INSERT INTO jon_kunena_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`)
VALUES ('0','1711686855','•просматривает список категорий•','','','listcat','https://yanzori.ru/index.php?option=com_kunena&func=listcat&Itemid=54','35.170.54.171','0')
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.*, am.params AS adv_params
FROM jon_modules AS m
LEFT JOIN jon_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
ORDER BY m.ordering, m.id
SELECT *
FROM jon_kunena_categories
WHERE parent='0'
AND published='1'
AND id IN (1,4,5,6,7)
ORDER BY ordering, name
SELECT *
FROM jon_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
SELECT w.userid, w.func, u.username AS username, k.showOnline
FROM jon_kunena_whoisonline AS w
LEFT JOIN jon_users AS u
ON u.id=w.userid
LEFT JOIN jon_kunena_users AS k
ON k.userid=w.userid
WHERE w.link LIKE 'https://yanzori.ru/index.php?option=com_kunena&func=listcat&Itemid=54%'
AND w.func='listcat'
GROUP BY w.userid
ORDER BY u.username ASC
SELECT *
FROM jon_kunena_categories
WHERE id IN (1,4,5,6,7)
ORDER BY ordering, name
SELECT c.*, m.id AS mesid, m.thread, m.catid, t.subject AS topicsubject, m.subject, m.name AS mname, u.id AS userid, u.username, u.name AS uname,
(SELECT COUNT(*)
FROM jon_kunena_messages AS mm
WHERE m.thread=mm.thread) AS msgcount, 0 AS NEW
FROM jon_kunena_categories AS c
LEFT JOIN jon_kunena_messages AS m
ON c.id_last_msg=m.id
LEFT JOIN jon_kunena_messages AS t
ON m.thread=t.id
LEFT JOIN jon_users AS u
ON u.id=m.userid
WHERE c.parent IN (1,4,6)
AND c.published='1'
AND c.id IN(1,4,5,6,7)
ORDER BY ordering, name
SELECT c.id, c.name, c.description, c.parent, c.numTopics, c.numPosts, 0 AS NEW
FROM jon_kunena_categories AS c
WHERE c.parent IN (5,7)
AND c.published='1'
AND c.id IN(1,4,5,6,7)
ORDER BY c.ordering, c.name
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jon_users AS u
LEFT JOIN jon_kunena_users AS k
ON k.userid=u.id
INNER JOIN jon_session AS s
ON s.client_id=0
AND s.userid=u.id
AND s.userid>0
GROUP BY s.userid
ORDER BY username ASC
SELECT id, username AS username
FROM jon_users
WHERE block='0' OR activation=''
ORDER BY id DESC
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jon_users AS u
LEFT JOIN jon_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (92,20676)
SELECT code, `location`
FROM jon_kunena_smileys
SELECT u.id AS userid, 0 AS catid
FROM jon_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jon_users AS u
LEFT JOIN jon_kunena_users AS k
ON k.userid=u.id
INNER JOIN jon_session AS s
ON s.client_id=0
AND s.userid=u.id
AND s.userid>0
GROUP BY s.userid
ORDER BY username ASC
SELECT guest, TIME, usertype, client_id
FROM jon_session
WHERE client_id = 0
SELECT guest, TIME, usertype, client_id
FROM jon_session
WHERE client_id = 0
SELECT COUNT(*)
FROM jon_users
WHERE block=0
AND activation=''
SELECT SUM(TIME >= '1711659600'
AND parent='0') AS todayopen,
SUM(TIME >= '1711573200'
AND TIME < '1711659600'
AND parent='0') AS yesterdayopen,
SUM(TIME >= '1711659600'
AND parent>'0') AS todayanswer,
SUM(TIME >= '1711573200'
AND TIME < '1711659600'
AND parent>'0') AS yesterdayanswer
FROM jon_kunena_messages
WHERE TIME >= '1711573200'
AND hold='0'
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jon_kunena_categories
WHERE parent='0'
AND published=1
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jon_kunena_categories
WHERE published=1