SELECT *
FROM jos_session
WHERE session_id = '75tabitjmo6lsfgvlchrpfvei5'
DELETE
FROM jos_session
WHERE ( TIME < '1329944228' )
SELECT *
FROM jos_session
WHERE session_id = '75tabitjmo6lsfgvlchrpfvei5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '75tabitjmo6lsfgvlchrpfvei5','1329945128','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_kunena_config
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 4)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`
SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access IN (0)
AND TYPE = 'user'
ORDER BY ordering
SELECT COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='38.107.179.227'
AND userid='0'
DELETE
FROM jos_kunena_whoisonline
WHERE TIME < '1329943328'
INSERT INTO jos_kunena_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`)
VALUES ('0','1329945128','User is viewing recent discussions','','','latest','http://www.buzz50.co.uk/forum','38.107.179.227','0')
SELECT c.*
FROM jos_kunena_categories AS c
SELECT g1.id, g2.id AS parent
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
ORDER BY g1.lft
SELECT `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_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 = 2 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT COUNT(DISTINCT t.thread)
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0)
AND m.catid IN (241,2,5,6,7,8,9,12,15,17,238,19,20,21,24,25,26,28,29,30,31,32,35,237,37,176,40,42,43,44,46,49,56,57,58,259,64,65,66,67,68,69,70,72,81,83,84,85,80,86,87,88,89,90,91,92,93,94,95,96,97,103,98,101,104,105,106,108,109,110,111,112,114,115,116,117,119,121,144,189,185,152,157,158,169,164,182,173,236,186,190,188,192,258,194,195,196,198,199,201,202,203,205,207,224,208,209,210,214,215,216,218,265,266,223,225,226,229,234,239,1,243,244,245,246,247,248,249,250,254,251,252,253,255,257,260,261,263,264)
AND t.hold IN (0)
AND t.moved=0
AND t.catid IN (241,2,5,6,7,8,9,12,15,17,238,19,20,21,24,25,26,28,29,30,31,32,35,237,37,176,40,42,43,44,46,49,56,57,58,259,64,65,66,67,68,69,70,72,81,83,84,85,80,86,87,88,89,90,91,92,93,94,95,96,97,103,98,101,104,105,106,108,109,110,111,112,114,115,116,117,119,121,144,189,185,152,157,158,169,164,182,173,236,186,190,188,192,258,194,195,196,198,199,201,202,203,205,207,224,208,209,210,214,215,216,218,265,266,223,225,226,229,234,239,1,243,244,245,246,247,248,249,250,254,251,252,253,255,257,260,261,263,264)
AND m.catid NOT IN (184,234,205,192,35,173,32,30,31,195,196,198,199,95,12,185,251)
AND t.time>'1327353128'
SELECT m.id, MAX(t.id) AS lastid
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0)
AND m.catid IN (241,2,5,6,7,8,9,12,15,17,238,19,20,21,24,25,26,28,29,30,31,32,35,237,37,176,40,42,43,44,46,49,56,57,58,259,64,65,66,67,68,69,70,72,81,83,84,85,80,86,87,88,89,90,91,92,93,94,95,96,97,103,98,101,104,105,106,108,109,110,111,112,114,115,116,117,119,121,144,189,185,152,157,158,169,164,182,173,236,186,190,188,192,258,194,195,196,198,199,201,202,203,205,207,224,208,209,210,214,215,216,218,265,266,223,225,226,229,234,239,1,243,244,245,246,247,248,249,250,254,251,252,253,255,257,260,261,263,264)
AND t.hold IN (0)
AND t.moved='0'
AND t.catid IN (241,2,5,6,7,8,9,12,15,17,238,19,20,21,24,25,26,28,29,30,31,32,35,237,37,176,40,42,43,44,46,49,56,57,58,259,64,65,66,67,68,69,70,72,81,83,84,85,80,86,87,88,89,90,91,92,93,94,95,96,97,103,98,101,104,105,106,108,109,110,111,112,114,115,116,117,119,121,144,189,185,152,157,158,169,164,182,173,236,186,190,188,192,258,194,195,196,198,199,201,202,203,205,207,224,208,209,210,214,215,216,218,265,266,223,225,226,229,234,239,1,243,244,245,246,247,248,249,250,254,251,252,253,255,257,260,261,263,264)
AND m.catid NOT IN (184,234,205,192,35,173,32,30,31,195,196,198,199,95,12,185,251)
AND t.time>'1327353128'
GROUP BY t.thread
ORDER BY lastid DESC
LIMIT 0, 20
SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments,
l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx
FROM (
SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL
AND f.userid='0') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount,
COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='0', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='0', m.id, 0)) AS mylastid, MAX(m.TIME) AS lasttime
FROM jos_kunena_messages AS m
LEFT JOIN jos_kunena_favorites AS f
ON f.thread = m.thread
LEFT JOIN jos_kunena_attachments AS a
ON a.mesid = m.id
WHERE m.hold IN (0)
AND m.moved='0'
AND m.thread IN (1420231)
GROUP BY thread
) AS l
INNER JOIN jos_kunena_messages AS a
ON a.thread = l.thread
INNER JOIN jos_kunena_messages_text AS t
ON a.id = t.mesid
LEFT JOIN jos_users AS j
ON j.id = a.userid
LEFT JOIN jos_kunena_users AS u
ON u.userid = j.id
LEFT JOIN jos_kunena_categories AS c
ON c.id = a.catid
LEFT JOIN jos_kunena_attachments AS aa
ON aa.mesid = a.id
WHERE (a.parent='0' OR a.id=l.lastid )
GROUP BY a.id
ORDER BY lastid DESC
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id
INNER JOIN jos_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 jos_users
WHERE block=0 OR activation=""
ORDER BY id DESC
LIMIT 0, 1
SELECT u.name, u.username, u.block AS blocked, ku.*
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id IN (2325,4785)
SELECT *
FROM jos_kunena_categories
WHERE id IN (241,2,5,6,7,8,9,12,15,17,238,19,20,21,24,25,26,28,29,30,31,32,35,237,37,176,40,42,43,44,46,49,56,57,58,259,64,65,66,67,68,69,70,72,81,83,84,85,80,86,87,88,89,90,91,92,93,94,95,96,97,103,98,101,104,105,106,108,109,110,111,112,114,115,116,117,119,121,144,189,185,152,157,158,169,164,182,173,236,186,190,188,192,258,194,195,196,198,199,201,202,203,205,207,224,208,209,210,214,215,216,218,265,266,223,225,226,229,234,239,1,243,244,245,246,247,248,249,250,254,251,252,253,255,257,260,261,263,264)
AND published='1'
ORDER BY ordering, name
SELECT id, name, parent
FROM jos_kunena_categories
WHERE published=1
SELECT code, `location`
FROM jos_kunena_smileys
SELECT u.id AS userid, 0 AS catid
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
SELECT `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`
SELECT u.id AS userid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS ku
ON u.id=ku.userid
LEFT JOIN jos_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jos_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 `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`
SELECT *, u.id
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id IN (2325,4785)
SELECT `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published = 1
AND access IN (0)
SELECT username
FROM jos_users
WHERE id = 2325
LIMIT 0, 1
SELECT `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`
SELECT g1.`id` AS group_id, g1.`name`
FROM `jos_core_acl_aro_groups` AS g1
LEFT JOIN `jos_core_acl_aro_groups` AS g2
ON g2.`lft` >= g1.`lft`
WHERE g2.`id` = 29
ORDER BY g1.`name`
SELECT lft, rgt
FROM jos_core_acl_aro_groups
WHERE name = 'USERS'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 2
AND 21
GROUP BY g1.name
ORDER BY g1.lft
SELECT f.*
FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
AND f.profile != 0
AND t.enabled = 1
AND t.viewaccesslevel IN (1)
AND t.useraccessgroupid IN (-2,28,29)
ORDER BY t.POSITION, t.ordering, f.ordering
SELECT `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`
SELECT username
FROM jos_users
WHERE id = 2325
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 2325
LIMIT 0, 1
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline
FROM jos_users AS u
LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id
INNER JOIN jos_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 jos_session
WHERE client_id = 0
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT COUNT(*)
FROM jos_users
WHERE block=0 OR activation=""
SELECT SUM(TIME >= '1329868800'
AND parent='0') AS todayopen,
SUM(TIME >= '1329782400'
AND TIME < '1329868800'
AND parent='0') AS yesterdayopen,
SUM(TIME >= '1329868800'
AND parent>'0') AS todayanswer,
SUM(TIME >= '1329782400'
AND TIME < '1329868800'
AND parent>'0') AS yesterdayanswer
FROM jos_kunena_messages
WHERE TIME >= '1329782400'
AND hold='0'
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
SELECT username
FROM jos_users
WHERE id = 4785
LIMIT 0, 1
SELECT `id`
FROM `jos_groups`
WHERE `id` <= 0
ORDER BY `id`