Продажа и ремонт компьютеров, ноутбуков и сетевого оборудования

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

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

Все регионы

Вы здесь: Главная » БЫТОВАЯ ТЕХНИКА / КОМПЬЮТЕРЫ / ОФИСНАЯ ТЕХНИКА » Компьютеры

Компьютеры

Подкатегории:

— Продажа компьютеров / комплектующих — Ремонт компьютеров — Сетевое оборудование — Услуги системного администрирования

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

СИТИКОМ ООО

Москва, Звенигородское ш., д. 4, ТЦ Электроника на Пресне, п-н А-38, Б-23
Телефон +7(495) 7425046

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

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

Рейтинг: 800

Рубрики: Ремонт компьютеров

ИНФОСЕЛ ЗАО

Москва, Ибрагимова ул., д. 31, корп. 50
Телефон +7(495) 6518285

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

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

Рейтинг: 335

Рубрики: Продажа компьютеров / комплектующих

СИТИЛИНК

Москва, Амурская ул., д. 7, стр. 1
Телефон +7 (495) 780-20-02

Факс: +7 (495) 787-00-48
Web:

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

Рейтинг: 296

Рубрики: Продажа компьютеров / комплектующих , Аудио / видеотехника , Бытовая техника , Фотоаппараты / Фототовары

ЭЛМИР, ООО

Смоленск, г. Десногорск 3-й м/р-н 11
Телефон (48153) 3-15-53(48153)3-22-32

E-mail: desnogorsk@elec-mir.ru
Web:

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

Рейтинг: 292

Рубрики: Продажа компьютеров / комплектующих

АГАТ-АКВАРИУС НПК ООО

Москва, Авиамоторная ул., д. 51А
Телефон +7(495) 6734215

Факс: +7(495) 6734215

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

Рейтинг: 247

Рубрики: Ремонт компьютеров

MACYOU.RU

Санкт-Петербург, Кондратьевский проспект, д. 54
Телефон +7(952) 241-59-07

Web:

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

Рейтинг: 244

Рубрики: Продажа компьютеров / комплектующих

ИНФОРМ-СЕРВИС ООО

Москва, Ямского Поля 3-я ул., д. 26, оф. 22
Телефон +7(499) 6170439

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

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

Рейтинг: 237

Рубрики: Ремонт компьютеров

АРКИС

Москва, Тихорецкий бул., д. 1, ТЦ Москва
Телефон +7(495) 3598036

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

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

Рейтинг: 219

Рубрики: Продажа компьютеров / комплектующих

СКОРАЯ ПОМОЩЬ ДЛЯ КОМПЬЮТЕРА

Москва, ул. Краснобогатырская, 2
Телефон +7 (495) 995-22-98

E-mail: info@pchelp.ru
Web:

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

Рейтинг: 212

Рубрики: Ремонт компьютеров , Услуги системного администрирования

ТЕХМАРКЕТ ООО

Москва, Генерала Карбышева бул., д. 5, корп. 2
Телефон +7(499) 1991005

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

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

Рейтинг: 188

Рубрики: Ремонт компьютеров

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

Response

Settings

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

Globals

cookie:
  firm_rating_100713: '1378169834'
  firm_rating_100718: '1378167887'
  firm_rating_100721: '1378236676'
  firm_rating_100751: '1378183362'
  firm_rating_100756: '1378186680'
  firm_rating_100757: '1378241022'
  firm_rating_100760: '1378174596'
  firm_rating_100766: '1378168565'
  firm_rating_100776: '1378168351'
  firm_rating_100782: '1378168808'
  firm_rating_100788: '1378235466'
  firm_rating_116669: '1378242399'
  firm_rating_116680: '1378243068'
  firm_rating_116689: '1378242862'
  firm_rating_116693: '1378236615'
  firm_rating_116712: '1378173843'
  firm_rating_116724: '1378174309'
  firm_rating_116752: '1378244357'
  firm_rating_140929: '1378173940'
  firm_rating_140938: '1378242473'
  firm_rating_140962: '1378168700'
  firm_rating_141025: '1378238602'
  firm_rating_141066: '1378239786'
  firm_rating_197336: '1378242352'
  firm_rating_202090: '1378246730'
  firm_rating_205186: '1378183136'
  firm_rating_205188: '1378173895'
  firm_rating_205191: '1378238539'
  firm_rating_205193: '1378183053'
  firm_rating_208216: '1378242005'
  firm_rating_208221: '1378242665'
  firm_rating_209200: '1378244994'
  firm_rating_209222: '1378245341'
  firm_rating_210405: '1378174205'
  firm_rating_220574: '1378242527'
  firm_rating_223805: '1378168184'
  firm_rating_226873: '1378246938'
  firm_rating_231637: '1378244321'
  firm_rating_233968: '1378174500'
  firm_rating_233974: '1378174147'
  firm_rating_233986: '1378239936'
  firm_rating_233994: '1378223019'
  firm_rating_234015: '1378173980'
  firm_rating_234027: '1378168106'
  firm_rating_234046: '1378168269'
  firm_rating_234058: '1378174529'
  firm_rating_234929: '1378168241'
  firm_rating_235680: '1378245453'
  firm_rating_236239: '1378247037'
  firm_rating_247073: '1378245259'
  firm_rating_24782: '1378235541'
  firm_rating_24796: '1378230667'
  firm_rating_24887: '1378183252'
  firm_rating_24979: '1378222981'
  firm_rating_25046: '1378244562'
  firm_rating_25068: '1378242946'
  firm_rating_250714: '1378244885'
  firm_rating_250721: '1378244922'
  firm_rating_250722: '1378245563'
  firm_rating_250725: '1378245175'
  firm_rating_250730: '1378244663'
  firm_rating_250731: '1378244737'
  firm_rating_250744: '1378245303'
  firm_rating_256291: '1378233529'
  firm_rating_256306: '1378242378'
  firm_rating_257282: '1378238655'
  firm_rating_257616: '1378245372'
  firm_rating_257644: '1378242110'
  firm_rating_262712: '1378242804'
  firm_rating_262713: '1378226796'
  firm_rating_262715: '1378174264'
  firm_rating_262898: '1378185490'
  firm_rating_267155: '1378167995'
  firm_rating_269010: '1378245141'
  firm_rating_273183: '1378239758'
  firm_rating_273184: '1378174632'
  firm_rating_273188: '1378239813'
  firm_rating_273191: '1378174062'
  firm_rating_273192: '1378242426'
  firm_rating_273199: '1378182972'
  firm_rating_273202: '1378242554'
  firm_rating_273203: '1378182999'
  firm_rating_273204: '1378168434'
  firm_rating_273205: '1378236649'
  firm_rating_273206: '1378244257'
  firm_rating_273208: '1378242831'
  firm_rating_273218: '1378185633'
  firm_rating_273220: '1378168023'
  firm_rating_277977: '1378244627'
  firm_rating_278003: '1378246903'
  firm_rating_280271: '1378240041'
  firm_rating_280279: '1378242320'
  firm_rating_282668: '1378242774'
  firm_rating_283844: '1378230496'
  firm_rating_283846: '1378174658'
  firm_rating_283849: '1378183450'
  firm_rating_283855: '1378168729'
  firm_rating_283857: '1378244138'
  firm_rating_283861: '1378183507'
  firm_rating_283863: '1378183080'
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_100713=1378169834; firm_rating_100718=1378167887; firm_rating_100721=1378236676; firm_rating_100751=1378183362; firm_rating_100756=1378186680; firm_rating_100757=1378241022; firm_rating_100760=1378174596; firm_rating_100766=1378168565; firm_rating_100776=1378168351; firm_rating_100782=1378168808; firm_rating_100788=1378235466; firm_rating_116669=1378242399; firm_rating_116680=1378243068; firm_rating_116689=1378242862; firm_rating_116693=1378236615; firm_rating_116712=1378173843; firm_rating_116724=1378174309; firm_rating_116752=1378244357; firm_rating_140929=1378173940; firm_rating_140938=1378242473; firm_rating_140962=1378168700; firm_rating_141025=1378238602; firm_rating_141066=1378239786; firm_rating_197336=1378242352; firm_rating_202090=1378246730; firm_rating_205186=1378183136; firm_rating_205188=1378173895; firm_rating_205191=1378238539; firm_rating_205193=1378183053; firm_rating_208216=1378242005; firm_rating_208221=1378242665; firm_rating_209200=1378244994; firm_rating_209222=1378245341; firm_rating_210405=1378174205; firm_rating_220574=1378242527; firm_rating_223805=1378168184; firm_rating_226873=1378246938; firm_rating_231637=1378244321; firm_rating_233968=1378174500; firm_rating_233974=1378174147; firm_rating_233986=1378239936; firm_rating_233994=1378223019; firm_rating_234015=1378173980; firm_rating_234027=1378168106; firm_rating_234046=1378168269; firm_rating_234058=1378174529; firm_rating_234929=1378168241; firm_rating_235680=1378245453; firm_rating_236239=1378247037; firm_rating_247073=1378245259; firm_rating_24782=1378235541; firm_rating_24796=1378230667; firm_rating_24887=1378183252; firm_rating_24979=1378222981; firm_rating_25046=1378244562; firm_rating_25068=1378242946; firm_rating_250714=1378244885; firm_rating_250721=1378244922; firm_rating_250722=1378245563; firm_rating_250725=1378245175; firm_rating_250730=1378244663; firm_rating_250731=1378244737; firm_rating_250744=1378245303; firm_rating_256291=1378233529; firm_rating_256306=1378242378; firm_rating_257282=1378238655; firm_rating_257616=1378245372; firm_rating_257644=1378242110; firm_rating_262712=1378242804; firm_rating_262713=1378226796; firm_rating_262715=1378174264; firm_rating_262898=1378185490; firm_rating_267155=1378167995; firm_rating_269010=1378245141; firm_rating_273183=1378239758; firm_rating_273184=1378174632; firm_rating_273188=1378239813; firm_rating_273191=1378174062; firm_rating_273192=1378242426; firm_rating_273199=1378182972; firm_rating_273202=1378242554; firm_rating_273203=1378182999; firm_rating_273204=1378168434; firm_rating_273205=1378236649; firm_rating_273206=1378244257; firm_rating_273208=1378242831; firm_rating_273218=1378185633; firm_rating_273220=1378168023; firm_rating_277977=1378244627; firm_rating_278003=1378246903; firm_rating_280271=1378240041; firm_rating_280279=1378242320; firm_rating_282668=1378242774; firm_rating_283844=1378230496; firm_rating_283846=1378174658; firm_rating_283849=1378183450; firm_rating_283855=1378168729; firm_rating_283857=1378244138; firm_rating_283861=1378183507; firm_rating_283863=1378183080; firm_rating_288228=1378244599; firm_rating_288249=1378244456; firm_rating_292039=1378245065; firm_rating_292311=1378183164; firm_rating_292330=1378182939; firm_rating_297646=1378244957; firm_rating_297652=1378244702; firm_rating_297763=1378245488; firm_rating_299387=1378246763; firm_rating_302379=1378174015; firm_rating_302426=1378240068; firm_rating_302429=1378168325; firm_rating_302965=1378242215; firm_rating_303003=1378238513; firm_rating_303011=1378168867; firm_rating_303092=1378242919; firm_rating_303183=1378242605; firm_rating_303192=1378169964; firm_rating_303215=1378242284; firm_rating_303236=1378236585; firm_rating_303250=1378174367; firm_rating_303259=1378185545; firm_rating_305809=1378184468; firm_rating_305812=1378185517; firm_rating_305816=1378185602; firm_rating_306024=1378243039; firm_rating_306048=1378235647; firm_rating_306133=1378168593; firm_rating_306134=1378169934; firm_rating_306137=1378239865; firm_rating_306139=1378185685; firm_rating_306142=1378239838; firm_rating_306152=1378218388; firm_rating_310041=1378238629; firm_rating_311950=1378235611; firm_rating_311960=1378185462; firm_rating_311966=1378233568; firm_rating_311988=1378244194; firm_rating_311989=1378174558; firm_rating_311991=1378183193; firm_rating_311998=1378182906; firm_rating_312020=1378171979; firm_rating_312501=1378245642; firm_rating_312629=1378245713; firm_rating_316320=1378240014; firm_rating_316322=1378238775; firm_rating_316339=1378167914; firm_rating_316349=1378185574; firm_rating_317365=1378245107; firm_rating_317394=1378246797; firm_rating_322692=1378243012; firm_rating_322719=1378245029; firm_rating_324198=1378242695; firm_rating_324199=1378174175; firm_rating_324485=1378226760; firm_rating_327869=1378244815; firm_rating_328342=1378183478; firm_rating_328343=1378168212; firm_rating_329356=1378243096; firm_rating_330601=1378185753; firm_rating_331611=1378246840; firm_rating_332109=1378168297; firm_rating_336362=1378238569; firm_rating_346489=1378246867; firm_rating_347004=1378214736; firm_rating_347006=1378244486; firm_rating_347010=1378169885; firm_rating_348369=1378239965; firm_rating_348372=1378183303; firm_rating_348374=1378167848; firm_rating_348375=1378168135; firm_rating_349789=1378174685; firm_rating_350354=1378183420; firm_rating_351045=1378242160; firm_rating_351616=1378245415; firm_rating_352991=1378170962; firm_rating_352992=1378168384; firm_rating_352995=1378239990; firm_rating_352996=1378174287; firm_rating_352999=1378169862; firm_rating_353174=1378226831; firm_rating_357651=1378168050; firm_rating_358560=1378242579; firm_rating_361684=1378168489; firm_rating_362905=1378244773; firm_rating_364220=1378168835; firm_rating_365689=1378167940; firm_rating_366130=1378168462; firm_rating_366139=1378239732; firm_rating_366954=1378168784; firm_rating_369422=1378223095; firm_rating_371090=1378185441; firm_rating_375093=1378242136; firm_rating_375356=1378245217; firm_rating_378312=1378168668; firm_rating_378314=1378242891; firm_rating_378315=1378238726; firm_rating_378321=1378174093; firm_rating_378322=1378171922; firm_rating_379705=1378247009; firm_rating_379741=1378242637; firm_rating_379948=1378174446; firm_rating_380105=1378168620; firm_rating_380306=1378235578; firm_rating_380498=1378235506; firm_rating_380856=1378183222; firm_rating_381108=1378230570; firm_rating_39649=1378245677; firm_rating_39668=1378246695; firm_rating_39916=1378245751; firm_rating_42718=1378230702; firm_rating_4360=1378242241; firm_rating_4416=1378168538; firm_rating_45028=1378239704; firm_rating_45055=1378167968; firm_rating_45061=1378174119; firm_rating_45124=1378168079; firm_rating_45172=1378185724; firm_rating_45197=1378244094; firm_rating_45257=1378168757; firm_rating_45284=1378245604; firm_rating_45790=1378222942; firm_rating_45884=1378183333; firm_rating_45892=1378171950; firm_rating_45921=1378242083; firm_rating_45989=1378183109; firm_rating_47726=1378223057; firm_rating_47829=1378174234; firm_rating_47852=1378244526; firm_rating_48037=1378242725; firm_rating_48062=1378182852; firm_rating_49882=1378238754; firm_rating_49933=1378183280; firm_rating_49940=1378174338; firm_rating_49954=1378169913; firm_rating_49981=1378241049; firm_rating_5207=1378183391; firm_rating_5269=1378168407; firm_rating_55091=1378242751; firm_rating_55117=1378185664; firm_rating_55149=1378174037; firm_rating_55177=1378244426; firm_rating_55283=1378168516; firm_rating_55308=1378170939; firm_rating_55316=1378242452; firm_rating_55379=1378238703; firm_rating_55484=1378168647; firm_rating_55515=1378244229; firm_rating_55528=1378244295; firm_rating_55567=1378230606; firm_rating_55615=1378168162; firm_rating_55639=1378242193; firm_rating_76054=1378242038; firm_rating_76074=1378182884; firm_rating_76109=1378239895; firm_rating_76111=1378174408; firm_rating_78401=1378230534; firm_rating_8508=1378244390; firm_rating_96431=1378183026; firm_rating_96463=1378242501; firm_rating_96485=1378238678; firm_rating_99662=1378244846; symfony=3it8aumjvhrupsej1adgr6a0h7'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/uslugi_sistemnogo_administrirovaniya'
  HTTP_USER_AGENT: 'Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)'
  HTTP_X_FORWARDED_FOR: 207.241.237.205
  HTTP_X_REAL_IP: 207.241.237.205
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /rubric/kompyutery
  PATH_TRANSLATED: 'redirect:/index.php/kompyutery'
  PHP_SELF: /frontend.php/rubric/kompyutery
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.205
  REMOTE_PORT: '54977'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1378249779
  REQUEST_URI: /frontend.php/rubric/kompyutery
  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" (/rubric/:id) for /rubric/kompyutery with parameters array ( 'module' => 'default', 'action' => 'rubric', 'id' => 'kompyutery',)
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/rubricchildren.php"
90	main	Call "default->execute()"
91	PartialView	Render "sf_app_dir/modules/default/templates/_pager.php"
92	PHPView	Decorate content with "sf_app_dir/templates/firm-list.php"
93	PHPView	Render "sf_app_dir/templates/firm-list.php"
94	main	Call "default->execute()"
95	PartialView	Render "sf_app_dir/modules/default/templates/_about.php"
96	main	Call "default->execute()"
97	PartialView	Render "sf_app_dir/modules/default/templates/_controlMenu.php"
98	main	Call "search->execute()"
99	PartialView	Render "sf_app_dir/modules/search/templates/_siteSearch.php"
100	main	Call "default->execute()"
101	PartialView	Render "sf_app_dir/modules/default/templates/_statistic.php"
102	main	Call "news->execute()"
103	PartialView	Render "sf_app_dir/modules/news/templates/_recommend.php"
104	main	Call "default->execute()"
105	PartialView	Render "sf_app_dir/modules/default/templates/_rubricsTree.php"
106	main	Call "currencies->execute()"
107	PartialView	Render "sf_app_dir/modules/currencies/templates/_currencies.php"
108	main	Call "default->execute()"
109	PartialView	Render "sf_app_dir/modules/default/templates/_personal.php"
110	main	Get slot "firm-left"
111	main	Get slot "full-search-left"
112	main	Call "default->execute()"
113	PartialView	Render "sf_app_dir/modules/default/templates/_footer.php"
114	PartialView	Render "sf_app_dir/modules/personal/templates/_login.php"
115	WebResponse	Send status "HTTP/1.0 200 OK"
116	WebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	20	1.70	0
Action "default/rubric"	1	8.94	0
View "children" for "default/rubric"	1	1245.03	94
Component "default/pager"	1	0.07	0
Partial "default/_pager"	1	2.17	0
Component "default/about"	1	4.92	0
Partial "default/_about"	1	2.02	0
Component "default/controlMenu"	1	0.58	0
Partial "default/_controlMenu"	1	0.19	0
Component "search/siteSearch"	1	6.64	0
Partial "search/_siteSearch"	1	649.15	49
Component "default/statistic"	1	0.92	0
Partial "default/_statistic"	1	0.22	0
Component "news/recommend"	1	4.78	0
Partial "news/_recommend"	1	0.27	0
Component "default/rubricsTree"	1	5.66	0
Partial "default/_rubricsTree"	1	0.94	0
Component "currencies/currencies"	1	8.87	0
Partial "currencies/_currencies"	1	0.75	0
Component "default/personal"	1	5.00	0
Partial "default/_personal"	1	2.77	0
Component "default/footer"	1	2.81	0
Partial "default/_footer"	1	1.39	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='kompyutery' 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=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=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 IS NULL
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.PARENT_ID=17 ORDER BY rubrics.PRIORITY ASC
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 (16,19,20,18,17) AND firms.ACTIVITY=true AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_PR 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>='3488738765' LIMIT 1
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738765' ORDER BY ip_place.IP_FROM DESC LIMIT 1
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738765' AND ip_place.IP_TO>='3488738765'
SELECT COUNT(*) FROM `firms__rubrics`, `firms` WHERE firms__rubrics.RUBRIC_ID IN (16,19,20,18,17) AND firms.ACTIVITY=true AND firms.ID IN (188355,189213,13523,377570,188143,277672,188483,188568,187282,188508,244972,277570,188562,239869,188740,244973,188538,277707,277980,322845,188280,188685,188127,188760,189214,277550,187529,188338,356001,187507,213862,189306,187442,188724,187175,187469,188796,188166,187480,187474,188223,189108,188560,277991,188203,187349,277887,187178,188577,187165,278012,187121,187252,277969,278054,189407,189421,277880,189149,188118,188221,187383,278042,189503,187399,188695,239868,189269,187514,188445,278059,278051,188717,187164,277732,189439,278057,277531,377564,187481,189492,277841,334575,188567,188569,189030,188514,377546,278020,187476,189015,189068,187437,187470,188505,277589,334611,188251,188556,277768,277956,189211,277664,188222,277669,188106,277905,355917,277990,278000,239931,277534,277987,188716,189067,189083,277536,187098,277970,278029,277551,277665,277733,277738,334619,188210,188423,188427,277917,377540,277998,278004,334599,277947,277963,278068,188707,188728,189117,189397,277699,377569,187913,188313,188347,188430,188440,188444,278066,188566,188656,189170,189432,277678,277704,377563,188220,188281,188422,247064,277784,277895,277928,277954,188578,189124,189335,277630,377548,187543,188117,188325,188379,188383,277870,277907,277918,277971,189219,189246,189435,277548,277751,187457,188414,188545,277843,277868,278067,380154,189314,189325,189444,277590,277606,334605,277875,277883,355946,368354,278056,188593,188632,189128,188207,188260,277808,277882,277953,334568,277962,188646,188714,189221,277553,277597,277600,277646,277675,277680,277683,377549,377557,188100,188293,239915,277822,277896,277997,278049,188671,188686,188712,188745,188992,189032,189066,189082,189225,189427,189478,239951,239964,277598,277619,277761,334613,334624,188334,188507,277766,277814,277876,277938,277959,355903,278001,278002,278021,278036,188570,188595,188642,188710,189055,189162,189238,189264,277511,277526,277537,277571,277626,277653,277718,355978,187925,188241,188243,188298,188319,188412,188486,239884,247070,277796,277992,278063,188592,188603,188616,188690,188721,188998,189072,189182,189316,239968,277509,277521,377556,377566,187718,188148,188267,188303,188452,188497,277781,277867,277890,277957,334570,277974,277984,278065,380210,188625,188665,188706,188783,189059,189224,189446,189490,239952,277688,277729,277744,187532,187607,188399,188463,188495,188532,188542,277827,277834,277840,277910,355910,355939,380437,188564,188576,189019,189024,189103,189340,189483,277525,277586,277757,187525,188300,188342,188378,188405,188513,239906,277777,334589,368356,187331,188572,189144,189151,189205,189451,277505,277724,334610,334627,377568,187505,187676,188099,188105,188138,239909,277770,277812,278006,188709,188738,189009,189044,189183,189186,189312,189372,271807,277610,277625,277663,277700,277710,334603,334632,355967,355979,188236,188245,188292,188384,188426,188447,220792,239874,271834,277769,277771,277851,277926,277936,368340,277986,278069,188565,189035,189101,189159,189210,189216,189220,189288,189302,239943,239945,277583,277584,277609,277654,277715,334630,188168,188192,188194,188209,188476,239891,239894,277772,277786,247073,278030,278039,278055,278058,278064,188617,188637,188652,188705,188719,189008,189091,189109,189129,189171,189190,189192,189199,189227,189248,189324,189351,189438,189495,189496,247032,247047,277519,277604,277637,334631,377552,187795,188175,188248,188272,188278,188305,188317,188395,188471,239917,277801,277803,277886,277952,334573,355932,377541,187159,277968,188563,188589,188638,188657,188697,188787,189212,189217,189339,189352,189481,239987,277556,277643,187991,188140,188344,188367,188375,188421,188443,188526,239922,277767,277791,277832,277863,277897,277902,355919,355945,368342,247076,278016,278045,188613,188681,188683,188725,189309,239989,188108,188120,188123,188149,188162,188185,188433,188434,188449,188485,277848,277852,277866,334584,187218,277979,278019,278038,278062,188634,188731,188999,189005,189025,189105,189258,189259,189394,189441,247034,247035,277507,277596,277615,355956,187746,187885,188125,188129,188188,188242,188327,188343,188435,188453,188456,188479,188529,239880,277804,277879,277909,334577,355911,368351,277983,278040,188584,188645,188718,189016,189107,189126,189140,189234,189362,189391,189402,189515,239955,239988,240011,277656,277690,277725,277765,355983,188147,188153,188158,188159,188206,188252,188271,188332,188336,188364,188376,188503,188518,188525,239890,277836,277933,277948,277967,278005,278007,278015,278044,188630,188708,188726,188973,188988,189001,189046,189135,189139,189164,189202,189255,189261,189353,189370,189468,189499,277520,277624,277635,277698,334621,380889,187547,187663,188146,188233,188263,188266,188268,188270,188276,188382,188394,188493,188500,277793,277795,277911,277912,277960,377536,278052,188620,189080,189090,189099,189187,189241,189250,189294,189365,189399,189419,189516,239994,271813,277518,277579,277593,277617,277657,277659,277691,277706,277741,355954,377562,187450,187541,188104,188126,188139,188145,188186,188213,188229,188331,188333,188341,188369,188370,188387,188397,188441,188512,188546,277856,277891,277894,355909,368337,277973,277976,277981,277988,278003,278028,278053,278061,188573,188586,188590,188626,188651,188698,188727,188732,188791,188990,189002,189023,189114,189136,189142,189163,189218,189223,189228,189298,189367,189382,189426,189431,189433,189497,239935,239946,239984,240013,240015,247046,277581,277639,277668,277681,277746,277760,377561,187569,187646,187712,188176,188177,188225,188240,188249,188253,188254,188287,188296,188311,188328,188337,188374,188392,188425,188429,188439,188475,188478,188484,188491,188501,188530,239903,271825,277785,277805,277838,277839,277889,277901,277946,334576,334592,334593,244892,247075,277965,277975,277977,277993,278013,188575,188600,188631,188644,188711,188750,188755,189018,189029,189052,189060,189123,189173,189194,189292,189318,189361,189384,189428,189442,189448,239933,239936,239990,239997,277512,277539,277569,277580,277614,277618,277628,277633,277634,277642,277644,277670,277682,277685,277686,277708,277712,277728,277736,277740,277745,277758,334622,334626,355962,355977,187487,187502,187517,188114,188130,188154,188156,188161,188167,188181,188182,188205,188214,188232,188256,188274,188282,188291,188302,188321,188322,188353,188362,188366,188400,188407,188446,188481,188515,188541,188544,239913,247068,277797,277800,277817,277824,277826,277833,277837,277913,277914,277915,277916,277929,277934,277955,278017,278025,278037,278041,188647,188661,188699,188704,188747,188754,188776,188997,189042,189084,189095,189110,189113,189131,189154,189160,189229,189240,189282,189303,189310,189345,189371,189374,189460,189502,189517,239941,239967,239975,247042,271809,277514,277522,277529,277546,277547,277562,277572,277594,277645,277689,277719,277735,277753,277754,277755,334604,355951,368381,187479,187485,187576,187652,187883,188012,188050,188112,188122,188124,188137,188151,188163,188164,188173,188174,188202,188217,188228,188231,188234,188264,188283,188286,188299,188358,188365,188417,188474,188499,188522,188535,271821,271823,277774,277787,277798,277820,277835,277846,277858,277859,277860,277940,277950,277958,355896,355902,355918,355922,377543,187278,278022,278024,278047,188609,188614,188667,188677,188701,188742,188767,188970,188981,189000,189007,189033,189039,189045,189050,189073,189088,189111,189132,189165,189169,189237,189270,189299,189301,189323,189341,189344,189347,189494,189514,239958,239979,239986,271815,277517,277542,277543,277554,277565,277588,277591,277603,277608,277611,277632,277640,277702,277717,277727,277731,277734,277739,277749,334606,334612,355991,377550,187511,187557,187581,187835,188131,188135,188184,188284,188318,188330,188335,188388,188403,188415,188416,188428,188489,188494,188536,188540,239872,247062,277773,277792,277809,277821,277829,277847,277853,277861,277874,277877,277884,277898,277906,277919,277921,277925,277935,277937,277943,355920,355923,355930,377547,277966,277989,278033,188594,188597,188618,188641,188663,188666,188756,188772,189021,189056,189092,189094,189148,189153,189247,189256,189279,189289,189383,189437,189464,189486,239937,239953,239962,239981,240004,240006,247045,277510,277513,277523,277532,277533,277538,277540,277544,277558,277561,277563,277585,277607,277616,277621,277649,277662,277667,277692,277714,277723,277759,277763,355973,355993,188128,188187,188273,188294,188295,188316,188324,188420,188438,188462,188465,188470,188472,188488,188509,188510,221663,239881,247065,271826,277783,277790,277831,277844,277845,277857,277862,277903,277904,277927,334595,355931,355947,187247,277985,277994,278014,278048,188571,188581,188606,188623,188672,188676,188689,188696,188773,188778,188784,188797,189047,189112,189145,189196,189286,189463,189501,239944,239970,239998,240002,240005,247048,247056,271810,271814,277508,277515,277530,277555,277564,277568,277576,277578,277605,277620,277627,277636,277671,277676,277677,277697,277701,277748,277752,277756,277764,187443,188045,188150,188211,188216,188306,188380,188409,188411,188424,188459,188461,188473,188477,188482,188487,188492,188511,188539,188547,239883,239898,239911,247067,247069,277789,277849,277864,277865,277872,277900,334565,334581,334590,355935,368361,377542,187145,278010,278011,188607,188659,188703,188744,188763,188793,188868,188993,189004,189012,189041,189051,189119,189157,189168,189285,189291,189305,189313,189348,189358,189377,189450,189454,189471,239959,239985,239992,247057,277506,277528,277535,277541,277552,277573,277595,277601,277612,277638,277641,277660,277673,277721,277747,355952,355970,368382,187444,187758,188103,188107,188119,188133,188157,188218,188239,188244,188304,188310,188329,188350,188389,188457,188464,188496,188543,188550,239877,239930,277810,277815,277816,277830,277871,277893,277922,277932,277941,277951,355926,368349,368350,368366,187187,277972,277978,277996,278008,278032,188588,188670,188957,189058,189097,189100,189198,189222,189343,189356,239932,239960,239971,239991,247031,247050,271806,271811,277527,277545,277557,277587,277599,277602,277658,277661,277679,277716,277750,356000,187556,188179,188183,188258,188265,188275,188381,188398,188458,188502,188528,271817,271818,271822,271827,277778,277807,277813,277828,277854,277892,277908,277930,277945,334567,334583,355898,355908,355921,187233,278009,278031,278034,188664,188679,188720,188766,188769,188980,189130,189184,189195,189249,189330,189400,239950,239974,240007,247036,247044,277560,277567,277651,277655,277666,277742,334602,334615,334616,334623,334628,334629,355957,355995,377558,187567,187654,188152,188165,188171,188195,188198,188224,188227,188277,188285,188288,188308,188312,188339,188340,188373,188437,188442,239900,239905,239910,271820,277775,277788,277819,277825,277855,277878,277881,277885,334571,334578,355885,368343,380517,277964,277999,188633,188639,188669,188786,188971,188972,189010,189011,189013,189116,189122,189200,189440,189474,239969,277524,277549,277574,277613,277650,277652,277674,277687,277693,277694,277695,277703,277722,277726,277762,334600,334601,334607,334620,355958,355959,355996,356003,356005,368374,368375,368383,377553,377555,187552,187558,187700,187848,187850,188116,188189,188237,188289,188352,188356,188361,188419,188454,188527,188531,239924,247058,271824,271829,271831,271832,271833,277776,277779,277811,277818,277842,277939,334574,334579,334588,355891,355912,368336,368352,368353,368372,377545,277982,188561,188624,188751,188757,188759,188762,188792,189147,189416,247033,271808,277516,277577,277582,277629,277631,277648,277709,277713,277730,334614,355966,356002,368377,187542,187770,188197,188315,188345,188360,188498,239925,247060,277780,277888,277899,277923,334569,334586,334597,355888,355915,355924,355943,368346,368348,368357,277961,278023,188583,188627,188650,188668,188780,188984,189079,189146,247030,277592,334609,334618,355976,355982,355990,355997,188190,188246,188259,188390,188401,188406,188410,188451,188466,239882,247071,271835,277799,277850,277920,334566,334587,355897,355927,368345,368363,377537,188658,188734,188758,188768,188782,188975,188977,189133,247041,247051,247055,271812,277566,277575,277647,277705,277720,277743,334617,355953,355960,355963,355980,355998,356004,368379,368384,377554,377560,377567,187510,187904,188368,188404,188468,188519,188523,239870,239875,271828,271830,277806,277949,334596,355887,355934,355944,355949,368338,368344,368362,368368,377535,277995,278050,188684,188692,189078,189093,247040,247052,277559,277623,277684,355964,355968,355984,355992,355994,377559,380047,188314,271819,277794,277924,334572,334580,334594,355894,355904,355906,355914,355938,368365,368371,377539,188621,188764,189381,239954,247037,277696,355981,355985,368380,187808,188208,188279,188385,188460,188553,271816,277782,277931,334598,355889,355913,355942,368355,368359,368369,368370,278035,278043,188788,240014,247028,334625,368373,368378,188065,188413,239865,277873,334591,355890,355893,355899,355901,355907,355916,355925,355928,355936,355941,368341,368358,368364,377538,377544,278046,240012,277622,355961,355965,355972,355974,355986,355999,368376,377551,355900,355933,368339,368347,368360,368367,277711,334608,355955,355987,355988,377565,334582,334585,355886,355895,355905,355940,355950,355969,277823,277942,355892,355937,355948,377534,380343,355989,355929,380127,379947,355971,355975,380361,380297,381062,381252,380921,381283,381228,381165,244878,189487,244949,271733) 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 (16,19,20,18,17) AND firms.ACTIVITY=true AND firms.ID IN (188355,189213,13523,377570,188143,277672,188483,188568,187282,188508,244972,277570,188562,239869,188740,244973,188538,277707,277980,322845,188280,188685,188127,188760,189214,277550,187529,188338,356001,187507,213862,189306,187442,188724,187175,187469,188796,188166,187480,187474,188223,189108,188560,277991,188203,187349,277887,187178,188577,187165,278012,187121,187252,277969,278054,189407,189421,277880,189149,188118,188221,187383,278042,189503,187399,188695,239868,189269,187514,188445,278059,278051,188717,187164,277732,189439,278057,277531,377564,187481,189492,277841,334575,188567,188569,189030,188514,377546,278020,187476,189015,189068,187437,187470,188505,277589,334611,188251,188556,277768,277956,189211,277664,188222,277669,188106,277905,355917,277990,278000,239931,277534,277987,188716,189067,189083,277536,187098,277970,278029,277551,277665,277733,277738,334619,188210,188423,188427,277917,377540,277998,278004,334599,277947,277963,278068,188707,188728,189117,189397,277699,377569,187913,188313,188347,188430,188440,188444,278066,188566,188656,189170,189432,277678,277704,377563,188220,188281,188422,247064,277784,277895,277928,277954,188578,189124,189335,277630,377548,187543,188117,188325,188379,188383,277870,277907,277918,277971,189219,189246,189435,277548,277751,187457,188414,188545,277843,277868,278067,380154,189314,189325,189444,277590,277606,334605,277875,277883,355946,368354,278056,188593,188632,189128,188207,188260,277808,277882,277953,334568,277962,188646,188714,189221,277553,277597,277600,277646,277675,277680,277683,377549,377557,188100,188293,239915,277822,277896,277997,278049,188671,188686,188712,188745,188992,189032,189066,189082,189225,189427,189478,239951,239964,277598,277619,277761,334613,334624,188334,188507,277766,277814,277876,277938,277959,355903,278001,278002,278021,278036,188570,188595,188642,188710,189055,189162,189238,189264,277511,277526,277537,277571,277626,277653,277718,355978,187925,188241,188243,188298,188319,188412,188486,239884,247070,277796,277992,278063,188592,188603,188616,188690,188721,188998,189072,189182,189316,239968,277509,277521,377556,377566,187718,188148,188267,188303,188452,188497,277781,277867,277890,277957,334570,277974,277984,278065,380210,188625,188665,188706,188783,189059,189224,189446,189490,239952,277688,277729,277744,187532,187607,188399,188463,188495,188532,188542,277827,277834,277840,277910,355910,355939,380437,188564,188576,189019,189024,189103,189340,189483,277525,277586,277757,187525,188300,188342,188378,188405,188513,239906,277777,334589,368356,187331,188572,189144,189151,189205,189451,277505,277724,334610,334627,377568,187505,187676,188099,188105,188138,239909,277770,277812,278006,188709,188738,189009,189044,189183,189186,189312,189372,271807,277610,277625,277663,277700,277710,334603,334632,355967,355979,188236,188245,188292,188384,188426,188447,220792,239874,271834,277769,277771,277851,277926,277936,368340,277986,278069,188565,189035,189101,189159,189210,189216,189220,189288,189302,239943,239945,277583,277584,277609,277654,277715,334630,188168,188192,188194,188209,188476,239891,239894,277772,277786,247073,278030,278039,278055,278058,278064,188617,188637,188652,188705,188719,189008,189091,189109,189129,189171,189190,189192,189199,189227,189248,189324,189351,189438,189495,189496,247032,247047,277519,277604,277637,334631,377552,187795,188175,188248,188272,188278,188305,188317,188395,188471,239917,277801,277803,277886,277952,334573,355932,377541,187159,277968,188563,188589,188638,188657,188697,188787,189212,189217,189339,189352,189481,239987,277556,277643,187991,188140,188344,188367,188375,188421,188443,188526,239922,277767,277791,277832,277863,277897,277902,355919,355945,368342,247076,278016,278045,188613,188681,188683,188725,189309,239989,188108,188120,188123,188149,188162,188185,188433,188434,188449,188485,277848,277852,277866,334584,187218,277979,278019,278038,278062,188634,188731,188999,189005,189025,189105,189258,189259,189394,189441,247034,247035,277507,277596,277615,355956,187746,187885,188125,188129,188188,188242,188327,188343,188435,188453,188456,188479,188529,239880,277804,277879,277909,334577,355911,368351,277983,278040,188584,188645,188718,189016,189107,189126,189140,189234,189362,189391,189402,189515,239955,239988,240011,277656,277690,277725,277765,355983,188147,188153,188158,188159,188206,188252,188271,188332,188336,188364,188376,188503,188518,188525,239890,277836,277933,277948,277967,278005,278007,278015,278044,188630,188708,188726,188973,188988,189001,189046,189135,189139,189164,189202,189255,189261,189353,189370,189468,189499,277520,277624,277635,277698,334621,380889,187547,187663,188146,188233,188263,188266,188268,188270,188276,188382,188394,188493,188500,277793,277795,277911,277912,277960,377536,278052,188620,189080,189090,189099,189187,189241,189250,189294,189365,189399,189419,189516,239994,271813,277518,277579,277593,277617,277657,277659,277691,277706,277741,355954,377562,187450,187541,188104,188126,188139,188145,188186,188213,188229,188331,188333,188341,188369,188370,188387,188397,188441,188512,188546,277856,277891,277894,355909,368337,277973,277976,277981,277988,278003,278028,278053,278061,188573,188586,188590,188626,188651,188698,188727,188732,188791,188990,189002,189023,189114,189136,189142,189163,189218,189223,189228,189298,189367,189382,189426,189431,189433,189497,239935,239946,239984,240013,240015,247046,277581,277639,277668,277681,277746,277760,377561,187569,187646,187712,188176,188177,188225,188240,188249,188253,188254,188287,188296,188311,188328,188337,188374,188392,188425,188429,188439,188475,188478,188484,188491,188501,188530,239903,271825,277785,277805,277838,277839,277889,277901,277946,334576,334592,334593,244892,247075,277965,277975,277977,277993,278013,188575,188600,188631,188644,188711,188750,188755,189018,189029,189052,189060,189123,189173,189194,189292,189318,189361,189384,189428,189442,189448,239933,239936,239990,239997,277512,277539,277569,277580,277614,277618,277628,277633,277634,277642,277644,277670,277682,277685,277686,277708,277712,277728,277736,277740,277745,277758,334622,334626,355962,355977,187487,187502,187517,188114,188130,188154,188156,188161,188167,188181,188182,188205,188214,188232,188256,188274,188282,188291,188302,188321,188322,188353,188362,188366,188400,188407,188446,188481,188515,188541,188544,239913,247068,277797,277800,277817,277824,277826,277833,277837,277913,277914,277915,277916,277929,277934,277955,278017,278025,278037,278041,188647,188661,188699,188704,188747,188754,188776,188997,189042,189084,189095,189110,189113,189131,189154,189160,189229,189240,189282,189303,189310,189345,189371,189374,189460,189502,189517,239941,239967,239975,247042,271809,277514,277522,277529,277546,277547,277562,277572,277594,277645,277689,277719,277735,277753,277754,277755,334604,355951,368381,187479,187485,187576,187652,187883,188012,188050,188112,188122,188124,188137,188151,188163,188164,188173,188174,188202,188217,188228,188231,188234,188264,188283,188286,188299,188358,188365,188417,188474,188499,188522,188535,271821,271823,277774,277787,277798,277820,277835,277846,277858,277859,277860,277940,277950,277958,355896,355902,355918,355922,377543,187278,278022,278024,278047,188609,188614,188667,188677,188701,188742,188767,188970,188981,189000,189007,189033,189039,189045,189050,189073,189088,189111,189132,189165,189169,189237,189270,189299,189301,189323,189341,189344,189347,189494,189514,239958,239979,239986,271815,277517,277542,277543,277554,277565,277588,277591,277603,277608,277611,277632,277640,277702,277717,277727,277731,277734,277739,277749,334606,334612,355991,377550,187511,187557,187581,187835,188131,188135,188184,188284,188318,188330,188335,188388,188403,188415,188416,188428,188489,188494,188536,188540,239872,247062,277773,277792,277809,277821,277829,277847,277853,277861,277874,277877,277884,277898,277906,277919,277921,277925,277935,277937,277943,355920,355923,355930,377547,277966,277989,278033,188594,188597,188618,188641,188663,188666,188756,188772,189021,189056,189092,189094,189148,189153,189247,189256,189279,189289,189383,189437,189464,189486,239937,239953,239962,239981,240004,240006,247045,277510,277513,277523,277532,277533,277538,277540,277544,277558,277561,277563,277585,277607,277616,277621,277649,277662,277667,277692,277714,277723,277759,277763,355973,355993,188128,188187,188273,188294,188295,188316,188324,188420,188438,188462,188465,188470,188472,188488,188509,188510,221663,239881,247065,271826,277783,277790,277831,277844,277845,277857,277862,277903,277904,277927,334595,355931,355947,187247,277985,277994,278014,278048,188571,188581,188606,188623,188672,188676,188689,188696,188773,188778,188784,188797,189047,189112,189145,189196,189286,189463,189501,239944,239970,239998,240002,240005,247048,247056,271810,271814,277508,277515,277530,277555,277564,277568,277576,277578,277605,277620,277627,277636,277671,277676,277677,277697,277701,277748,277752,277756,277764,187443,188045,188150,188211,188216,188306,188380,188409,188411,188424,188459,188461,188473,188477,188482,188487,188492,188511,188539,188547,239883,239898,239911,247067,247069,277789,277849,277864,277865,277872,277900,334565,334581,334590,355935,368361,377542,187145,278010,278011,188607,188659,188703,188744,188763,188793,188868,188993,189004,189012,189041,189051,189119,189157,189168,189285,189291,189305,189313,189348,189358,189377,189450,189454,189471,239959,239985,239992,247057,277506,277528,277535,277541,277552,277573,277595,277601,277612,277638,277641,277660,277673,277721,277747,355952,355970,368382,187444,187758,188103,188107,188119,188133,188157,188218,188239,188244,188304,188310,188329,188350,188389,188457,188464,188496,188543,188550,239877,239930,277810,277815,277816,277830,277871,277893,277922,277932,277941,277951,355926,368349,368350,368366,187187,277972,277978,277996,278008,278032,188588,188670,188957,189058,189097,189100,189198,189222,189343,189356,239932,239960,239971,239991,247031,247050,271806,271811,277527,277545,277557,277587,277599,277602,277658,277661,277679,277716,277750,356000,187556,188179,188183,188258,188265,188275,188381,188398,188458,188502,188528,271817,271818,271822,271827,277778,277807,277813,277828,277854,277892,277908,277930,277945,334567,334583,355898,355908,355921,187233,278009,278031,278034,188664,188679,188720,188766,188769,188980,189130,189184,189195,189249,189330,189400,239950,239974,240007,247036,247044,277560,277567,277651,277655,277666,277742,334602,334615,334616,334623,334628,334629,355957,355995,377558,187567,187654,188152,188165,188171,188195,188198,188224,188227,188277,188285,188288,188308,188312,188339,188340,188373,188437,188442,239900,239905,239910,271820,277775,277788,277819,277825,277855,277878,277881,277885,334571,334578,355885,368343,380517,277964,277999,188633,188639,188669,188786,188971,188972,189010,189011,189013,189116,189122,189200,189440,189474,239969,277524,277549,277574,277613,277650,277652,277674,277687,277693,277694,277695,277703,277722,277726,277762,334600,334601,334607,334620,355958,355959,355996,356003,356005,368374,368375,368383,377553,377555,187552,187558,187700,187848,187850,188116,188189,188237,188289,188352,188356,188361,188419,188454,188527,188531,239924,247058,271824,271829,271831,271832,271833,277776,277779,277811,277818,277842,277939,334574,334579,334588,355891,355912,368336,368352,368353,368372,377545,277982,188561,188624,188751,188757,188759,188762,188792,189147,189416,247033,271808,277516,277577,277582,277629,277631,277648,277709,277713,277730,334614,355966,356002,368377,187542,187770,188197,188315,188345,188360,188498,239925,247060,277780,277888,277899,277923,334569,334586,334597,355888,355915,355924,355943,368346,368348,368357,277961,278023,188583,188627,188650,188668,188780,188984,189079,189146,247030,277592,334609,334618,355976,355982,355990,355997,188190,188246,188259,188390,188401,188406,188410,188451,188466,239882,247071,271835,277799,277850,277920,334566,334587,355897,355927,368345,368363,377537,188658,188734,188758,188768,188782,188975,188977,189133,247041,247051,247055,271812,277566,277575,277647,277705,277720,277743,334617,355953,355960,355963,355980,355998,356004,368379,368384,377554,377560,377567,187510,187904,188368,188404,188468,188519,188523,239870,239875,271828,271830,277806,277949,334596,355887,355934,355944,355949,368338,368344,368362,368368,377535,277995,278050,188684,188692,189078,189093,247040,247052,277559,277623,277684,355964,355968,355984,355992,355994,377559,380047,188314,271819,277794,277924,334572,334580,334594,355894,355904,355906,355914,355938,368365,368371,377539,188621,188764,189381,239954,247037,277696,355981,355985,368380,187808,188208,188279,188385,188460,188553,271816,277782,277931,334598,355889,355913,355942,368355,368359,368369,368370,278035,278043,188788,240014,247028,334625,368373,368378,188065,188413,239865,277873,334591,355890,355893,355899,355901,355907,355916,355925,355928,355936,355941,368341,368358,368364,377538,377544,278046,240012,277622,355961,355965,355972,355974,355986,355999,368376,377551,355900,355933,368339,368347,368360,368367,277711,334608,355955,355987,355988,377565,334582,334585,355886,355895,355905,355940,355950,355969,277823,277942,355892,355937,355948,377534,380343,355989,355929,380127,379947,355971,355975,380361,380297,381062,381252,380921,381283,381228,381165,244878,189487,244949,271733) AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_PR DESC,firms.VIEWS_COUNT DESC LIMIT 10
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=188355 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=189213 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=13523 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=377570 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=152985
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=188143 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=277672 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188291
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=188483 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=188568 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=187282 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=188508 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
SELECT articles.ID, articles.NAME, articles.CODE, articles.THUMBNAIL, articles.DESCRIPTION, articles.CREATE_DATE, articles.CREATE_DAY, articles.PAGE_TITLE, articles.PAGE_KEYWORDS, articles.PAGE_DESCRIPTION, articles.PRIORITY, articles.ACTIVITY FROM `articles`, `tags`, `articles__tags` WHERE articles.ACTIVITY=true AND tags.CODE='about' AND articles__tags.ARTICLE_ID=articles.ID AND articles__tags.TAG_ID=tags.ID ORDER BY articles.PRIORITY ASC
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738765' LIMIT 1
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738765' ORDER BY ip_place.IP_FROM DESC LIMIT 1
SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738765' AND ip_place.IP_TO>='3488738765'
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188256 ORDER BY places.NAME ASC
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4 LIMIT 1
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188291 ORDER BY places.NAME ASC
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188291,188325,188326,188327,188328,188329,188330,188331,188333,188334)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (1,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,52459,52461)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (61110,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,181070,181072,181039)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (63755,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,69032,69015,69045,69047,69057,69076)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10421,10447,10506,10422)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (70235,70237,70814)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74428)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10705)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (11012,11030,11013,11046)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74567,74569,74672,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,75886,76059)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (12236,12252,12279,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,81037)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (30027,30100,30125,30146,30028,30179,30210)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (32100,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,84896,84937)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,86292)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (89769,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,95422)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13250,13285)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (15000,15001)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97312,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,105834,105860,105864,105829,105873,105922,105923,105924,105883,105891,105895,105899,105920)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188602 ORDER BY places.NAME ASC
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (106031,106159,106139,106033,106158)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,111391)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (115543,115603,115572,115604,115605,115544,115602,115606)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117286)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,119261,119270,119236,119280)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (121215,121737,122109,123001,123094,123373,123545,121485)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (124340,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,126000,126007,126017,126183,126196,126578,126317,126324,125936,126393,126394,126489)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (35102,35109,35110,35152,35103,35155,35156,35163,35119,35128,35161,35162,35142)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,130965)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (140423,140757,140425,140434,140454,140478,140518,140530,140572,140590,140424,140614,140666)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (143212,143213)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (146138,146149,146180,146156,146164,146165,146178,146139,146174,146169,146166)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (147530,147583,147646,147649,147650,147673,147681,147682,147683,147688,147533,147689,147582,147691)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (16462,16479,16464)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,149752)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (150080,150767,150786,150127,150143,150787,150816,150166,150795,150826,150823,150828,150081,150196,150201,150796,150469,150797,150256,150272,150275,150291,150311,150798,150322,150342,150803,150474,150788,150354,150380,150387,150422,150439,150453,150807,150819,150813,150815)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17399,17411,17520,17295,17419,17507)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,152958,152985)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (35833,36022,36027,35953,35955,35990,35998,36028,36013,36014,35834)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (158302,158312,158303,158319,158304,158322,158311,158323)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17558,17559,17669)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (160505,160751,160562,160555,160554,160508,160553)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171165,171173,171191,171119)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (172125,172184,172126)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (21655,21657,21656,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,22378)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178336,178231)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (36895,36900,36902,36904,36912,36913,36896)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25452)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189026,189094,189029,189031,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,179478,179499,179516,179527,179538,179552,179604,179646,179653,179656,179673,179657,179430,179669)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (26154,26178,26179,26180,26155,26181)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189595,189598,189622,189629,189630,189636,189639,189596,189747)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,181922,181921)
SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=0
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.TRANSLIT_NAME='kompyutery' 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=1
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') AND recommend.RUBRIC_ID IN (16,1) AND recommend.START_DATE<='2013-09-04' AND recommend.END_DATE>='2013-09-04' 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='kompyutery'
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-04' 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-04'
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

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

Компьютеры

Подкатегории:

СИТИКОМ ООО

ИНФОСЕЛ ЗАО

СИТИЛИНК

ЭЛМИР, ООО

АГАТ-АКВАРИУС НПК ООО

MACYOU.RU

ИНФОРМ-СЕРВИС ООО

АРКИС

СКОРАЯ ПОМОЩЬ ДЛЯ КОМПЬЮТЕРА

ТЕХМАРКЕТ ООО

Cегодня: 04.09.2013

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

Поиск рубрик

Курсы валют

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries

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

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

Компьютеры

Подкатегории:

Cегодня: 04.09.2013

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

Поиск рубрик

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

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

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

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries