// // //
//
-

(04637) 5-08-55 . , 170, . ,
., 17500
 colledgprilukigmail.com
15 2018 - Asyaua - 0 - 30
̲ ֲ ί Ͳ
15 2018 - Asyaua - 0 - 31

 ² ֲ ̲ ֲ ί Ͳ

³
8 2018 - Natasha Denisenko - 0 - 67
1
22 2018 - Asyaua - 0 - 129
12 2018 - .. - 0 - 100
7 2018 - Natasha Denisenko - 0 - 192
7 2018 - Natasha Denisenko - 0 - 170
: 1 2 3 4
: 0.5985 .
: 68
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 = 'vqo75convlfspi2t7rh4ebgsv3' AND ip = '54.234.13.175' LIMIT 1

INSERT INTO cms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.234.13.175', 'vqo75convlfspi2t7rh4ebgsv3', NOW(), '0', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '/')

SELECT id FROM cms_stats WHERE (ip = '54.234.13.175' AND page = '/')

INSERT INTO cms_stats (ip, logdate, page, agent, refer) VALUES ('54.234.13.175', NOW(), '/', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '')

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 = '1' 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 = '1' 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 = '1' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = '1' 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 < 66 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 = '1' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT NSLeft, NSRight FROM cms_category WHERE id='1' ORDER BY id ASC LIMIT 1

SELECT con.*,
                       con.pubdate as fdate,
                       u.nickname as author,
                       u.login as author_login
                       FROM cms_content con
				       LEFT JOIN cms_category cat ON cat.id = con.category_id
				       LEFT JOIN cms_users u ON u.id = con.user_id
                       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2018-11-18 18:48:11'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-11-18 18:48:11'))
                      AND (cat.NSLeft >= -1 AND cat.NSRight <= 106)
				ORDER BY con.pubdate DESC
				LIMIT 7

SELECT 1
					FROM cms_content con
					LEFT JOIN cms_category cat ON cat.id = con.category_id
					WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2018-11-18 18:48:11' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-11-18 18:48:11')) AND (cat.NSLeft >= -1 AND cat.NSRight <= 106)

SELECT id FROM cms_comments WHERE target = 'article' AND target_id = '1181' AND published = 1

SELECT id FROM cms_comments WHERE target = 'article' AND target_id = '1180' AND published = 1

SELECT id FROM cms_comments WHERE target = 'article' AND target_id = '1179' AND published = 1

SELECT id FROM cms_comments WHERE target = 'article' AND target_id = '1178' AND published = 1

SELECT id FROM cms_comments WHERE target = 'article' AND target_id = '1176' AND published = 1

SELECT id FROM cms_comments WHERE target = 'article' AND target_id = '1174' AND published = 1

SELECT id FROM cms_comments WHERE target = 'article' AND target_id = '1175' AND published = 1

SELECT log.id as id,
                       log.object as object,
                       log.object_url as object_url,
                       log.target as target,
                       log.target_url as target_url,
                       log.pubdate as pubdate,
                       log.description as description,
                       a.message as message,
                       a.name as name,
                       u.nickname as user_nickname,
                       u.login as user_login

                FROM cms_actions_log log
                LEFT JOIN cms_actions a ON a.id = log.action_id AND a.is_visible = 1
                LEFT JOIN cms_users u ON u.id = log.user_id
   
                WHERE (a.id IN (15,10,25,13,29,23,24,2,12,17,8,18,16,21,28,9,14))AND (log.is_friends_only = 0)AND (log.is_users_only = 0)

                ORDER BY log.id DESC
                LIMIT 10

SELECT u.*, p.imageurl 
				FROM cms_users u
				INNER JOIN cms_user_profiles p ON p.user_id = u.id
				WHERE u.is_deleted = 0 AND u.is_locked=0
				ORDER BY u.regdate DESC
				LIMIT 8

SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = '1' 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 < 66 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 = 'mainbottom') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' 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 = 'sidebar') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '1' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT link, title FROM cms_components WHERE internal = 0 AND published = 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT f.*, a.title album_title
				FROM cms_photo_files f, cms_photo_albums a
				WHERE f.album_id = a.id AND f.album_id = 1041 AND f.published = 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM cms_filter_rules

SELECT id as getfield FROM cms_content WHERE seolink='' LIMIT 1

SELECT		        
				o.user_id as id,
				u.login,
				u.nickname,
				p.gender as gender
				FROM cms_online o
                LEFT JOIN cms_users u ON  u.id = o.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
				WHERE u.is_locked = 0 AND u.is_deleted = 0
                GROUP BY o.user_id

SELECT 1 FROM cms_online WHERE user_id = 0 OR user_id = ''

SELECT u.id as id, u.nickname as nickname, u.login as login, p.gender as gender
                FROM cms_users u
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                WHERE u.is_locked = 0 AND u.is_deleted = 0 AND DATE_FORMAT(u.logdate, '%Y-%m-%d')='2018-11-18'
                ORDER BY u.logdate DESC