Добро пожаловать в единую систему скидок РублиCARD!

Приобретите нашу дисконтную пластиковую карту и Вы сможете:

  • Покупать товары и получать услуги со скидкой в огромном количестве организаций из нашего каталога по всей России.
  • Получать свежую информацию, где еще можно получить скидку по карте РублиCARD.
  • С легкостью ориентироваться по карте города на нашем сайте среди организаций, предоставляющих скидки по нашей системе, сравнивать предоставляемые скидки между собой.
  • Писать отзывы об организациях и читать отзывы других покупателей.
  • и многое-многое другое...
Каталог организаций

скачать все скидки одним файлом

 

Последние комментарии
Время генерации страницы: 0.6440 сек.
Запросы к базе: 279
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 = '1f8d466cb9f23ab3df7110fdae79f026' AND ip = '54.161.88.189' LIMIT 1

INSERT INTO icms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.161.88.189', '1f8d466cb9f23ab3df7110fdae79f026', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/')

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

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

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 = '1f8d466cb9f23ab3df7110fdae79f026'

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

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

SELECT * FROM icms_uc_items WHERE published=1 AND dealofday=1 ORDER BY pubdate DESC LIMIT 0,15

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

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
                        

                FROM    icms_map_cats c
                        ,
                        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 = '1f8d466cb9f23ab3df7110fdae79f026'

                WHERE   i.published = 1
                        

                GROUP BY i.id

                ORDER BY i.pubdate desc
LIMIT 1000

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=149

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='149'

SELECT 1 FROM icms_map_ratings WHERE item_id=149 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=146

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='146'

SELECT 1 FROM icms_map_ratings WHERE item_id=146 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=145

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='145'

SELECT 1 FROM icms_map_ratings WHERE item_id=145 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=143

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='143'

SELECT 1 FROM icms_map_ratings WHERE item_id=143 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=139

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='139'

SELECT 1 FROM icms_map_ratings WHERE item_id=139 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=132

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='132'

SELECT 1 FROM icms_map_ratings WHERE item_id=132 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=131

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='131'

SELECT 1 FROM icms_map_ratings WHERE item_id=131 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=130

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='130'

SELECT 1 FROM icms_map_ratings WHERE item_id=130 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=125

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='125'

SELECT 1 FROM icms_map_ratings WHERE item_id=125 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=124

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='124'

SELECT 1 FROM icms_map_ratings WHERE item_id=124 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=119

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='119'

SELECT 1 FROM icms_map_ratings WHERE item_id=119 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=115

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='115'

SELECT 1 FROM icms_map_ratings WHERE item_id=115 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=112

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='112'

SELECT 1 FROM icms_map_ratings WHERE item_id=112 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=108

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='108'

SELECT 1 FROM icms_map_ratings WHERE item_id=108 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=104

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='104'

SELECT 1 FROM icms_map_ratings WHERE item_id=104 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=97

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='97'

SELECT 1 FROM icms_map_ratings WHERE item_id=97 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=69

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='69'

SELECT 1 FROM icms_map_ratings WHERE item_id=69 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=66

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='66'

SELECT 1 FROM icms_map_ratings WHERE item_id=66 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=62

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='62'

SELECT 1 FROM icms_map_ratings WHERE item_id=62 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=45

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='45'

SELECT 1 FROM icms_map_ratings WHERE item_id=45 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=46

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='46'

SELECT 1 FROM icms_map_ratings WHERE item_id=46 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=33

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='33'

SELECT 1 FROM icms_map_ratings WHERE item_id=33 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=31

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='31'

SELECT 1 FROM icms_map_ratings WHERE item_id=31 AND user_id=0 LIMIT 1

SELECT * FROM icms_map_items WHERE allcity=1 AND published=1

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

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
                        

                FROM    icms_map_cats c
                        ,
                        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 = '1f8d466cb9f23ab3df7110fdae79f026'

                WHERE   i.published = 1
                        

                GROUP BY i.id

                ORDER BY i.pubdate desc
LIMIT 0, 12

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=149

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='149'

SELECT 1 FROM icms_map_ratings WHERE item_id=149 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=146

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='146'

SELECT 1 FROM icms_map_ratings WHERE item_id=146 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=145

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='145'

SELECT 1 FROM icms_map_ratings WHERE item_id=145 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=143

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='143'

SELECT 1 FROM icms_map_ratings WHERE item_id=143 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=139

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='139'

SELECT 1 FROM icms_map_ratings WHERE item_id=139 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=132

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='132'

SELECT 1 FROM icms_map_ratings WHERE item_id=132 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=131

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='131'

SELECT 1 FROM icms_map_ratings WHERE item_id=131 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=130

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='130'

SELECT 1 FROM icms_map_ratings WHERE item_id=130 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=125

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='125'

SELECT 1 FROM icms_map_ratings WHERE item_id=125 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=124

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='124'

SELECT 1 FROM icms_map_ratings WHERE item_id=124 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=119

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='119'

SELECT 1 FROM icms_map_ratings WHERE item_id=119 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=115

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='115'

SELECT 1 FROM icms_map_ratings WHERE item_id=115 AND user_id=0 LIMIT 1

SELECT c.id as id,
                       c.target as target,
                       c.target_id as target_id,
                       c.target_link as target_link, 
					   c.target_title,
                       c.content as content,
                       c.guestname,
                       c.pubdate as fpubdate,
                       IFNULL(c.user_id, 0) as user_id,
                       IFNULL(u.nickname, '') as author,
                       IFNULL(u.login, '') as author_login,
                       IFNULL(v.total_rating, 0) as rating
				FROM icms_comments c
				INNER JOIN icms_users u ON u.id = c.user_id OR c.guestname<>''
                LEFT JOIN icms_ratings_total v ON v.item_id=c.id AND v.target='comment'
				WHERE c.published=1 AND c.is_hidden=0 AND c.target IN ('faq','catalog','mapnews','mapitem','blog','mapevent','article')
                GROUP BY c.id
                ORDER BY c.id DESC
                LIMIT 70

SELECT *, m.id as mid, m.template as tpl
            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 = '1' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

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
                        

                FROM    icms_map_cats c
                        ,
                        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 = '1f8d466cb9f23ab3df7110fdae79f026'

                WHERE   i.published = 1
                        

                GROUP BY i.id

                ORDER BY i.pubdate desc
LIMIT 1000

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=149

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='149'

SELECT 1 FROM icms_map_ratings WHERE item_id=149 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=146

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='146'

SELECT 1 FROM icms_map_ratings WHERE item_id=146 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=145

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='145'

SELECT 1 FROM icms_map_ratings WHERE item_id=145 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=143

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='143'

SELECT 1 FROM icms_map_ratings WHERE item_id=143 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=139

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='139'

SELECT 1 FROM icms_map_ratings WHERE item_id=139 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=132

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='132'

SELECT 1 FROM icms_map_ratings WHERE item_id=132 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=131

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='131'

SELECT 1 FROM icms_map_ratings WHERE item_id=131 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=130

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='130'

SELECT 1 FROM icms_map_ratings WHERE item_id=130 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=125

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='125'

SELECT 1 FROM icms_map_ratings WHERE item_id=125 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=124

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='124'

SELECT 1 FROM icms_map_ratings WHERE item_id=124 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=119

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='119'

SELECT 1 FROM icms_map_ratings WHERE item_id=119 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=115

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='115'

SELECT 1 FROM icms_map_ratings WHERE item_id=115 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=112

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='112'

SELECT 1 FROM icms_map_ratings WHERE item_id=112 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=108

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='108'

SELECT 1 FROM icms_map_ratings WHERE item_id=108 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=104

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='104'

SELECT 1 FROM icms_map_ratings WHERE item_id=104 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=97

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='97'

SELECT 1 FROM icms_map_ratings WHERE item_id=97 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=69

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='69'

SELECT 1 FROM icms_map_ratings WHERE item_id=69 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=66

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='66'

SELECT 1 FROM icms_map_ratings WHERE item_id=66 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=62

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='62'

SELECT 1 FROM icms_map_ratings WHERE item_id=62 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=45

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='45'

SELECT 1 FROM icms_map_ratings WHERE item_id=45 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=46

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='46'

SELECT 1 FROM icms_map_ratings WHERE item_id=46 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=33

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='33'

SELECT 1 FROM icms_map_ratings WHERE item_id=33 AND user_id=0 LIMIT 1

SELECT addr_city, addr_street, addr_prefix, addr_house, addr_room FROM icms_map_markers WHERE item_id=31

SELECT 1 FROM icms_comments WHERE target='mapitem' AND target_id='31'

SELECT 1 FROM icms_map_ratings WHERE item_id=31 AND user_id=0 LIMIT 1

SELECT * FROM icms_map_items WHERE allcity=1

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

SELECT NSLeft, NSRight, NSLevel FROM icms_menu WHERE id = '1' 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 = '1' 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