:

.

.

.

?
  • 1113
?
  • 0
  • 1
?
?
: 0.1191 .
: 55
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 = '3ce4c3bd8fd4b1ebc37b06405fb112aa' AND ip = '54.198.111.185' LIMIT 1

INSERT INTO cms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.198.111.185', '3ce4c3bd8fd4b1ebc37b06405fb112aa', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/')

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

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

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'left' 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 = 'main_menu') 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 < 22 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'banner1' 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 = 'banner1') 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 m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'search' 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 = 'search') 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 m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'banner2' 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 = 'tab1') 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 FROM cms_category WHERE id='16' 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
				       LEFT JOIN cms_user_profiles p ON p.user_id = con.user_id
				       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2018-07-18 07:33:47'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-07-18 07:33:47')) AND p.karma >= 10 
                      AND (cat.NSLeft >= 2 AND cat.NSRight <= 17)
				ORDER BY con.pubdate DESC
				LIMIT 10

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-07-18 07:33:47' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-07-18 07:33:47')) AND (cat.NSLeft >= 2 AND cat.NSRight <= 17)

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'tab2') 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 FROM cms_category WHERE id='17' 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
				       LEFT JOIN cms_user_profiles p ON p.user_id = con.user_id
				       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2018-07-18 07:33:47'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-07-18 07:33:47')) AND p.karma >= 10 
                      AND (cat.NSLeft >= 18 AND cat.NSRight <= 33)
				ORDER BY con.pubdate DESC
				LIMIT 4

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-07-18 07:33:47' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-07-18 07:33:47')) AND (cat.NSLeft >= 18 AND cat.NSRight <= 33)

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'tab3') 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 FROM cms_category WHERE id='18' 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
				       LEFT JOIN cms_user_profiles p ON p.user_id = con.user_id
				       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '2018-07-18 07:33:47'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-07-18 07:33:47')) AND p.karma >= 10 
                      AND (cat.NSLeft >= 34 AND cat.NSRight <= 35)
				ORDER BY con.pubdate DESC
				LIMIT 4

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-07-18 07:33:47' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2018-07-18 07:33:47')) AND (cat.NSLeft >= 34 AND cat.NSRight <= 35)

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'tabber_ban' 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 = 'maintop' 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 = '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 t.id, t.forum_id, t.user_id, t.title, t.description, t.description, t.pubdate, t.hits, t.closed, t.pinned, f.id as fid, f.title as forum,
						u.id as uid, u.nickname as starter, u.login as login
						FROM cms_forum_threads t
						INNER JOIN cms_forums f ON f.id = t.forum_id 
						
						INNER JOIN cms_users u ON u.id = t.user_id
						WHERE t.is_hidden = 0
						ORDER BY t.pubdate DESC
						LIMIT 2

SELECT 1 FROM cms_forum_posts WHERE thread_id = '667'

SELECT p.id, p.pubdate, p.content as msg, u.id as uid, u.nickname as author, u.login as login
			FROM cms_forum_posts p
			INNER JOIN cms_users u ON u.id = p.user_id
			WHERE p.thread_id = '667'
			ORDER BY p.pubdate DESC
			LIMIT 1

SELECT 1 FROM cms_forum_posts WHERE thread_id = '666'

SELECT p.id, p.pubdate, p.content as msg, u.id as uid, u.nickname as author, u.login as login
			FROM cms_forum_posts p
			INNER JOIN cms_users u ON u.id = p.user_id
			WHERE p.thread_id = '666'
			ORDER BY p.pubdate DESC
			LIMIT 1

SELECT m.access_list
            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)

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'banner3' 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 = 'left') 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 1 FROM cms_users WHERE is_locked=0 AND is_deleted=0

SELECT u.id
			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 p.gender = 'm'

SELECT u.id 
			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 p.gender = 'f'

SELECT IF (p.city != '', p.city, ' ') city, COUNT( p.user_id ) count
			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
			GROUP BY p.city

SELECT user_id FROM cms_online

SELECT u.id as id, u.nickname as nickname, u.login as login, u.birthdate, 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 p.showbirth = 1 AND DATE_FORMAT(u.birthdate, '%d-%m')='18-07'

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