|
|
|
|
|
1 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
2 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 32 ) ORDER BY menuid DESC LIMIT 1
3 DELETE FROM jos_session WHERE ( ( time < '1729607581' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1729607581' ) AND guest = 1 AND userid = 0 )
4 SELECT * FROM jos_session WHERE session_id = '05d63bcb160c3dd575592ea805efc7fe'
5 UPDATE jos_session SET `time`='1729608481',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='05d63bcb160c3dd575592ea805efc7fe'
6 SELECT * FROM jos_menu WHERE id = 32
7 SELECT count(cid) FROM jos_ponygallery_catg WHERE cid = '11' AND access <= '0'
8 SELECT * FROM jos_ponygallery_catg WHERE cid=11 AND published = 1 AND access <= '0'
9 SELECT parent FROM jos_ponygallery_catg WHERE cid='11'
10 SELECT count(id) FROM jos_ponygallery as a LEFT JOIN jos_ponygallery_catg AS c ON c.cid=a.catid WHERE a.published = '1' AND a.approved = 1 AND c.published = '1' AND c.access <= '0'
11 SELECT imgcounter FROM jos_ponygallery as a LEFT JOIN jos_ponygallery_catg AS c ON c.cid=a.catid WHERE imgcounter > 0 AND a.published = '1' AND a.approved = 1 AND c.published = '1'
12 SELECT imgcounter FROM jos_ponygallery as a LEFT JOIN jos_ponygallery_catg AS c ON c.cid=a.catid WHERE imgcounter > 0 AND a.published = '1' AND a.approved = 1 AND c.published = '1'
13 SELECT d.* FROM jos_ponygallery_catg AS d WHERE d.parent=11 and d.published='1' and d.access<= '0' ORDER BY d.ordering
14 SELECT count(id) FROM jos_ponygallery as a left join jos_ponygallery_catg as c ON c.cid=a.catid WHERE a.published = '1' AND a.catid = '11' AND a.approved = '1' AND c.access <= '0'
15 SELECT * FROM jos_ponygallery_catg WHERE cid = '11'
16 SELECT count(*) FROM jos_ponygallery AS a LEFT JOIN jos_ponygallery_catg AS c ON c.cid=a.catid WHERE a.published = '1' AND a.catid = '11' AND a.approved = '1' AND c.access <= '0'
17 SELECT description FROM jos_ponygallery_catg WHERE cid = '11'
18 SELECT *, ROUND(imgvotesum/imgvotes, 2) AS rating FROM jos_ponygallery AS a LEFT JOIN jos_ponygallery_catg AS c ON c.cid=a.catid WHERE a.published = '1' AND a.catid = '11' AND a.approved = '1' AND c.access <= '0' ORDER BY a.ordering DESC, a.imgtitle ASC, a.imgdate DESC LIMIT 0,16
19 SELECT id, imgfilename, imgthumbname, imgtitle FROM jos_ponygallery AS a LEFT JOIN jos_ponygallery_catg AS c ON c.cid=a.catid WHERE a.published = '1' AND a.catid = '11' AND a.approved = '1' AND c.access <= '0' ORDER BY a.ordering DESC, a.imgtitle ASC, a.imgdate DESC LIMIT 16,17
20 SELECT parent FROM jos_ponygallery_catg WHERE cid='11'
21 SELECT * FROM jos_ponygallery_catg WHERE cid=11 AND published = 1 AND access <= '0'
22 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
23 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 32 ) ORDER BY ordering
24 SELECT guest, usertype FROM jos_session
25 SELECT DISTINCT a.username FROM jos_session AS a WHERE a.guest = 0 AND usertype <> 'Super Administrator'
26 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
27 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
28 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=15'
29 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=60'
30 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
31 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=70'
32 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=71'
33 SELECT id FROM jos_menu WHERE link = "index.php?option=com_eventlist" AND published > 0
34 SELECT a.*, l.club, l.city, l.url FROM jos_eventlist_dates AS a LEFT JOIN jos_eventlist_locate AS l ON l.id = a.locid LEFT JOIN jos_eventlist_categories AS c ON c.id = a.catsid WHERE a.published = 1 AND c.access <= 0 ORDER BY a.dates, a.times LIMIT 5
35 SELECT * FROM jos_banner WHERE showBanner=1
36 UPDATE jos_banner SET impmade = impmade + 1 WHERE bid = 9
37 SELECT p.id as picid, p.catid, p.imgthumbname, p.imgfilename, p.imgdate , p.imgtitle, p.imgtext, p.imgcounter, p.imgvotes , (p.imgvotesum/p.imgvotes) AS vote, c.name AS cattitle FROM jos_ponygallery as p INNER JOIN jos_ponygallery_catg as c ON c.cid=p.catid WHERE c.published='1' AND c.access<=0 AND p.published='1' AND p.approved='1' ORDER BY rand() LIMIT 2
38 SELECT a. * , b.id as category, b.published as published FROM jos_sb_messages AS a, jos_sb_categories AS b WHERE a.catid = b.id AND a.hold = 0 AND b.published = 1 ORDER BY a.time DESC LIMIT 3