Бани и сауны

Поиск по сайту

Регион поиска:

Все регионы

Вы здесь: Главная » ДОСУГ / РАЗВЛЕЧЕНИЯ » Отдых / Развлечения » Бани / Сауны

Бани / Сауны

Сортировать: по посещаемости | по алфавиту
Отбражать на странице: 20 40 60

Компания Рейтинг

ЛУЖНИКИ

Ступинский, Лужники с., Центральная ул., д. 1
Телефон +7(926) 1113660

Факс: +7(499) 9004800

Свернуть Добавить
в портфель

Рейтинг: 82

Рубрики: Бани / Сауны

ИНСАУНА

Москва, Масловка Верхн. ул., д. 21
Телефон +7(495) 6564209

Факс: +7(495) 6603684

Свернуть Добавить
в портфель

Рейтинг: 82

Рубрики: Бани / Сауны

Президент-отель

Санкт-Петербург, Приморское шоссе, 572
Телефон +7(812) 433 86 82

E-mail: domino67@mail.ru
Web:

Свернуть Добавить
в портфель

Рейтинг: 82

Рубрики: Косметические салоны , Организация свадеб , Гостиницы , Бани / Сауны , Рестораны

ВЕРОНА САУНА

Москва, Каширское ш., д. 41
Телефон +7(495) 5178313

Факс: +7(495) 911-76-50

Свернуть Добавить
в портфель

Рейтинг: 81

Рубрики: Бани / Сауны

БЕРЛИЗЕВ ГРУПП

Москва, пос. Новобратцевский, ул. Фабричная, д.6
Телефон +7(985) 111-83-27, 111-83-26

Факс: +7(495) 948-19-98
Web:

Свернуть Добавить
в портфель

Рейтинг: 81

Рубрики: Бани / Сауны

ВАЛЬКИРИЯ

Москва, Почтовая Б. ул., д. 36, стр. 3
Телефон +7(495) 3802063

Факс: +7(499) 2612771

Свернуть Добавить
в портфель

Рейтинг: 80

Рубрики: Бани / Сауны

САУНА В ЛЮБЕРЦАХ

Люберцы, Красная ул., д. 1
Телефон +7(495) 7225487

Факс: +7(495) 4886273

Свернуть Добавить
в портфель

Рейтинг: 79

Рубрики: Бани / Сауны

БАРСКИЕ ЗАДВОРКИ

Москва, Дежнева пр., д. 23
Телефон +7(499) 1865010

Факс: +7(495) 4430237

Свернуть Добавить
в портфель

Рейтинг: 79

Рубрики: Бани / Сауны

ОРИОН ООО

Мытищи, Силикатная ул., д. 36
Телефон +7(495) 5839585

Факс: +7(495) 5784140

Свернуть Добавить
в портфель

Рейтинг: 78

Рубрики: Бани / Сауны , Электроизоляционные материалы

Охотник, ИП Вайков А. В.

Смоленск, Смоленский р-н д. Богородицкое
Телефон (4812) 68-20-67

Свернуть Добавить
в портфель

Рейтинг: 78

Рубрики: Бани / Сауны

АЙВЕНГО

Москва, Академика Арцимовича ул., д. 3Б
Телефон +7(495) 7792200

Факс: +7(495) 911-76-50

Свернуть Добавить
в портфель

Рейтинг: 77

Рубрики: Бани / Сауны

УСАЧЕВСКИЕ БАНИ

Москва, Усачева ул., д. 10
Телефон +7(499) 246-60-79, +7(499) 271-75-71

Факс: +7(495) 911-76-50
E-mail: spa@usbani.ru
Web:

Свернуть Добавить
в портфель

Рейтинг: 77

Рубрики: Бани / Сауны

ЮЖНОЕ БУТОВО КУЛЬТУРНО-ОЗДОРОВИТЕЛЬНЫЙ ЦЕНТР

Москва, Адмирала Ушакова бул., д. 12
Телефон +7(495) 7166528

Факс: +7(495) 9957813

Свернуть Добавить
в портфель

Рейтинг: 77

Рубрики: Бани / Сауны

ПРОМИНВЕСТГРУПП ООО

Москва, Дорожная ул., д. 60Б, оф. 23
Телефон +7(495) 7273212

Факс: +7(495) 7273212
Web:

Свернуть Добавить
в портфель

Рейтинг: 77

Рубрики: Бани / Сауны

БРИЗ ООО

Москва, Кусковская ул., д. 20А
Телефон +7(495) 2343016

Факс: +7(495) 4886273

Свернуть Добавить
в портфель

Рейтинг: 77

Рубрики: Бани / Сауны

ПАРИЛКА.РУ

Москва, Москва
Телефон +7(499) 1897828

Факс: +7(495) 4785135

Свернуть Добавить
в портфель

Рейтинг: 76

Рубрики: Бани / Сауны

ИРБИС

Москва, Маршала Неделина ул., д. 13
Телефон +7(495) 7807594

Факс: +7(49664) 25322

Свернуть Добавить
в портфель

Рейтинг: 76

Рубрики: Бани / Сауны , Холодильное оборудование

МТК ТЕХНОСТРОЙ

Москва, Алтуфьевское ш., д. 33Б
Телефон +7(495) 7203121

Факс: +7(495) 6701901
Web:

Свернуть Добавить
в портфель

Рейтинг: 76

Рубрики: Бани / Сауны

АСТ ТРЭЙД

Москва, Калибровская ул., д. 31А/16
Телефон +7(495) 6158517

Факс: +7(495) 6701901

Свернуть Добавить
в портфель

Рейтинг: 76

Рубрики: Бани / Сауны

БЕСТ ТРЕВЕЛ

Москва, Кастанаевская ул., д. 16Б
Телефон +7(499) 1421094

Факс: +7(495) 9806053

Свернуть Добавить
в портфель

Рейтинг: 76

Рубрики: Бани / Сауны

Страницы: 1 2 3 4 5

Response

Settings

app_base_backend_url: /backend.php
app_base_frontend_url: /
app_briefcase_cookie_lifetime: 2419200
app_exhibition:
  illustrations: { path: /var/www/rspravkaru/www/uploads/exhibition_illustrations, url: /uploads/exhibition_illustrations }
app_exhibition_illustrations_path: /var/www/rspravkaru/www/uploads/exhibition_illustrations
app_exhibition_illustrations_url: /uploads/exhibition_illustrations
app_files_per_firm: 5
app_firm:
  price: { path: /var/www/rspravkaru/www/uploads/firm_prices, url: /uploads/firm_prices }
app_firm_drive_map_height: 46
app_firm_drive_map_width: 84
app_firm_drive_maps_path: /var/www/rspravkaru/www/uploads/firm_drive_maps
app_firm_drive_maps_url: /uploads/firm_drive_maps
app_firm_files_path: /var/www/rspravkaru/www/uploads/firm_files
app_firm_files_url: /uploads/firm_files
app_firm_logo:
  path: /var/www/rspravkaru/www/uploads/firm_logos
  url: /uploads/firm_logos
  size: { small: { width: 84, height: 46 }, medium: { width: 162, height: 89 } }
app_firm_photo_height: 46
app_firm_photo_width: 84
app_firm_photos_path: /var/www/rspravkaru/www/uploads/firm_photos
app_firm_photos_url: /uploads/firm_photos
app_firm_prices_path: /var/www/rspravkaru/www/uploads/firm_prices
app_firm_prices_url: /uploads/firm_prices
app_footer_services_count: 5
app_frontend_host: 'http://rspravka.ru'
app_hash_algo: sha512
app_hash_salt: 17bd053d4c1f6707574de3f2f71f5c4178f212f5c79de883259e9fd4bffa4938
app_months:
  - январь
  - февраль
  - март
  - апрель
  - май
  - июнь
  - июль
  - август
  - сентябрь
  - октябрь
  - ноябрь
  - декабрь
app_news_at_left_side: 5
app_news_illustration_height: 46
app_news_illustration_width: 84
app_news_illustrations_path: /var/www/rspravkaru/www/uploads/news_illustrations
app_news_illustrations_url: /uploads/news_illustrations
app_price_list_rows_per_page: 10
app_price_lists_per_firm: 3
app_rubric_icons_path: /var/www/rspravkaru/www/uploads/rubric_icons
app_rubric_icons_url: /uploads/rubric_icons
app_rubrics_list_size:
  - 20
  - 40
  - 60
app_rubrics_sort_types:
  rating: 'по посещаемости'
  alphabet: 'по алфавиту'
ex_meta_category: b2b
ex_meta_creator: Rspravka
ex_meta_description: 'Business Refernce System'
ex_meta_keywords: Rspravka
ex_meta_subject: Rspravka
ex_meta_title: 'Generated Excel File'
mod_currencies_enabled: true
mod_currencies_is_internal: false
mod_currencies_view_class: sfPHP
mod_default_default_firms_list_size: 10
mod_default_enabled: true
mod_default_firms_list_sizes:
  - 10
  - 20
  - 30
mod_default_is_internal: false
mod_default_pager_range: 4
mod_default_rubrics_columns_count: 2
mod_default_view_class: sfPHP
mod_news_enabled: true
mod_news_is_internal: false
mod_news_tiny_options:
  language: ru
  document_base_url: null
  convert_urls: false
  plugins: 'safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,inlinepopups'
  theme: advanced
  theme_advanced_buttons1: 'bold,italic,underline,strikethrough,|,image,code,|,fullscreen'
  theme_advanced_buttons2: null
  theme_advanced_buttons3: null
  theme_advanced_toolbar_location: top
  theme_advanced_toolbar_align: left
  theme_advanced_statusbar_location: bottom
  theme_advanced_resizing: true
  external_image_list_url: /backend.php/news/getIllustrationsList
mod_news_view_class: sfPHP
mod_search_context_results_count: 5
mod_search_default_order: rating
mod_search_default_type: firms
mod_search_enabled: true
mod_search_is_internal: false
mod_search_orders:
  rating: 'по релевантности'
  alphabet: 'по алфавиту'
mod_search_rating_weight: 0.01
mod_search_types:
  firms: 'В фирмах'
  rubrics: 'В рубриках'
  pricelists: 'В прайс-листах'
mod_search_view_class: sfPHP
sf_admin_module_web_dir: /sfPropelPlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /var/www/rspravkaru/cache/frontend
sf_app_cache_dir: /var/www/rspravkaru/cache/frontend/dev
sf_app_config_dir: /var/www/rspravkaru/apps/frontend/config
sf_app_dir: /var/www/rspravkaru/apps/frontend
sf_app_i18n_dir: /var/www/rspravkaru/apps/frontend/i18n
sf_app_lib_dir: /var/www/rspravkaru/apps/frontend/lib
sf_app_module_dir: /var/www/rspravkaru/apps/frontend/modules
sf_app_template_dir: /var/www/rspravkaru/apps/frontend/templates
sf_apps_dir: /var/www/rspravkaru/apps
sf_cache: false
sf_cache_dir: /var/www/rspravkaru/cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: false
sf_check_symfony_version: false
sf_compressed: false
sf_config_cache_dir: /var/www/rspravkaru/cache/frontend/dev/config
sf_config_dir: /var/www/rspravkaru/config
sf_csrf_secret: false
sf_data_dir: /var/www/rspravkaru/data
sf_debug: true
sf_default_culture: en
sf_doc_dir: /var/www/rspravkaru/doc
sf_enabled_modules:
  - default
  - sfPhpExcel
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: false
sf_etag: false
sf_i18n: false
sf_i18n_cache_dir: /var/www/rspravkaru/cache/frontend/dev/i18n
sf_lazy_cache_key: false
sf_lib_dir: /var/www/rspravkaru/lib
sf_log_dir: /var/www/rspravkaru/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_max_forwards: 5
sf_module_cache_dir: /var/www/rspravkaru/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: propel
sf_plugins_dir: /var/www/rspravkaru/plugins
sf_prototype_web_dir: /sfProtoculousPlugin
sf_rich_text_js_dir: js/tiny_mce
sf_root_dir: /var/www/rspravkaru
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Partial
  - Cache
  - Form
sf_strip_comments: true
sf_symfony_lib_dir: /var/symfony/1.2/lib
sf_template_cache_dir: /var/www/rspravkaru/cache/frontend/dev/template
sf_test_cache_dir: /var/www/rspravkaru/cache/frontend/dev/test
sf_test_dir: /var/www/rspravkaru/test
sf_upload_dir: /var/www/rspravkaru/www/uploads
sf_use_database: true
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix: ' &darr;&nbsp;'
sf_validation_error_suffix: ' &nbsp;&darr;'
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/rspravkaru/www
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false
url_root: 'http://rspravka.ru'

Globals

cookie:
  firm_rating_110352: '1379428367'
  firm_rating_110353: '1379419838'
  firm_rating_110362: '1379420047'
  firm_rating_111451: '1379469942'
  firm_rating_111485: '1379465356'
  firm_rating_112704: '1379430223'
  firm_rating_120174: '1379461240'
  firm_rating_133075: '1379456037'
  firm_rating_133675: '1379453983'
  firm_rating_168464: '1379455422'
  firm_rating_168481: '1379457325'
  firm_rating_19552: '1379454214'
  firm_rating_19606: '1379450251'
  firm_rating_19612: '1379453950'
  firm_rating_202833: '1379448683'
  firm_rating_206245: '1379453174'
  firm_rating_209499: '1379451733'
  firm_rating_219376: '1379481238'
  firm_rating_220381: '1379451668'
  firm_rating_22075: '1379429797'
  firm_rating_22087: '1379436328'
  firm_rating_22102: '1379434723'
  firm_rating_22111: '1379430851'
  firm_rating_227870: '1379482176'
  firm_rating_232401: '1379459385'
  firm_rating_242618: '1379482287'
  firm_rating_256280: '1379463042'
  firm_rating_258371: '1379456399'
  firm_rating_26964: '1379444449'
  firm_rating_26980: '1379439813'
  firm_rating_27105: '1379440915'
  firm_rating_27180: '1379444651'
  firm_rating_298685: '1379441444'
  firm_rating_298686: '1379443278'
  firm_rating_298687: '1379447475'
  firm_rating_300275: '1379455314'
  firm_rating_301562: '1379439877'
  firm_rating_317486: '1379470132'
  firm_rating_324665: '1379468961'
  firm_rating_331770: '1379455285'
  firm_rating_350386: '1379449489'
  firm_rating_350389: '1379452598'
  firm_rating_350393: '1379457618'
  firm_rating_365879: '1379459644'
  firm_rating_369941: '1379434533'
  firm_rating_380685: '1379448712'
  firm_rating_39465: '1379443151'
  firm_rating_39473: '1379440844'
  firm_rating_39610: '1379448344'
  firm_rating_42710: '1379468990'
  firm_rating_56896: '1379451871'
  firm_rating_56897: '1379450531'
  firm_rating_60958: '1379469968'
  firm_rating_61008: '1379469990'
  firm_rating_61060: '1379470092'
  firm_rating_61061: '1379470174'
  firm_rating_62827: '1379453928'
  firm_rating_64092: '1379442206'
  firm_rating_64149: '1379441916'
  firm_rating_73531: '1379467521'
  firm_rating_73731: '1379481213'
  firm_rating_74691: '1379439847'
  firm_rating_74701: '1379439904'
  firm_rating_74748: '1379446267'
  firm_rating_82636: '1379457520'
  firm_rating_82713: '1379452043'
  firm_rating_82723: '1379452445'
  firm_rating_83704: '1379429770'
  firm_rating_83917: '1379436031'
  firm_rating_84220: '1379434931'
  firm_rating_86070: '1379428736'
  firm_rating_86133: '1379435994'
  firm_rating_86144: '1379431846'
  firm_rating_86148: '1379432170'
  firm_rating_88299: '1379447379'
  firm_rating_88310: '1379440707'
  firm_rating_88311: '1379447896'
  firm_rating_98123: '1379482240'
  firm_rating_99684: '1379458165'
  firm_rating_99717: '1379448642'
  firm_rating_99728: '1379459458'
  firm_rating_99839: '1379455347'
  firm_rating_99848: '1379459126'
  symfony: lnvt803gql9h8okh6m8qah23f3
env: {  }
files: {  }
get: {  }
post: {  }
server:
  DOCUMENT_ROOT: /var/www/rspravkaru/www
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  HTTP_CONNECTION: close
  HTTP_COOKIE: 'firm_rating_110352=1379428367; firm_rating_110353=1379419838; firm_rating_110362=1379420047; firm_rating_111451=1379469942; firm_rating_111485=1379465356; firm_rating_112704=1379430223; firm_rating_120174=1379461240; firm_rating_133075=1379456037; firm_rating_133675=1379453983; firm_rating_168464=1379455422; firm_rating_168481=1379457325; firm_rating_19552=1379454214; firm_rating_19606=1379450251; firm_rating_19612=1379453950; firm_rating_202833=1379448683; firm_rating_206245=1379453174; firm_rating_209499=1379451733; firm_rating_219376=1379481238; firm_rating_220381=1379451668; firm_rating_22075=1379429797; firm_rating_22087=1379436328; firm_rating_22102=1379434723; firm_rating_22111=1379430851; firm_rating_227870=1379482176; firm_rating_232401=1379459385; firm_rating_242618=1379482287; firm_rating_256280=1379463042; firm_rating_258371=1379456399; firm_rating_26964=1379444449; firm_rating_26980=1379439813; firm_rating_27105=1379440915; firm_rating_27180=1379444651; firm_rating_298685=1379441444; firm_rating_298686=1379443278; firm_rating_298687=1379447475; firm_rating_300275=1379455314; firm_rating_301562=1379439877; firm_rating_317486=1379470132; firm_rating_324665=1379468961; firm_rating_331770=1379455285; firm_rating_350386=1379449489; firm_rating_350389=1379452598; firm_rating_350393=1379457618; firm_rating_365879=1379459644; firm_rating_369941=1379434533; firm_rating_380685=1379448712; firm_rating_39465=1379443151; firm_rating_39473=1379440844; firm_rating_39610=1379448344; firm_rating_42710=1379468990; firm_rating_56896=1379451871; firm_rating_56897=1379450531; firm_rating_60958=1379469968; firm_rating_61008=1379469990; firm_rating_61060=1379470092; firm_rating_61061=1379470174; firm_rating_62827=1379453928; firm_rating_64092=1379442206; firm_rating_64149=1379441916; firm_rating_73531=1379467521; firm_rating_73731=1379481213; firm_rating_74691=1379439847; firm_rating_74701=1379439904; firm_rating_74748=1379446267; firm_rating_82636=1379457520; firm_rating_82713=1379452043; firm_rating_82723=1379452445; firm_rating_83704=1379429770; firm_rating_83917=1379436031; firm_rating_84220=1379434931; firm_rating_86070=1379428736; firm_rating_86133=1379435994; firm_rating_86144=1379431846; firm_rating_86148=1379432170; firm_rating_88299=1379447379; firm_rating_88310=1379440707; firm_rating_88311=1379447896; firm_rating_98123=1379482240; firm_rating_99684=1379458165; firm_rating_99717=1379448642; firm_rating_99728=1379459458; firm_rating_99839=1379455347; firm_rating_99848=1379459126; symfony=lnvt803gql9h8okh6m8qah23f3'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/bani_sauny'
  HTTP_USER_AGENT: 'Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)'
  HTTP_X_FORWARDED_FOR: 207.241.237.205
  HTTP_X_REAL_IP: 207.241.237.205
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /rubric/bani_sauny/page/3/
  PATH_TRANSLATED: 'redirect:/index.php/bani_sauny/page/3/'
  PHP_SELF: /frontend.php/rubric/bani_sauny/page/3/
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.205
  REMOTE_PORT: '38979'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1379482364
  REQUEST_URI: /frontend.php/rubric/bani_sauny/page/3/
  SCRIPT_FILENAME: /var/www/rspravkaru/www/frontend.php
  SCRIPT_NAME: /frontend.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: '[no address given]'
  SERVER_NAME: rspravka.ru
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: "<address>Apache/2.2.16 (Debian) Server at rspravka.ru Port 80</address>\n"
  SERVER_SOFTWARE: 'Apache/2.2.16 (Debian)'
session:
  symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { region_id: 0 } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1379482339

Php

Logs

#	type	message
1	PatternRouting	Connect sfRoute "homepage" (/)
2	PatternRouting	Connect sfRoute "about" (/about)
3	PatternRouting	Connect sfRoute "akciya" (/akciya)
4	PatternRouting	Connect sfRoute "reklama" (/reklama)
5	PatternRouting	Connect sfRoute "contacts" (/contacts)
6	PatternRouting	Connect sfRoute "site_map" (/site_map)
7	PatternRouting	Connect sfRoute "banner" (/click/:h/)
8	PatternRouting	Connect sfRoute "faq" (/faq)
9	PatternRouting	Connect sfRoute "start" (/start)
10	PatternRouting	Connect sfRoute "search_string" (/search/:search/)
11	PatternRouting	Connect sfRoute "search" (/search/:search/type/:type/order/:order/)
12	PatternRouting	Connect sfRoute "search_page" (/search/:search/type/:type/order/:order/page/:page/)
13	PatternRouting	Connect sfRoute "search_context" (/search-context)
14	PatternRouting	Connect sfRoute "services_postalcodes_zipstreethouse" (/services/zipstreethouse)
15	PatternRouting	Connect sfRoute "services_phonecodes" (/services/phone_codes)
16	PatternRouting	Connect sfRoute "services_currencygraph" (/services/currencygraph)
17	PatternRouting	Connect sfRoute "services_update_currency_course" (/services/updateCurrencyCourse)
18	PatternRouting	Connect sfRoute "services_export_barcode" (/services/export_barcode)
19	PatternRouting	Connect sfRoute "rss_news" (/news/rss.:sf_format)
20	PatternRouting	Connect sfRoute "rss_exhibitions" (/exhibitions/rss.:sf_format)
21	PatternRouting	Connect sfRoute "services_code" (/services/:code)
22	PatternRouting	Connect sfRoute "services_all" (/services/)
23	PatternRouting	Connect sfRoute "services_interesno" (/services/:code/interesno/:id)
24	PatternRouting	Connect sfRoute "services" (/services/:code/:action/:page)
25	PatternRouting	Connect sfRoute "exhibitions_new" (/exhibitions/new)
26	PatternRouting	Connect sfRoute "exhibitions" (/exhibitions/:id/:action)
27	PatternRouting	Connect sfRoute "exhibitions_all" (/exhibitions)
28	PatternRouting	Connect sfRoute "articles" (/articles/:code/:action)
29	PatternRouting	Connect sfRoute "news_new" (/news/new/:id)
30	PatternRouting	Connect sfRoute "news_ok" (/news/ok)
31	PatternRouting	Connect sfRoute "news_list_pager" (/news/page/:page)
32	PatternRouting	Connect sfRoute "news_list" (/news)
33	PatternRouting	Connect sfRoute "news" (/news/:id)
34	PatternRouting	Connect sfRoute "registration" (/registration)
35	PatternRouting	Connect sfRoute "rubric_page" (/rubric/:id/page/:page/)
36	PatternRouting	Connect sfRoute "rubric_sorting" (/rubric/:id/sort/:sort/)
37	PatternRouting	Connect sfRoute "rubric_size" (/rubric/:id/size/:size/)
38	PatternRouting	Connect sfRoute "rubric" (/rubric/:id)
39	PatternRouting	Connect sfRoute "firm_add" (/firm/new)
40	PatternRouting	Connect sfRoute "logout" (/logout)
41	PatternRouting	Connect sfRoute "firm" (/firm/:id)
42	PatternRouting	Connect sfRoute "firm_edit_success" (/firm/:id/edit/success/:success)
43	PatternRouting	Connect sfRoute "firm_edit" (/firm/:id/edit)
44	PatternRouting	Connect sfRoute "firm_print_map" (/firm/:id/print/map)
45	PatternRouting	Connect sfRoute "firm_print" (/firm/:id/print)
46	PatternRouting	Connect sfRoute "firm_name" (/:name)
47	PatternRouting	Connect sfRoute "default_index" (/:module)
48	PatternRouting	Connect sfRoute "default" (/:module/:action/*)
49	PatternRouting	Match route "rubric_page" (/rubric/:id/page/:page/) for /rubric/bani_sauny/page/3/ with parameters array ( 'module' => 'default', 'action' => 'rubric', 'id' => 'bani_sauny', 'page' => '3',)
50	FilterChain	Executing filter "sfRenderingFilter"
51	FilterChain	Executing filter "sfCommonFilter"
52	FilterChain	Executing filter "sfExecutionFilter"
53	PHPView	Set component "services_top" (services/servicesTop)
54	PHPView	Set component "messages_top" (default/messagesTop)
55	PHPView	Set component "about" (default/about)
56	PHPView	Set component "control_menu" (default/controlMenu)
57	PHPView	Set component "references" (default/references)
58	PHPView	Set component "firms_search" (search/firmsSearch)
59	PHPView	Set component "rubrics_tree" (default/rubricsTree)
60	PHPView	Set component "footer" (default/footer)
61	PHPView	Set component "statistic" (default/statistic)
62	PHPView	Set component "news" (news/news)
63	PHPView	Set component "news_top" (news/newsTop)
64	PHPView	Set component "recommend" (news/recommend)
65	PHPView	Set component "rubrics_search" (default/rubricsSearch)
66	PHPView	Set component "rubrics" (default/rubrics)
67	PHPView	Set component "currencies" (currencies/currencies)
68	PHPView	Set component "global_search" (search/siteSearch)
69	PHPView	Set component "detail_rubrics" (default/detailRubrics)
70	PHPView	Set component "briefcase" (default/briefcase)
71	PHPView	Set component "personal" (default/personal)
72	PHPView	Set component "rubric" (default/rubric)
73	PHPView	Set component "pager" (default/pager)
74	PHPView	Set component "pager_sphinx" (default/pagerSphinx)
75	PHPView	Set component "article" (articles/article)
76	PHPView	Set component "main_menu" (articles/mainMenu)
77	PHPView	Set component "services_list" (articles/servicesList)
78	PHPView	Set component "exhibitions_top" (exhibitions/exhibitionsTop)
79	PHPView	Set component "exhibition_thumbnail" (exhibitions/exhibitionThumbnail)
80	PHPView	Set component "firm" (default/firm)
81	PHPView	Set component "carousel" (personal/carousel)
82	PHPView	Set component "firmDigest" (default/firmDigest)
83	PHPView	Set component "firms_list_control" (default/firmsListControl)
84	PHPView	Set component "firms_list_item" (default/firmsListItem)
85	PHPView	Set component "firm_contacts" (default/firmContacts)
86	PHPView	Set component "firm_control" (default/firmControl)
87	PHPView	Set component "pager_price_list" (default/pagerPriceList)
88	PHPView	Set component "price_list" (default/priceList)
89	PHPView	Render "sf_app_dir/modules/default/templates/rubricSuccess.php"
90	main	Call "default->execute()"
91	PartialView	Render "sf_app_dir/modules/default/templates/_rubric.php"
92	main	Call "default->execute()"
93	PartialView	Render "sf_app_dir/modules/default/templates/_pager.php"
94	PHPView	Decorate content with "sf_app_dir/templates/firm-list.php"
95	PHPView	Render "sf_app_dir/templates/firm-list.php"
96	main	Call "default->execute()"
97	PartialView	Render "sf_app_dir/modules/default/templates/_about.php"
98	main	Call "default->execute()"
99	PartialView	Render "sf_app_dir/modules/default/templates/_controlMenu.php"
100	main	Call "search->execute()"
101	PartialView	Render "sf_app_dir/modules/search/templates/_siteSearch.php"
102	main	Call "default->execute()"
103	PartialView	Render "sf_app_dir/modules/default/templates/_statistic.php"
104	main	Call "news->execute()"
105	PartialView	Render "sf_app_dir/modules/news/templates/_recommend.php"
106	main	Call "default->execute()"
107	PartialView	Render "sf_app_dir/modules/default/templates/_rubricsTree.php"
108	main	Call "currencies->execute()"
109	PartialView	Render "sf_app_dir/modules/currencies/templates/_currencies.php"
110	main	Call "default->execute()"
111	PartialView	Render "sf_app_dir/modules/default/templates/_personal.php"
112	main	Get slot "firm-left"
113	main	Get slot "full-search-left"
114	main	Call "default->execute()"
115	PartialView	Render "sf_app_dir/modules/default/templates/_footer.php"
116	PartialView	Render "sf_app_dir/modules/personal/templates/_login.php"
117	WebResponse	Send status "HTTP/1.0 200 OK"
118	WebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	21	1.82	0
Action "default/rubric"	1	9.28	1
View "Success" for "default/rubric"	1	664.74	92
Component "default/rubric"	1	237.63	32
Partial "default/_rubric"	1	64.71	8
Component "default/pager"	1	0.06	0
Partial "default/_pager"	1	1.79	0
Component "default/about"	1	4.60	0
Partial "default/_about"	1	1.83	0
Component "default/controlMenu"	1	0.52	0
Partial "default/_controlMenu"	1	0.17	0
Component "search/siteSearch"	1	8.06	1
Partial "search/_siteSearch"	1	292.44	40
Component "default/statistic"	1	0.89	0
Partial "default/_statistic"	1	0.20	0
Component "news/recommend"	1	4.94	0
Partial "news/_recommend"	1	0.27	0
Component "default/rubricsTree"	1	5.68	0
Partial "default/_rubricsTree"	1	1.01	0
Component "currencies/currencies"	1	8.71	1
Partial "currencies/_currencies"	1	0.75	0
Component "default/personal"	1	4.85	0
Partial "default/_personal"	1	2.77	0
Component "default/footer"	1	2.71	0
Partial "default/_footer"	1	1.40	0
Partial "personal/_login"	1	0.19	0

SET NAMES 'utf8'
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.TRANSLIT_NAME='bani_sauny' LIMIT 1
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=559
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=558
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.TRANSLIT_NAME='bani_sauny' LIMIT 1
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=559
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=558
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID IS NULL
SELECT firms.ID, firms.NAME, firms.THUMBNAIL, firms.DESCRIPTION, firms.ADDRESS, firms.PLACE_ID, firms.SUBWAY_STATION_ID, firms.PHONE, firms.FAX, firms.ICQ, firms.SKYPE, firms.SCHEMA, firms.EMAIL, firms.SITE, firms.LOGO, firms.VIEWS_COUNT, firms.FIRM_OWNER_ID, firms.CREATE_DATE, firms.CREATE_DAY, firms.PAGE_TITLE, firms.PAGE_KEYWORDS, firms.PAGE_DESCRIPTION, firms.PRIORITY, firms.ACTIVITY, firms.PRIORITY_RR, firms.DOP_PRIORITY_RR, firms.END_DATE_RR, firms.STATUS_RR, firms.PRIORITY_PR, firms.DOP_PRIORITY_PR, firms.END_DATE_PR, firms.STATUS_PR, firms.PRIORITY_KR, firms.DOP_PRIORITY_KR, firms.END_DATE_KR, firms.STATUS_KR, firms.PRIORITY_S, firms.DOP_PRIORITY_S, firms.END_DATE_S, firms.STATUS_S, firms.OPERATING_SHEDULE_TYPE, firms.SCHEMA_TYPE, firms.UPDATED_AT, firms.LINK_NAME FROM `firms`, `firms__rubrics` WHERE firms__rubrics.RUBRIC_ID IN (575) AND firms.ACTIVITY=true AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.VIEWS_COUNT DESC
SELECT COUNT(*) FROM `firms__rubrics`, `firms` WHERE firms__rubrics.RUBRIC_ID IN (575) AND firms.ACTIVITY=true AND firms.ID IN (377668,28878,28893,29214,29005,28951,28933,28903,28880,28942,29290,368564,28947,28892,214208,28894,29088,28888,28884,29226,28882,28885,28978,214259,28975,29144,29245,253190,356384,29003,29104,28887,29162,214212,28876,29061,28953,29122,28886,29157,28901,28912,379714,28961,29074,29010,28877,29151,29105,377684,28948,28950,28996,29222,253108,28984,29096,29136,29142,29272,214256,28896,28973,28955,28983,379799,28937,29002,28879,28957,28989,29028,29080,29217,28898,29008,29023,29163,29263,28891,29029,29045,29094,29140,29266,368567,29051,368566,28890,29038,28938,29152,214253,29009,29041,29065,29124,29175,29259,28875,28895,29131,29231,286203,377682,28914,29001,29017,29052,29168,29252,29287,286137,368559,368562,28909,286162,356387,28934,29078,214207,28972,28988,29210,29280,29301,214270,356336,377679,28883,28965,29026,214230,286215,334913,368570,377690,28910,28962,29014,29030,29069,29111,29123,29145,29247,214213,214218,286139,377666,377680,28927,28935,29189,29190,29208,29238,240403,356340,28956,29097,29103,29120,29139,29223,334916,368553,377674,29043,29062,29130,29164,29173,29216,29273,286134,286186,286187,356342,28940,28958,29058,29128,29154,29174,29209,29299,240412,377675,28913,28944,28949,28974,28990,29054,29179,29236,214211,253198,334927,368546,368574,377670,28928,29207,29237,240427,334918,356344,368554,29018,29032,29100,29132,29150,29182,29202,29248,29283,29284,253145,286188,356335,356386,377671,28920,28952,29019,29022,29254,286146,286147,286181,356341,356366,368552,377685,28881,29012,29027,29059,29071,29086,29108,29212,29269,214268,240424,253110,253134,286152,334921,334930,356374,368578,28923,28936,28959,28970,28985,29040,29063,29087,29092,29148,29165,29186,29203,29239,214258,240426,253136,253202,334915,356372,356388,377669,377687,28916,28926,28941,28945,28997,28999,29011,29031,29047,29064,29085,29098,29101,29106,29129,29185,29193,29219,29227,29256,29264,29281,29292,214234,253128,286189,334919,334935,334941,28905,28907,28919,28966,28969,28971,28991,29057,29077,29082,29083,29091,29116,29126,29134,29138,29172,29176,29177,29184,29194,29199,29201,29220,29224,29225,29243,29260,29262,29279,214264,240402,240415,240420,240441,253146,253149,253166,253182,286128,368565,28902,28908,28911,28929,28946,28977,28981,28992,29006,29015,29025,29056,29076,29095,29110,29117,29133,29158,29166,29167,29183,29197,29211,29213,29228,29233,29240,29241,29244,29249,29288,29294,29297,29300,214225,214235,214236,286195,334931,28889,28906,28924,29020,29053,29055,29060,29089,29090,29099,29102,29113,29115,29127,29135,29137,29147,29149,29156,29160,29187,29191,29195,29198,29235,29270,29303,214226,214229,214237,214257,214273,253169,253195,286135,286148,286150,334917,334928,356402,377667,28904,28921,28922,28939,28943,28994,29004,29034,29066,29081,29084,29114,29121,29141,29143,29169,29206,29253,29255,29268,29276,29298,214209,240399,240401,240450,253126,253132,286198,356378,368548,28899,28917,28954,28967,28968,28980,28986,28987,28998,29007,29013,29016,29021,29033,29067,29079,29109,29161,29170,29178,29205,29218,29230,29232,29246,29275,29285,214223,214266,214271,240413,240429,240445,240457,253118,253119,253130,253141,253148,253155,253165,253167,253177,253194,253201,286132,286145,286219,334934,334952,28900,28915,28925,28930,28931,28960,28963,28982,28993,29035,29036,29037,29042,29068,29075,29119,29155,29159,29180,29181,29188,29200,29251,29258,29282,29286,29289,29293,29295,214246,253131,253139,253185,286130,286141,286143,286151,286184,334914,356334,356383,356408,368579,377681,28897,28918,29070,29093,29107,29125,29215,29221,29229,29250,29265,29291,29302,214202,214210,214216,214260,214265,240404,240444,253114,253135,253175,286133,286138,286142,286153,286157,286161,286166,286168,286169,286176,286179,286180,286182,286191,286199,356410,28932,28976,28979,28995,29000,29024,29044,29048,29146,29196,29204,29234,29257,29274,214203,214215,214217,214221,214224,214227,214255,214263,240396,240423,240455,253122,253157,253159,253161,253180,253199,286171,286175,286183,286197,286204,334929,356379,368555,368556,377673,377677,377683,377693,29049,29171,29278,214238,214239,214244,214250,240419,240447,240452,240463,253109,253111,253144,253158,253160,253172,253188,253191,286178,286202,286216,286222,334938,356337,356393,28964,29039,29073,29118,214274,240449,253127,253133,253137,253174,253178,286131,286205,368568,377692,377694,29072,29112,29153,29277,214245,214254,240400,240428,240435,240442,240456,253112,253120,253151,253162,286144,286155,286177,286190,286194,286220,334932,334939,334953,356351,356368,356376,29046,29242,29261,29267,29296,240414,240418,240438,240439,240446,240451,253115,253116,253117,253142,253150,253154,253179,253184,253189,286129,286193,286196,334936,334943,334946,334949,356352,356357,356390,356395,356401,377691,29192,214247,240407,240408,240448,240458,253140,253143,253147,253183,253187,253192,253197,286140,286159,286172,286174,286218,334925,334947,334948,356330,356346,356404,356406,356411,356412,214251,214252,214269,240411,253121,253123,253164,253170,253200,286201,334920,334924,334926,356349,356356,356367,356375,368563,368576,377686,214267,240394,240436,240453,253163,253168,253193,286164,286214,334923,334940,334942,356343,356355,356359,356361,356362,356392,356414,368545,368551,368560,368561,377688,377689,214206,214219,214243,214272,240416,253152,253173,286136,286167,286185,334944,356333,356350,377672,377678,214241,214248,214262,240405,240409,240410,240430,240443,240462,253113,253129,253138,253153,253171,253176,253186,286154,286156,286163,286165,286170,286173,286192,286207,334933,334950,356331,356377,356380,356397,368544,377676,214214,214249,214261,240398,240417,240460,253124,253125,286200,286208,286210,286213,334922,334951,356332,356339,356353,356409,356415,368557,368572,368573,368575,240425,240433,240440,253156,253181,253196,286149,286211,286212,356348,356364,356381,356396,368549,240406,286206,286209,356338,356345,356347,356369,356382,356385,356389,356391,356405,368558,368577,286217,286221,286223,334945,356358,356360,356373,356399,356413,368547,286158,286224,356354,356371,356394,368550,368571,334937,356363,356370,356398,356400,368569,356365,356407,356403,29050,29271,381303,379671) AND firms__rubrics.FIRM_ID=firms.ID
SELECT firms.ID, firms.NAME, firms.THUMBNAIL, firms.DESCRIPTION, firms.ADDRESS, firms.PLACE_ID, firms.SUBWAY_STATION_ID, firms.PHONE, firms.FAX, firms.ICQ, firms.SKYPE, firms.SCHEMA, firms.EMAIL, firms.SITE, firms.LOGO, firms.VIEWS_COUNT, firms.FIRM_OWNER_ID, firms.CREATE_DATE, firms.CREATE_DAY, firms.PAGE_TITLE, firms.PAGE_KEYWORDS, firms.PAGE_DESCRIPTION, firms.PRIORITY, firms.ACTIVITY, firms.PRIORITY_RR, firms.DOP_PRIORITY_RR, firms.END_DATE_RR, firms.STATUS_RR, firms.PRIORITY_PR, firms.DOP_PRIORITY_PR, firms.END_DATE_PR, firms.STATUS_PR, firms.PRIORITY_KR, firms.DOP_PRIORITY_KR, firms.END_DATE_KR, firms.STATUS_KR, firms.PRIORITY_S, firms.DOP_PRIORITY_S, firms.END_DATE_S, firms.STATUS_S, firms.OPERATING_SHEDULE_TYPE, firms.SCHEMA_TYPE, firms.UPDATED_AT, firms.LINK_NAME FROM `firms`, `firms__rubrics` WHERE firms__rubrics.RUBRIC_ID IN (575) AND firms.ACTIVITY=true AND firms.ID IN (377668,28878,28893,29214,29005,28951,28933,28903,28880,28942,29290,368564,28947,28892,214208,28894,29088,28888,28884,29226,28882,28885,28978,214259,28975,29144,29245,253190,356384,29003,29104,28887,29162,214212,28876,29061,28953,29122,28886,29157,28901,28912,379714,28961,29074,29010,28877,29151,29105,377684,28948,28950,28996,29222,253108,28984,29096,29136,29142,29272,214256,28896,28973,28955,28983,379799,28937,29002,28879,28957,28989,29028,29080,29217,28898,29008,29023,29163,29263,28891,29029,29045,29094,29140,29266,368567,29051,368566,28890,29038,28938,29152,214253,29009,29041,29065,29124,29175,29259,28875,28895,29131,29231,286203,377682,28914,29001,29017,29052,29168,29252,29287,286137,368559,368562,28909,286162,356387,28934,29078,214207,28972,28988,29210,29280,29301,214270,356336,377679,28883,28965,29026,214230,286215,334913,368570,377690,28910,28962,29014,29030,29069,29111,29123,29145,29247,214213,214218,286139,377666,377680,28927,28935,29189,29190,29208,29238,240403,356340,28956,29097,29103,29120,29139,29223,334916,368553,377674,29043,29062,29130,29164,29173,29216,29273,286134,286186,286187,356342,28940,28958,29058,29128,29154,29174,29209,29299,240412,377675,28913,28944,28949,28974,28990,29054,29179,29236,214211,253198,334927,368546,368574,377670,28928,29207,29237,240427,334918,356344,368554,29018,29032,29100,29132,29150,29182,29202,29248,29283,29284,253145,286188,356335,356386,377671,28920,28952,29019,29022,29254,286146,286147,286181,356341,356366,368552,377685,28881,29012,29027,29059,29071,29086,29108,29212,29269,214268,240424,253110,253134,286152,334921,334930,356374,368578,28923,28936,28959,28970,28985,29040,29063,29087,29092,29148,29165,29186,29203,29239,214258,240426,253136,253202,334915,356372,356388,377669,377687,28916,28926,28941,28945,28997,28999,29011,29031,29047,29064,29085,29098,29101,29106,29129,29185,29193,29219,29227,29256,29264,29281,29292,214234,253128,286189,334919,334935,334941,28905,28907,28919,28966,28969,28971,28991,29057,29077,29082,29083,29091,29116,29126,29134,29138,29172,29176,29177,29184,29194,29199,29201,29220,29224,29225,29243,29260,29262,29279,214264,240402,240415,240420,240441,253146,253149,253166,253182,286128,368565,28902,28908,28911,28929,28946,28977,28981,28992,29006,29015,29025,29056,29076,29095,29110,29117,29133,29158,29166,29167,29183,29197,29211,29213,29228,29233,29240,29241,29244,29249,29288,29294,29297,29300,214225,214235,214236,286195,334931,28889,28906,28924,29020,29053,29055,29060,29089,29090,29099,29102,29113,29115,29127,29135,29137,29147,29149,29156,29160,29187,29191,29195,29198,29235,29270,29303,214226,214229,214237,214257,214273,253169,253195,286135,286148,286150,334917,334928,356402,377667,28904,28921,28922,28939,28943,28994,29004,29034,29066,29081,29084,29114,29121,29141,29143,29169,29206,29253,29255,29268,29276,29298,214209,240399,240401,240450,253126,253132,286198,356378,368548,28899,28917,28954,28967,28968,28980,28986,28987,28998,29007,29013,29016,29021,29033,29067,29079,29109,29161,29170,29178,29205,29218,29230,29232,29246,29275,29285,214223,214266,214271,240413,240429,240445,240457,253118,253119,253130,253141,253148,253155,253165,253167,253177,253194,253201,286132,286145,286219,334934,334952,28900,28915,28925,28930,28931,28960,28963,28982,28993,29035,29036,29037,29042,29068,29075,29119,29155,29159,29180,29181,29188,29200,29251,29258,29282,29286,29289,29293,29295,214246,253131,253139,253185,286130,286141,286143,286151,286184,334914,356334,356383,356408,368579,377681,28897,28918,29070,29093,29107,29125,29215,29221,29229,29250,29265,29291,29302,214202,214210,214216,214260,214265,240404,240444,253114,253135,253175,286133,286138,286142,286153,286157,286161,286166,286168,286169,286176,286179,286180,286182,286191,286199,356410,28932,28976,28979,28995,29000,29024,29044,29048,29146,29196,29204,29234,29257,29274,214203,214215,214217,214221,214224,214227,214255,214263,240396,240423,240455,253122,253157,253159,253161,253180,253199,286171,286175,286183,286197,286204,334929,356379,368555,368556,377673,377677,377683,377693,29049,29171,29278,214238,214239,214244,214250,240419,240447,240452,240463,253109,253111,253144,253158,253160,253172,253188,253191,286178,286202,286216,286222,334938,356337,356393,28964,29039,29073,29118,214274,240449,253127,253133,253137,253174,253178,286131,286205,368568,377692,377694,29072,29112,29153,29277,214245,214254,240400,240428,240435,240442,240456,253112,253120,253151,253162,286144,286155,286177,286190,286194,286220,334932,334939,334953,356351,356368,356376,29046,29242,29261,29267,29296,240414,240418,240438,240439,240446,240451,253115,253116,253117,253142,253150,253154,253179,253184,253189,286129,286193,286196,334936,334943,334946,334949,356352,356357,356390,356395,356401,377691,29192,214247,240407,240408,240448,240458,253140,253143,253147,253183,253187,253192,253197,286140,286159,286172,286174,286218,334925,334947,334948,356330,356346,356404,356406,356411,356412,214251,214252,214269,240411,253121,253123,253164,253170,253200,286201,334920,334924,334926,356349,356356,356367,356375,368563,368576,377686,214267,240394,240436,240453,253163,253168,253193,286164,286214,334923,334940,334942,356343,356355,356359,356361,356362,356392,356414,368545,368551,368560,368561,377688,377689,214206,214219,214243,214272,240416,253152,253173,286136,286167,286185,334944,356333,356350,377672,377678,214241,214248,214262,240405,240409,240410,240430,240443,240462,253113,253129,253138,253153,253171,253176,253186,286154,286156,286163,286165,286170,286173,286192,286207,334933,334950,356331,356377,356380,356397,368544,377676,214214,214249,214261,240398,240417,240460,253124,253125,286200,286208,286210,286213,334922,334951,356332,356339,356353,356409,356415,368557,368572,368573,368575,240425,240433,240440,253156,253181,253196,286149,286211,286212,356348,356364,356381,356396,368549,240406,286206,286209,356338,356345,356347,356369,356382,356385,356389,356391,356405,368558,368577,286217,286221,286223,334945,356358,356360,356373,356399,356413,368547,286158,286224,356354,356371,356394,368550,368571,334937,356363,356370,356398,356400,368569,356365,356407,356403,29050,29271,381303,379671) AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.VIEWS_COUNT DESC LIMIT 40, 20
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28901 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=104618
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28912 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=379714 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188291
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28961 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29074 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29010 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28877 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=100429
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29151 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29105 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=101275
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=377684 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=152985
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28948 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28950 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28996 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29222 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=253108 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=28984 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29096 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29136 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29142 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=29272 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT articles.ID, articles.NAME, articles.CODE, articles.THUMBNAIL, articles.DESCRIPTION, articles.CREATE_DATE, articles.CREATE_DAY, articles.PAGE_TITLE, articles.PAGE_KEYWORDS, articles.PAGE_DESCRIPTION, articles.PRIORITY, articles.ACTIVITY FROM `articles`, `tags`, `articles__tags` WHERE articles.ACTIVITY=true AND tags.CODE='about' AND articles__tags.ARTICLE_ID=articles.ID AND articles__tags.TAG_ID=tags.ID ORDER BY articles.PRIORITY ASC
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738765' LIMIT 1
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738765' ORDER BY ip_place.IP_FROM DESC LIMIT 1
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738765' AND ip_place.IP_TO>='3488738765'
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188256 ORDER BY places.NAME ASC
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4 LIMIT 1
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188291 ORDER BY places.NAME ASC
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188291,188325,188326,188327,188328,188329,188330,188331,188333,188334)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (1,51,2)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8155,8156)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (28145,28185,28148,28187,28188,28263,28243,28245,28249,28260,28264)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (37572,37596,37573,37598,37603,37589,37599,37600,37602)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (38283,38284,38327,38299,38301,38310)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (42636,42637,42638)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (430,431,457,448,455,453,432,441,456,442,444,458,454)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (43097,43098)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (44843,44844,44852,44856,44851)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (6815,6851,6816)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (48088,48089,48114)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (50728,50730,50783)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (52458,52459,52461)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (61110,61111,61476,61475)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8450,8494,8469,8484,8470,8472,8485,8491,8451,8493,8482)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188335,188336)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181037,181070,181072,181039)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (63755,63756)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10132,10133)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (66981,67008,67054,67029,67058,66995,67060,66982,67090,67066,67067,67069,67077,67078,67084,67089)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=3 AND places.PARENT_ID IN (188667,188724,188804,188863,188939,188984,188669) ORDER BY places.NAME ASC
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188667)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10200,10201)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (69014,69032,69015,69045,69047,69057,69076)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10421,10447,10506,10422)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (70235,70237,70814)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74428)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10892,10985,10705)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (11012,11030,11013,11046)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74567,74569,74672,74586,74606,74648,74610,74696,74656,74681,74616,74662,74634,74659,74669,74640,74671)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (75884,75886,76059)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (12236,12252,12279,12308,12332,12365,12238,12395,12419)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (81036,81037)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (30027,30100,30125,30146,30028,30179,30210)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (32100,32360,32362,32108,32113,32363,32124,32364,32346,32365,32373,32102,32352,32366,32368,32355,32372,32358,32369)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (84895,84896,84937)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,86292)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (89769,89774)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (95421,95422)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13250,13285)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (15000,15001)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97312,97319,97390,97397,97324,97325,97327,97328,97353,97354,97393,97356,97362,97365,97366,97368,97392,97391,97371,97372,97375,97376,97396,97380,97381,97401,97383,97387,97389)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (105825,105830,105916,105833,105834,105860,105864,105829,105873,105922,105923,105924,105883,105891,105895,105899,105920)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188602 ORDER BY places.NAME ASC
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (106031,106159,106139,106033,106158)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,111391)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (115543,115603,115572,115604,115605,115544,115602,115606)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117286)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,119261,119270,119236,119280)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (121215,121737,122109,123001,123094,123373,123545,121485)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (124340,124349,124341)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (125933,125956,125944,126000,126007,126017,126183,126196,126578,126317,126324,125936,126393,126394,126489)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (35102,35109,35110,35152,35103,35155,35156,35163,35119,35128,35161,35162,35142)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,130965)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (140423,140757,140425,140434,140454,140478,140518,140530,140572,140590,140424,140614,140666)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (143212,143213)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (146138,146149,146180,146156,146164,146165,146178,146139,146174,146169,146166)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (147530,147583,147646,147649,147650,147673,147681,147682,147683,147688,147533,147689,147582,147691)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (16462,16479,16464)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,149752)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (150080,150767,150786,150127,150143,150787,150816,150166,150795,150826,150823,150828,150081,150196,150201,150796,150469,150797,150256,150272,150275,150291,150311,150798,150322,150342,150803,150474,150788,150354,150380,150387,150422,150439,150453,150807,150819,150813,150815)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17295)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,152958,152985)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (35833,36022,36027,35953,35955,35990,35998,36028,36013,36014,35834)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (158302,158312,158303,158319,158304,158322,158311,158323)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17558,17559,17669)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (160505,160751,160562,160555,160554,160508,160553)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171165,171173,171191,171119)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (172125,172184,172126)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (21655,21657,21656)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (176078,176268,176079)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (22132,22387,22573,22133,23952,24633,22378)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178336,178231)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (36895,36900,36902,36904,36912,36913,36896)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25452)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189026,189094,189029,189031,189032,189096,189087,189034,189036,189037,189181,189060,189058,189028,189189)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=1 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (179428,179478,179499,179516,179527,179538,179552,179604,179646,179653,179656,179673,179657,179430,179669)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (26154,26178,26179,26180,26155,26181)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189595,189598,189622,189629,189630,189636,189639,189596,189747)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,181922,181921)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=0
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.TRANSLIT_NAME='bani_sauny' LIMIT 1
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=559
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=558
SELECT recommend.ID, recommend.FIRM_ID, recommend.RUBRIC_ID, recommend.PLACE_ID, recommend.HEADER, recommend.URL, recommend.DESCRIPTION, recommend.SPECIAL, recommend.VIEWS_COUNT, recommend.TYPE, recommend.SEARCH, recommend.START_DATE, recommend.END_DATE, recommend.ACTIVITY FROM `recommend` WHERE recommend.ACTIVITY=true AND recommend.TYPE IN ('pr','rr','kr') AND recommend.RUBRIC_ID IN (575,559,558) AND recommend.START_DATE<='2013-09-18' AND recommend.END_DATE>='2013-09-18' ORDER BY recommend.VIEWS_COUNT DESC LIMIT 5
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID='bani_sauny'
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE (rubrics.ACTIVITY=2 OR rubrics.ACTIVITY=1) AND (((rubrics.KEYWORDS LIKE '%game%' OR rubrics.KEYWORDS LIKE '%22%') OR rubrics.KEYWORDS LIKE '%88%') OR rubrics.KEYWORDS LIKE '%Работы%') ORDER BY rubrics.PRIORITY ASC
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE (rubrics.ACTIVITY=2 OR rubrics.ACTIVITY=1) AND (((rubrics.KEYWORDS LIKE '%game%' OR rubrics.KEYWORDS LIKE '%22%') OR rubrics.KEYWORDS LIKE '%88%') OR rubrics.KEYWORDS LIKE '%Работы%') AND (((rubrics.NAME LIKE '%game%' OR rubrics.NAME LIKE '%22%') OR rubrics.NAME LIKE '%88%') OR rubrics.NAME LIKE '%Работы%') ORDER BY rubrics.PRIORITY ASC
SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.ACTIVITY>2
SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.CODE='RUB' LIMIT 1
SELECT currency_cources.ID, currency_cources.VALUE, currency_cources.AMOUNT, currency_cources.CURRENCY_ID, currency_cources.BASE_CURRENCY_ID, currency_cources.DATE, currency_cources.ACTIVITY FROM `currency_cources` WHERE currency_cources.DATE<='2013-09-18' ORDER BY currency_cources.DATE DESC LIMIT 1
SELECT currency_cources.ID, currency_cources.VALUE, currency_cources.AMOUNT, currency_cources.CURRENCY_ID, currency_cources.BASE_CURRENCY_ID, currency_cources.DATE, currency_cources.ACTIVITY FROM `currency_cources` WHERE currency_cources.ACTIVITY=true AND currency_cources.CURRENCY_ID=1 AND currency_cources.DATE='2013-09-18'
SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.CODE='rub' LIMIT 1
SELECT currency_cources.ID, currency_cources.VALUE, currency_cources.AMOUNT, currency_cources.CURRENCY_ID, currency_cources.BASE_CURRENCY_ID, currency_cources.DATE, currency_cources.ACTIVITY FROM `currency_cources` WHERE currency_cources.CURRENCY_ID=1 AND currency_cources.BASE_CURRENCY_ID=2 AND currency_cources.ACTIVITY=true ORDER BY currency_cources.DATE DESC LIMIT 2
SELECT currency_cources.ID, currency_cources.VALUE, currency_cources.AMOUNT, currency_cources.CURRENCY_ID, currency_cources.BASE_CURRENCY_ID, currency_cources.DATE, currency_cources.ACTIVITY FROM `currency_cources` WHERE currency_cources.CURRENCY_ID=1 AND currency_cources.BASE_CURRENCY_ID=3 AND currency_cources.ACTIVITY=true ORDER BY currency_cources.DATE DESC LIMIT 2
SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
SELECT services.ID, services.NAME, services.CODE, services.ICON, services.COMPONENT, services.PARAMETERS, services.PRIORITY, services.ACTIVITY FROM `services` WHERE services.ACTIVITY=true ORDER BY services.PRIORITY ASC

Поиск по сайту

Бани / Сауны

ЛУЖНИКИ

ИНСАУНА

Президент-отель

ВЕРОНА САУНА

БЕРЛИЗЕВ ГРУПП

ВАЛЬКИРИЯ

САУНА В ЛЮБЕРЦАХ

БАРСКИЕ ЗАДВОРКИ

ОРИОН ООО

Охотник, ИП Вайков А. В.

АЙВЕНГО

УСАЧЕВСКИЕ БАНИ

ЮЖНОЕ БУТОВО КУЛЬТУРНО-ОЗДОРОВИТЕЛЬНЫЙ ЦЕНТР

ПРОМИНВЕСТГРУПП ООО

БРИЗ ООО

ПАРИЛКА.РУ

ИРБИС

МТК ТЕХНОСТРОЙ

АСТ ТРЭЙД

БЕСТ ТРЕВЕЛ

Cегодня: 18.09.2013

Рсправка рекомендует

Поиск рубрик

Курсы валют

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries

	Запомнить меня

Поиск по сайту

Бани / Сауны

Cегодня: 18.09.2013

Рсправка рекомендует

Поиск рубрик

Превышен лимит добавляемых компаний!

Авторизуйтесь

Забыли пароль

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries