Каталог организаций

Время генерации страницы: 0.3281 сек.
Запросы к базе: 93
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 = 'f8e3613dc1ea6c143f322df128812088' 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', 'f8e3613dc1ea6c143f322df128812088', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/maps')

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

INSERT INTO icms_stats (ip, logdate, page, agent, refer) VALUES ('54.226.113.250', NOW(), '/maps', '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 id as getfield FROM icms_map_cats WHERE parent_id=0 LIMIT 1

SELECT * FROM icms_map_cats WHERE id=1 ORDER BY id ASC LIMIT 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=1) 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 >= 44 AND cat.NSRight <= 47) 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=35) 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 >= 45 AND cat.NSRight <= 46) AND con.published = 1

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 20 AND cat.NSRight <= 21) 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=25) 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 >= 70 AND cat.NSRight <= 73) 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=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 con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 74 AND cat.NSRight <= 75) 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=51) 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 >= 64 AND cat.NSRight <= 67) 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=45) 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 >= 65 AND cat.NSRight <= 66) AND con.published = 1

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 22 AND cat.NSRight <= 39) 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=33) 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 >= 33 AND cat.NSRight <= 34) AND con.published = 1

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

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

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

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

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

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 2 AND cat.NSRight <= 5) 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=23) 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 >= 3 AND cat.NSRight <= 4) AND con.published = 1

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 68 AND cat.NSRight <= 69) 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=48) 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 >= 40 AND cat.NSRight <= 43) 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=31) 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 >= 41 AND cat.NSRight <= 42) AND con.published = 1

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 58 AND cat.NSRight <= 63) 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=43) 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 >= 61 AND cat.NSRight <= 62) AND con.published = 1

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

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 6 AND cat.NSRight <= 19) 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=24) 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 >= 15 AND cat.NSRight <= 16) AND con.published = 1

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

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

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

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

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

SELECT con.id
                          FROM icms_map_items con, icms_map_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 76 AND cat.NSRight <= 77) 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=52) 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 >= 48 AND cat.NSRight <= 57) 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=37) 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 >= 51 AND cat.NSRight <= 54) AND con.published = 1

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

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

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=1 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 (ic.category_id=1)
 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 = 'f8e3613dc1ea6c143f322df128812088'

                WHERE   i.published = 1
                        AND (ic.category_id = c.id AND ic.item_id = i.id)
                         AND (ic.category_id=1)
 AND (i.published=1)


                GROUP BY i.id

                ORDER BY ordering asc
LIMIT 0, 10

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)

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)

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)

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)

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)

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)
                  
            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)
                  
            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)
                  
            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)
                  
            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)
                  
            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)
                  
            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='' LIMIT 1