parameterHolder:
  action: rubric
  arrRubricBranch: [21, 57, 62]
  id: teploventilyacionnoe_oborudovanie
  module: default
  page: '2'
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: {  }
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: 'Справочная информация о компаниях, специализирующихся на производстве, продаже и установке тепловентиляционного оборудования. У нас представлены адреса, телефоны, цены и полная информация о компаниях'
  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
url_root: 'http://rspravka.ru'

cookie:
  firm_rating_10561: '1378264354'
  firm_rating_109644: '1378266150'
  firm_rating_109742: '1378265988'
  firm_rating_114187: '1378230356'
  firm_rating_114199: '1378234498'
  firm_rating_114294: '1378264325'
  firm_rating_114296: '1378200302'
  firm_rating_114317: '1378237155'
  firm_rating_114335: '1378235700'
  firm_rating_114345: '1378237126'
  firm_rating_114352: '1378200095'
  firm_rating_114357: '1378264205'
  firm_rating_114404: '1378265599'
  firm_rating_115128: '1378266286'
  firm_rating_116722: '1378192861'
  firm_rating_1257: '1378266474'
  firm_rating_138942: '1378234148'
  firm_rating_141090: '1378197766'
  firm_rating_154907: '1378264079'
  firm_rating_16264: '1378265961'
  firm_rating_16368: '1378266231'
  firm_rating_164792: '1378235866'
  firm_rating_164811: '1378235576'
  firm_rating_164948: '1378198907'
  firm_rating_164973: '1378237209'
  firm_rating_164989: '1378201054'
  firm_rating_180049: '1378265879'
  firm_rating_195361: '1378266338'
  firm_rating_200007: '1378235756'
  firm_rating_200011: '1378200597'
  firm_rating_200930: '1378237097'
  firm_rating_202082: '1378200898'
  firm_rating_202083: '1378265512'
  firm_rating_205190: '1378191805'
  firm_rating_209197: '1378235539'
  firm_rating_209202: '1378211093'
  firm_rating_209218: '1378200439'
  firm_rating_210598: '1378266094'
  firm_rating_220658: '1378238508'
  firm_rating_222846: '1378266016'
  firm_rating_226891: '1378198810'
  firm_rating_228291: '1378263974'
  firm_rating_228292: '1378200134'
  firm_rating_231463: '1378191569'
  firm_rating_233973: '1378191828'
  firm_rating_235678: '1378199974'
  firm_rating_235679: '1378200330'
  firm_rating_236203: '1378200493'
  firm_rating_236206: '1378264141'
  firm_rating_236234: '1378201123'
  firm_rating_237218: '1378193916'
  firm_rating_237358: '1378265802'
  firm_rating_24788: '1378191517'
  firm_rating_250710: '1378200960'
  firm_rating_250716: '1378200932'
  firm_rating_250729: '1378238358'
  firm_rating_250738: '1378264022'
  firm_rating_250743: '1378200703'
  firm_rating_250751: '1378200057'
  firm_rating_250752: '1378198710'
  firm_rating_250763: '1378236046'
  firm_rating_250768: '1378198874'
  firm_rating_256567: '1378238480'
  firm_rating_257609: '1378265737'
  firm_rating_257611: '1378198843'
  firm_rating_257614: '1378201531'
  firm_rating_257618: '1378264176'
  firm_rating_257627: '1378232235'
  firm_rating_260547: '1378198941'
  firm_rating_267866: '1378266258'
  firm_rating_268978: '1378265653'
  firm_rating_268983: '1378200224'
  firm_rating_268990: '1378264484'
  firm_rating_269016: '1378205519'
  firm_rating_269023: '1378234368'
  firm_rating_269037: '1378201182'
  firm_rating_269041: '1378235788'
  firm_rating_269043: '1378264549'
  firm_rating_269051: '1378234403'
  firm_rating_271635: '1378235665'
  firm_rating_272219: '1378266176'
  firm_rating_274171: '1378192783'
  firm_rating_274219: '1378191613'
  firm_rating_277963: '1378235901'
  firm_rating_277983: '1378200467'
  firm_rating_277989: '1378201004'
  firm_rating_278020: '1378224812'
  firm_rating_278038: '1378264385'
  firm_rating_278041: '1378235938'
  firm_rating_278043: '1378264264'
  firm_rating_278044: '1378235974'
  firm_rating_278055: '1378221150'
  firm_rating_278059: '1378237023'
  firm_rating_278069: '1378201379'
  firm_rating_280207: '1378198774'
  firm_rating_280210: '1378230323'
  firm_rating_280211: '1378265682'
  firm_rating_292070: '1378236082'
  firm_rating_292073: '1378237182'
  firm_rating_294812: '1378238456'
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_10561=1378264354; firm_rating_109644=1378266150; firm_rating_109742=1378265988; firm_rating_114187=1378230356; firm_rating_114199=1378234498; firm_rating_114294=1378264325; firm_rating_114296=1378200302; firm_rating_114317=1378237155; firm_rating_114335=1378235700; firm_rating_114345=1378237126; firm_rating_114352=1378200095; firm_rating_114357=1378264205; firm_rating_114404=1378265599; firm_rating_115128=1378266286; firm_rating_116722=1378192861; firm_rating_1257=1378266474; firm_rating_138942=1378234148; firm_rating_141090=1378197766; firm_rating_154907=1378264079; firm_rating_16264=1378265961; firm_rating_16368=1378266231; firm_rating_164792=1378235866; firm_rating_164811=1378235576; firm_rating_164948=1378198907; firm_rating_164973=1378237209; firm_rating_164989=1378201054; firm_rating_180049=1378265879; firm_rating_195361=1378266338; firm_rating_200007=1378235756; firm_rating_200011=1378200597; firm_rating_200930=1378237097; firm_rating_202082=1378200898; firm_rating_202083=1378265512; firm_rating_205190=1378191805; firm_rating_209197=1378235539; firm_rating_209202=1378211093; firm_rating_209218=1378200439; firm_rating_210598=1378266094; firm_rating_220658=1378238508; firm_rating_222846=1378266016; firm_rating_226891=1378198810; firm_rating_228291=1378263974; firm_rating_228292=1378200134; firm_rating_231463=1378191569; firm_rating_233973=1378191828; firm_rating_235678=1378199974; firm_rating_235679=1378200330; firm_rating_236203=1378200493; firm_rating_236206=1378264141; firm_rating_236234=1378201123; firm_rating_237218=1378193916; firm_rating_237358=1378265802; firm_rating_24788=1378191517; firm_rating_250710=1378200960; firm_rating_250716=1378200932; firm_rating_250729=1378238358; firm_rating_250738=1378264022; firm_rating_250743=1378200703; firm_rating_250751=1378200057; firm_rating_250752=1378198710; firm_rating_250763=1378236046; firm_rating_250768=1378198874; firm_rating_256567=1378238480; firm_rating_257609=1378265737; firm_rating_257611=1378198843; firm_rating_257614=1378201531; firm_rating_257618=1378264176; firm_rating_257627=1378232235; firm_rating_260547=1378198941; firm_rating_267866=1378266258; firm_rating_268978=1378265653; firm_rating_268983=1378200224; firm_rating_268990=1378264484; firm_rating_269016=1378205519; firm_rating_269023=1378234368; firm_rating_269037=1378201182; firm_rating_269041=1378235788; firm_rating_269043=1378264549; firm_rating_269051=1378234403; firm_rating_271635=1378235665; firm_rating_272219=1378266176; firm_rating_274171=1378192783; firm_rating_274219=1378191613; firm_rating_277963=1378235901; firm_rating_277983=1378200467; firm_rating_277989=1378201004; firm_rating_278020=1378224812; firm_rating_278038=1378264385; firm_rating_278041=1378235938; firm_rating_278043=1378264264; firm_rating_278044=1378235974; firm_rating_278055=1378221150; firm_rating_278059=1378237023; firm_rating_278069=1378201379; firm_rating_280207=1378198774; firm_rating_280210=1378230323; firm_rating_280211=1378265682; firm_rating_292070=1378236082; firm_rating_292073=1378237182; firm_rating_294812=1378238456; firm_rating_295827=1378266121; firm_rating_297625=1378201566; firm_rating_297651=1378234588; firm_rating_297662=1378264054; firm_rating_297730=1378203474; firm_rating_297762=1378234256; firm_rating_297766=1378238537; firm_rating_297775=1378198743; firm_rating_297789=1378200370; firm_rating_297826=1378203540; firm_rating_299216=1378201151; firm_rating_299226=1378234450; firm_rating_299244=1378235731; firm_rating_299245=1378203576; firm_rating_299280=1378204548; firm_rating_299286=1378237075; firm_rating_299291=1378238408; firm_rating_299322=1378238253; firm_rating_299328=1378201414; firm_rating_299368=1378235639; firm_rating_299388=1378238331; firm_rating_302364=1378195808; firm_rating_303081=1378193840; firm_rating_303157=1378191753; firm_rating_303260=1378193813; firm_rating_306148=1378191716; firm_rating_308472=1378265856; firm_rating_308635=1378211059; firm_rating_308644=1378200013; firm_rating_308652=1378238223; firm_rating_308653=1378265626; firm_rating_308654=1378265541; firm_rating_311973=1378191543; firm_rating_311975=1378193889; firm_rating_311983=1378191640; firm_rating_312492=1378238196; firm_rating_312517=1378234292; firm_rating_312552=1378200761; firm_rating_312607=1378201279; firm_rating_312631=1378226656; firm_rating_312724=1378200633; firm_rating_312733=1378204582; firm_rating_316441=1378203509; firm_rating_316445=1378200528; firm_rating_316446=1378236010; firm_rating_316448=1378200864; firm_rating_316450=1378201250; firm_rating_317380=1378201503; firm_rating_317387=1378201093; firm_rating_317404=1378203410; firm_rating_317409=1378200831; firm_rating_317421=1378200405; firm_rating_317443=1378232297; firm_rating_317450=1378238384; firm_rating_326756=1378201215; firm_rating_331242=1378201470; firm_rating_331595=1378264422; firm_rating_331614=1378238165; firm_rating_341406=1378200796; firm_rating_341442=1378192810; firm_rating_345416=1378263948; firm_rating_346495=1378237051; firm_rating_346497=1378232268; firm_rating_349613=1378238140; firm_rating_351619=1378234545; firm_rating_351620=1378200668; firm_rating_361685=1378191854; firm_rating_363537=1378265708; firm_rating_363538=1378200562; firm_rating_363539=1378203444; firm_rating_365634=1378200188; firm_rating_366118=1378195835; firm_rating_367101=1378266310; firm_rating_367662=1378234180; firm_rating_375536=1378264112; firm_rating_378307=1378192836; firm_rating_379751=1378265569; firm_rating_379829=1378234219; firm_rating_379868=1378201344; firm_rating_380037=1378197738; firm_rating_380173=1378264294; firm_rating_39705=1378238429; firm_rating_39712=1378264515; firm_rating_39747=1378264234; firm_rating_39754=1378234328; firm_rating_39762=1378199934; firm_rating_39812=1378214783; firm_rating_39825=1378201315; firm_rating_40344=1378265829; firm_rating_40612=1378266205; firm_rating_40614=1378266415; firm_rating_44793=1378263921; firm_rating_44963=1378235609; firm_rating_45089=1378191669; firm_rating_45351=1378238306; firm_rating_45399=1378235829; firm_rating_45429=1378213840; firm_rating_48795=1378266443; firm_rating_48848=1378265907; firm_rating_49107=1378265766; firm_rating_49215=1378266389; firm_rating_49969=1378191593; firm_rating_50014=1378193867; firm_rating_51312=1378266361; firm_rating_5210=1378195871; firm_rating_55291=1378196808; firm_rating_55366=1378191695; firm_rating_56899=1378205564; firm_rating_76891=1378266065; firm_rating_76895=1378265934; firm_rating_88806=1378266042; firm_rating_96494=1378191779; firm_rating_99663=1378200263; symfony=ns5jhsju14uvjqibjdd3qk22s4'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/teploventilyacionnoe_oborudovanie'
  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.208
  HTTP_X_REAL_IP: 207.241.237.208
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /rubric/teploventilyacionnoe_oborudovanie/page/2/
  PATH_TRANSLATED: 'redirect:/index.php/teploventilyacionnoe_oborudovanie/page/2/'
  PHP_SELF: /frontend.php/rubric/teploventilyacionnoe_oborudovanie/page/2/
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.208
  REMOTE_PORT: '33451'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1378267413
  REQUEST_URI: /frontend.php/rubric/teploventilyacionnoe_oborudovanie/page/2/
  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 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='teploventilyacionnoe_oborudovanie' 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` WHERE rubrics.ID=57
4. 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=21
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.TRANSLIT_NAME='teploventilyacionnoe_oborudovanie' LIMIT 1
6. 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=57
7. 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=21
8. 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
9. 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 (62) AND firms.ACTIVITY=true AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.VIEWS_COUNT DESC
10. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738768' LIMIT 1
11. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738768' ORDER BY ip_place.IP_FROM DESC LIMIT 1
12. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738768' AND ip_place.IP_TO>='3488738768'
13. SELECT COUNT(*) FROM `firms__rubrics`, `firms` WHERE firms__rubrics.RUBRIC_ID IN (62) AND firms.ACTIVITY=true AND firms.ID IN (49137,49248,48634,49272,49212,46316,11073,49256,44839,48545,48831,44396,49078,7234,11687,16893,289970,380226,172268,48795,27918,48898,10150,49317,49408,16554,49171,48812,16733,49120,16575,379818,16549,371132,46022,49254,49199,16083,49072,11789,43157,48823,49159,48869,49065,290156,46272,49394,18244,16552,16123,16599,46167,49007,289972,49319,371127,16551,46016,45613,48807,49052,290012,290121,290051,11282,46117,48841,16731,46064,46080,46485,48692,48819,289964,16608,49151,16108,46253,49203,15970,48748,49260,11271,46046,11261,46604,48625,48765,48903,49267,49348,223350,290145,11247,45668,48608,48987,223337,290036,9225,46251,48651,49198,49287,223343,289954,48861,48942,49315,289944,48602,48996,196091,223335,45663,46083,48497,48630,48656,48881,49030,49278,49294,196122,257189,16634,48486,48633,48658,49038,49380,289937,290147,16670,46342,47411,49067,49150,49158,49253,49316,49402,340404,46020,48761,48911,48935,49221,196120,223344,9619,48642,48655,196084,290015,290023,290063,16712,48806,48952,48961,49082,49204,290052,290164,46036,48922,49059,49118,49169,49247,49313,49320,223374,289925,323990,46084,46177,46215,48592,48601,48901,49095,49239,49273,49398,196101,289916,289966,290005,290017,340394,9303,45701,46185,48872,48915,49238,49336,289915,290003,290016,290098,323989,340402,361581,45634,46392,46443,47527,48781,48848,48860,48990,49009,49035,49066,49080,49085,49132,49234,49312,196097,257182,290077,290117,290135,4636,11287,16680,44208,46153,46159,48534,48641,48681,48879,48945,48970,49031,49081,49105,49146,49286,49352,49389,289891,289917,289930,289956,290174,323991,46188,46849,47386,48291,48725,48810,48854,48917,49075,49092,49325,16538,44383,48648,48673,48737,48762,48845,48914,48932,48992,49057,49074,49089,49135,49276,49364,49374,49391,49412,196087,289945,289979,290037,290057,290064,340443,361580,16562,16583,37127,46291,46384,48518,48618,48669,48688,48723,48775,48817,48840,49099,49141,49226,49230,289888,289903,290027,290120,340393,16688,16713,46280,48610,48702,48730,48750,48900,48980,48998,49037,49054,49083,49108,49121,49197,49227,49310,49347,223348,289962,290084,324005,340390,340401,16148,16354,16681,46171,46266,48616,48617,48680,48721,48754,48759,48820,48839,48928,48954,48975,49020,49021,49077,49088,49153,49208,49274,49280,49291,49296,49360,49400,323993,340423,340430,16183,46127,46158,46162,46208,46282,46370,48615,48632,48701,48787,48884,48897,48921,48997,49032,49056,49093,49098,49100,49101,49116,49127,49128,49134,49195,49215,49241,49249,49288,49311,49353,49358,49395,223425,290033,290044,290126,290138,324014,379821,46098,46105,46110,46134,46234,46235,46241,46277,46365,48522,48575,48657,48663,48682,48720,48726,48742,48743,48768,48791,48826,48837,49012,49028,49062,49070,49103,49109,49122,49192,49217,49229,49262,49263,49390,49399,289920,290072,290087,290162,340420,46061,46111,46116,46146,46298,46302,46391,46422,47387,48583,48585,48624,48654,48662,48784,48880,48919,48986,49064,49071,49079,49102,49129,49172,49178,49202,49255,49293,49346,49357,49359,49367,289921,290109,340387,11694,16548,45628,46229,46393,48594,48613,48660,48671,48694,48695,48699,48706,48736,48802,48838,48865,48891,48926,48948,49058,49063,49086,49090,49106,49113,49114,49133,49140,49147,49173,49185,49207,49240,49246,49265,49321,49328,49351,49366,257179,289929,289975,289988,290096,290102,340399,340412,9323,11472,16637,45624,46053,46141,47392,48623,48638,48666,48679,48684,48755,48782,48790,48827,48830,48846,48887,48965,48977,48989,48999,49000,49010,49096,49097,49111,49123,49136,49187,49218,49275,49277,49279,49295,49298,49301,49307,49318,49337,49355,49368,49385,49396,49403,49405,49414,196189,196190,223442,223455,257196,257197,289898,289933,289997,290020,371128,45633,46322,46366,48636,48675,48707,48709,48729,48772,48773,48776,48816,48852,48868,48874,48940,48995,49015,49026,49053,49069,49110,49115,49143,49152,49155,49162,49164,49166,49210,49214,49225,49231,49251,49261,49284,49314,49329,49344,49361,49362,49382,49401,49417,196086,196154,196193,221131,223339,223353,223448,257187,289914,289923,289928,289989,290061,290078,290137,290161,340397,11276,44880,46057,46262,46339,47403,48552,48711,48749,48849,48871,48910,48991,48994,49013,49025,49034,49050,49076,49119,49144,49188,49223,49233,49304,49331,49335,49339,49342,49343,49345,49350,196075,196112,223321,223362,223391,223407,223410,223451,289897,289913,289958,289959,289983,289986,290035,290045,290053,290068,290114,290116,290172,340386,340405,340418,11519,16162,16594,16626,45636,46265,46283,46306,46399,48687,48727,48741,48792,48798,48815,48883,48981,49003,49018,49061,49107,49130,49139,49156,49157,49160,49179,49183,49186,49196,49200,49211,49220,49228,49235,49264,49303,49305,49327,49341,49354,49379,49397,49407,223427,223460,289899,289936,289965,289985,290014,290019,290050,290067,290107,290123,290128,324011,324012,340403,340408,16638,46307,46373,46969,48676,48705,48835,49094,49145,49148,49154,49161,49167,49174,49177,49222,49224,49242,49250,49268,49283,49306,49332,49338,49369,49371,49383,49413,196126,196169,223334,223357,223446,257183,289894,289895,289927,289941,289953,289974,290021,290025,290065,290097,290104,290125,290133,290152,290159,290168,290175,340426,340431,361579,9584,10884,11272,43167,46238,46347,46368,48607,48619,48653,48793,48794,48818,48847,48859,48916,48971,49060,49068,49124,49131,49149,49170,49176,49180,49184,49189,49219,49258,49259,49266,49285,49330,49370,49378,49416,196073,196106,196164,223349,223356,223384,223389,223422,223444,223456,223457,289901,289922,289951,289952,289973,289978,289993,290001,290026,290040,290046,290058,290085,290086,290095,290118,324004,324007,8236,11273,16660,45125,45589,46082,48612,48732,48850,48862,48934,48972,49084,49091,49104,49125,49213,49269,49300,49340,49406,196083,196090,221132,223326,223354,223364,223385,223395,223405,223420,223423,223440,257181,289905,289906,289912,289943,289949,289971,289992,289999,290008,290055,290082,290111,290124,290127,290132,290139,290141,290143,290144,290153,290160,290167,290171,323987,323996,324015,340422,4844,9309,45717,48774,49051,49055,49073,49112,49117,49126,49163,49175,49181,49190,49191,49193,49194,49205,49232,49236,49237,49244,49252,49270,49282,49289,49290,49297,49302,49308,49322,49324,49333,49349,49356,49372,49373,49377,49381,49386,49388,49393,49409,49411,49415,196088,196103,196113,196124,196157,196160,196176,196201,223366,223367,223396,223400,223416,223435,257176,257180,289892,289948,289968,289996,290018,290034,290039,290041,290119,340382,371131,48265,48809,48856,49022,49023,49087,49138,49168,49182,49206,49271,49323,49363,49365,196123,219789,223330,223338,223402,223429,223431,223449,257195,290075,290080,290093,290136,290140,290142,290146,290148,290149,290150,290158,290176,323994,323998,324002,324006,340384,340385,340411,340414,340415,340417,340427,340433,340442,45662,48801,48858,48930,49008,49165,49201,49326,49375,289887,289907,289909,289926,289982,290000,290006,290024,290029,290030,290047,290059,290066,290074,290089,290092,290094,46345,48808,48993,49376,49387,49404,196092,196105,196145,196161,196171,196200,223351,223386,223392,257194,289904,289910,289924,289934,289950,289963,289977,289990,289994,289998,290002,290009,290010,290022,290028,290042,290048,290069,290071,290090,290103,290106,290112,290134,290154,290157,290169,290170,340383,48822,48955,49142,49243,49281,49292,49299,49334,49392,223363,223369,223387,223409,223430,223437,223459,257175,257184,257192,289890,289896,289931,289939,289942,289946,289957,289961,289969,289981,289984,290004,290013,290038,290049,290060,290062,290073,290079,290083,290105,290108,290130,323992,323999,324008,340396,340406,340410,340428,340432,340434,340440,340444,361583,371130,379784,49384,49410,196108,196167,223340,223346,223383,223397,223412,223424,257185,257186,289908,289955,290007,290032,290076,290081,290088,290100,290155,290166,290173,324003,324016,340398,361578,49209,196173,223325,223360,223401,257178,289938,289980,290011,290099,323988,340388,340389,340407,340416,340424,340435,361573,371129,49216,49245,49257,49309,196072,196181,196182,223419,257191,289893,289900,289911,289918,289976,289995,290043,290091,290113,290122,290129,290177,323995,324001,324010,340419,361586,196172,289889,290054,323997,324013,340391,340395,340409,340413,340425,340429,340436,361576,196183,257188,289940,290056,290110,290115,290131,324009,340439,340441,361574,223371,257193,289947,289991,290070,290151,290165,323986,340438,257190,289935,289960,289987,290163,340400,361577,196117,196186,289902,289919,289932,289967,290031,290101,361582,361585,324000,380032,340421,361584,380610,340392,340437,361575,381088,380229,271719,271769) AND firms__rubrics.FIRM_ID=firms.ID
14. 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 (62) AND firms.ACTIVITY=true AND firms.ID IN (49137,49248,48634,49272,49212,46316,11073,49256,44839,48545,48831,44396,49078,7234,11687,16893,289970,380226,172268,48795,27918,48898,10150,49317,49408,16554,49171,48812,16733,49120,16575,379818,16549,371132,46022,49254,49199,16083,49072,11789,43157,48823,49159,48869,49065,290156,46272,49394,18244,16552,16123,16599,46167,49007,289972,49319,371127,16551,46016,45613,48807,49052,290012,290121,290051,11282,46117,48841,16731,46064,46080,46485,48692,48819,289964,16608,49151,16108,46253,49203,15970,48748,49260,11271,46046,11261,46604,48625,48765,48903,49267,49348,223350,290145,11247,45668,48608,48987,223337,290036,9225,46251,48651,49198,49287,223343,289954,48861,48942,49315,289944,48602,48996,196091,223335,45663,46083,48497,48630,48656,48881,49030,49278,49294,196122,257189,16634,48486,48633,48658,49038,49380,289937,290147,16670,46342,47411,49067,49150,49158,49253,49316,49402,340404,46020,48761,48911,48935,49221,196120,223344,9619,48642,48655,196084,290015,290023,290063,16712,48806,48952,48961,49082,49204,290052,290164,46036,48922,49059,49118,49169,49247,49313,49320,223374,289925,323990,46084,46177,46215,48592,48601,48901,49095,49239,49273,49398,196101,289916,289966,290005,290017,340394,9303,45701,46185,48872,48915,49238,49336,289915,290003,290016,290098,323989,340402,361581,45634,46392,46443,47527,48781,48848,48860,48990,49009,49035,49066,49080,49085,49132,49234,49312,196097,257182,290077,290117,290135,4636,11287,16680,44208,46153,46159,48534,48641,48681,48879,48945,48970,49031,49081,49105,49146,49286,49352,49389,289891,289917,289930,289956,290174,323991,46188,46849,47386,48291,48725,48810,48854,48917,49075,49092,49325,16538,44383,48648,48673,48737,48762,48845,48914,48932,48992,49057,49074,49089,49135,49276,49364,49374,49391,49412,196087,289945,289979,290037,290057,290064,340443,361580,16562,16583,37127,46291,46384,48518,48618,48669,48688,48723,48775,48817,48840,49099,49141,49226,49230,289888,289903,290027,290120,340393,16688,16713,46280,48610,48702,48730,48750,48900,48980,48998,49037,49054,49083,49108,49121,49197,49227,49310,49347,223348,289962,290084,324005,340390,340401,16148,16354,16681,46171,46266,48616,48617,48680,48721,48754,48759,48820,48839,48928,48954,48975,49020,49021,49077,49088,49153,49208,49274,49280,49291,49296,49360,49400,323993,340423,340430,16183,46127,46158,46162,46208,46282,46370,48615,48632,48701,48787,48884,48897,48921,48997,49032,49056,49093,49098,49100,49101,49116,49127,49128,49134,49195,49215,49241,49249,49288,49311,49353,49358,49395,223425,290033,290044,290126,290138,324014,379821,46098,46105,46110,46134,46234,46235,46241,46277,46365,48522,48575,48657,48663,48682,48720,48726,48742,48743,48768,48791,48826,48837,49012,49028,49062,49070,49103,49109,49122,49192,49217,49229,49262,49263,49390,49399,289920,290072,290087,290162,340420,46061,46111,46116,46146,46298,46302,46391,46422,47387,48583,48585,48624,48654,48662,48784,48880,48919,48986,49064,49071,49079,49102,49129,49172,49178,49202,49255,49293,49346,49357,49359,49367,289921,290109,340387,11694,16548,45628,46229,46393,48594,48613,48660,48671,48694,48695,48699,48706,48736,48802,48838,48865,48891,48926,48948,49058,49063,49086,49090,49106,49113,49114,49133,49140,49147,49173,49185,49207,49240,49246,49265,49321,49328,49351,49366,257179,289929,289975,289988,290096,290102,340399,340412,9323,11472,16637,45624,46053,46141,47392,48623,48638,48666,48679,48684,48755,48782,48790,48827,48830,48846,48887,48965,48977,48989,48999,49000,49010,49096,49097,49111,49123,49136,49187,49218,49275,49277,49279,49295,49298,49301,49307,49318,49337,49355,49368,49385,49396,49403,49405,49414,196189,196190,223442,223455,257196,257197,289898,289933,289997,290020,371128,45633,46322,46366,48636,48675,48707,48709,48729,48772,48773,48776,48816,48852,48868,48874,48940,48995,49015,49026,49053,49069,49110,49115,49143,49152,49155,49162,49164,49166,49210,49214,49225,49231,49251,49261,49284,49314,49329,49344,49361,49362,49382,49401,49417,196086,196154,196193,221131,223339,223353,223448,257187,289914,289923,289928,289989,290061,290078,290137,290161,340397,11276,44880,46057,46262,46339,47403,48552,48711,48749,48849,48871,48910,48991,48994,49013,49025,49034,49050,49076,49119,49144,49188,49223,49233,49304,49331,49335,49339,49342,49343,49345,49350,196075,196112,223321,223362,223391,223407,223410,223451,289897,289913,289958,289959,289983,289986,290035,290045,290053,290068,290114,290116,290172,340386,340405,340418,11519,16162,16594,16626,45636,46265,46283,46306,46399,48687,48727,48741,48792,48798,48815,48883,48981,49003,49018,49061,49107,49130,49139,49156,49157,49160,49179,49183,49186,49196,49200,49211,49220,49228,49235,49264,49303,49305,49327,49341,49354,49379,49397,49407,223427,223460,289899,289936,289965,289985,290014,290019,290050,290067,290107,290123,290128,324011,324012,340403,340408,16638,46307,46373,46969,48676,48705,48835,49094,49145,49148,49154,49161,49167,49174,49177,49222,49224,49242,49250,49268,49283,49306,49332,49338,49369,49371,49383,49413,196126,196169,223334,223357,223446,257183,289894,289895,289927,289941,289953,289974,290021,290025,290065,290097,290104,290125,290133,290152,290159,290168,290175,340426,340431,361579,9584,10884,11272,43167,46238,46347,46368,48607,48619,48653,48793,48794,48818,48847,48859,48916,48971,49060,49068,49124,49131,49149,49170,49176,49180,49184,49189,49219,49258,49259,49266,49285,49330,49370,49378,49416,196073,196106,196164,223349,223356,223384,223389,223422,223444,223456,223457,289901,289922,289951,289952,289973,289978,289993,290001,290026,290040,290046,290058,290085,290086,290095,290118,324004,324007,8236,11273,16660,45125,45589,46082,48612,48732,48850,48862,48934,48972,49084,49091,49104,49125,49213,49269,49300,49340,49406,196083,196090,221132,223326,223354,223364,223385,223395,223405,223420,223423,223440,257181,289905,289906,289912,289943,289949,289971,289992,289999,290008,290055,290082,290111,290124,290127,290132,290139,290141,290143,290144,290153,290160,290167,290171,323987,323996,324015,340422,4844,9309,45717,48774,49051,49055,49073,49112,49117,49126,49163,49175,49181,49190,49191,49193,49194,49205,49232,49236,49237,49244,49252,49270,49282,49289,49290,49297,49302,49308,49322,49324,49333,49349,49356,49372,49373,49377,49381,49386,49388,49393,49409,49411,49415,196088,196103,196113,196124,196157,196160,196176,196201,223366,223367,223396,223400,223416,223435,257176,257180,289892,289948,289968,289996,290018,290034,290039,290041,290119,340382,371131,48265,48809,48856,49022,49023,49087,49138,49168,49182,49206,49271,49323,49363,49365,196123,219789,223330,223338,223402,223429,223431,223449,257195,290075,290080,290093,290136,290140,290142,290146,290148,290149,290150,290158,290176,323994,323998,324002,324006,340384,340385,340411,340414,340415,340417,340427,340433,340442,45662,48801,48858,48930,49008,49165,49201,49326,49375,289887,289907,289909,289926,289982,290000,290006,290024,290029,290030,290047,290059,290066,290074,290089,290092,290094,46345,48808,48993,49376,49387,49404,196092,196105,196145,196161,196171,196200,223351,223386,223392,257194,289904,289910,289924,289934,289950,289963,289977,289990,289994,289998,290002,290009,290010,290022,290028,290042,290048,290069,290071,290090,290103,290106,290112,290134,290154,290157,290169,290170,340383,48822,48955,49142,49243,49281,49292,49299,49334,49392,223363,223369,223387,223409,223430,223437,223459,257175,257184,257192,289890,289896,289931,289939,289942,289946,289957,289961,289969,289981,289984,290004,290013,290038,290049,290060,290062,290073,290079,290083,290105,290108,290130,323992,323999,324008,340396,340406,340410,340428,340432,340434,340440,340444,361583,371130,379784,49384,49410,196108,196167,223340,223346,223383,223397,223412,223424,257185,257186,289908,289955,290007,290032,290076,290081,290088,290100,290155,290166,290173,324003,324016,340398,361578,49209,196173,223325,223360,223401,257178,289938,289980,290011,290099,323988,340388,340389,340407,340416,340424,340435,361573,371129,49216,49245,49257,49309,196072,196181,196182,223419,257191,289893,289900,289911,289918,289976,289995,290043,290091,290113,290122,290129,290177,323995,324001,324010,340419,361586,196172,289889,290054,323997,324013,340391,340395,340409,340413,340425,340429,340436,361576,196183,257188,289940,290056,290110,290115,290131,324009,340439,340441,361574,223371,257193,289947,289991,290070,290151,290165,323986,340438,257190,289935,289960,289987,290163,340400,361577,196117,196186,289902,289919,289932,289967,290031,290101,361582,361585,324000,380032,340421,361584,380610,340392,340437,361575,381088,380229,271719,271769) AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.VIEWS_COUNT DESC LIMIT 20, 20
15. 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=27918 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
16. 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
17. 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=48898 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
18. 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=105822
19. 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=10150 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
20. 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
21. 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=49317 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
22. 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
23. 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=49408 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
24. 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
25. 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=16554 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
26. 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
27. 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=49171 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
28. 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
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=48812 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
30. 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
31. 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=16733 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
32. 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
33. 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=49120 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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.ID=188256
35. 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=16575 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
36. 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
37. 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=379818 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
38. 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
39. 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=16549 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
40. 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
41. 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=371132 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
42. 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
43. 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=46022 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
44. 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
45. 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=49254 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
46. 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
47. 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=49199 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
48. 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
49. 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=16083 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
50. 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
51. 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=49072 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
52. 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
53. 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=11789 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
54. 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
55. 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
56. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738768' LIMIT 1
57. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738768' ORDER BY ip_place.IP_FROM DESC LIMIT 1
58. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738768' AND ip_place.IP_TO>='3488738768'
59. 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
60. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
61. 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
62. 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
63. 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)
64. 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
65. 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)
66. 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
67. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8155,8156)
68. 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)
69. 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
70. 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)
71. 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
72. 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)
73. 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
74. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (42636,42637,42685,42638,42884,43017,43078)
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 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)
77. 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
78. 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)
79. 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
80. 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)
81. 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
82. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (6815,7276,7807,7129,7471,6851,6816)
83. 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
84. 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)
85. 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
86. 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)
87. 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
88. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (52458,52459,52461)
89. 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
90. 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)
91. 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
92. 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)
93. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188335,188336,188416)
94. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181037,181221,181251,181070,181072,181365,181480,181522,181640,181710,181802,181039,181916)
95. 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
96. 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)
97. 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
98. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10132,10196,10133,10180,10144)
99. 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)
100. 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
101. 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
102. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188667)
103. 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)
104. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (69014,69032,69015,69045,69047,69057,69076)
105. 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
106. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10421,10447,10506,10422)
107. 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)
108. 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
109. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74428)
110. 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
111. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10705)
112. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (11012,11030,11013,11046)
113. 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
114. 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)
115. 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
116. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (75884,75886,76059)
117. 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
118. 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)
119. 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
120. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (81036,81037)
121. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (30027,30100,30125,30146,30028,30179,30210)
122. 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
123. 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)
124. 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
125. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (84895,84896,84937)
126. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,86292)
127. 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
128. 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)
129. 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
130. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (95421,95422)
131. 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
132. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199)
133. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13250,13285)
134. 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
135. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (15000,15001)
136. 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)
137. 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
138. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (105825,105830,105916,105833,106017,105834,105860,105940,105986,105864,105829,105873,105922,105923,105924,105883,105891,105895,105899,105920)
139. 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
140. 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
141. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
142. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (106031,106159,106139,106033,106158)
143. 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
144. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,111391)
145. 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
146. 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)
147. 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
148. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117286)
149. 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
150. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,119261,119270,119236,119280)
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 (121215,121737,122109,123001,123094,123373,123545,121485)
153. 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
154. 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)
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 (125933,125956,125944,126000,126007,126017,126183,126196,126578,126317,126324,125936,126393,126394,126489)
157. 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
158. 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)
159. 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
160. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,130965)
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 (140423,140757,140425,140434,140454,140478,140518,140530,140572,140590,140424,140614,140666)
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 (143212,143213)
165. 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
166. 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)
167. 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
168. 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)
169. 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
170. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (16462,16479,16464)
171. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,149752)
172. 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)
173. 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
174. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17399,17411,17520,17295,17419,17507)
175. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,152958,152985)
176. 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
177. 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)
178. 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
179. 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)
180. 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
181. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17558,17559,17669)
182. 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
183. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (160505,160751,160562,160555,160554,160508,160553)
184. 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
185. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171165,171173,171191,171119)
186. 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
187. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (172125,172184,172126)
188. 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
189. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (21655,21657,21656,21937,21846,22056)
190. 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)
191. 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
192. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (22132,22387,22573,22133,22378)
193. 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
194. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178336,178231)
195. 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
196. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (36895,36900,36902,36904,36912,36913,36896)
197. 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
198. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25452)
199. 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
200. 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)
201. 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
202. 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)
203. 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
204. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747)
205. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (26154,26178,26179,26180,26155,26181)
206. 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
207. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493)
208. 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)
209. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,181922,181921)
210. 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
211. SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
212. 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
213. 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='teploventilyacionnoe_oborudovanie' LIMIT 1
214. 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=57
215. 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=21
216. SELECT recommend.ID, recommend.FIRM_ID, recommend.RUBRIC_ID, recommend.PLACE_ID, recommend.HEADER, recommend.URL, recommend.DESCRIPTION, recommend.SPECIAL, recommend.VIEWS_COUNT, recommend.TYPE, recommend.SEARCH, recommend.START_DATE, recommend.END_DATE, recommend.ACTIVITY FROM `recommend` WHERE recommend.ACTIVITY=true AND recommend.TYPE IN ('pr','rr','kr') AND recommend.RUBRIC_ID IN (62,57,21) AND recommend.START_DATE<='2013-09-04' AND recommend.END_DATE>='2013-09-04' ORDER BY recommend.VIEWS_COUNT DESC LIMIT 5
217. 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='teploventilyacionnoe_oborudovanie'
218. 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
219. 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
220. SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.ACTIVITY>2
221. 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
222. 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
223. 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'
224. 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
225. 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
226. 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
227. SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
228. 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