// // //
//
-2017 014 ( )

014 ( )

 

  014 ( )

 

(0)

. !

: 0.9812 .
: 36
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 = '6i38fvvs5808qol5diqjki1f71' AND ip = '54.198.221.13' LIMIT 1

INSERT INTO cms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.198.221.13', '6i38fvvs5808qol5diqjki1f71', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/novyny/pryimalna-kom-s-ja/2017-r-k/rozklad-provedenja-konsultac-i-ekzamen-v-dlja-vstupnyk-v-na-spec-aln-st-014-serednja-osv-ta-f-zychna-kultura.html')

SELECT id FROM cms_stats WHERE (ip = '54.198.221.13' AND page = '/novyny/pryimalna-kom-s-ja/2017-r-k/rozklad-provedenja-konsultac-i-ekzamen-v-dlja-vstupnyk-v-na-spec-aln-st-014-serednja-osv-ta-f-zychna-kultura.html')

INSERT INTO cms_stats (ip, logdate, page, agent, refer) VALUES ('54.198.221.13', NOW(), '/novyny/pryimalna-kom-s-ja/2017-r-k/rozklad-provedenja-konsultac-i-ekzamen-v-dlja-vstupnyk-v-na-spec-aln-st-014-serednja-osv-ta-f-zychna-kultura.html', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')

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

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

SELECT con.*,
						cat.title cat_title, cat.id cat_id, cat.NSLeft as leftkey, cat.NSRight as rightkey, cat.showtags as showtags,
						cat.modgrp_id, u.nickname as author, con.user_id as user_id, u.login as user_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.seolink = 'novyny/pryimalna-kom-s-ja/2017-r-k/rozklad-provedenja-konsultac-i-ekzamen-v-dlja-vstupnyk-v-na-spec-aln-st-014-serednja-osv-ta-f-zychna-kultura' AND con.pubdate <= '2017-11-19 15:56:32' LIMIT 1

SELECT group_id FROM cms_content_access WHERE content_type = 'material' AND content_id = '996'

SELECT group_id FROM cms_content_access WHERE content_type = 'category' AND content_id = '61'

UPDATE cms_content SET hits = hits + 1 WHERE id = '996'

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='novyny/pryimalna-kom-s-ja/2017-r-k/rozklad-provedenja-konsultac-i-ekzamen-v-dlja-vstupnyk-v-na-spec-aln-st-014-serednja-osv-ta-f-zychna-kultura' LIMIT 1

SELECT title as getfield FROM cms_content WHERE id=996 LIMIT 1

SELECT id as getfield FROM cms_forum_threads WHERE rel_to='content' AND rel_id='996' LIMIT 1

SELECT tag
			FROM cms_tags 
			WHERE target='content' AND item_id='996'
			ORDER BY tag DESC

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

SELECT access FROM cms_user_groups WHERE id = 8 LIMIT 1

SELECT access FROM cms_user_groups WHERE id = 8 LIMIT 1

SELECT c.*,
                       IFNULL(v.total_rating, 0) as votes,
					   IFNULL(u.nickname, 0) as nickname,
					   IFNULL(u.login, 0) as login,
					   IFNULL(u.is_deleted, 0) as is_deleted,
					   IFNULL(p.imageurl, 0) as imageurl,
                       (NOW() < DATE_ADD(c.pubdate, INTERVAL 0 MINUTE)) as is_editable
                FROM cms_comments c
                LEFT JOIN cms_ratings_total v ON v.item_id = c.id AND v.target = 'comment'
				LEFT JOIN cms_users u ON u.id = c.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                WHERE c.target='article' AND c.target_id=996 AND c.published=1
                ORDER BY c.pubdate ASC

SELECT 1 FROM cms_subscribe WHERE user_id = 0 AND target = 'article' AND target_id = 996

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

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