parameterHolder:
  action: firm
  id: severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij
  module: default
attributeHolder:
  sf_route: 'sfRoute Object()'

options:
  http_protocol: HTTP/1.0
  logging: '1'
  charset: utf-8
  send_http_headers: true
  content_type: 'text/html; charset=utf-8'
cookies:
  firm_rating_22045: { name: firm_rating_22045, value: 1379567007, expire: 1379653407, path: /, domain: '', secure: false, httpOnly: false }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  jquery.js: {  }
  jquery.reveal.js: {  }
  jquery-spoiler_control.js: {  }
  scripts.js: {  }
  cuselFilter-min-2.3.1.js: {  }
  custom.js: {  }
  gmap.js: {  }
  select.js: {  }
  'http://maps.google.com/maps/api/js?sensor=true': {  }
stylesheets:
  style.css: {  }
  default_firm.css: {  }
  search.css: {  }
metas:
  title: 'СЕВЕРО-ЗАПАДНОГО АО ЦЕНТР ЗАНЯТОСТИ НАСЕЛЕНИЯ (ЦЗН) ГУ ОТДЕЛ СТРОГИНСКИЙ. Службы занятости населения. г. Москва'
  description: 'Справочная информация о компании СЕВЕРО-ЗАПАДНОГО АО ЦЕНТР ЗАНЯТОСТИ НАСЕЛЕНИЯ (ЦЗН) ГУ ОТДЕЛ СТРОГИНСКИЙ расположенной по адресу г. Москва, г. Москва, Исаковского ул., д. 2, корп. 2, +7(495) 7508108. Область деятельности - Службы занятости населения'
  keywords: 'адреса, телефоны, бесплатный справочник, справочная служба г. Москва, база данных г. Москва, каталог компаний, компания СЕВЕРО-ЗАПАДНОГО АО ЦЕНТР ЗАНЯТОСТИ НАСЕЛЕНИЯ (ЦЗН) ГУ ОТДЕЛ СТРОГИНСКИЙ, организация, фирма, бизнес справочник, адреса и телефоны Службы занятости населения, товары, услуги, желтые страницы'
  language: ru
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: null
  default_culture: en
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder:
  symfony/user/sfUser/attributes: { region_id: 0 }
culture: en

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: ' ↓ '
sf_validation_error_suffix: '  ↓'
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
symfony.view.slot_names: {  }
url_root: 'http://rspravka.ru'

cookie:
  firm_rating_110562: '1379559760'
  firm_rating_110564: '1379561134'
  firm_rating_110569: '1379560442'
  firm_rating_110571: '1379556694'
  firm_rating_111478: '1379482167'
  firm_rating_1175: '1379531501'
  firm_rating_118212: '1379538738'
  firm_rating_118214: '1379539385'
  firm_rating_118216: '1379537735'
  firm_rating_118221: '1379541976'
  firm_rating_118224: '1379538975'
  firm_rating_119291: '1379539645'
  firm_rating_119300: '1379540773'
  firm_rating_120170: '1379482221'
  firm_rating_131908: '1379529737'
  firm_rating_132210: '1379527404'
  firm_rating_146842: '1379516876'
  firm_rating_146878: '1379520575'
  firm_rating_146956: '1379511430'
  firm_rating_160273: '1379565185'
  firm_rating_16910: '1379554524'
  firm_rating_16920: '1379554695'
  firm_rating_16959: '1379558979'
  firm_rating_16978: '1379561110'
  firm_rating_17015: '1379561467'
  firm_rating_17071: '1379556974'
  firm_rating_17145: '1379529821'
  firm_rating_1753: '1379522415'
  firm_rating_18409: '1379504539'
  firm_rating_187282: '1379529475'
  firm_rating_188483: '1379522076'
  firm_rating_18871: '1379537089'
  firm_rating_18872: '1379532366'
  firm_rating_204795: '1379488198'
  firm_rating_204803: '1379491625'
  firm_rating_204808: '1379493312'
  firm_rating_206845: '1379519133'
  firm_rating_206863: '1379519524'
  firm_rating_207722: '1379526500'
  firm_rating_213902: '1379564735'
  firm_rating_221351: '1379550891'
  firm_rating_22647: '1379525062'
  firm_rating_22648: '1379529062'
  firm_rating_22703: '1379524692'
  firm_rating_2329: '1379523481'
  firm_rating_242554: '1379491309'
  firm_rating_250394: '1379510205'
  firm_rating_250399: '1379514650'
  firm_rating_250418: '1379519551'
  firm_rating_2539: '1379534085'
  firm_rating_256130: '1379482438'
  firm_rating_267244: '1379529032'
  firm_rating_2693: '1379524750'
  firm_rating_27906: '1379491474'
  firm_rating_281011: '1379487137'
  firm_rating_281012: '1379489399'
  firm_rating_281018: '1379488289'
  firm_rating_281019: '1379491753'
  firm_rating_281029: '1379490156'
  firm_rating_281714: '1379482278'
  firm_rating_281728: '1379482990'
  firm_rating_281755: '1379482412'
  firm_rating_281757: '1379483038'
  firm_rating_282823: '1379489731'
  firm_rating_282833: '1379492881'
  firm_rating_282835: '1379487769'
  firm_rating_287569: '1379482251'
  firm_rating_28882: '1379482966'
  firm_rating_28892: '1379482622'
  firm_rating_28933: '1379482463'
  firm_rating_28942: '1379482880'
  firm_rating_28947: '1379482648'
  firm_rating_298892: '1379499440'
  firm_rating_298893: '1379502854'
  firm_rating_299418: '1379554873'
  firm_rating_306125: '1379492300'
  firm_rating_31234: '1379548419'
  firm_rating_31238: '1379546184'
  firm_rating_312890: '1379529911'
  firm_rating_317475: '1379482127'
  firm_rating_31762: '1379518156'
  firm_rating_31764: '1379521126'
  firm_rating_31771: '1379516725'
  firm_rating_31781: '1379516651'
  firm_rating_31789: '1379514745'
  firm_rating_31802: '1379521767'
  firm_rating_326334: '1379482104'
  firm_rating_327448: '1379500349'
  firm_rating_328672: '1379482714'
  firm_rating_330126: '1379513059'
  firm_rating_330514: '1379523610'
  firm_rating_331493: '1379540897'
  firm_rating_346294: '1379525629'
  firm_rating_349969: '1379526631'
  firm_rating_362702: '1379482352'
  firm_rating_364919: '1379494902'
  firm_rating_366457: '1379561624'
  firm_rating_367819: '1379537120'
  firm_rating_368564: '1379482905'
  firm_rating_371430: '1379541885'
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_110562=1379559760; firm_rating_110564=1379561134; firm_rating_110569=1379560442; firm_rating_110571=1379556694; firm_rating_111478=1379482167; firm_rating_1175=1379531501; firm_rating_118212=1379538738; firm_rating_118214=1379539385; firm_rating_118216=1379537735; firm_rating_118221=1379541976; firm_rating_118224=1379538975; firm_rating_119291=1379539645; firm_rating_119300=1379540773; firm_rating_120170=1379482221; firm_rating_131908=1379529737; firm_rating_132210=1379527404; firm_rating_146842=1379516876; firm_rating_146878=1379520575; firm_rating_146956=1379511430; firm_rating_160273=1379565185; firm_rating_16910=1379554524; firm_rating_16920=1379554695; firm_rating_16959=1379558979; firm_rating_16978=1379561110; firm_rating_17015=1379561467; firm_rating_17071=1379556974; firm_rating_17145=1379529821; firm_rating_1753=1379522415; firm_rating_18409=1379504539; firm_rating_187282=1379529475; firm_rating_188483=1379522076; firm_rating_18871=1379537089; firm_rating_18872=1379532366; firm_rating_204795=1379488198; firm_rating_204803=1379491625; firm_rating_204808=1379493312; firm_rating_206845=1379519133; firm_rating_206863=1379519524; firm_rating_207722=1379526500; firm_rating_213902=1379564735; firm_rating_221351=1379550891; firm_rating_22647=1379525062; firm_rating_22648=1379529062; firm_rating_22703=1379524692; firm_rating_2329=1379523481; firm_rating_242554=1379491309; firm_rating_250394=1379510205; firm_rating_250399=1379514650; firm_rating_250418=1379519551; firm_rating_2539=1379534085; firm_rating_256130=1379482438; firm_rating_267244=1379529032; firm_rating_2693=1379524750; firm_rating_27906=1379491474; firm_rating_281011=1379487137; firm_rating_281012=1379489399; firm_rating_281018=1379488289; firm_rating_281019=1379491753; firm_rating_281029=1379490156; firm_rating_281714=1379482278; firm_rating_281728=1379482990; firm_rating_281755=1379482412; firm_rating_281757=1379483038; firm_rating_282823=1379489731; firm_rating_282833=1379492881; firm_rating_282835=1379487769; firm_rating_287569=1379482251; firm_rating_28882=1379482966; firm_rating_28892=1379482622; firm_rating_28933=1379482463; firm_rating_28942=1379482880; firm_rating_28947=1379482648; firm_rating_298892=1379499440; firm_rating_298893=1379502854; firm_rating_299418=1379554873; firm_rating_306125=1379492300; firm_rating_31234=1379548419; firm_rating_31238=1379546184; firm_rating_312890=1379529911; firm_rating_317475=1379482127; firm_rating_31762=1379518156; firm_rating_31764=1379521126; firm_rating_31771=1379516725; firm_rating_31781=1379516651; firm_rating_31789=1379514745; firm_rating_31802=1379521767; firm_rating_326334=1379482104; firm_rating_327448=1379500349; firm_rating_328672=1379482714; firm_rating_330126=1379513059; firm_rating_330514=1379523610; firm_rating_331493=1379540897; firm_rating_346294=1379525629; firm_rating_349969=1379526631; firm_rating_362702=1379482352; firm_rating_364919=1379494902; firm_rating_366457=1379561624; firm_rating_367819=1379537120; firm_rating_368564=1379482905; firm_rating_371430=1379541885; firm_rating_374693=1379513092; firm_rating_377806=1379549760; firm_rating_377821=1379547698; firm_rating_379726=1379520141; firm_rating_380256=1379521482; firm_rating_38125=1379528074; firm_rating_38901=1379482774; firm_rating_38949=1379482827; firm_rating_38982=1379482737; firm_rating_38996=1379482692; firm_rating_38998=1379482561; firm_rating_39002=1379482797; firm_rating_39003=1379482302; firm_rating_39004=1379483337; firm_rating_4050=1379521901; firm_rating_41941=1379563957; firm_rating_41950=1379565390; firm_rating_426=1379527286; firm_rating_49872=1379483018; firm_rating_49949=1379484551; firm_rating_49957=1379482940; firm_rating_49960=1379482537; firm_rating_51052=1379534382; firm_rating_53392=1379509181; firm_rating_53776=1379525294; firm_rating_53988=1379528652; firm_rating_54172=1379524565; firm_rating_54269=1379545538; firm_rating_54277=1379548381; firm_rating_54340=1379539221; firm_rating_58367=1379564331; firm_rating_58368=1379565746; firm_rating_61606=1379497969; firm_rating_61611=1379507894; firm_rating_61633=1379500189; firm_rating_65481=1379530355; firm_rating_65490=1379522243; firm_rating_65505=1379524185; firm_rating_65513=1379529314; firm_rating_72868=1379550554; firm_rating_73094=1379547896; firm_rating_73564=1379481150; firm_rating_75289=1379547584; firm_rating_75290=1379542340; firm_rating_75293=1379541744; firm_rating_75300=1379544191; firm_rating_78800=1379520618; firm_rating_79156=1379565606; firm_rating_80788=1379513210; firm_rating_80790=1379519070; firm_rating_80798=1379519469; firm_rating_81500=1379487742; firm_rating_81502=1379493393; firm_rating_81504=1379484925; firm_rating_81505=1379491902; firm_rating_81510=1379492838; firm_rating_81511=1379490647; firm_rating_81515=1379489926; firm_rating_81516=1379493365; firm_rating_85371=1379509223; firm_rating_85406=1379504911; firm_rating_85491=1379498000; firm_rating_86330=1379561871; firm_rating_86335=1379553518; firm_rating_86352=1379554182; firm_rating_86369=1379523216; firm_rating_86376=1379527204; firm_rating_86380=1379522580; firm_rating_86384=1379523672; firm_rating_86435=1379530635; firm_rating_88049=1379500976; firm_rating_88116=1379499565; firm_rating_88200=1379502257; firm_rating_88243=1379506721; firm_rating_98730=1379482508; symfony=9ggt42qkniq0qgh7d4no9lhpl4'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/slujby_zanyatosti_naseleniya'
  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.209
  HTTP_X_REAL_IP: 207.241.237.209
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /firm/severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij
  PATH_TRANSLATED: 'redirect:/index.php/severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij'
  PHP_SELF: /frontend.php/firm/severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.209
  REMOTE_PORT: '50314'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1379567007
  REQUEST_URI: /frontend.php/firm/severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij
  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: 5.3.3-7+squeeze13
os: 'Linux cs8195 2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 x86_64'
extensions:
  - 'Core (5.3.3-7+squeeze13)'
  - 'date (5.3.3-7+squeeze13)'
  - ereg
  - libxml
  - openssl
  - pcre
  - 'zlib (1.1)'
  - bcmath
  - bz2
  - calendar
  - ctype
  - dba
  - 'dom (20031129)'
  - 'hash (1.0)'
  - 'fileinfo (1.0.5-dev)'
  - 'filter (0.11.0)'
  - ftp
  - gettext
  - session
  - iconv
  - 'json (1.2.1)'
  - mbstring
  - 'apc (3.1.3p1)'
  - posix
  - 'Reflection ($Revision: 300393 $)'
  - 'standard (5.3.3-7+squeeze13)'
  - shmop
  - 'SPL (0.2)'
  - soap
  - sockets
  - 'SimpleXML (0.1)'
  - 'exif (1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $)'
  - sysvmsg
  - sysvsem
  - sysvshm
  - 'tokenizer (0.1)'
  - wddx
  - xml
  - 'xmlreader (0.1)'
  - 'xmlwriter (0.1)'
  - 'zip (1.9.1)'
  - apache2handler
  - 'Phar (2.0.1)'
  - gd
  - 'geoip (1.0.7)'
  - mcrypt
  - 'memcache (3.0.4)'
  - 'mysql (1.0)'
  - 'mysqli (0.1)'
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_sqlite (1.0.1)'
  - 'SQLite (2.0-dev)'
  - 'sqlite3 (0.7-dev)'
  - 'suhosin (0.9.32.1)'
  - 'xsl (0.1)'
  - mhash

version: 1.2.12
path: /var/symfony/1.2/lib

1. SET NAMES 'utf8'
2. 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` WHERE firms.LINK_NAME='severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij' LIMIT 1
3. 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=22045 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
4. 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 LIMIT 1
5. 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 IS NULL
6. 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 IS NULL
7. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
8. 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 IS NULL
9. 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 IS NULL
10. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
11. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
12. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
13. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
14. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738769' LIMIT 1
15. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738769' ORDER BY ip_place.IP_FROM DESC LIMIT 1
16. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738769' AND ip_place.IP_TO>='3488738769'
17. 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` WHERE firms.LINK_NAME='severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij' LIMIT 1
18. UPDATE firms SET `VIEWS_COUNT`=93, `UPDATED_AT`='2013-09-19 09:03:27' WHERE firms.ID=22045
19. SELECT news.ID, news.PARENT_ID, news.NAME, news.THUMBNAIL, news.DESCRIPTION, news.CREATE_DATE, news.CREATE_DAY, news.PAGE_TITLE, news.PAGE_KEYWORDS, news.PAGE_DESCRIPTION, news.FIRM_ID, news.VISITOR_ID, news.SECURITY_CODE, news.PRIORITY, news.ACTIVITY FROM `news` WHERE news.ACTIVITY>0 AND news.FIRM_ID=22045 ORDER BY news.CREATE_DATE DESC LIMIT 3
20. SELECT operating_shedules.ID, operating_shedules.MONDAY_FROM, operating_shedules.MONDAY_TO, operating_shedules.TUESDAY_FROM, operating_shedules.TUESDAY_TO, operating_shedules.WEDNESDAY_FROM, operating_shedules.WEDNESDAY_TO, operating_shedules.THURSDAY_FROM, operating_shedules.THURSDAY_TO, operating_shedules.FRIDAY_FROM, operating_shedules.FRIDAY_TO, operating_shedules.WEEKDAYS_FROM, operating_shedules.WEEKDAYS_TO, operating_shedules.SATURDAY_FROM, operating_shedules.SATURDAY_TO, operating_shedules.SUNDAY_FROM, operating_shedules.SUNDAY_TO, operating_shedules.FIRM_ID FROM `operating_shedules` WHERE operating_shedules.FIRM_ID=22045 LIMIT 1
21. SELECT payment_methods.ID, payment_methods.NAME, payment_methods.PRIORITY, payment_methods.ACTIVITY FROM `payment_methods`, `firms__payment_methods` WHERE firms__payment_methods.FIRM_ID=22045 AND firms__payment_methods.PAYMENT_METHOD_ID=payment_methods.ID
22. SELECT firm_files.ID, firm_files.NAME, firm_files.FILENAME, firm_files.EXTENSION, firm_files.SIZE, firm_files.DOWNLOADS_COUNT, firm_files.FIRM_ID, firm_files.PRIORITY, firm_files.ACTIVITY FROM `firm_files` WHERE firm_files.ACTIVITY=true AND firm_files.FIRM_ID=22045
23. SELECT price_lists.ID, price_lists.NAME, price_lists.DATE, price_lists.FIRM_ID, price_lists.PRIORITY, price_lists.ACTIVITY FROM `price_lists` WHERE price_lists.FIRM_ID=22045
24. 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=22045 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
25. 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 LIMIT 1
26. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
27. SELECT drive_maps.ID, drive_maps.MAP_FILE, drive_maps.MAP_CODE, drive_maps.FIRM_ID FROM `drive_maps` WHERE drive_maps.FIRM_ID=22045 LIMIT 1
28. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
29. 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=22045 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
30. 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
31. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738769' LIMIT 1
32. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738769' ORDER BY ip_place.IP_FROM DESC LIMIT 1
33. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738769' AND ip_place.IP_TO>='3488738769'
34. 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
35. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
36. 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
37. 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
38. 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)
39. 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
40. 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)
41. 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
42. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8155,8156)
43. 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)
44. 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
45. 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)
46. 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
47. 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)
48. 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
49. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (42636,42637,42685,42638,42884,43017,43078)
50. 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
51. 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)
52. 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
53. 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)
54. 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
55. 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)
56. 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
57. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (6815,7276,7807,7129,7471,6851,6816)
58. 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
59. 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)
60. 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
61. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (50728,50730,50783)
62. 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
63. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (52458,52459,52461)
64. 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
65. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (61110,61111,61476,61475)
66. 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
67. 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)
68. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188335,188336)
69. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181037,181070,181072,181039)
70. 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
71. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (63755,63756)
72. 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
73. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10132,10196,10133,10180,10144)
74. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (66981,67008,67054,67029,67058,66995,67060,66982,67090,67066,67067,67069,67077,67078,67084,67089)
75. 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
76. 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
77. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188667)
78. 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)
79. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (69014,69175,69032,69248,69402,69445,69569,69015,69633,69176,69177,69684,69742,69851,69045,69922,70053,69047,69057,70124,69076,70233)
80. 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
81. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10421,10447,10506,10422)
82. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (70235,71186,71906,71182,71193,71709,71904,70237,72144,72331,71511,71907,72545,72823,72961,73144,73330,70814,72336,71323,73655,73828,74423,74424,74425)
83. 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
84. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74500,74428)
85. 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
86. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10892,10985,10705)
87. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (11012,11030,11013,11046)
88. 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
89. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74567,74569,74672,74586,74606,74648,74610,74696,74656,74681,74616,74662,74634,74659,74669,74640,74671)
90. 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
91. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (75884,75886,76059)
92. 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
93. 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)
94. 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
95. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (81036,81037)
96. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (30027,30100,30125,30146,30028,30179,30210)
97. 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
98. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (32100,32360,32362,32108,32113,32363,32124,32364,32346,32365,32373,32102,32352,32366,32368,32355,32372,32358,32369)
99. 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
100. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (84895,85219,85384,84896,85526,85628,85773,84937,86163,86223)
101. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,87696,88167,87697,88168,87232,88393,88394,88539,87233,86497,89222,87873,87234,86919,87109,87110,88096,88395,87499,87978,88656,87979,89055,87610,88848,86920,87980,86345,86346,87111,87348,88396,88157,86741,89748,87419,86347,88397,88158,88241,86593,89223,89056,87693,88398,88097,89057,89527,88242,88399,88243,86429,87611,87612,88756,86430,89749,88159,87112,88657,87981,87982,86594,88849,86742,87235,87349,87113,86922,88540,87236,87420,89757,89058,88244,88541,88160,89059,87237,86498,87421,89750,89541,86348,87238,88161,88542,86925,86431,88757,87114,88658,89751,88850,88659,87874,87613,87875,89528,88245,87876,89529,86743,86349,87350,89224,89060,88758,88759,87422,88400,87614,88543,86928,87239,88162,87877,87115,87983,88760,87615,87694,88660,86744,87507,86740,87116,89061,88661,86350,87984,88246,87117,86499,87500,87501,89225,88401,88098,87240,89355,86893,87241,87351,88761,88762,88851,87695,87352,89530,86500,87118,86595,89531,87985,88662,88663,88402,87616,88763,89062,88163,86432,87626,86351,89342,88764,89226,87986,87987,86352,89752,88403,86939,86501,89532,88099,88765,88852,87878,89227,89753,86596,86502,88404,88247,87502,89063,87423,86353,86354,86921,87424,86503,86355,89533,87504,88405,87988,88248,87242,87252,88544,87243,89343,87425,88545,87698,89534,87617,89064,88406,86745,87699,89535,87618,86504,86597,86292,87498,87700,87244,88766,89754,88546,88853,88854,88547,87245,86505,88664,86929,89344,88100,88407,88408,89228,88249,87609,87883,86433,87426,89065,87879,86434,87503,87353,88665,87619,89229,88409,87354,87989,88767,86356,88548,87701,87620,86506,88768,88769,87355,87246,89536,86746,89230,89066,88549,86930,89345,88410,89755,86357,89067,89756,87702,88250,89231,88550,87356,86747,88411,88412,89346,86598,88551,86435,86937,89758,86507,89347,89068,87880,88164,89069,89232,87505,88413,87506,88101,86599,89537,86938,88414,88770,86600,86748,89759,89348,87119,89760,87977,87427,86358,89538,88552,88415,86359,87428,88165,89233,87621,87248,88666,87703,89539,87990,86749,87881,87882,89761,86360,86750,88166,88553,86361,89234,87884,89349,87357,88771,87429,88667,88102,86751,87249,88855,88772,89235,89350,89762,87991,89763,88416,86752,86508,88773,86956,86753,89540,88417,89236,88251,87358,88252,88253,87704,87430,86940,88254,86942,88554,87120,87705,87706,86436,87707,88856,86437,89237,87992,89351,89070,88774,87993,87359,88392,89764,86944,88255,89238,86438,87431,88775,87708,87121,87360,87122,87709,87622,86754,87250,86509,87123,89239,86439,87432,86947,86755,88555,88857,89071,86601,87124,86602,89072,87885,86603,86604,88256,88556,89352,88169,88858,88103,87361,86756,88668,86605,89353,89240,86440,89241,87994,88418,86948,87710,88669,87623,88755,86510,87125,87886,89542,88859,89543,87433,89765,86952,89544,86953,89354,86606,88776,87995,87251,88860,86757,89054,87126,88104,87624,86758,89073,87247,87625,87508,87887,88670,86759,88105,87362,88257,87996,89766,87434,87127,87363,89074,89767,88671,87364,86362,88419,89768,89526,87365,88258,89075,86607,87711)
102. 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
103. 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)
104. 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
105. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (95421,95422)
106. 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
107. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199)
108. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13250,13285)
109. 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
110. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (15000,15001)
111. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97312,97319,97390,97397,97324,97325,97327,97328,97353,97354,97393,97356,97362,97365,97366,97368,97392,97391,97371,97372,97375,97376,97396,97380,97381,97401,97383,97387,97389)
112. 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
113. 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)
114. 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
115. 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
116. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
117. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (106031,106159,106139,106033,106158)
118. 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
119. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,111391)
120. 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
121. 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)
122. 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
123. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117286)
124. 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
125. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,119261,119270,119236,119280)
126. 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
127. 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)
128. 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
129. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (124340,124349,124341)
130. 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
131. 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)
132. 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
133. 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)
134. 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
135. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,130965)
136. 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
137. 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)
138. 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
139. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (143212,143213)
140. 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
141. 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)
142. 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
143. 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)
144. 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
145. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (16462,16479,16464)
146. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,149752)
147. 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)
148. 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
149. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17295)
150. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,152958,152985)
151. 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
152. 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)
153. 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
154. 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)
155. 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
156. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17558,17559,17669)
157. 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
158. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (160505,160751,160562,160555,160554,160508,160553)
159. 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
160. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171165,171173,171191,171119)
161. 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
162. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (172125,172399,172689,172777,174120,173010,172184,173452,173917,174119,174123,174617,174889,175905,175043,172126,175281,175044,175903,176077)
163. 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
164. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (21655,21657,21656,21937,21846,22056)
165. 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)
166. 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
167. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (22132,22387,22573,22133,23952,24633,22378)
168. 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
169. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178646,178336,179141,178231)
170. 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
171. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (36895,36900,36902,37137,36904,36912,37403,36913,36896)
172. 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
173. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25705,25452)
174. 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
175. 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)
176. 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
177. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (179428,179705,179881,180164,179478,180974,179499,179516,179773,179828,179850,179527,180987,180463,179538,179552,179604,179702,180552,179646,181016,179887,179703,179653,179656,179673,180779,179657,180935,179430,179669,179848)
178. 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
179. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747,25882,26054)
180. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (26154,26178,26179,26746,27091,26180,27507,26155,26181,28057)
181. 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
182. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493,189513,189554)
183. 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)
184. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,183526,184148,184433,184692,181922,186436,186758,187384,187738,188255,181921)
185. 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
186. SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
187. 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
188. 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` WHERE firms.LINK_NAME='severo-zapadnogo-ao-tsentr-zanyatosti-naseleniya-tszn-gu-otdel-stroginskij' LIMIT 1
189. 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=22045 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
190. 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=599
191. 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=598
192. 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
193. 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.RUBRIC_ID IN (605,599,598) AND recommend.START_DATE<='2013-09-19' AND recommend.END_DATE>='2013-09-19' ORDER BY recommend.VIEWS_COUNT DESC LIMIT 5
194. 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
195. 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
196. SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.ACTIVITY>2
197. 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
198. 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-19' ORDER BY currency_cources.DATE DESC LIMIT 1
199. 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-19'
200. 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
201. 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
202. 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
203. SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
204. 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