// // //
//

+100
+101
DSC_1886fgt
+90
+70
IMG_7414
+71
 20
+50
Dream^^
+50
+41
+40
11618
+40
_DSC0172
+40
 16  2012 .
+30
11616
+30
+30
+30
+30
³
+31
20
+30
 19
+20
 18
+20
 #15
+20
  ϳ
+20
  ϳ
+20
.
+20
: 1.0226 .
: 47
SET NAMES cp1251

SELECT * FROM cms_menu ORDER BY id ASC

SELECT id, title, link, config, internal, published, version, system FROM cms_components

SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id

SELECT id FROM cms_user_groups WHERE alias = 'guest'

DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)

SELECT id as getfield FROM cms_online WHERE sess_id = 'bpp7ika6ga981610ccrgduvgq7' AND ip = '54.156.56.73' LIMIT 1

INSERT INTO cms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.156.56.73', 'bpp7ika6ga981610ccrgduvgq7', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/photos/top.html')

SELECT id FROM cms_stats WHERE (ip = '54.156.56.73' AND page = '/photos/top.html')

INSERT INTO cms_stats (ip, logdate, page, agent, refer) VALUES ('54.156.56.73', NOW(), '/photos/top.html', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')

SELECT NSLeft, NSRight FROM cms_menu WHERE id = '43'

SELECT id, title, link, linktype
                           FROM cms_menu
                           WHERE NSLeft <= 39 AND NSRight >= 40 AND parent_id > 0
                           ORDER BY NSLeft

SELECT id, title FROM cms_photo_albums WHERE parent_id=0 AND NSDiffer='' ORDER BY id ASC LIMIT 1

SELECT f.*, f.id as fid, f.pubdate as fpubdate, a.id as album_id, a.title as album, IFNULL(r.total_rating, 0) as rating
			FROM cms_photo_files f
			LEFT JOIN cms_ratings_total r ON r.item_id=f.id AND r.target = 'photo'
			LEFT JOIN cms_photo_albums a ON a.id = f.album_id
			WHERE f.published = 1
			ORDER BY rating DESC 
			LIMIT 24

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1605' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1612' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1609' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1610' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1695' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '21' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1616' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '18' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1611' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1619' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1802' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '66' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1617' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1629' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1636' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1637' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1640' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1946' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '20' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '19' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '53' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '141' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '144' AND published = 1

SELECT id FROM cms_comments WHERE target = 'photo' AND target_id = '1607' AND published = 1

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'top' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '43' OR mb.menu_id = 0)

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '43' OR mb.menu_id = 0)

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'topmenu') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '43' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = '43' ORDER BY id ASC LIMIT 1

SELECT id as getfield FROM cms_menu WHERE parent_id=0 LIMIT 1

SELECT * FROM cms_menu WHERE id = 1 AND NSDiffer = ''

SELECT * FROM cms_menu WHERE NSLeft > 1 AND NSRight < 64 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'maintop') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '43' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'mainbottom') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '43' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC