Рсправка - Рубрика ЖКХ

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

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

Все регионы

Вы здесь: Главная » БЫТОВЫЕ / КОММУНАЛЬНЫЕ / РИТУАЛЬНЫЕ УСЛУГИ » Коммунальные услуги » ЖКХ

ЖКХ

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

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

ВОСТОЧНОГО АО ИЗМАЙЛОВО ЖИЛКОМСЕРВИС ЛАДЬЯ ООО

Москва, Измайловский бул., д. 40
Телефон +7(495) 9654701

Факс: +7(495) 6127044

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

Рейтинг: 66

Рубрики: ЖКХ

НОВЫЕ РЖАВКИ-1 ТСЖ

Солнечногорский, Новые Ржавки дер.
Телефон +7(499) 7355383

Факс: +7(499) 7338177

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

Рейтинг: 66

Рубрики: ЖКХ

ВИРГО-П ООО

Москва, Подольская ул., д. 1, корп. 2
Телефон +7(495) 3568521

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

Рейтинг: 65

Рубрики: ЖКХ

ВИТАПРОМ ООО

Москва, Красносельская Верхн. ул., д. 17А
Телефон +7(495) 7489206

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

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

Рейтинг: 65

Рубрики: ЖКХ

МО г. ОРЕХОВО-ЗУЕВО ГЖП

Орехово-Зуево, Ленина ул., д. 63
Телефон +7(4964) 150199

Факс: +7(4964) 150199

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

Рейтинг: 65

Рубрики: ЖКХ

ЛЮБЕРЕЦКАЯ УПРАВЛЯЮЩАЯ КОМПАНИЯ ЗАО

Московская, Люберцы-3 г., корп. 43
Телефон +7(495) 7449947

Факс: +7(495) 7449947

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

Рейтинг: 65

Рубрики: ЖКХ

ЮГО-ВОСТОЧНОГО АО ГУ ИС ДИСПЕТЧЕРСКАЯ СЛУЖБА (ЦДС)

Москва, Ферганская ул., д. 12
Телефон +7(495) 3728517

Факс: +7(495) 5433650

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

Рейтинг: 65

Рубрики: ЖКХ

РАСПОРЯДИТЕЛЬНАЯ ДИРЕКЦИЯ ПО ПЕЧАТИ ОАО

Москва, Тишинский Б. пер., д. 38
Телефон +7(495) 6053707

Факс: +7(495) 6053712

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

Рейтинг: 65

Рубрики: ЖКХ

Опалихинская 16, ТСЖ

Екатеринбург, Опалихинская ул. 16
Телефон (343) 373-73-37

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

Рейтинг: 65

Рубрики: ЖКХ

КОМСЕРВИС-СТОЛИЦА ООО

Москва, Каргопольская ул., д. 24
Телефон +7(905) 7807800

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

Рейтинг: 64

Рубрики: ЖКХ

МО ДМИТРОВСКОГО РАЙОНА ГХ г. ЯХРОМА ЖИЛКОМ ООО

Дмитровский, Яхрома г., Советская ул., д. 1
Телефон +7(49622) 52338

Факс: +7(495) 9390177

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

Рейтинг: 64

Рубрики: ЖКХ

МО ШАХОВСКОГО РАЙОНА ЖКХ УЧАСТОК с. СУДИСЛОВО

Шаховской, Судислово дер., д. 3
Телефон +7(49637) 67324

Факс: +7(499) 7806771

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

Рейтинг: 64

Рубрики: ЖКХ

АЭРОПОРТ ДЕЗ ООО

Москва, Балтийский 2-й пер., д. 4
Телефон +7(499) 1513434

Факс: +7(495) 5935302

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

Рейтинг: 64

Рубрики: ЖКХ

ЮНИСЕРВИС

Москва, Мичуринский просп., д. 5
Телефон +7(495) 9692056

Факс: +7(499) 2434002
Web:

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

Рейтинг: 64

Рубрики: ЖКХ

БРАТСТВО

Красноярск, Водопьянова ул. 7
Телефон +7(391) 253-40-14

Факс: +7(391) 253-40-14

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

Рейтинг: 64

Рубрики: ЖКХ

МО НАХАБИНСКОГО РАЙОНАЯ КЭЧ

Красногорский, Нахабино пос., Панфилова ул., д. 12А
Телефон +7(495) 5662667

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

Рейтинг: 63

Рубрики: ЖКХ

ГАРИБАЛЬДИ ТСЖ

Москва, Гарибальди ул., д. 10, корп. 3
Телефон +7(499) 1320422

Факс: +7(49657) 54649

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

Рейтинг: 63

Рубрики: ЖКХ

МО ЛУХОВИЦКОГО РАЙОНА ЖКХ СЛУЖБА ЕДИНОГО ЗАКАЗЧИКА РАЙОННОЕ КБХ

Луховицы, Горького ул., д. 9
Телефон +7(49663) 21409

Факс: +7(495) 5971227

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

Рейтинг: 63

Рубрики: ЖКХ

МО г. РЕУТОВ ЖИЛСЕРВИС РЭУ # 1

Реутов, Садовый пр., д. 6
Телефон +7(495) 5283021

Факс: +7(495) 6127044

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

Рейтинг: 63

Рубрики: ЖКХ

ЛИГОВКА-98, ТСЖ

Санкт-Петербург, Лиговский проспект, д. 98
Телефон +7(812) 764-40-23

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

Рейтинг: 63

Рубрики: ЖКХ

Страницы: 3 4 5 6 7

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_110124: '1378596437'
  firm_rating_110184: '1378596402'
  firm_rating_111802: '1378614410'
  firm_rating_113116: '1378605665'
  firm_rating_117355: '1378618282'
  firm_rating_119575: '1378595457'
  firm_rating_147725: '1378601366'
  firm_rating_167494: '1378606822'
  firm_rating_18819: '1378677686'
  firm_rating_194609: '1378609312'
  firm_rating_194613: '1378605607'
  firm_rating_195114: '1378677734'
  firm_rating_20062: '1378672294'
  firm_rating_205544: '1378615696'
  firm_rating_209428: '1378596514'
  firm_rating_211147: '1378596846'
  firm_rating_213616: '1378610736'
  firm_rating_213808: '1378618332'
  firm_rating_213830: '1378624888'
  firm_rating_215575: '1378610302'
  firm_rating_218149: '1378608077'
  firm_rating_218555: '1378616093'
  firm_rating_218578: '1378619877'
  firm_rating_219675: '1378675365'
  firm_rating_221781: '1378609224'
  firm_rating_228851: '1378675485'
  firm_rating_235822: '1378639290'
  firm_rating_236414: '1378601425'
  firm_rating_239132: '1378606719'
  firm_rating_242705: '1378598155'
  firm_rating_244368: '1378596662'
  firm_rating_244988: '1378606851'
  firm_rating_246934: '1378607090'
  firm_rating_246958: '1378620435'
  firm_rating_260283: '1378634059'
  firm_rating_260519: '1378604480'
  firm_rating_268531: '1378616062'
  firm_rating_271672: '1378597777'
  firm_rating_276853: '1378626917'
  firm_rating_277222: '1378609340'
  firm_rating_28184: '1378606935'
  firm_rating_284229: '1378602499'
  firm_rating_284230: '1378596632'
  firm_rating_284239: '1378608104'
  firm_rating_289457: '1378601311'
  firm_rating_289829: '1378677539'
  firm_rating_29404: '1378671101'
  firm_rating_295610: '1378671178'
  firm_rating_296058: '1378614098'
  firm_rating_298433: '1378675292'
  firm_rating_298844: '1378601510'
  firm_rating_299266: '1378606747'
  firm_rating_299451: '1378625005'
  firm_rating_300503: '1378601338'
  firm_rating_300507: '1378596604'
  firm_rating_301631: '1378610330'
  firm_rating_30319: '1378607013'
  firm_rating_30390: '1378596545'
  firm_rating_308247: '1378626222'
  firm_rating_309534: '1378597806'
  firm_rating_309601: '1378671247'
  firm_rating_309906: '1378670057'
  firm_rating_311621: '1378601395'
  firm_rating_311636: '1378608050'
  firm_rating_311638: '1378611830'
  firm_rating_313896: '1378605569'
  firm_rating_313940: '1378675256'
  firm_rating_313964: '1378634113'
  firm_rating_315952: '1378627471'
  firm_rating_319998: '1378615746'
  firm_rating_321119: '1378675588'
  firm_rating_321122: '1378675658'
  firm_rating_321292: '1378607063'
  firm_rating_321299: '1378596692'
  firm_rating_321562: '1378641334'
  firm_rating_322768: '1378597586'
  firm_rating_323043: '1378597749'
  firm_rating_326680: '1378620515'
  firm_rating_337557: '1378618305'
  firm_rating_337883: '1378596801'
  firm_rating_339279: '1378643383'
  firm_rating_339839: '1378675326'
  firm_rating_341032: '1378595428'
  firm_rating_349977: '1378632756'
  firm_rating_350010: '1378643588'
  firm_rating_352219: '1378603461'
  firm_rating_352225: '1378609257'
  firm_rating_355859: '1378597684'
  firm_rating_357667: '1378596755'
  firm_rating_359748: '1378637240'
  firm_rating_360773: '1378605636'
  firm_rating_365884: '1378674275'
  firm_rating_366414: '1378606800'
  firm_rating_369947: '1378608237'
  firm_rating_375433: '1378673304'
  firm_rating_378051: '1378673275'
  firm_rating_380028: '1378605463'
  firm_rating_380170: '1378618360'
  firm_rating_380225: '1378597662'
  firm_rating_381172: '1378601459'
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_110124=1378596437; firm_rating_110184=1378596402; firm_rating_111802=1378614410; firm_rating_113116=1378605665; firm_rating_117355=1378618282; firm_rating_119575=1378595457; firm_rating_147725=1378601366; firm_rating_167494=1378606822; firm_rating_18819=1378677686; firm_rating_194609=1378609312; firm_rating_194613=1378605607; firm_rating_195114=1378677734; firm_rating_20062=1378672294; firm_rating_205544=1378615696; firm_rating_209428=1378596514; firm_rating_211147=1378596846; firm_rating_213616=1378610736; firm_rating_213808=1378618332; firm_rating_213830=1378624888; firm_rating_215575=1378610302; firm_rating_218149=1378608077; firm_rating_218555=1378616093; firm_rating_218578=1378619877; firm_rating_219675=1378675365; firm_rating_221781=1378609224; firm_rating_228851=1378675485; firm_rating_235822=1378639290; firm_rating_236414=1378601425; firm_rating_239132=1378606719; firm_rating_242705=1378598155; firm_rating_244368=1378596662; firm_rating_244988=1378606851; firm_rating_246934=1378607090; firm_rating_246958=1378620435; firm_rating_260283=1378634059; firm_rating_260519=1378604480; firm_rating_268531=1378616062; firm_rating_271672=1378597777; firm_rating_276853=1378626917; firm_rating_277222=1378609340; firm_rating_28184=1378606935; firm_rating_284229=1378602499; firm_rating_284230=1378596632; firm_rating_284239=1378608104; firm_rating_289457=1378601311; firm_rating_289829=1378677539; firm_rating_29404=1378671101; firm_rating_295610=1378671178; firm_rating_296058=1378614098; firm_rating_298433=1378675292; firm_rating_298844=1378601510; firm_rating_299266=1378606747; firm_rating_299451=1378625005; firm_rating_300503=1378601338; firm_rating_300507=1378596604; firm_rating_301631=1378610330; firm_rating_30319=1378607013; firm_rating_30390=1378596545; firm_rating_308247=1378626222; firm_rating_309534=1378597806; firm_rating_309601=1378671247; firm_rating_309906=1378670057; firm_rating_311621=1378601395; firm_rating_311636=1378608050; firm_rating_311638=1378611830; firm_rating_313896=1378605569; firm_rating_313940=1378675256; firm_rating_313964=1378634113; firm_rating_315952=1378627471; firm_rating_319998=1378615746; firm_rating_321119=1378675588; firm_rating_321122=1378675658; firm_rating_321292=1378607063; firm_rating_321299=1378596692; firm_rating_321562=1378641334; firm_rating_322768=1378597586; firm_rating_323043=1378597749; firm_rating_326680=1378620515; firm_rating_337557=1378618305; firm_rating_337883=1378596801; firm_rating_339279=1378643383; firm_rating_339839=1378675326; firm_rating_341032=1378595428; firm_rating_349977=1378632756; firm_rating_350010=1378643588; firm_rating_352219=1378603461; firm_rating_352225=1378609257; firm_rating_355859=1378597684; firm_rating_357667=1378596755; firm_rating_359748=1378637240; firm_rating_360773=1378605636; firm_rating_365884=1378674275; firm_rating_366414=1378606800; firm_rating_369947=1378608237; firm_rating_375433=1378673304; firm_rating_378051=1378673275; firm_rating_380028=1378605463; firm_rating_380170=1378618360; firm_rating_380225=1378597662; firm_rating_381172=1378601459; firm_rating_3812=1378626739; firm_rating_38371=1378675452; firm_rating_39073=1378599367; firm_rating_39083=1378596722; firm_rating_39148=1378672222; firm_rating_4120=1378677567; firm_rating_42171=1378677595; firm_rating_42604=1378606770; firm_rating_42607=1378608210; firm_rating_42608=1378608165; firm_rating_43090=1378601537; firm_rating_43116=1378604527; firm_rating_43739=1378605493; firm_rating_43901=1378607123; firm_rating_44780=1378619455; firm_rating_45654=1378604436; firm_rating_46125=1378595398; firm_rating_46217=1378677660; firm_rating_46369=1378630725; firm_rating_47471=1378640876; firm_rating_47583=1378643886; firm_rating_48593=1378675529; firm_rating_48905=1378675426; firm_rating_49030=1378675399; firm_rating_49773=1378672259; firm_rating_49791=1378673335; firm_rating_49805=1378671284; firm_rating_50081=1378641786; firm_rating_50149=1378671209; firm_rating_50904=1378606906; firm_rating_51227=1378677769; firm_rating_52368=1378624860; firm_rating_52443=1378670129; firm_rating_52453=1378670029; firm_rating_52463=1378639185; firm_rating_52679=1378609197; firm_rating_52825=1378610377; firm_rating_52890=1378605732; firm_rating_53021=1378608136; firm_rating_53607=1378606663; firm_rating_55123=1378605709; firm_rating_55141=1378606970; firm_rating_55470=1378601273; firm_rating_55518=1378596492; firm_rating_55545=1378606884; firm_rating_55590=1378606991; firm_rating_61389=1378605540; firm_rating_61410=1378609286; firm_rating_61620=1378618260; firm_rating_61642=1378615949; firm_rating_63676=1378637847; firm_rating_63766=1378630685; firm_rating_63813=1378634086; firm_rating_73947=1378596464; firm_rating_74637=1378607041; firm_rating_74745=1378605516; firm_rating_77016=1378642347; firm_rating_78472=1378639131; firm_rating_78779=1378610350; firm_rating_81571=1378675625; firm_rating_85215=1378670095; firm_rating_86048=1378671141; firm_rating_86049=1378642695; firm_rating_8611=1378616033; firm_rating_86391=1378625902; firm_rating_8698=1378675560; firm_rating_93475=1378596574; firm_rating_93511=1378601482; firm_rating_93512=1378606691; symfony=cccniq7fuqb8c3tuke3n2sfkc7'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/jkh'
  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.206
  HTTP_X_REAL_IP: 207.241.237.206
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /rubric/jkh/page/5/
  PATH_TRANSLATED: 'redirect:/index.php/jkh/page/5/'
  PHP_SELF: /frontend.php/rubric/jkh/page/5/
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.206
  REMOTE_PORT: '40670'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1378681420
  REQUEST_URI: /frontend.php/rubric/jkh/page/5/
  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: {  }

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/jkh/page/5/ with parameters array ( 'module' => 'default', 'action' => 'rubric', 'id' => 'jkh', 'page' => '5',)
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.83	0
Action "default/rubric"	1	2.75	0
View "Success" for "default/rubric"	1	1296.73	95
Component "default/rubric"	1	413.65	30
Partial "default/_rubric"	1	39.58	2
Component "default/pager"	1	0.06	0
Partial "default/_pager"	1	1.81	0
Component "default/about"	1	1.73	0
Partial "default/_about"	1	1.94	0
Component "default/controlMenu"	1	0.40	0
Partial "default/_controlMenu"	1	0.12	0
Component "search/siteSearch"	1	7.36	0
Partial "search/_siteSearch"	1	792.20	58
Component "default/statistic"	1	1.39	0
Partial "default/_statistic"	1	0.23	0
Component "news/recommend"	1	4.71	0
Partial "news/_recommend"	1	0.22	0
Component "default/rubricsTree"	1	6.39	0
Partial "default/_rubricsTree"	1	0.85	0
Component "currencies/currencies"	1	5.25	0
Partial "currencies/_currencies"	1	0.68	0
Component "default/personal"	1	1.93	0
Partial "default/_personal"	1	2.53	0
Component "default/footer"	1	1.15	0
Partial "default/_footer"	1	1.54	0
Partial "personal/_login"	1	0.17	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='jkh' 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=666
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=654
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='jkh' 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=666
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=654
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 (676) 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 ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738766' 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<='3488738766' 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<='3488738766' AND ip_place.IP_TO>='3488738766'
SELECT COUNT(*) FROM `firms__rubrics`, `firms` WHERE firms__rubrics.RUBRIC_ID IN (676) AND firms.ACTIVITY=true AND firms.ID IN (18016,372797,17627,17465,17340,17962,17706,17581,17520,372790,18001,17744,17970,17253,18232,327387,17455,17381,372759,17264,372746,345652,17768,17451,372747,17473,363618,327365,17714,17711,17825,17919,278851,17535,17727,17379,17841,17992,228520,17864,17793,17728,17281,17976,17679,17547,18218,17861,372737,18003,327411,17275,17839,17478,18089,18233,17336,17433,228607,18124,372792,17335,363612,345649,18103,363615,17646,17723,17753,17796,18082,17329,18053,202273,18202,18228,17699,327389,327424,17257,17661,17951,17258,17261,17502,17755,17824,18225,345630,17251,17305,17464,18039,18234,228508,17252,17352,17611,17667,278922,17365,17402,17424,17470,17625,17678,17968,17998,327405,372791,17330,17887,18216,327379,363619,17302,17357,17645,17988,17570,17639,17806,18041,228594,278836,17589,17716,18050,18176,18189,372764,372779,17292,17303,17707,17809,345650,17296,17317,17406,17543,18092,18220,327436,363617,17290,17360,17409,17456,17620,17730,17929,18052,18191,18204,17300,17316,17376,17519,17701,17724,17921,278849,327404,345693,372780,17284,17386,17499,17672,17677,18095,18147,18200,228497,278806,327397,345549,345570,345576,345682,372738,17517,17690,17865,17993,18226,228560,228564,345703,363613,363616,372784,17366,17466,17637,17650,17721,17738,17854,202251,228548,278859,278860,345633,345701,372765,17267,17371,17405,17675,17708,18093,18109,228521,228559,278863,327367,345681,345709,17266,17279,17446,17888,17892,17928,18206,18210,18231,202276,228581,345628,17309,17321,17393,17394,17594,17704,17720,17780,17907,17990,18027,18117,18223,228527,228549,278939,17361,17410,17494,17632,17658,17673,17681,17732,17868,17875,17969,17985,18065,18111,18132,202264,202299,228529,228557,278805,327422,345567,345573,363640,372741,372754,372755,372766,17263,17271,17332,17333,17493,17531,17564,17740,17830,17913,17930,18017,18020,18110,18118,18208,18221,228523,228546,228568,228597,345556,345651,372733,372745,372789,17278,17306,17327,17377,17439,17461,17477,17497,17597,17608,17735,17743,17751,17752,18047,18070,18135,18222,202275,228569,228576,228595,278830,278845,345552,345672,345702,17265,17287,17297,17307,17310,17350,17355,17442,17640,17698,17759,17760,17778,17785,17898,17900,17981,18011,18209,18211,202292,228622,278815,278839,278844,327372,327410,327435,345559,345602,363611,363629,372794,17346,17378,17400,17425,17436,17447,17521,17522,17524,17552,17569,17577,17578,17631,17717,17719,17774,17847,17873,17911,17933,18024,18025,18058,18077,18108,18121,202249,228518,228563,228599,278834,278856,278926,345603,345669,345698,345719,372804,17283,17323,17390,17417,17428,17435,17629,17813,17860,17953,17991,18043,18096,18114,18133,18165,18196,18205,18219,202290,221317,228558,228585,228623,278817,278868,327393,345561,345577,345578,345605,363621,372751,372801,17285,17293,17301,17312,17319,17331,17349,17363,17369,17370,17387,17445,17489,17492,17571,17572,17592,17605,17609,17612,17624,17741,17745,17779,17801,17805,17822,17918,17937,17963,18008,18046,18055,18079,18094,18112,18134,18144,18151,18190,18203,202281,228509,228582,345557,345562,345581,345607,345639,345656,345665,345700,363620,363634,17255,17314,17339,17359,17403,17431,17474,17485,17542,17544,17549,17550,17561,17601,17614,17617,17662,17694,17771,17773,17804,17815,17848,17852,17859,17862,17891,17903,17961,18037,18072,18107,18154,18197,18230,202263,202278,202295,220128,228524,228550,228561,228592,278857,278865,278886,327366,345580,345604,345625,345720,363608,372775,372778,17269,17276,17282,17286,17343,17345,17364,17367,17389,17407,17491,17495,17514,17545,17556,17558,17591,17619,17664,17722,17747,17765,17769,17770,17789,17800,17840,17882,17949,17982,17995,17996,18009,18051,18087,18100,18137,18201,18207,18217,202257,202284,228502,228513,228551,228565,228588,228589,228591,228598,228602,278858,278866,278912,327363,327376,327396,327407,345566,345618,345621,345631,345643,345678,345708,363614,372752,372782,372793,372795,17274,17354,17388,17397,17412,17413,17481,17482,17488,17498,17575,17576,17593,17622,17636,17641,17644,17692,17709,17713,17756,17786,17810,17835,17867,17883,17884,18013,18015,18031,18054,18073,18074,18099,18146,18150,18178,18215,202245,202250,202300,228503,228603,228612,248343,278846,278854,278864,278880,278896,327368,327391,327401,345641,345683,345711,363602,372770,372772,372785,17288,17291,17298,17304,17337,17351,17358,17373,17391,17401,17411,17454,17459,17467,17490,17503,17513,17528,17541,17598,17602,17626,17635,17647,17663,17671,17683,17700,17712,17749,17772,17792,17799,17803,17811,17845,17863,17869,17872,17877,17904,17943,17964,17989,18007,18038,18057,18066,18084,18090,18091,18113,18125,18128,18129,18153,18168,18185,18213,18214,202246,202282,202291,228501,228510,228547,228555,228596,228625,278824,278827,278840,278850,278894,278895,278931,327385,327415,327418,327426,345574,345593,345608,345638,345660,345684,345710,372740,372742,372743,372748,372750,372753,372762,372773,372783,372786,17273,17280,17320,17326,17328,17372,17374,17441,17449,17509,17512,17527,17566,17567,17603,17607,17630,17669,17696,17697,17781,17797,17814,17821,17827,17849,17857,17879,17881,17905,17915,17923,17938,17945,17948,17954,17966,17971,17975,17977,17978,17984,18022,18061,18080,18120,18138,18158,18175,18183,18187,18235,202253,202271,202277,228507,228511,228528,228533,228534,228562,228606,228613,228620,228626,278808,278811,278812,278842,278853,278855,278861,278904,278929,327351,327373,327394,327414,345551,345553,345591,345609,345610,345640,345642,345675,345713,363628,372735,372798,379804,379881,17272,17311,17324,17341,17362,17382,17392,17396,17414,17418,17420,17468,17469,17479,17480,17483,17501,17504,17537,17551,17557,17560,17565,17582,17587,17595,17600,17610,17653,17746,17757,17763,17784,17790,17794,17795,17843,17850,17922,17972,18021,18049,18056,18060,18085,18106,18136,18140,18152,18157,18160,18227,18229,202244,202248,202260,202272,202274,202296,202297,228506,228537,228553,228584,228600,248359,278814,278867,278878,278881,278893,278900,278902,327409,327421,327430,345575,345632,345644,345646,345655,345657,345695,345696,345714,345718,363609,363641,372734,372760,372803,17250,17254,17313,17325,17334,17348,17353,17395,17398,17416,17440,17458,17462,17500,17510,17554,17563,17573,17586,17604,17628,17634,17670,17682,17685,17687,17689,17703,17710,17758,17783,17817,17818,17819,17826,17829,17851,17870,17874,17880,17890,17899,17925,17934,17935,17967,17999,18010,18062,18063,18068,18071,18101,18143,18170,18174,18177,18180,18181,18184,18192,202254,202267,202280,202298,228516,228536,228538,228541,228542,228573,228590,228605,228616,228617,248341,248345,278831,278832,278862,278890,278913,278921,278932,278942,327353,327374,327381,327388,327392,327398,327400,327406,327427,327429,345564,345582,345596,345606,345613,345635,345654,345659,345664,345667,345680,363593,363600,363624,372761,372769,17248,17260,17262,17289,17295,17315,17322,17338,17347,17375,17384,17399,17457,17463,17476,17506,17515,17518,17523,17534,17538,17559,17562,17579,17583,17585,17588,17648,17649,17684,17695,17725,17726,17736,17739,17750,17798,17802,17832,17836,17837,17846,17871,17876,17895,17897,17901,17910,17920,17927,17946,17950,17956,17965,17980,18005,18045,18048,18067,18097,18105,18156,18179,18199,18212,202255,202256,202258,202266,202279,202287,202288,202289,228500,228504,228512,228517,228522,228539,228540,228556,228571,228572,228574,228575,228583,228614,228615,228621,248333,278810,278829,278869,278871,278879,278883,278884,278897,278901,278905,278911,278919,278923,278924,327364,327386,327390,327395,345548,345584,345597,345599,345611,345622,345624,345661,345671,345687,345704,345707,363625,363626,363633,363636,363642,372749,372767,372799,17247,17256,17259,17294,17299,17308,17318,17368,17385,17408,17453,17471,17484,17486,17487,17505,17507,17511,17526,17529,17530,17532,17536,17540,17553,17555,17606,17638,17651,17657,17659,17668,17691,17731,17766,17776,17782,17807,17816,17833,17878,17912,17936,17940,17958,17960,17974,17979,17986,17994,18004,18018,18023,18034,18069,18083,18088,18098,18102,18122,18127,18131,18148,18167,18194,202252,202259,202261,202268,202283,202293,202294,202301,228525,228531,228532,228535,228543,228545,228552,228566,228579,228619,228624,248342,248344,248347,248350,248358,278818,278822,278826,278837,278874,278891,278892,327355,327357,327412,327423,327428,327433,345550,345579,345585,345592,345595,345600,345617,345623,345626,345634,345658,345663,345679,345688,345690,345697,345712,363604,363627,363632,372774,372776,372802,17246,17270,17342,17356,17429,17432,17434,17443,17444,17472,17516,17548,17580,17584,17621,17623,17655,17660,17665,17680,17693,17715,17733,17734,17748,17761,17762,17777,17823,17844,17855,17858,17889,17894,17906,17909,17917,17941,17942,17944,17952,17957,17987,18019,18030,18035,18042,18044,18059,18104,18115,18123,18130,18139,18141,18159,18166,18169,18171,18182,18193,202265,202269,202305,202307,228567,228570,228586,248337,248346,278821,278823,278828,278898,278927,278935,327370,327413,327432,345568,345569,345590,345594,345601,345636,345645,345692,345705,345715,363601,372736,372758,372771,372800,17268,17383,17404,17419,17430,17437,17450,17496,17525,17539,17590,17596,17599,17613,17652,17666,17676,17705,17729,17737,17767,17775,17787,17791,17808,17828,17831,17853,17866,17885,17896,17902,17908,17924,17926,17973,18000,18006,18026,18033,18040,18076,18081,18086,18116,18126,18155,18162,18172,18173,202262,202270,202285,202286,228498,228577,228578,248336,248353,278838,278843,278899,278928,278936,278937,327352,327371,327416,345547,345554,345555,345571,345586,345598,345629,345648,345666,345676,345694,345706,345716,345717,363597,363622,363623,372788,17249,17277,17344,17421,17422,17423,17533,17615,17643,17654,17656,17674,17686,17702,17742,17754,17788,17820,17856,17893,17914,17916,17931,17932,17939,17997,18002,18014,18029,18032,18075,18119,18145,18161,18195,18224,228530,228544,228610,248330,248331,248332,248338,248339,248352,248354,248357,278807,278809,278819,278820,278833,278872,278889,278907,278910,278914,278930,278933,327361,327362,327380,327383,327384,327402,327408,327434,345558,345565,345587,345588,345614,345616,345619,345620,345627,345653,345668,345685,345689,345691,363606,363630,363637,372744,372757,372763,372781,372787,17426,17438,17448,17452,17475,17508,17546,17616,17633,17642,17688,17764,17834,17886,17955,17983,18012,18036,18064,18142,18149,18186,18188,228499,228587,228593,248340,248351,278825,278847,278875,278876,278882,278887,278918,278938,278941,327354,327356,327358,327360,327382,327417,345670,345699,363607,372739,372756,372777,17380,17415,17427,17460,17574,17618,17812,17842,17947,17959,18028,18078,18163,202247,202302,202306,228514,228515,228519,248348,278816,278835,278848,278870,278903,278916,278917,278934,327378,327399,345563,345583,345615,345637,345662,345686,363595,363605,363610,363631,363635,363643,372796,17718,17838,18164,18198,228580,228608,228609,228618,278873,278877,278885,278908,278909,278920,278925,327375,327377,327403,327431,345589,345673,345674,345677,363594,363638,363639,372768,202303,228505,228554,228601,228611,248335,248349,278813,278852,278888,278915,327369,327425,345560,345572,345647,17568,228526,228604,248329,248334,248355,278906,327420,345612,363596,363598,363603,202304,248356,278841,278940,327359,327419,363599,380199,380235) 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 (676) AND firms.ACTIVITY=true AND firms.ID IN (18016,372797,17627,17465,17340,17962,17706,17581,17520,372790,18001,17744,17970,17253,18232,327387,17455,17381,372759,17264,372746,345652,17768,17451,372747,17473,363618,327365,17714,17711,17825,17919,278851,17535,17727,17379,17841,17992,228520,17864,17793,17728,17281,17976,17679,17547,18218,17861,372737,18003,327411,17275,17839,17478,18089,18233,17336,17433,228607,18124,372792,17335,363612,345649,18103,363615,17646,17723,17753,17796,18082,17329,18053,202273,18202,18228,17699,327389,327424,17257,17661,17951,17258,17261,17502,17755,17824,18225,345630,17251,17305,17464,18039,18234,228508,17252,17352,17611,17667,278922,17365,17402,17424,17470,17625,17678,17968,17998,327405,372791,17330,17887,18216,327379,363619,17302,17357,17645,17988,17570,17639,17806,18041,228594,278836,17589,17716,18050,18176,18189,372764,372779,17292,17303,17707,17809,345650,17296,17317,17406,17543,18092,18220,327436,363617,17290,17360,17409,17456,17620,17730,17929,18052,18191,18204,17300,17316,17376,17519,17701,17724,17921,278849,327404,345693,372780,17284,17386,17499,17672,17677,18095,18147,18200,228497,278806,327397,345549,345570,345576,345682,372738,17517,17690,17865,17993,18226,228560,228564,345703,363613,363616,372784,17366,17466,17637,17650,17721,17738,17854,202251,228548,278859,278860,345633,345701,372765,17267,17371,17405,17675,17708,18093,18109,228521,228559,278863,327367,345681,345709,17266,17279,17446,17888,17892,17928,18206,18210,18231,202276,228581,345628,17309,17321,17393,17394,17594,17704,17720,17780,17907,17990,18027,18117,18223,228527,228549,278939,17361,17410,17494,17632,17658,17673,17681,17732,17868,17875,17969,17985,18065,18111,18132,202264,202299,228529,228557,278805,327422,345567,345573,363640,372741,372754,372755,372766,17263,17271,17332,17333,17493,17531,17564,17740,17830,17913,17930,18017,18020,18110,18118,18208,18221,228523,228546,228568,228597,345556,345651,372733,372745,372789,17278,17306,17327,17377,17439,17461,17477,17497,17597,17608,17735,17743,17751,17752,18047,18070,18135,18222,202275,228569,228576,228595,278830,278845,345552,345672,345702,17265,17287,17297,17307,17310,17350,17355,17442,17640,17698,17759,17760,17778,17785,17898,17900,17981,18011,18209,18211,202292,228622,278815,278839,278844,327372,327410,327435,345559,345602,363611,363629,372794,17346,17378,17400,17425,17436,17447,17521,17522,17524,17552,17569,17577,17578,17631,17717,17719,17774,17847,17873,17911,17933,18024,18025,18058,18077,18108,18121,202249,228518,228563,228599,278834,278856,278926,345603,345669,345698,345719,372804,17283,17323,17390,17417,17428,17435,17629,17813,17860,17953,17991,18043,18096,18114,18133,18165,18196,18205,18219,202290,221317,228558,228585,228623,278817,278868,327393,345561,345577,345578,345605,363621,372751,372801,17285,17293,17301,17312,17319,17331,17349,17363,17369,17370,17387,17445,17489,17492,17571,17572,17592,17605,17609,17612,17624,17741,17745,17779,17801,17805,17822,17918,17937,17963,18008,18046,18055,18079,18094,18112,18134,18144,18151,18190,18203,202281,228509,228582,345557,345562,345581,345607,345639,345656,345665,345700,363620,363634,17255,17314,17339,17359,17403,17431,17474,17485,17542,17544,17549,17550,17561,17601,17614,17617,17662,17694,17771,17773,17804,17815,17848,17852,17859,17862,17891,17903,17961,18037,18072,18107,18154,18197,18230,202263,202278,202295,220128,228524,228550,228561,228592,278857,278865,278886,327366,345580,345604,345625,345720,363608,372775,372778,17269,17276,17282,17286,17343,17345,17364,17367,17389,17407,17491,17495,17514,17545,17556,17558,17591,17619,17664,17722,17747,17765,17769,17770,17789,17800,17840,17882,17949,17982,17995,17996,18009,18051,18087,18100,18137,18201,18207,18217,202257,202284,228502,228513,228551,228565,228588,228589,228591,228598,228602,278858,278866,278912,327363,327376,327396,327407,345566,345618,345621,345631,345643,345678,345708,363614,372752,372782,372793,372795,17274,17354,17388,17397,17412,17413,17481,17482,17488,17498,17575,17576,17593,17622,17636,17641,17644,17692,17709,17713,17756,17786,17810,17835,17867,17883,17884,18013,18015,18031,18054,18073,18074,18099,18146,18150,18178,18215,202245,202250,202300,228503,228603,228612,248343,278846,278854,278864,278880,278896,327368,327391,327401,345641,345683,345711,363602,372770,372772,372785,17288,17291,17298,17304,17337,17351,17358,17373,17391,17401,17411,17454,17459,17467,17490,17503,17513,17528,17541,17598,17602,17626,17635,17647,17663,17671,17683,17700,17712,17749,17772,17792,17799,17803,17811,17845,17863,17869,17872,17877,17904,17943,17964,17989,18007,18038,18057,18066,18084,18090,18091,18113,18125,18128,18129,18153,18168,18185,18213,18214,202246,202282,202291,228501,228510,228547,228555,228596,228625,278824,278827,278840,278850,278894,278895,278931,327385,327415,327418,327426,345574,345593,345608,345638,345660,345684,345710,372740,372742,372743,372748,372750,372753,372762,372773,372783,372786,17273,17280,17320,17326,17328,17372,17374,17441,17449,17509,17512,17527,17566,17567,17603,17607,17630,17669,17696,17697,17781,17797,17814,17821,17827,17849,17857,17879,17881,17905,17915,17923,17938,17945,17948,17954,17966,17971,17975,17977,17978,17984,18022,18061,18080,18120,18138,18158,18175,18183,18187,18235,202253,202271,202277,228507,228511,228528,228533,228534,228562,228606,228613,228620,228626,278808,278811,278812,278842,278853,278855,278861,278904,278929,327351,327373,327394,327414,345551,345553,345591,345609,345610,345640,345642,345675,345713,363628,372735,372798,379804,379881,17272,17311,17324,17341,17362,17382,17392,17396,17414,17418,17420,17468,17469,17479,17480,17483,17501,17504,17537,17551,17557,17560,17565,17582,17587,17595,17600,17610,17653,17746,17757,17763,17784,17790,17794,17795,17843,17850,17922,17972,18021,18049,18056,18060,18085,18106,18136,18140,18152,18157,18160,18227,18229,202244,202248,202260,202272,202274,202296,202297,228506,228537,228553,228584,228600,248359,278814,278867,278878,278881,278893,278900,278902,327409,327421,327430,345575,345632,345644,345646,345655,345657,345695,345696,345714,345718,363609,363641,372734,372760,372803,17250,17254,17313,17325,17334,17348,17353,17395,17398,17416,17440,17458,17462,17500,17510,17554,17563,17573,17586,17604,17628,17634,17670,17682,17685,17687,17689,17703,17710,17758,17783,17817,17818,17819,17826,17829,17851,17870,17874,17880,17890,17899,17925,17934,17935,17967,17999,18010,18062,18063,18068,18071,18101,18143,18170,18174,18177,18180,18181,18184,18192,202254,202267,202280,202298,228516,228536,228538,228541,228542,228573,228590,228605,228616,228617,248341,248345,278831,278832,278862,278890,278913,278921,278932,278942,327353,327374,327381,327388,327392,327398,327400,327406,327427,327429,345564,345582,345596,345606,345613,345635,345654,345659,345664,345667,345680,363593,363600,363624,372761,372769,17248,17260,17262,17289,17295,17315,17322,17338,17347,17375,17384,17399,17457,17463,17476,17506,17515,17518,17523,17534,17538,17559,17562,17579,17583,17585,17588,17648,17649,17684,17695,17725,17726,17736,17739,17750,17798,17802,17832,17836,17837,17846,17871,17876,17895,17897,17901,17910,17920,17927,17946,17950,17956,17965,17980,18005,18045,18048,18067,18097,18105,18156,18179,18199,18212,202255,202256,202258,202266,202279,202287,202288,202289,228500,228504,228512,228517,228522,228539,228540,228556,228571,228572,228574,228575,228583,228614,228615,228621,248333,278810,278829,278869,278871,278879,278883,278884,278897,278901,278905,278911,278919,278923,278924,327364,327386,327390,327395,345548,345584,345597,345599,345611,345622,345624,345661,345671,345687,345704,345707,363625,363626,363633,363636,363642,372749,372767,372799,17247,17256,17259,17294,17299,17308,17318,17368,17385,17408,17453,17471,17484,17486,17487,17505,17507,17511,17526,17529,17530,17532,17536,17540,17553,17555,17606,17638,17651,17657,17659,17668,17691,17731,17766,17776,17782,17807,17816,17833,17878,17912,17936,17940,17958,17960,17974,17979,17986,17994,18004,18018,18023,18034,18069,18083,18088,18098,18102,18122,18127,18131,18148,18167,18194,202252,202259,202261,202268,202283,202293,202294,202301,228525,228531,228532,228535,228543,228545,228552,228566,228579,228619,228624,248342,248344,248347,248350,248358,278818,278822,278826,278837,278874,278891,278892,327355,327357,327412,327423,327428,327433,345550,345579,345585,345592,345595,345600,345617,345623,345626,345634,345658,345663,345679,345688,345690,345697,345712,363604,363627,363632,372774,372776,372802,17246,17270,17342,17356,17429,17432,17434,17443,17444,17472,17516,17548,17580,17584,17621,17623,17655,17660,17665,17680,17693,17715,17733,17734,17748,17761,17762,17777,17823,17844,17855,17858,17889,17894,17906,17909,17917,17941,17942,17944,17952,17957,17987,18019,18030,18035,18042,18044,18059,18104,18115,18123,18130,18139,18141,18159,18166,18169,18171,18182,18193,202265,202269,202305,202307,228567,228570,228586,248337,248346,278821,278823,278828,278898,278927,278935,327370,327413,327432,345568,345569,345590,345594,345601,345636,345645,345692,345705,345715,363601,372736,372758,372771,372800,17268,17383,17404,17419,17430,17437,17450,17496,17525,17539,17590,17596,17599,17613,17652,17666,17676,17705,17729,17737,17767,17775,17787,17791,17808,17828,17831,17853,17866,17885,17896,17902,17908,17924,17926,17973,18000,18006,18026,18033,18040,18076,18081,18086,18116,18126,18155,18162,18172,18173,202262,202270,202285,202286,228498,228577,228578,248336,248353,278838,278843,278899,278928,278936,278937,327352,327371,327416,345547,345554,345555,345571,345586,345598,345629,345648,345666,345676,345694,345706,345716,345717,363597,363622,363623,372788,17249,17277,17344,17421,17422,17423,17533,17615,17643,17654,17656,17674,17686,17702,17742,17754,17788,17820,17856,17893,17914,17916,17931,17932,17939,17997,18002,18014,18029,18032,18075,18119,18145,18161,18195,18224,228530,228544,228610,248330,248331,248332,248338,248339,248352,248354,248357,278807,278809,278819,278820,278833,278872,278889,278907,278910,278914,278930,278933,327361,327362,327380,327383,327384,327402,327408,327434,345558,345565,345587,345588,345614,345616,345619,345620,345627,345653,345668,345685,345689,345691,363606,363630,363637,372744,372757,372763,372781,372787,17426,17438,17448,17452,17475,17508,17546,17616,17633,17642,17688,17764,17834,17886,17955,17983,18012,18036,18064,18142,18149,18186,18188,228499,228587,228593,248340,248351,278825,278847,278875,278876,278882,278887,278918,278938,278941,327354,327356,327358,327360,327382,327417,345670,345699,363607,372739,372756,372777,17380,17415,17427,17460,17574,17618,17812,17842,17947,17959,18028,18078,18163,202247,202302,202306,228514,228515,228519,248348,278816,278835,278848,278870,278903,278916,278917,278934,327378,327399,345563,345583,345615,345637,345662,345686,363595,363605,363610,363631,363635,363643,372796,17718,17838,18164,18198,228580,228608,228609,228618,278873,278877,278885,278908,278909,278920,278925,327375,327377,327403,327431,345589,345673,345674,345677,363594,363638,363639,372768,202303,228505,228554,228601,228611,248335,248349,278813,278852,278888,278915,327369,327425,345560,345572,345647,17568,228526,228604,248329,248334,248355,278906,327420,345612,363596,363598,363603,202304,248356,278841,278940,327359,327419,363599,380199,380235) AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.VIEWS_COUNT DESC LIMIT 80, 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=17661 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=17951 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=104362
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=17258 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=17261 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=17502 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=97392
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=17755 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=97312
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=17824 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=18225 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=345630 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=150081
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=17251 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=17305 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=97868
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=17464 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=105549
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=18039 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=18234 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=228508 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=32102
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=17252 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=24304
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=17352 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=17611 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=100424
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=17667 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=97375
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=278922 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 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>='3488738766' 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<='3488738766' 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<='3488738766' AND ip_place.IP_TO>='3488738766'
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,219,51,425,338,289,117,79,118,80,339,343,426,220,376,340,81,427,377,82,119,378,83,428,221,292,84,120,222,223,224,2,85,381,86,225,341,342,121,429,290,291,226,122,380,379,123,87,293)
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 (8155,8156)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (28145,28185,28148,28187,28188,28408,29030,28263,28672,28243,29154,28420,28395,28417,28245,29149,29144,28419,28249,28411,28260,29158,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,37784,37598,37603,37589,37599,38200,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,39039,39884,38327,40327,40986,38299,38301,41147,41258,38310,40332,42623)
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,42685,42638,42884,43017,43078)
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,835,3015,1329,4730,4434,4067,5752,1917,935,3118,4629,5922,6038,3119,695,431,4005,4731,1918,936,2672,2038,6439,5355,5207,6302,3362,4825,5480,3478,1330,5481,1715,836,5923,5924,5356,6678,4732,4630,6679,694,2255,6175,5206,5101,6563,6564,5753,3723,457,6795,3479,1714,5925,4631,4632,1025,2927,5102,4154,3597,6176,6177,2574,4068,3851,938,2854,937,6440,2723,6565,1026,1919,6796,1789,2724,6441,3363,1457,3613,4520,5754,5357,5358,3852,2673,5482,2134,1701,1027,6303,3480,2034,6566,3120,2725,5021,6797,3598,6442,5926,3121,837,3855,3853,3854,1328,4826,2726,4521,939,1458,5208,5839,3364,5840,1195,2256,1196,4435,2135,5022,6039,2407,4006,3009,1331,1691,2855,1915,5359,2856,1790,3197,2137,2039,6680,3122,4953,2037,2674,1332,2131,1197,5619,3481,2257,2406,1575,4961,2408,4957,3724,4733,4827,4734,4828,5209,2559,4007,1460,5755,696,5483,5841,2675,6567,5927,5362,2857,1028,2136,2858,2409,2676,4633,3599,3198,1920,5620,3199,4069,2138,3482,3856,5484,5621,1576,5842,3600,838,2928,2410,4315,4634,2677,3008,6443,839,2727,2560,5622,5843,4522,1461,6568,6677,6569,5844,2042,5845,4636,5363,1462,6304,697,2258,6178,3200,1702,4735,2929,6179,4071,3483,6793,6305,1029,4070,3013,2040,1791,6180,4964,6181,3001,4436,1711,4008,1923,698,2930,6444,2859,4316,840,1921,1333,3195,2860,4955,1577,4635,6306,2036,1710,5364,699,1922,4438,6182,4072,4317,1198,841,3365,3201,6681,5928,3366,3484,4318,6445,2411,2412,2415,4437,5756,4965,5623,5757,6682,5758,2861,6040,940,1924,2728,941,4829,4319,3485,3486,4320,690,3014,1199,6798,6446,3123,3487,6447,3601,1334,1335,1338,3602,5103,3596,3488,1925,1200,1336,1337,4637,4830,4009,5210,1926,6683,3489,5381,5759,3124,6684,842,1463,1030,2678,843,4831,5624,3725,2035,2139,6041,2931,3726,3727,3367,5485,3368,5486,4832,2045,4010,1464,3196,4073,5625,3202,2561,6183,3490,5211,6042,3857,5846,5626,4963,2562,1792,5627,4523,3858,3125,2259,4155,4011,1793,6448,700,4012,844,1031,4951,2260,2679,3203,1032,1201,3728,2044,1033,6685,2729,1465,2563,1466,845,2730,6570,3859,701,4321,5760,6449,1034,2862,4960,5360,2564,4645,2043,6571,3369,5023,942,5024,943,2863,3732,5366,702,4439,846,1035,5212,5365,4322,5487,3370,3126,3491,2681,2565,5847,3603,6799,2735,3604,1341,448,1578,5761,1036,1579,5213,1580,4736,5488,6686,3860,1339,2140,6572,2261,2680,4524,1467,4440,4156,1037,1038,3012,847,5104,5105,2932,4737,3371,4441,4833,6184,4074,944,1927,4834,3861,1794,3372,5929,3605,1712,6450,5361,4323,1708,4738,5106,5489,5743,1039,4525,3204,2141,6800,455,453,4628,4638,848,4962,1342,1202,6451,2933,1706,2934,5107,5108,6687,703,5742,6801,2262,6688,704,1459,945,5848,1203,2935,2047,6307,4835,4958,4956,4442,6802,4324,2864,3862,4157,3127,1340,4443,5109,1468,1040,1204,691,1469,3373,5110,1205,5367,5744,432,1343,849,850,6803,5490,4325,6308,1795,1581,3730,4075,6804,1582,6309,5628,3000,851,4013,5629,5368,1928,4950,2414,705,4159,4158,5025,5026,5849,3606,6452,5745,6043,1796,3863,4160,5930,1470,4161,4162,1206,6805,4954,6044,1471,4014,2682,3731,3729,5027,6045,1472,3492,4739,3864,4740,4163,2413,4326,3128,5028,2731,5491,6185,4836,1473,6186,3129,692,4741,1797,4639,1583,4640,4327,6310,5634,1929,3865,5746,2936,2416,441,5370,706,2417,946,6453,2142,4444,5369,3374,5029,4641,5371,4642,6454,2263,5030,5111,3608,1041,6311,4328,456,5372,4015,3866,5373,2418,5850,6689,5747,5374,4016,5851,6455,6573,6690,852,4164,5852,6046,4526,1709,6691,4165,6047,4742,5375,3493,707,2937,5376,3011,2566,3205,4017,2865,4643,5630,3607,3130,442,5112,3609,2938,5931,6456,4329,2419,853,5214,5031,4644,4952,4166,5748,6187,4018,4445,2567,1584,1207,1707,3003,1344,6806,5631,2568,6692,1930,444,1345,2939,2143,4019,3610,1705,854,6693,1931,2999,3010,1474,3867,4837,4020,2144,6807,5749,1585,5032,1798,6457,4527,5033,5215,6048,4528,5632,1476,6458,3494,4529,1475,1478,1477,2732,6188,4021,4167,2420,2145,2733,3004,3495,5633,4530,6312,3006,1479,1586,4168,6808,3734,1208,5932,5216,5354,5635,3735,6809,3002,1042,1209,3131,2146,2046,5750,2264,3496,2866,947,2569,1346,3375,2683,3132,4446,5113,6810,6049,6811,1480,5377,5934,2684,2265,708,1799,3005,2940,5636,1347,5933,2867,6574,458,2868,855,2570,1210,6575,3868,1348,5853,2685,5114,2734,1932,4330,1211,2869,1587,2266,856,1212,1349,2421,4076,1703,6050,5614,1213,1933,5751,3497,3376,693,5217,5115,1214,1215,1588,454,4838,3733,5637,2571,5378,5218,2147,2422,2267,948,1934,3377,3378,2941,1481,1043,5762,5763,4331,1800,3869,2572,3206,3611,1482,3379,5116,3498,1044,6051,6313,2573,1045,4959,1216,4839,3870,1704,5379,3007,1046,3133,2870,1801,577,5935,5764,5741,6812,5854,689,5936,5219,6576,6577,5937,6314,4332,857,4840,6052,2686,3499,709,6813,710,6189,6814,2148,6190,1217,3380,5638,4841,858,5380,6694,4447,1589,4022,6315,4531,1713,859,4646,711,6695,1935,6191,1590,6459,2687,5492,4169,2041,1218,3207,4333,4334,712,1350,6053,3500,4743,3501,3871,2268,4448,1591,5493,4335,6460,2269,3208,6438,5117,6578,2871,5220,3612,3134,1802,2270,1351,3502,2942,5221)
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,43192,43098,43976,43350,43546,43658,43831,44126,44475,44736,44648)
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,46012,46718,45393,47682,46717,46398,47205,47957,46608,47206,45463,48080,45464,46936,45905,45084,46142,44844,45459,46399,46719,46937,47207,46287,46609,45906,45085,46797,45465,45907,46610,46720,46938,47208,47818,45547,45086,47334,47617,45176,48081,46618,45699,47618,46945,44974,45259,45087,45260,47958,46939,46940,45644,46288,47209,47819,46798,45701,47622,47210,45088,47430,44975,46941,47211,44976,45908,45392,45082,47820,45457,45468,45548,45642,45643,44977,45646,46799,47619,47620,45697,45698,48082,45460,46400,46143,47621,46145,45903,45904,46146,46942,46011,44852,46721,45177,47681,46467,46396,46289,47433,48083,46466,46611,47212,45178,45089,45647,47821,46147,45648,46401,45081,47822,46397,46290,45179,46468,46013,46469,45461,46470,46402,46606,46607,46291,47626,45258,46014,46148,44978,47623,46141,46617,45549,47213,47624,46015,45910,46716,46016,48084,47683,45466,44980,47823,44979,44856,47684,46612,46149,44981,46616,46150,47436,45649,47824,45180,46613,44982,48085,44983,45394,47214,46292,46471,45909,45261,46144,46935,45083,47435,47215,47625,46943,47202,47203,46944,46723,47434,47216,47204,45911,46724,45395,47217,45650,47333,45702,46293,45262,45396,46725,46151,44984,47428,47429,47959,47685,47335,44851,47218,47960,45397,47219,45398,46614,46726,45181,45467,46294,46295,44985,45090,46615,46727,45182,45703,46800,48086,47616,46801,48087,45462,44986,46946,45091,46947,47680,44987,47816,47817,46152,45263,47961,47220,47432,45651,46803,47955,47956,47336,48078,48079,45264,46403,47962,45183,47337,45458,46802,45184,45652,47686,46153,45185,46948,47431,44988,46722,46154,47221,46155,45645,47338,46804,46619,46728,45700,46949,47963,46472)
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,7276,7807,7129,7471,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,48364,48089,48606,48755,48941,49069,48365,49189,49367,49514,49910,50004,48949,50206,49641,49745,49909,49912,48114,50205,48366,50415,50573,50727)
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,50986,51071,51174,51227,51345,51373,52100,51486,51544,51631,51714,51893,51228,52035,52204,52310,52359)
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,53664,54095,54772,52459,55621,56155,58268,56921,57693,58267,58986,59487,59881,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,61616,61672,61712,61757,63566,61111,61476,61995,62253,61475,62488,62636,62693,62837,63247,63457,63754)
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,188416)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181037,181221,181251,181070,181072,181365,181480,181522,181640,181710,181802,181039,181916)
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,64306,64397,64567,63756,64961,65088,63989,64962,65765,65764,66001,66160,66430,66552,66726,66825,66980)
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,10196,10133,10180,10144)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (66981,68404,67008,68494,68594,67054,67029,68283,67679,68461,68272,67058,66995,68137,68501,68246,67576,67060,68285,68301,68292,66982,67090,68492,67066,67067,67069,67077,67078,68294,68462,67084,67089,68296,68595,68298)
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,10229,10271,10201,10368,10318,10346,10409,10385)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (69014,69175,69032,69248,69402,69445,69569,69015,69633,69176,69177,69684,69742,69851,69045,69922,70053,69047,69057,70124,69076,70233)
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,71186,71906,71182,71193,71709,71904,70237,72144,72331,71511,71907,72545,72823,72961,73144,73330,70814,72336,71323,73655,73828,74423,74424,74425)
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,74500,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,11263,11307,11435,11030,11490,11769,11875,11013,11943,12155,12197,11046,12235)
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,75561,74586,75709,74858,74949,74907,75676,75493,74606,74648,74610,75562,74947,74696,74656,75081,74681,75495,74616,74662,74634,74659,74669,75382,74861,75499,74640,75492,75503,75559,75628,75675,75507,74671,75883,75822)
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,76396,76649,76991,75886,77429,76509,77740,78123,78232,78285,78519,78573,79115,76059,79914,80054,76746,80397,81035)
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,12553,12857,12308,13133,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,81811,81037,82358,82556,81340,82875,82978,83337,83145,84133,84691,84880)
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 (30027,30356,30417,30484,30100,30567,30125,30146,30695,30761,30901,30028,30799,31104,31144,31301,31440,30179,31595,31705,30210,31812,31856,31927,32006,32083,30487)
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,33305,34904,34594,33030,33125,34339,33533,34544,32934,33589,33927,34478,33668,33714,34382,32973,33669,32441,33359,32867,33925,32974,33670,34661,32360,35087,34905,33814,34383,33031,32623,33847,32513,32975,32814,33081,34957,32442,33928,33534,33082,32362,32935,34429,32976,34595,34596,34545,33415,32936,34151,33416,32579,33417,33083,33671,33418,32108,34546,34668,34745,33929,33672,34480,33084,32937,34854,34700,33673,33032,34257,34746,34340,33715,33306,33535,33360,34787,34430,34707,34597,32443,32627,35081,34747,33590,35088,34906,33848,33991,33307,34662,33591,33220,33674,34598,34258,32977,32515,33309,34152,33361,34907,32580,33473,34788,33765,34547,33126,33930,33127,32113,33419,32444,34259,35066,33592,33420,32581,33221,33033,33474,32363,33034,33308,33362,32656,35092,33363,32124,33310,34153,33815,33766,32445,32364,34789,33593,32868,33222,32346,34865,34154,34748,32682,34958,33364,34431,33536,34341,34750,34999,33421,33537,34483,33471,34855,35000,34432,33769,33932,34433,33538,33768,34155,35001,33594,33992,34049,34342,32365,35002,33475,33716,35089,34343,35093,33717,35094,32373,33767,34484,34482,34186,32876,34050,32517,33764,32582,34434,34051,34485,34384,34663,33933,33849,33934,34790,32583,32978,34548,32938,33675,34265,34260,33850,32102,35095,33311,32939,34856,34187,34600,34857,33128,33595,33422,33935,33476,34344,35033,33087,34791,33816,32518,33718,33851,35082,34385,34792,32352,34858,34156,33312,32733,33423,33313,33314,32520,34601,33315,33540,34859,34549,32869,34157,33424,32979,33931,32870,34188,34602,33035,33541,35083,33365,34664,33223,34435,32366,34860,33224,33129,33936,33596,33676,33597,33719,33937,34603,32368,34550,34052,34665,32980,33770,33720,33721,33366,33130,32982,32446,33225,33425,35096,34551,34345,34959,34189,33426,32871,33317,33477,33085,34552,33318,33771,34793,33316,33478,33088,33479,33367,34908,35097,34386,34553,33852,33427,34161,33598,32447,32981,33817,32355,35090,32584,33319,34861,33369,32989,34190,34053,32872,33131,34599,32983,33599,33428,35034,34261,34346,33772,34960,34436,34191,34192,34054,34554,32585,32449,32984,34486,33320,34794,33321,33322,34666,34262,33938,32448,32450,32873,35032,35098,33323,35084,32451,32514,34263,34862,32586,34864,34158,32522,33774,32874,33600,33039,33368,32587,34961,33601,33429,33036,33939,34909,33677,34555,34193,33722,33853,33370,32452,34264,33854,34387,34159,33371,33542,34701,35003,35004,34347,33480,34863,32372,33226,34481,32358,33678,34604,33723,33543,34070,34266,34437,34348,35005,32875,34667,34702,34911,33086,34910,33324,35099,33773,32990,33775,33681,32985,33602,33037,33544,33227,33372,32524,34703,33724,33725,33679,34150,34160,34349,34605,34350,34912,34388,34479,34704,34606,33548,33855,32453,34749,32588,34795,33089,33726,34853,34071,34607,34556,33545,35085,33546,33325,33326,35091,33547,32454,33228,34903,34705,33682,32455,34706,35086,35100,35101,34962,32986,33430,34487,32940,33327,33229,33727,32589,33940,33680,34796,32590,34389,32987,33549,33818,34072,33941,33328,32369,33132,32988,34669,34162,33230,34963,33942,33219,33539,33481,33038,32941,33776,33329,32526)
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,85219,85384,84896,85526,85628,85773,84937,86163,86223)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,87696,88167,87697,88168,87232,88393,88394,88539,87233,86497,89222,87873,87234,86919,87109,87110,88096,88395,87499,87978,88656,87979,89055,87610,88848,86920,87980,86345,86346,87111,87348,88396,88157,86741,89748,87419,86347,88397,88158,88241,86593,89223,89056,87693,88398,88097,89057,89527,88242,88399,88243,86429,87611,87612,88756,86430,89749,88159,87112,88657,87981,87982,86594,88849,86742,87235,87349,87113,86922,88540,87236,87420,89757,89058,88244,88541,88160,89059,87237,86498,87421,89750,89541,86348,87238,88161,88542,86925,86431,88757,87114,88658,89751,88850,88659,87874,87613,87875,89528,88245,87876,89529,86743,86349,87350,89224,89060,88758,88759,87422,88400,87614,88543,86928,87239,88162,87877,87115,87983,88760,87615,87694,88660,86744,87507,86740,87116,89061,88661,86350,87984,88246,87117,86499,87500,87501,89225,88401,88098,87240,89355,86893,87241,87351,88761,88762,88851,87695,87352,89530,86500,87118,86595,89531,87985,88662,88663,88402,87616,88763,89062,88163,86432,87626,86351,89342,88764,89226,87986,87987,86352,89752,88403,86939,86501,89532,88099,88765,88852,87878,89227,89753,86596,86502,88404,88247,87502,89063,87423,86353,86354,86921,87424,86503,86355,89533,87504,88405,87988,88248,87242,87252,88544,87243,89343,87425,88545,87698,89534,87617,89064,88406,86745,87699,89535,87618,86504,86597,86292,87498,87700,87244,88766,89754,88546,88853,88854,88547,87245,86505,88664,86929,89344,88100,88407,88408,89228,88249,87609,87883,86433,87426,89065,87879,86434,87503,87353,88665,87619,89229,88409,87354,87989,88767,86356,88548,87701,87620,86506,88768,88769,87355,87246,89536,86746,89230,89066,88549,86930,89345,88410,89755,86357,89067,89756,87702,88250,89231,88550,87356,86747,88411,88412,89346,86598,88551,86435,86937,89758,86507,89347,89068,87880,88164,89069,89232,87505,88413,87506,88101,86599,89537,86938,88414,88770,86600,86748,89759,89348,87119,89760,87977,87427,86358,89538,88552,88415,86359,87428,88165,89233,87621,87248,88666,87703,89539,87990,86749,87881,87882,89761,86360,86750,88166,88553,86361,89234,87884,89349,87357,88771,87429,88667,88102,86751,87249,88855,88772,89235,89350,89762,87991,89763,88416,86752,86508,88773,86956,86753,89540,88417,89236,88251,87358,88252,88253,87704,87430,86940,88254,86942,88554,87120,87705,87706,86436,87707,88856,86437,89237,87992,89351,89070,88774,87993,87359,88392,89764,86944,88255,89238,86438,87431,88775,87708,87121,87360,87122,87709,87622,86754,87250,86509,87123,89239,86439,87432,86947,86755,88555,88857,89071,86601,87124,86602,89072,87885,86603,86604,88256,88556,89352,88169,88858,88103,87361,86756,88668,86605,89353,89240,86440,89241,87994,88418,86948,87710,88669,87623,88755,86510,87125,87886,89542,88859,89543,87433,89765,86952,89544,86953,89354,86606,88776,87995,87251,88860,86757,89054,87126,88104,87624,86758,89073,87247,87625,87508,87887,88670,86759,88105,87362,88257,87996,89766,87434,87127,87363,89074,89767,88671,87364,86362,88419,89768,89526,87365,88258,89075,86607,87711)
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,91335,91405,91407,91409,91569,91430,91572,91576,91330,91772,91756,91585,91593,91595,91597,91667,91674,91446,91185,91193,90258,92964,91162,91200,91602,91789,91246,91348,91559,93190,91310,90526,90820,91033,92412,92440,91536,91551,92726,91608,91676,91063,91265,91646,91274,93242,91534,92449,91678,91276,91680,91518,92931,93345,93454,91525,92727,91288,93036,91165,93086,91648,91167,91503,91641,91169,91544,91684,93650,94377,91523,95420,91541,91415,91293,93107,95419,90821,91695,91791,91261,91172,91516,93132,93455,91720,90263,91333,94504,92459,94688,91305,93166,91343,91267,91663,91139,91312,91782,92480,91174,91056,91495,94855,91320,89774,91499,91342,91512,90822,95105,91563,91776,95418,91180,91413,93216,93024,91337,91787,91566,91339,93456,91322,91785)
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,95604,95776,96157,96292,96598,95422,96939,97096)
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,97258)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13753,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,15081,15546,15782,15904,16122,15001,16298)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97312,101608,97472,102185,102186,97319,99119,99152,101609,100192,97778,97866,99827,102050,102187,99116,97390,98290,97397,98494,102444,97324,98728,99193,102188,102194,97325,97327,98864,102189,97328,99217,97353,99111,99540,97354,99815,97393,97356,99238,100445,100451,97362,100028,104086,97365,102069,102445,102184,102446,97366,105824,100424,99275,97368,100429,100460,101159,101275,102190,101607,102191,102183,99304,101742,99331,102017,102049,99541,102256,100463,99344,97392,99356,102510,104088,97391,97371,102874,97372,103140,97375,97376,103787,104090,97396,99370,104613,104614,104616,104617,104615,101747,104865,105058,100465,97380,102192,97381,97401,104087,102193,101746,105212,105231,105227,105228,105232,105234,105235,105229,105230,105529,105822,97383,102511,97387,101743,97389,99379,98291)
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,106017,105834,105860,105940,105986,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,106407,109184,106558,109182,106409,106986,107473,107635,109567,107870,109568,108510,106139,108511,106410,108721,106411,106412,109179,109212,109303,109407,109459,106033,109183,109566,109620,109677,106158,110028,110095,109181,110842,109180,111072,111388,106413)
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,112127,112346,111391,113343,113910,114261,114634,114635,114946,115278,115410)
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,115695,115855,116705,116707,115693,115604,116371,116110,116153,116714,115605,116518,115694,116712,115544,116702,115602,116709,115606,116973,117174,117284,115793)
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,117884,117940,118383,117286,118966,119099)
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,121209,119437,119902,119482,120014,119261,119270,119236,119280,120171,119584,119649)
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,124578,124754,124349,124945,125126,125520,125580,124341,125678,124444,124755)
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,127099,127121,126000,126007,126017,126183,128448,126196,126578,126317,126324,128674,128854,129072,129165,125936,126393,129865,126394,130106,127621,130254,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,132594,133147,134464,134875,135208,135737,136250,137097,137834,130965,138104,138779,139214)
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,140920,140425,141035,140434,140454,140478,140518,141388,140530,141715,141800,142119,142225,140572,140590,142610,140424,142750,142787,140614,143090,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,143835,144232,144544,144766,144959,145022,143213,145351,145494,144116,145634,146015)
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,146944,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,147891,148008,147583,147646,147649,147944,147650,148573,147893,148665,147903,147673,148744,147681,147917,149005,147682,147929,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,16517,16648,16676,16750,16877,16479,16966,17057,17255,17084,16519,16878,16464)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,150079,149786,149800,149824,149834,149852,149868,149918,149934,149936,149968,150013,150046,150014,149752)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (150080,150767,152529,150786,150127,150143,150787,150816,150166,150795,150826,151438,150823,150828,150081,150196,150201,150796,150469,150797,150256,150272,150275,150291,150311,150798,150322,150342,151950,150803,151946,150474,150788,150354,151989,150380,150387,150422,150439,152294,150453,150807,150819,150813,152528,150815,152760,152908)
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,17399,17411,17520,17295,17419,17507)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,153617,154019,154265,154624,152958,154757,154993,155174,156355,156687,156948,157182,152985,157326,158298)
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,36166,36022,36202,36203,36204,36205,36206,36207,36208,36209,36027,35953,35955,36786,36278,36327,35990,35998,36028,36893,36013,36627,36669,36351,36014,36710,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,158706,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,17778,17860,18323,18564,18666,21181,18813,18916,19486,19576,19823,17559,20163,20234,20380,20417,20510,17669,20667,20804,21257,21613)
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,167992,163742,161612,164071,162018,162165,162329,164128,164761,168039,164180,162605,167891,160751,165091,164212,164562,168140,163367,167919,163641,167848,165044,163662,164250,164049,164644,168060,160562,165578,164962,165811,165981,168110,164499,166393,165262,165140,167948,160555,163823,167977,164613,167679,164295,164987,164322,165185,160554,163673,164354,169923,163930,165167,164523,160508,164879,160553,170747,171008,164381,165230,164406,164933,164585,164790,164452)
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,171258,171165,171462,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,172399,172689,172777,174120,173010,172184,173452,173917,174119,174123,174617,174889,175905,175043,172126,175281,175044,175903,176077)
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,21937,21846,22056)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (176078,177164,177165,177340,176268,176079,178033,178119)
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,178646,178336,179141,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,37137,36904,36912,37403,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,25705,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,189443,189032,189096,189087,189034,189036,189037,189181,189399,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,179705,179881,180164,179478,180974,179499,179516,179773,179828,179850,179527,180987,180463,179538,179552,179604,179702,180552,179646,181016,179887,179703,179653,179656,179673,180779,179657,180935,179430,179669,179848)
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,26746,27091,26180,27507,26155,26181,28057)
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,189513,189554)
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)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,183526,184148,184433,184692,181922,186436,186758,187384,187738,188255,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='jkh' 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=666
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=654
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 (676,666,654) AND recommend.START_DATE<='2013-09-09' AND recommend.END_DATE>='2013-09-09' 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='jkh'
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-09' 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-07'
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

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

ЖКХ

ВОСТОЧНОГО АО ИЗМАЙЛОВО ЖИЛКОМСЕРВИС ЛАДЬЯ ООО

НОВЫЕ РЖАВКИ-1 ТСЖ

ВИРГО-П ООО

ВИТАПРОМ ООО

МО г. ОРЕХОВО-ЗУЕВО ГЖП

ЛЮБЕРЕЦКАЯ УПРАВЛЯЮЩАЯ КОМПАНИЯ ЗАО

ЮГО-ВОСТОЧНОГО АО ГУ ИС ДИСПЕТЧЕРСКАЯ СЛУЖБА (ЦДС)

РАСПОРЯДИТЕЛЬНАЯ ДИРЕКЦИЯ ПО ПЕЧАТИ ОАО

Опалихинская 16, ТСЖ

КОМСЕРВИС-СТОЛИЦА ООО

МО ДМИТРОВСКОГО РАЙОНА ГХ г. ЯХРОМА ЖИЛКОМ ООО

МО ШАХОВСКОГО РАЙОНА ЖКХ УЧАСТОК с. СУДИСЛОВО

АЭРОПОРТ ДЕЗ ООО

ЮНИСЕРВИС

БРАТСТВО

МО НАХАБИНСКОГО РАЙОНАЯ КЭЧ

ГАРИБАЛЬДИ ТСЖ

МО ЛУХОВИЦКОГО РАЙОНА ЖКХ СЛУЖБА ЕДИНОГО ЗАКАЗЧИКА РАЙОННОЕ КБХ

МО г. РЕУТОВ ЖИЛСЕРВИС РЭУ # 1

ЛИГОВКА-98, ТСЖ

Cегодня: 09.09.2013

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

Поиск рубрик

Курсы валют

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries

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

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

ЖКХ

Cегодня: 09.09.2013

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

Поиск рубрик

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

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

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

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries