Найти на сайте: параметры поиска

Нет материалов для отображения.

Нет материалов для отображения.

Нет материалов для отображения.

Рейтинг пользователей

yjopuja
(0)
yjopuja
(0)
Blainegox
(0)
Blainegox
(0)
ovirel
(0)
ovirel
(0)
JamieZA
(0)
JamieZA
(0)
WalterXI
(0)
WalterXI
(0)
JacobIR
(0)
JacobIR
(0)
uholyqyf
(0)
uholyqyf
(0)
obedaf
(0)
obedaf
(0)
idisa
(0)
idisa
(0)
urotyqyx
(0)
urotyqyx
(0)

Авторизация

Пользователи сайта РИССР

Сколько нас?
  • 327 пользователей
Кто онлайн?
  • 0 пользователей
  • 1 гость
Кто мы?
Откуда мы?
Время генерации страницы: 0.3813 сек.
Запросы к базе: 52
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 = '4641279927a7191dd0c9b8de5e70ae36' AND ip = '54.225.54.120' LIMIT 1

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

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

INSERT INTO cms_stats (ip, logdate, page, agent, refer) VALUES ('54.225.54.120', 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 < 24 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 <= '2017-09-23 05:06:49'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2017-09-23 05:06:49')) AND p.karma >= 30 
                      AND (cat.NSLeft >= 2 AND cat.NSRight <= 19)
				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 <= '2017-09-23 05:06:49' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2017-09-23 05:06:49')) AND (cat.NSLeft >= 2 AND cat.NSRight <= 19)

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 <= '2017-09-23 05:06:50'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2017-09-23 05:06:50')) AND p.karma >= 10 
                      AND (cat.NSLeft >= 20 AND cat.NSRight <= 37)
				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 <= '2017-09-23 05:06:50' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2017-09-23 05:06:50')) AND (cat.NSLeft >= 20 AND cat.NSRight <= 37)

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 <= '2017-09-23 05:06:50'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2017-09-23 05:06:50')) AND p.karma >= 10 
                      AND (cat.NSLeft >= 38 AND cat.NSRight <= 39)
				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 <= '2017-09-23 05:06:50' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2017-09-23 05:06:50')) AND (cat.NSLeft >= 38 AND cat.NSRight <= 39)

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 u.id, u.login, u.nickname, u.rating as rating, u.is_deleted, p.karma as karma, p.user_id, p.imageurl, u.status
				FROM cms_users u
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
				WHERE u.is_deleted = 0 AND u.is_locked = 0
				ORDER BY rating DESC
				LIMIT 20

SELECT  p.title as title,
                        p.id as id,
                        p.seolink as seolink, 
                        b.title as blog,
                        b.owner as owner,
                        b.id as blog_id,
                        b.seolink as bloglink,
                        p.pubdate as fpubdate,
						b.user_id as uid,
                        IFNULL(r.total_rating, 0) as rating,
                        b.ownertype as ownertype,
                        u.id as author_id,
                        u.nickname as author,
                        up.imageurl as author_image,
                        u.is_deleted as author_deleted
				FROM cms_blog_posts p
				LEFT JOIN cms_blogs b ON b.id = p.blog_id
				LEFT JOIN cms_users u ON u.id = p.user_id				
				LEFT JOIN cms_user_profiles up ON up.user_id = p.user_id
                LEFT JOIN cms_ratings_total r ON r.item_id=p.id AND r.target='blogpost'
				WHERE p.published = 1 AND b.allow_who = 'all'
				ORDER BY p.id DESC
                LIMIT 30

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')='23-09'

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)