SELECT *
FROM jon_session
WHERE session_id = 'c95bafc8e3446b56ad4bd432ce1cda1a'
DELETE
FROM jon_session
WHERE ( TIME < '1711627036' )
SELECT *
FROM jon_session
WHERE session_id = 'c95bafc8e3446b56ad4bd432ce1cda1a'
INSERT INTO `jon_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'c95bafc8e3446b56ad4bd432ce1cda1a','1711627936','','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 = 53)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT COUNT(*)
FROM jon_kunena_whoisonline
WHERE userip='52.91.67.23'
AND userid='0'
SELECT subject
FROM jon_kunena_messages
WHERE id='507'
DELETE
FROM jon_kunena_whoisonline
WHERE TIME < '1711615336'
INSERT INTO jon_kunena_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`)
VALUES ('0','1711617136','•читает сообщение:• Сабантуй»: трезвый или пьяный?','','','view','https://yanzori.ru/index.php?option=com_kunena&func=view&catid=7&id=507&Itemid=53','52.91.67.23','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 a.*, b.*, p.id AS poll_id, modified.name AS modified_name, modified.username AS modified_username
FROM jon_kunena_messages AS a
LEFT JOIN jon_kunena_messages_text AS b
ON a.id=b.mesid
LEFT JOIN jon_users AS modified
ON a.modified_by = modified.id
LEFT JOIN jon_kunena_polls AS p
ON a.id=p.threadid
WHERE a.id='507'
AND a.hold IN (0)
SELECT *
FROM jon_kunena_categories
WHERE id='7'
SELECT id, name
FROM jon_kunena_categories
WHERE id='6'
SELECT code, `location`
FROM jon_kunena_smileys
UPDATE jon_kunena_messages
SET hits=hits+1
WHERE id='507'
AND parent='0'
SELECT COUNT(*)
FROM jon_kunena_messages AS a
WHERE a.thread='507'
AND a.hold IN (0)
SELECT a.*, b.*, modified.name AS modified_name, modified.username AS modified_username
FROM jon_kunena_messages AS a
LEFT JOIN jon_kunena_messages_text AS b
ON a.id=b.mesid
LEFT JOIN jon_users AS modified
ON a.modified_by = modified.id
WHERE a.thread='507'
AND a.hold IN (0)
ORDER BY id ASC
LIMIT 0, 8
SELECT *
FROM jon_kunena_attachments
WHERE mesid IN (507,509,510,511,512,518,519,522)
ORDER BY id
SELECT code, `location`
FROM jon_kunena_smileys
SELECT MAX(userid='0') AS favorited, COUNT(*) AS totalfavorited
FROM jon_kunena_favorites
WHERE thread='507'
SELECT m.*, u.*
FROM jon_kunena_moderation AS m
INNER JOIN jon_users AS u
ON u.id=m.userid
WHERE m.catid='7'
AND u.block=0
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 (181,92,109,102,20676)
SELECT *
FROM jon_kunena_categories
WHERE id='7'
AND published='1'
SELECT *
FROM jon_kunena_categories
WHERE id='6'
AND published='1'
SELECT subject, id
FROM jon_kunena_messages
WHERE id='507'
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=view&catid=7&id=507&Itemid=53%'
AND w.func='view'
GROUP BY w.userid
ORDER BY u.username ASC
SELECT a.*,b.*,b.id AS poll_option_id
FROM jon_kunena_polls AS a
INNER JOIN jon_kunena_polls_options AS b
ON a.threadid=b.pollid
WHERE a.threadid='507'
SELECT SUM(votes)
FROM jon_kunena_polls_users
WHERE pollid='507'
SELECT pollid,userid,name,username
FROM jon_kunena_polls_users AS a
INNER JOIN jon_users AS b
ON a.userid=b.id
WHERE pollid='507'
SELECT pollid,userid,lasttime,votes,
TIMEDIFF(CURTIME(),DATE_FORMAT(lasttime, '%H:%i:%s')) AS timediff
FROM jon_kunena_polls_users
WHERE pollid='507'
AND userid='0'
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 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 = 98
SELECT u.id AS userid, m.catid
FROM jon_users AS u
INNER JOIN jon_kunena_users AS ku
ON u.id=ku.userid
LEFT JOIN jon_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jon_kunena_categories AS c
ON m.catid=c.id
WHERE u.block='0'
AND ku.moderator='1'
AND (m.catid IS NULL OR c.moderated='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 = 124
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 = 153
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 = 179
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 = 181
SELECT *
FROM jon_kunena_ranks
SELECT u.username, u.id
FROM jon_users AS u
LEFT JOIN jon_kunena_thankyou AS s
ON u.id = s.userid
WHERE s.postid='509'
LIMIT 0, 10
SELECT s.userid, s.TIME
FROM jon_session AS s
INNER JOIN jon_kunena_users AS k
ON k.userid=s.userid
WHERE s.client_id=0
AND s.userid>0
GROUP BY s.userid
ORDER BY s.TIME DESC
SELECT u.username, u.id
FROM jon_users AS u
LEFT JOIN jon_kunena_thankyou AS s
ON u.id = s.userid
WHERE s.postid='510'
LIMIT 0, 10
SELECT u.username, u.id
FROM jon_users AS u
LEFT JOIN jon_kunena_thankyou AS s
ON u.id = s.userid
WHERE s.postid='512'
LIMIT 0, 10
SELECT u.username, u.id
FROM jon_users AS u
LEFT JOIN jon_kunena_thankyou AS s
ON u.id = s.userid
WHERE s.postid='518'
LIMIT 0, 10
SELECT u.username, u.id
FROM jon_users AS u
LEFT JOIN jon_kunena_thankyou AS s
ON u.id = s.userid
WHERE s.postid='519'
LIMIT 0, 10
SELECT u.username, u.id
FROM jon_users AS u
LEFT JOIN jon_kunena_thankyou AS s
ON u.id = s.userid
WHERE s.postid='522'
LIMIT 0, 10
SELECT *
FROM jon_kunena_categories
WHERE id IN (1,4,5,6,7)
ORDER BY ordering, name