LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.id='611' AND (a.state = '1' OR a.state = '-1'

AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-06-05 16:30:10'

AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-06-05 16:30:10'

AND a.access <= 0
13
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 437
AND a.state = 1 AND ordering < 7
AND a.access <= '0'
ORDER BY a.ordering DESC
LIMIT 1
14
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 437
AND a.state = 1 AND ordering > 7
AND a.access <= '0'
ORDER BY a.ordering
LIMIT 1
15
UPDATE mos_content SET hits=(hits+1) WHERE id='611'
16
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2008-06-05' AND item_table='#__content' AND item_id='611'
17
UPDATE mos_core_log_items SET hits=(hits+1)
WHERE time_stamp='2008-06-05' AND item_table='#__content' AND item_id='611'
18
SELECT id, title, module, position, content, showtitle, params, published
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '9' OR mm.menuid = '0'

ORDER BY ordering
19
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
20
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 35,1
21
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='48'
22
SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-06-05 16:30:11'

AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-06-05 16:30:11'

AND catid='422'
ORDER BY a.ordering
LIMIT 50
23
SELECT * FROM mos_content WHERE id='376'
24
SELECT count(*) FROM mos_comment WHERE articleid='376' AND published='1'
25
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
26
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 18,1
27
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='29'
28
SELECT metakey FROM mos_content WHERE id='611'
29
SELECT id, title
FROM mos_content
WHERE id<>611 AND state=1 AND access <=0 AND (metakey LIKE '%معرفي و تاريخچه پروژه%' OR metakey LIKE '%سوابق طراح پروژه%' OR metakey LIKE '%زندگینامه خلد آشیان جنت مكان مرحوم اشرف الملوك معينيان ( طبيب زاده حكيمي )%'
30
SELECT i.id, i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id ORDER BY i.id DESC LIMIT 250
31
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=182
32
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=223
33
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=260
34
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=261
35
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=262
36
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=263
37
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=264
38
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=265
39
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=266
40
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=267
41
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=268
42
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=269
43
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype=''
44
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
45
SELECT DISTINCT a.username
FROM mos_session AS a
WHERE (a.guest=0
علاقه مندی ها (Bookmarks)