Активный отдых


Время генерации страницы: 0.3429 сек.
Запросы к базе: 48
SET NAMES cp1251

SELECT * FROM icms_menu ORDER BY id ASC

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

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

SELECT id FROM icms_user_groups WHERE alias = 'guest'

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

SELECT id as getfield FROM icms_online WHERE sess_id = '079231fe299f34455f755ad4f800e533' AND ip = '54.226.113.250' LIMIT 1

INSERT INTO icms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.226.113.250', '079231fe299f34455f755ad4f800e533', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/maps/aktivnyi-otdyh')

SELECT id FROM icms_stats WHERE (ip = '54.226.113.250' AND page = '/maps/aktivnyi-otdyh')

INSERT INTO icms_stats (ip, logdate, page, agent, refer) VALUES ('54.226.113.250', NOW(), '/maps/aktivnyi-otdyh', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')

SELECT NSLeft, NSRight FROM icms_menu WHERE id = '47'

SELECT id, title, link, linktype
                           FROM icms_menu
                           WHERE NSLeft <= 6 AND NSRight >= 7 AND parent_id > 0
                           ORDER BY NSLeft

SELECT * FROM icms_map_cats WHERE seolink='aktivnyi-otdyh' ORDER BY id ASC LIMIT 1

SELECT id, title, NSLevel, seolink, url
                FROM icms_map_cats
                WHERE NSLeft <= 70 AND NSRight >= 73 AND parent_id > 0
                ORDER BY NSLeft

SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                FROM icms_map_cats cat
                LEFT JOIN icms_map_items con ON con.category_id = cat.id AND con.published = 1
                WHERE (cat.parent_id=50) AND cat.published = 1
                GROUP BY cat.id
                ORDER BY title

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 71 AND cat.NSRight <= 72) AND con.published = 1

SELECT cat.*, IFNULL(COUNT(con.id), 0) as content_count
                FROM icms_map_cats cat
                LEFT JOIN icms_map_items con ON con.category_id = cat.id AND con.published = 1
                WHERE (cat.parent_id=63) AND cat.published = 1
                GROUP BY cat.id
                ORDER BY title

SELECT  chars.id as id,
                                chars.published as published,
                                chars.title as title,
                                chars.fieldtype as fieldtype,
                                chars.fieldgroup as fieldgroup,
                                chars.is_compare as is_compare,
                                chars.is_filter as is_filter,
                                chars.is_filter_many as is_filter_many,
                                chars.`values` as `values`,
                                chars.bind_all as bind_all,
                                chars.ordering as ordering

                        FROM  icms_map_chars chars

                        WHERE  chars.bind_all = 1

                        ORDER BY chars.ordering ASC

SELECT  chars.id as id,
                            chars.published as published,
                            chars.title as title,
                            chars.fieldtype as fieldtype,                            
                            chars.fieldgroup as fieldgroup,
                            chars.is_compare as is_compare,
                            chars.is_filter as is_filter,
                            chars.is_filter_many as is_filter_many,
                            chars.`values` as `values`,
                            chars.bind_all as bind_all,
                            bind.ordering as ordering

                      FROM  icms_map_chars chars, icms_map_chars_bind bind

                     WHERE  bind.cat_id=50 AND
                            bind.char_id = chars.id

                    ORDER BY bind.ordering ASC

SELECT *
                 FROM icms_map_cats
                 WHERE parent_id > 0 AND published=1
                 ORDER BY NSLeft

SELECT  i.*, m.*, 
                        c.title as category,
                        DATE_FORMAT(i.pubdate, '%d.%m.%Y') as pubdate

                FROM    icms_map_cats c
                        , icms_map_items_cats ic, 
                        icms_map_markers m

                LEFT JOIN icms_map_items i      ON m.item_id = i.id

                WHERE   1=1
                        AND (ic.category_id = c.id AND ic.item_id = i.id)
                         AND (c.NSLeft>=70 AND c.NSRight<=73)
                         
 AND (i.published=1)


                GROUP BY i.id

SELECT id, marker FROM icms_map_cats

SELECT  DISTINCT i.id,
                        i.*,
                        m.addr_country,
                        m.addr_city,
                        m.addr_prefix,
                        m.addr_street,
                        m.addr_house,
                        m.addr_room,
                        m.addr_hash, 
                        c.title as category,
                        c.marker as marker,
                        c.zoom as zoom,
                        DATE_FORMAT(i.pubdate, '%d.%m.%Y') as pubdate,
                        IFNULL(v.title, '') as vendor,
                        IFNULL(v.id, 0) as vendor_id,
                        IFNULL(cm.item_id, 0) as is_in_compare
                        , ic.ordering as ordering

                FROM    icms_map_cats c
                        , icms_map_items_cats ic,
                        icms_map_markers m

                LEFT JOIN icms_map_items i      ON m.item_id = i.id
                LEFT JOIN icms_map_vendors v    ON i.vendor_id = v.id
                LEFT JOIN icms_map_compare cm   ON i.id = cm.item_id AND cm.session_id = '079231fe299f34455f755ad4f800e533'

                WHERE   i.published = 1
                        AND (ic.category_id = c.id AND ic.item_id = i.id)
                         AND (c.NSLeft>=70 AND c.NSRight<=73)
                         
 AND (i.published=1)


                GROUP BY i.id

                ORDER BY ordering asc
LIMIT 0, 10

SELECT 1 FROM icms_map_cats_access WHERE cat_id=50 AND group_id=8 LIMIT 1

SELECT maxmapobjects FROM icms_user_profiles WHERE user_id=0

SELECT COUNT(id) as cc FROM icms_map_items WHERE user_id=0

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'top' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'left' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'user1' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'user3' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

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

SELECT NSLeft, NSRight, NSLevel FROM icms_menu WHERE id = '47' ORDER BY id ASC LIMIT 1

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

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

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

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'top') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' 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 icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'maintop') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' 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 icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'mainbottom') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' 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 icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'footer1') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM icms_menu WHERE id = '47' ORDER BY id ASC LIMIT 1

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

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

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

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'footer2') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '47' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

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

SELECT * FROM icms_filter_rules

SELECT id as getfield FROM icms_content WHERE seolink='aktivnyi-otdyh' LIMIT 1