parameterHolder:
  action: rubric
  arrRubricBranch: [21, 63]
  id: oborudovanie_dlya_sfery_uslug
  module: default
attributeHolder:
  sf_route: 'sfRoute Object()'

options:
  http_protocol: HTTP/1.0
  logging: '1'
  charset: utf-8
  send_http_headers: true
  content_type: 'text/html; charset=utf-8'
cookies: {  }
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, rubrics_list_size: '40', rubrics_sort_type: alphabet }
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_11192: '1378062482'
  firm_rating_193678: '1378063453'
  firm_rating_198722: '1378092118'
  firm_rating_202215: '1378033784'
  firm_rating_209300: '1378035877'
  firm_rating_225290: '1378092016'
  firm_rating_228457: '1378092043'
  firm_rating_236321: '1378035738'
  firm_rating_236331: '1378032769'
  firm_rating_244688: '1378032588'
  firm_rating_259622: '1378065525'
  firm_rating_259623: '1378036819'
  firm_rating_28593: '1378036944'
  firm_rating_28600: '1378065396'
  firm_rating_28602: '1378062431'
  firm_rating_28603: '1378065357'
  firm_rating_288111: '1378065466'
  firm_rating_290522: '1378092142'
  firm_rating_291869: '1378035813'
  firm_rating_291871: '1378091909'
  firm_rating_296534: '1378065433'
  firm_rating_296585: '1378091824'
  firm_rating_301643: '1378092072'
  firm_rating_323107: '1378033751'
  firm_rating_327310: '1378033822'
  firm_rating_345496: '1378091797'
  firm_rating_345502: '1378036913'
  firm_rating_357820: '1378032735'
  firm_rating_357842: '1378032555'
  firm_rating_361353: '1378035780'
  firm_rating_361366: '1378035664'
  firm_rating_362263: '1378037012'
  firm_rating_370915: '1378032699'
  firm_rating_377695: '1378062375'
  firm_rating_380735: '1378036846'
  firm_rating_4148: '1378035844'
  firm_rating_42435: '1378092165'
  firm_rating_42442: '1378035704'
  firm_rating_44335: '1378032664'
  firm_rating_44353: '1378036879'
  firm_rating_45621: '1378036979'
  firm_rating_49648: '1378032630'
  firm_rating_53656: '1378091981'
  firm_rating_53667: '1378032811'
  firm_rating_74702: '1378091847'
  firm_rating_74726: '1378062406'
  firm_rating_88970: '1378091942'
  symfony: 5urhrhiouguf2abi2rdmdi9ma5
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_11192=1378062482; firm_rating_193678=1378063453; firm_rating_198722=1378092118; firm_rating_202215=1378033784; firm_rating_209300=1378035877; firm_rating_225290=1378092016; firm_rating_228457=1378092043; firm_rating_236321=1378035738; firm_rating_236331=1378032769; firm_rating_244688=1378032588; firm_rating_259622=1378065525; firm_rating_259623=1378036819; firm_rating_28593=1378036944; firm_rating_28600=1378065396; firm_rating_28602=1378062431; firm_rating_28603=1378065357; firm_rating_288111=1378065466; firm_rating_290522=1378092142; firm_rating_291869=1378035813; firm_rating_291871=1378091909; firm_rating_296534=1378065433; firm_rating_296585=1378091824; firm_rating_301643=1378092072; firm_rating_323107=1378033751; firm_rating_327310=1378033822; firm_rating_345496=1378091797; firm_rating_345502=1378036913; firm_rating_357820=1378032735; firm_rating_357842=1378032555; firm_rating_361353=1378035780; firm_rating_361366=1378035664; firm_rating_362263=1378037012; firm_rating_370915=1378032699; firm_rating_377695=1378062375; firm_rating_380735=1378036846; firm_rating_4148=1378035844; firm_rating_42435=1378092165; firm_rating_42442=1378035704; firm_rating_44335=1378032664; firm_rating_44353=1378036879; firm_rating_45621=1378036979; firm_rating_49648=1378032630; firm_rating_53656=1378091981; firm_rating_53667=1378032811; firm_rating_74702=1378091847; firm_rating_74726=1378062406; firm_rating_88970=1378091942; symfony=5urhrhiouguf2abi2rdmdi9ma5'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/igornoe_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/oborudovanie_dlya_sfery_uslug
  PATH_TRANSLATED: 'redirect:/index.php/oborudovanie_dlya_sfery_uslug'
  PHP_SELF: /frontend.php/rubric/oborudovanie_dlya_sfery_uslug
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.208
  REMOTE_PORT: '48365'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1378093096
  REQUEST_URI: /frontend.php/rubric/oborudovanie_dlya_sfery_uslug
  SCRIPT_FILENAME: /var/www/rspravkaru/www/frontend.php
  SCRIPT_NAME: /frontend.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: '[no address given]'
  SERVER_NAME: rspravka.ru
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: "<address>Apache/2.2.16 (Debian) Server at rspravka.ru Port 80</address>\n"
  SERVER_SOFTWARE: 'Apache/2.2.16 (Debian)'
session:
  symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { region_id: 0, rubrics_list_size: '40', rubrics_sort_type: alphabet } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1378092192

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='oborudovanie_dlya_sfery_uslug' 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=21
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.ID IS NULL
6. 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 (63,65,67,74,68,71,69,66,75,70,72,73,64) AND firms.ACTIVITY=true AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_PR DESC,firms.VIEWS_COUNT DESC
7. SELECT COUNT(*) FROM `firms__rubrics`, `firms` WHERE firms__rubrics.RUBRIC_ID IN (63,65,67,74,68,71,69,66,75,70,72,73,64) AND firms.ACTIVITY=true AND firms.ID IN (49424,49468,49462,22641,49483,49434,49432,49419,4125,34183,49456,49449,49815,195729,50149,49430,49437,49927,6822,49633,44778,371078,49761,34644,49507,195731,49796,49426,49647,49818,45488,4075,49905,50082,4068,49464,49490,43258,9207,49666,195734,15674,43839,361486,15816,38490,37429,49447,49770,4053,4074,11921,44669,4055,4050,15662,34536,1123,50085,38496,1333,45501,11914,6830,4077,6833,4161,45503,29394,5316,5354,49459,32453,5264,49423,5391,15661,49768,1162,195585,49678,4140,44620,49629,4081,45074,1175,15794,50210,16662,19724,49435,44627,50017,49824,4029,49869,195716,4046,49865,10870,29421,50055,10927,1405,11330,49820,4034,15848,49457,49485,49558,49635,6767,14551,38489,49078,2330,50081,50177,167261,15622,50095,49488,195664,5229,1160,4037,4044,44375,11925,49859,1547,4036,11970,49639,49645,49653,49916,49649,49750,4073,43235,15718,49771,49775,44516,49636,49642,15855,49758,1136,49855,49873,14466,49772,223001,27857,49937,11936,49615,49651,339936,49663,49840,4040,49640,11309,4088,11101,49634,4082,34930,49759,49482,44433,49565,6836,271760,32126,50084,339854,195730,44504,49945,50045,49648,49822,4047,361435,50131,49876,49489,11904,49874,34922,49484,50111,49429,49499,49816,1156,49861,50087,49487,49765,50072,49641,49760,49826,49769,257272,4131,11953,49644,49778,1138,4086,50000,4038,195720,12536,14006,49698,371092,49868,49425,49762,49821,4070,49912,49638,49814,50180,49486,49807,49823,290456,1152,4119,4061,4122,49958,49988,4042,49481,44982,4041,4105,11962,223115,4072,44521,195742,1121,4051,4078,5247,361444,49764,4106,4141,50078,4079,49421,49444,49550,38544,49791,49819,4027,4049,4085,4123,49956,49420,223122,49646,49784,4095,49728,195689,37191,49979,32189,371069,10914,49637,49831,4048,4080,13376,371068,49473,4089,4116,49948,339816,49552,49691,12164,49897,50118,43157,49453,49454,44919,195739,50073,4112,195722,223028,49793,290464,1153,4099,49846,49422,49470,49617,195737,49836,45240,49672,49817,47495,49474,49509,49657,4054,4110,50069,339832,290335,49549,49682,195748,4031,4092,4130,45862,49892,9147,49440,49480,195727,290334,223106,4076,49866,50037,49521,290393,49788,44781,4039,4101,49983,32835,37302,195532,49448,15652,49561,380014,49711,49811,44575,49932,50049,50076,49436,49471,49584,290405,49676,27723,49720,290455,12257,50128,45180,339999,49687,49706,290451,4096,32273,49428,49443,290340,45702,49537,49681,49683,49727,49838,11260,49871,24908,222982,49442,290337,340161,49605,49754,44692,4100,4129,49906,49935,34331,222972,49431,195595,195610,257292,290331,44878,45247,49577,49664,49690,15687,15838,49960,50167,371072,49475,195555,49620,49652,49658,4028,4090,49872,36955,290445,339797,49439,195668,49697,49757,49767,49799,339850,49830,290452,49856,49860,49863,49445,11150,11948,49536,290391,49643,195749,49786,49789,49851,49931,50080,290330,15809,49742,49785,49803,49810,4071,4121,49862,49880,50074,50091,50097,50124,50165,49477,49479,195565,195609,339859,49492,195625,219726,38491,49693,49800,49832,223108,290458,1582,4056,4060,4087,49885,257280,50070,49669,257206,15804,49749,257219,4045,4064,49893,34286,50117,50152,50188,339817,195613,361416,49583,49712,49730,4033,4102,4124,49845,49899,49949,49957,49990,50194,50203,195608,223119,44980,45029,45184,49497,49527,290392,195744,223124,257213,49695,49732,49766,49837,223109,4062,49848,290471,361441,50108,50193,50201,195495,361409,49433,195558,44598,49503,49508,49535,49660,195740,371099,49724,3598,4135,361478,44638,49986,50007,33133,50102,50155,50164,195502,49465,223121,11941,37622,49580,49590,195745,257215,49713,49725,49738,340124,49787,195712,257274,323825,340148,4091,45284,50058,34783,50094,50146,50183,50187,290419,290422,290426,339828,49427,195612,219720,195723,44895,45697,49511,49538,49582,49592,195628,49655,257207,49717,49736,49763,49783,49828,4069,340082,49864,49959,50003,323759,371087,37542,50132,50178,43185,49418,195567,195596,223006,339862,45035,45259,49540,49542,49556,49560,49587,195617,223030,49671,340176,340179,1552,49735,49755,323822,4126,49877,49909,361437,34306,50093,50122,50133,50148,50181,50213,49438,49478,223016,195735,223117,290338,44902,45696,49600,49656,46619,49699,49701,49737,49841,340146,49886,49967,50002,34588,50101,50142,50168,50182,195515,43422,49452,49476,219712,339880,223118,290333,49493,49548,49567,223043,49674,195690,49834,1141,3658,49857,43453,44734,50033,50050,34187,34311,50160,50192,323683,49458,49466,195576,195582,195598,219718,257295,323707,195719,44997,45913,49526,49546,49571,49576,49588,339988,48710,49723,49740,49746,195717,4065,49884,49955,49980,50047,34119,50109,50185,219705,339812,257289,195724,290336,361493,49522,49581,49625,195624,223033,323729,339974,340011,49661,49665,49686,49718,49722,49747,49842,195715,257273,290453,340156,4134,371091,49870,49913,49922,50089,50098,50197,290446,49085,49463,49469,221111,221113,339882,340162,49498,49512,49599,49606,49654,195677,195695,195706,340122,339838,223107,4083,44417,49918,50010,290505,340025,34702,50145,50159,50196,222979,222988,222993,257245,290410,290447,49472,195593,195728,195733,290339,49523,49530,339935,339984,340003,49650,49677,49688,290342,340175,49703,195676,340120,339841,371075,340155,340158,4084,4097,4139,223066,49921,50041,50056,340027,50099,50172,49450,49451,195553,219716,223008,219743,371098,45079,49496,49541,49573,195627,195639,223031,257233,323724,49659,49667,49685,223123,49729,49829,340157,4109,4132,6783,290375,361474,44772,49910,50006,50018,340042,340046,11293,50116,50121,195517,371073,49455,195597,221109,339904,340171,45740,49543,49551,49627,290394,323731,339957,371080,380481,223125,257214,290345,290348,340183,49715,49731,323812,340121,340128,49780,49809,195713,257275,340145,1143,1554,4098,4137,4142,49849,49852,223065,49902,49920,49943,34190,50141,50154,46375,49089,195579,223019,323701,361418,45023,45907,49504,49585,49604,49614,339924,339947,371081,49689,49696,49752,340125,49776,49801,223116,290461,290465,340147,4043,4093,4118,49844,361475,13998,49971,50043,290486,340045,361434,361451,34039,50139,50161,50179,50200,48471,49461,195588,195601,221110,223024,49569,195643,257231,339945,339969,45139,49668,195746,257209,290349,1825,49719,49734,49792,219710,290462,340159,3588,5882,340106,9771,49878,49919,49952,49964,50005,50012,50013,340038,361469,290424,49460,339873,339888,339901,290328,290332,323836,11001,49622,290402,339938,379853,49680,323844,323846,49710,49739,340130,340142,49773,49774,49781,49795,49835,195710,195711,223112,223114,290460,323829,4136,49853,223069,49907,49950,49962,49968,49977,50025,50053,257277,340020,340037,340040,361456,34743,290420,323684,339798,49446,323706,339864,339903,340163,44490,44874,44979,45853,49570,49602,195641,223038,290384,323736,339966,361426,49704,49748,371096,49794,49797,49802,323693,339843,195707,195709,290454,290463,323828,380244,49875,49896,49939,49944,49975,49982,49992,49993,49999,50036,50060,50061,361442,50068,50107,195543,290417,339819,49467,219715,223010,339852,45154,45209,45239,45320,45812,49630,223041,223046,257238,339934,361430,49662,49702,49716,290351,49782,49790,49806,49827,195714,290457,4057,4108,49854,323804,14142,49890,49929,49930,49940,49989,50026,50039,50059,50067,380792,34554,50125,195494,195500,257266,49441,219722,221117,339869,339897,340165,45171,49293,49510,49544,49547,49554,49562,49611,49624,257237,290379,323741,339989,49675,195738,223127,257212,371100,15688,15744,36214,49741,257216,49777,49808,221106,257224,371074,195708,340149,340150,340154,4058,49843,49847,49850,49858,223078,13579,49889,49898,49914,49915,49972,49973,49998,50034,50051,50052,290474,290497,323761,340024,340041,361453,50086,50106,50147,50157,50163,195527,195531,290423,195583,223021,323696,323700,340160,340164,44929,44996,49501,49513,49524,49532,49557,49603,49612,290398,339949,339973,339993,340001,49670,223126,49700,290372,340132,49798,49813,195546,49825,223113,323824,4035,4111,4128,6827,49867,49900,49926,49933,49936,49951,49981,50004,50011,50029,290499,323764,340034,34511,50096,50143,50198,50202,323690,195559,195572,195599,195611,223014,257293,45080,45260,49505,49516,49517,49534,49575,49591,49595,49631,195650,257232,257241,339979,257210,340177,15680,49692,195696,290355,340138,323695,49839,323826,340152,4107,4115,49901,49903,49969,49985,49996,50014,323757,32212,34513,36291,50090,50092,50100,50103,50105,50119,50130,50206,50207,257251,257262,195570,195591,195604,361421,340167,361487,11313,45193,47705,49506,49525,49528,49566,195647,223050,290383,290386,290395,290397,323726,339914,339971,339972,49679,257203,290347,15877,49714,49753,257221,290371,340127,361482,49804,257223,257226,339842,340151,4114,219736,221121,340091,49888,49895,49928,49934,49974,50015,50019,50028,257279,257282,290470,290488,290489,290504,323765,323775,340058,371090,33084,34645,34742,35257,43078,50088,50144,50151,50153,50176,50190,50205,195506,222966,290443,339806,195594,323718,44960,49491,49502,49529,49563,49564,49578,49586,49598,49610,49616,49626,49628,49632,339944,49673,15692,49743,49744,49751,223102,290352,323820,340119,49812,222998,222999,339840,49833,4120,223070,340103,1212,49882,49938,49942,49954,49978,50016,50021,50031,50032,50035,50063,290496,34407,37210,50071,50075,50126,50169,50171,195542,222977,257254,257256,257259,195605,339876,339886,44875,45017,45092,49621,195632,195656,223034,223044,223049,290389,290401,290404,323734,339942,339967,340009,257205,11310,43813,49726,219740,223103,257220,323806,339844,339848,4094,4143,44776,49879,49883,49941,49994,50009,50040,290493,290495,290506,323760,323788,340031,340035,340079,361452,361467,371086,34353,50114,50150,50170,50195,195524,222983,222984,222992,290436,290438,339829,361406,195568,323709,290329,45082,45318,49495,49500,49568,49579,49613,49619,195615,195630,195648,195661,219732,221120,223052,257235,290380,339976,339995,290346,323847,49705,257222,290363,290368,361483,4127,223074,340100,49965,49966,49970,49976,50001,50008,50020,50022,50027,50030,50057,290480,290482,290498,323771,323789,371083,34581,50112,50140,50162,50175,50191,50199,50209,195519,195536,195540,222963,323689,339815,339826,339831,221116,257288,339908,195732,290341,340169,31103,45127,49514,49519,49520,49572,49589,49597,49601,49609,49618,195614,195621,195634,195638,195645,195655,195666,195669,223036,223037,257229,257230,257236,323746,323747,339977,339978,339981,339983,323842,49709,49733,195691,195692,195698,195702,195703,195704,223091,223097,223100,290369,340139,323692,290459,4030,290374,340109,45119,49908,49911,49923,49947,49953,49961,49963,50023,50044,257285,257286,290469,290494,323769,323791,340068,340076,50079,50104,50110,50115,50123,50129,50138,50166,50186,50212,195525,219702,222970,222974,222975,222985,290412,290425,290432,290437,339833,195587,195592,219723,221114,223012,371079,195725,44887,45049,45205,49515,49531,49539,49545,49553,49559,49593,49594,49607,49608,49623,195637,195649,195651,195660,195665,219729,221118,223053,223059,257234,290390,290403,323719,339922,339953,340004,49684,290343,290344,340184,340187,49708,49745,195697,195705,221122,257218,290350,290356,290366,361484,49805,339846,4104,223071,290373,290376,290377,323795,323799,323805,340087,340092,340094,340097,340116,49881,49891,49894,49904,49924,49946,49991,50048,50065,290472,290473,290483,290490,290500,323773,340033,340044,340077,361446,361471,50083,50136,50173,50211,195501,195505,195509,195510,195523,219704,222976,222986,257246,257258,257261,290408,290416,290441,339804,361405,223005,223022,223025,339874,339875,339879,339890,339891,339907,361413,371077,195726,49494,49518,49555,49596,195616,195642,223035,223062,290382,290387,290400,323720,323745,323749,339952,339961,339987,257211,340174,340186,195675,195681,195687,195700,223088,223105,290357,290367,340123,257227,339847,223076,290378,323802,340096,361472,49925,49997,50024,50042,50054,50062,50064,290475,290478,290503,323776,340019,340029,340047,340049,340052,340067,340070,361450,371088,50156,50189,195511,195522,222964,222978,222991,222994,257255,290418,290430,290448,339801,339805,339822,219724,221107,221112,223017,323697,323699,323717,339856,339878,339883,339895,361424,323832,323833,323835,340168,340173,361491,49533,49574,195620,219730,290381,323727,323728,323750,339928,339930,339946,339960,339962,371082,195747,257208,323840,340180,340182,361494,49694,49756,195680,195684,195686,219741,290353,290370,340134,340137,371095,257225,339839,340153,223064,223075,223081,323794,323796,323800,49984,49995,50038,290466,290467,290485,290491,290492,290507,323768,323777,323780,323781,340013,340028,340036,340050,340060,340069,340080,361461,37541,50077,50113,50120,195497,195498,195499,195503,195512,195521,195528,195529,195535,195539,195541,222980,222987,222997,257242,257244,290428,323686,323688,339808,195566,323708,323710,339866,339894,339899,361417,195618,223027,223029,257240,323742,339913,339915,339929,339937,339948,339985,339986,339992,339996,340010,195741,257204,323843,340178,340185,49707,49721,195679,223086,290354,290358,290359,290360,290361,290365,323815,371093,49779,223067,340095,340098,49917,50066,257276,257278,290476,290479,290484,322691,323766,323786,340061,340062,340063,340066,361457,361460,361468,371084,371085,50134,50135,50158,50184,50204,50208,195526,222981,222989,222990,222996,290409,290415,290444,323691,219717,223007,257296,323711,339867,339881,339884,339885,339893,339900,339902,339906,323830,361488,361492,195644,195663,223045,257239,290385,290388,290396,290406,339917,339925,339954,339963,339975,339980,339991,339998,361428,195743,323839,323845,195688,195693,195699,223087,223094,223096,323808,323827,223079,340086,361479,50046,290481,290487,290501,290502,340014,340056,340073,361463,361465,50127,50174,195516,195530,195537,195538,219701,219703,222968,222973,257243,257248,257253,290407,290413,290427,290450,323675,323678,323687,339835,361408,361411,195575,219714,223023,323704,323715,339857,339860,339865,339889,323831,323834,195626,195629,195657,195662,223032,223048,323751,339912,339916,339918,339919,339923,339932,339939,339982,340006,340007,361427,361496,195678,223095,223098,223099,223101,340118,340126,339845,219737,340084,340102,340111,290477,323763,323787,340021,340022,340026,340051,340054,340059,340064,340072,340074,361443,361447,361462,361464,50137,222995,257252,257260,257264,257267,290435,323680,323682,339800,371071,257287,323702,339855,339871,339896,339898,339911,361423,371076,340166,340170,223040,223054,223060,257228,290399,323725,323733,323744,339941,339956,339958,340005,219742,223089,223093,323814,340131,340140,371094,323694,339851,223082,323801,340085,340088,340089,49987,257284,323753,323784,340015,340016,340030,340048,340071,340078,361448,361470,195518,222965,257257,257271,290433,290442,323676,323677,339803,339814,339821,339825,257291,323698,339853,339868,339892,340172,195640,223055,323723,323738,323739,323743,339927,339931,339950,339959,339994,339997,340000,340181,195682,323809,323810,323818,340136,371097,340110,49887,257281,323754,323755,323756,323782,323785,323790,323792,340023,340032,340053,361436,361439,361458,361466,195496,222969,222971,257247,257249,257269,290411,290429,323685,339802,339811,339836,339837,361404,257290,323713,339858,339872,361422,361489,323752,339921,339964,339990,361431,361433,195685,323811,323823,361485,339849,361412,219735,323797,340114,323772,323783,340057,361449,361459,371089,195504,257265,257268,290421,290449,323674,323681,339809,339810,339834,371070,339910,361420,223061,339940,339955,323837,323838,323807,323813,323817,340129,340135,340141,323798,323803,340093,340099,340104,340112,361473,361476,361477,290468,323774,340018,340039,257263,290431,323673,339820,361410,323705,323714,339877,339887,339905,361414,361415,323722,323730,323735,323740,339933,339943,339970,361429,361432,380250,323816,340133,340143,340083,340117,361480,323767,323778,340065,290434,323672,339799,339807,339827,323716,339863,195636,323721,323737,339920,339926,339951,340012,323841,361495,257217,290364,323819,323793,340081,340108,340115,323758,323770,340043,340055,361440,361454,257250,290414,323679,339813,339818,361407,257294,323703,339861,339870,361490,323732,339965,340008,290362,323821,340105,340113,340075,361419,223056,361425,340144,340090,323762,323779,290439,339823,339824,339830,339909,323748,340107,340017,361445,323712,339968,340002,340101,361455,361438,361481,381143,380885,380798,75655,244981,245007) AND firms__rubrics.FIRM_ID=firms.ID
8. 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 (63,65,67,74,68,71,69,66,75,70,72,73,64) AND firms.ACTIVITY=true AND firms.ID IN (49424,49468,49462,22641,49483,49434,49432,49419,4125,34183,49456,49449,49815,195729,50149,49430,49437,49927,6822,49633,44778,371078,49761,34644,49507,195731,49796,49426,49647,49818,45488,4075,49905,50082,4068,49464,49490,43258,9207,49666,195734,15674,43839,361486,15816,38490,37429,49447,49770,4053,4074,11921,44669,4055,4050,15662,34536,1123,50085,38496,1333,45501,11914,6830,4077,6833,4161,45503,29394,5316,5354,49459,32453,5264,49423,5391,15661,49768,1162,195585,49678,4140,44620,49629,4081,45074,1175,15794,50210,16662,19724,49435,44627,50017,49824,4029,49869,195716,4046,49865,10870,29421,50055,10927,1405,11330,49820,4034,15848,49457,49485,49558,49635,6767,14551,38489,49078,2330,50081,50177,167261,15622,50095,49488,195664,5229,1160,4037,4044,44375,11925,49859,1547,4036,11970,49639,49645,49653,49916,49649,49750,4073,43235,15718,49771,49775,44516,49636,49642,15855,49758,1136,49855,49873,14466,49772,223001,27857,49937,11936,49615,49651,339936,49663,49840,4040,49640,11309,4088,11101,49634,4082,34930,49759,49482,44433,49565,6836,271760,32126,50084,339854,195730,44504,49945,50045,49648,49822,4047,361435,50131,49876,49489,11904,49874,34922,49484,50111,49429,49499,49816,1156,49861,50087,49487,49765,50072,49641,49760,49826,49769,257272,4131,11953,49644,49778,1138,4086,50000,4038,195720,12536,14006,49698,371092,49868,49425,49762,49821,4070,49912,49638,49814,50180,49486,49807,49823,290456,1152,4119,4061,4122,49958,49988,4042,49481,44982,4041,4105,11962,223115,4072,44521,195742,1121,4051,4078,5247,361444,49764,4106,4141,50078,4079,49421,49444,49550,38544,49791,49819,4027,4049,4085,4123,49956,49420,223122,49646,49784,4095,49728,195689,37191,49979,32189,371069,10914,49637,49831,4048,4080,13376,371068,49473,4089,4116,49948,339816,49552,49691,12164,49897,50118,43157,49453,49454,44919,195739,50073,4112,195722,223028,49793,290464,1153,4099,49846,49422,49470,49617,195737,49836,45240,49672,49817,47495,49474,49509,49657,4054,4110,50069,339832,290335,49549,49682,195748,4031,4092,4130,45862,49892,9147,49440,49480,195727,290334,223106,4076,49866,50037,49521,290393,49788,44781,4039,4101,49983,32835,37302,195532,49448,15652,49561,380014,49711,49811,44575,49932,50049,50076,49436,49471,49584,290405,49676,27723,49720,290455,12257,50128,45180,339999,49687,49706,290451,4096,32273,49428,49443,290340,45702,49537,49681,49683,49727,49838,11260,49871,24908,222982,49442,290337,340161,49605,49754,44692,4100,4129,49906,49935,34331,222972,49431,195595,195610,257292,290331,44878,45247,49577,49664,49690,15687,15838,49960,50167,371072,49475,195555,49620,49652,49658,4028,4090,49872,36955,290445,339797,49439,195668,49697,49757,49767,49799,339850,49830,290452,49856,49860,49863,49445,11150,11948,49536,290391,49643,195749,49786,49789,49851,49931,50080,290330,15809,49742,49785,49803,49810,4071,4121,49862,49880,50074,50091,50097,50124,50165,49477,49479,195565,195609,339859,49492,195625,219726,38491,49693,49800,49832,223108,290458,1582,4056,4060,4087,49885,257280,50070,49669,257206,15804,49749,257219,4045,4064,49893,34286,50117,50152,50188,339817,195613,361416,49583,49712,49730,4033,4102,4124,49845,49899,49949,49957,49990,50194,50203,195608,223119,44980,45029,45184,49497,49527,290392,195744,223124,257213,49695,49732,49766,49837,223109,4062,49848,290471,361441,50108,50193,50201,195495,361409,49433,195558,44598,49503,49508,49535,49660,195740,371099,49724,3598,4135,361478,44638,49986,50007,33133,50102,50155,50164,195502,49465,223121,11941,37622,49580,49590,195745,257215,49713,49725,49738,340124,49787,195712,257274,323825,340148,4091,45284,50058,34783,50094,50146,50183,50187,290419,290422,290426,339828,49427,195612,219720,195723,44895,45697,49511,49538,49582,49592,195628,49655,257207,49717,49736,49763,49783,49828,4069,340082,49864,49959,50003,323759,371087,37542,50132,50178,43185,49418,195567,195596,223006,339862,45035,45259,49540,49542,49556,49560,49587,195617,223030,49671,340176,340179,1552,49735,49755,323822,4126,49877,49909,361437,34306,50093,50122,50133,50148,50181,50213,49438,49478,223016,195735,223117,290338,44902,45696,49600,49656,46619,49699,49701,49737,49841,340146,49886,49967,50002,34588,50101,50142,50168,50182,195515,43422,49452,49476,219712,339880,223118,290333,49493,49548,49567,223043,49674,195690,49834,1141,3658,49857,43453,44734,50033,50050,34187,34311,50160,50192,323683,49458,49466,195576,195582,195598,219718,257295,323707,195719,44997,45913,49526,49546,49571,49576,49588,339988,48710,49723,49740,49746,195717,4065,49884,49955,49980,50047,34119,50109,50185,219705,339812,257289,195724,290336,361493,49522,49581,49625,195624,223033,323729,339974,340011,49661,49665,49686,49718,49722,49747,49842,195715,257273,290453,340156,4134,371091,49870,49913,49922,50089,50098,50197,290446,49085,49463,49469,221111,221113,339882,340162,49498,49512,49599,49606,49654,195677,195695,195706,340122,339838,223107,4083,44417,49918,50010,290505,340025,34702,50145,50159,50196,222979,222988,222993,257245,290410,290447,49472,195593,195728,195733,290339,49523,49530,339935,339984,340003,49650,49677,49688,290342,340175,49703,195676,340120,339841,371075,340155,340158,4084,4097,4139,223066,49921,50041,50056,340027,50099,50172,49450,49451,195553,219716,223008,219743,371098,45079,49496,49541,49573,195627,195639,223031,257233,323724,49659,49667,49685,223123,49729,49829,340157,4109,4132,6783,290375,361474,44772,49910,50006,50018,340042,340046,11293,50116,50121,195517,371073,49455,195597,221109,339904,340171,45740,49543,49551,49627,290394,323731,339957,371080,380481,223125,257214,290345,290348,340183,49715,49731,323812,340121,340128,49780,49809,195713,257275,340145,1143,1554,4098,4137,4142,49849,49852,223065,49902,49920,49943,34190,50141,50154,46375,49089,195579,223019,323701,361418,45023,45907,49504,49585,49604,49614,339924,339947,371081,49689,49696,49752,340125,49776,49801,223116,290461,290465,340147,4043,4093,4118,49844,361475,13998,49971,50043,290486,340045,361434,361451,34039,50139,50161,50179,50200,48471,49461,195588,195601,221110,223024,49569,195643,257231,339945,339969,45139,49668,195746,257209,290349,1825,49719,49734,49792,219710,290462,340159,3588,5882,340106,9771,49878,49919,49952,49964,50005,50012,50013,340038,361469,290424,49460,339873,339888,339901,290328,290332,323836,11001,49622,290402,339938,379853,49680,323844,323846,49710,49739,340130,340142,49773,49774,49781,49795,49835,195710,195711,223112,223114,290460,323829,4136,49853,223069,49907,49950,49962,49968,49977,50025,50053,257277,340020,340037,340040,361456,34743,290420,323684,339798,49446,323706,339864,339903,340163,44490,44874,44979,45853,49570,49602,195641,223038,290384,323736,339966,361426,49704,49748,371096,49794,49797,49802,323693,339843,195707,195709,290454,290463,323828,380244,49875,49896,49939,49944,49975,49982,49992,49993,49999,50036,50060,50061,361442,50068,50107,195543,290417,339819,49467,219715,223010,339852,45154,45209,45239,45320,45812,49630,223041,223046,257238,339934,361430,49662,49702,49716,290351,49782,49790,49806,49827,195714,290457,4057,4108,49854,323804,14142,49890,49929,49930,49940,49989,50026,50039,50059,50067,380792,34554,50125,195494,195500,257266,49441,219722,221117,339869,339897,340165,45171,49293,49510,49544,49547,49554,49562,49611,49624,257237,290379,323741,339989,49675,195738,223127,257212,371100,15688,15744,36214,49741,257216,49777,49808,221106,257224,371074,195708,340149,340150,340154,4058,49843,49847,49850,49858,223078,13579,49889,49898,49914,49915,49972,49973,49998,50034,50051,50052,290474,290497,323761,340024,340041,361453,50086,50106,50147,50157,50163,195527,195531,290423,195583,223021,323696,323700,340160,340164,44929,44996,49501,49513,49524,49532,49557,49603,49612,290398,339949,339973,339993,340001,49670,223126,49700,290372,340132,49798,49813,195546,49825,223113,323824,4035,4111,4128,6827,49867,49900,49926,49933,49936,49951,49981,50004,50011,50029,290499,323764,340034,34511,50096,50143,50198,50202,323690,195559,195572,195599,195611,223014,257293,45080,45260,49505,49516,49517,49534,49575,49591,49595,49631,195650,257232,257241,339979,257210,340177,15680,49692,195696,290355,340138,323695,49839,323826,340152,4107,4115,49901,49903,49969,49985,49996,50014,323757,32212,34513,36291,50090,50092,50100,50103,50105,50119,50130,50206,50207,257251,257262,195570,195591,195604,361421,340167,361487,11313,45193,47705,49506,49525,49528,49566,195647,223050,290383,290386,290395,290397,323726,339914,339971,339972,49679,257203,290347,15877,49714,49753,257221,290371,340127,361482,49804,257223,257226,339842,340151,4114,219736,221121,340091,49888,49895,49928,49934,49974,50015,50019,50028,257279,257282,290470,290488,290489,290504,323765,323775,340058,371090,33084,34645,34742,35257,43078,50088,50144,50151,50153,50176,50190,50205,195506,222966,290443,339806,195594,323718,44960,49491,49502,49529,49563,49564,49578,49586,49598,49610,49616,49626,49628,49632,339944,49673,15692,49743,49744,49751,223102,290352,323820,340119,49812,222998,222999,339840,49833,4120,223070,340103,1212,49882,49938,49942,49954,49978,50016,50021,50031,50032,50035,50063,290496,34407,37210,50071,50075,50126,50169,50171,195542,222977,257254,257256,257259,195605,339876,339886,44875,45017,45092,49621,195632,195656,223034,223044,223049,290389,290401,290404,323734,339942,339967,340009,257205,11310,43813,49726,219740,223103,257220,323806,339844,339848,4094,4143,44776,49879,49883,49941,49994,50009,50040,290493,290495,290506,323760,323788,340031,340035,340079,361452,361467,371086,34353,50114,50150,50170,50195,195524,222983,222984,222992,290436,290438,339829,361406,195568,323709,290329,45082,45318,49495,49500,49568,49579,49613,49619,195615,195630,195648,195661,219732,221120,223052,257235,290380,339976,339995,290346,323847,49705,257222,290363,290368,361483,4127,223074,340100,49965,49966,49970,49976,50001,50008,50020,50022,50027,50030,50057,290480,290482,290498,323771,323789,371083,34581,50112,50140,50162,50175,50191,50199,50209,195519,195536,195540,222963,323689,339815,339826,339831,221116,257288,339908,195732,290341,340169,31103,45127,49514,49519,49520,49572,49589,49597,49601,49609,49618,195614,195621,195634,195638,195645,195655,195666,195669,223036,223037,257229,257230,257236,323746,323747,339977,339978,339981,339983,323842,49709,49733,195691,195692,195698,195702,195703,195704,223091,223097,223100,290369,340139,323692,290459,4030,290374,340109,45119,49908,49911,49923,49947,49953,49961,49963,50023,50044,257285,257286,290469,290494,323769,323791,340068,340076,50079,50104,50110,50115,50123,50129,50138,50166,50186,50212,195525,219702,222970,222974,222975,222985,290412,290425,290432,290437,339833,195587,195592,219723,221114,223012,371079,195725,44887,45049,45205,49515,49531,49539,49545,49553,49559,49593,49594,49607,49608,49623,195637,195649,195651,195660,195665,219729,221118,223053,223059,257234,290390,290403,323719,339922,339953,340004,49684,290343,290344,340184,340187,49708,49745,195697,195705,221122,257218,290350,290356,290366,361484,49805,339846,4104,223071,290373,290376,290377,323795,323799,323805,340087,340092,340094,340097,340116,49881,49891,49894,49904,49924,49946,49991,50048,50065,290472,290473,290483,290490,290500,323773,340033,340044,340077,361446,361471,50083,50136,50173,50211,195501,195505,195509,195510,195523,219704,222976,222986,257246,257258,257261,290408,290416,290441,339804,361405,223005,223022,223025,339874,339875,339879,339890,339891,339907,361413,371077,195726,49494,49518,49555,49596,195616,195642,223035,223062,290382,290387,290400,323720,323745,323749,339952,339961,339987,257211,340174,340186,195675,195681,195687,195700,223088,223105,290357,290367,340123,257227,339847,223076,290378,323802,340096,361472,49925,49997,50024,50042,50054,50062,50064,290475,290478,290503,323776,340019,340029,340047,340049,340052,340067,340070,361450,371088,50156,50189,195511,195522,222964,222978,222991,222994,257255,290418,290430,290448,339801,339805,339822,219724,221107,221112,223017,323697,323699,323717,339856,339878,339883,339895,361424,323832,323833,323835,340168,340173,361491,49533,49574,195620,219730,290381,323727,323728,323750,339928,339930,339946,339960,339962,371082,195747,257208,323840,340180,340182,361494,49694,49756,195680,195684,195686,219741,290353,290370,340134,340137,371095,257225,339839,340153,223064,223075,223081,323794,323796,323800,49984,49995,50038,290466,290467,290485,290491,290492,290507,323768,323777,323780,323781,340013,340028,340036,340050,340060,340069,340080,361461,37541,50077,50113,50120,195497,195498,195499,195503,195512,195521,195528,195529,195535,195539,195541,222980,222987,222997,257242,257244,290428,323686,323688,339808,195566,323708,323710,339866,339894,339899,361417,195618,223027,223029,257240,323742,339913,339915,339929,339937,339948,339985,339986,339992,339996,340010,195741,257204,323843,340178,340185,49707,49721,195679,223086,290354,290358,290359,290360,290361,290365,323815,371093,49779,223067,340095,340098,49917,50066,257276,257278,290476,290479,290484,322691,323766,323786,340061,340062,340063,340066,361457,361460,361468,371084,371085,50134,50135,50158,50184,50204,50208,195526,222981,222989,222990,222996,290409,290415,290444,323691,219717,223007,257296,323711,339867,339881,339884,339885,339893,339900,339902,339906,323830,361488,361492,195644,195663,223045,257239,290385,290388,290396,290406,339917,339925,339954,339963,339975,339980,339991,339998,361428,195743,323839,323845,195688,195693,195699,223087,223094,223096,323808,323827,223079,340086,361479,50046,290481,290487,290501,290502,340014,340056,340073,361463,361465,50127,50174,195516,195530,195537,195538,219701,219703,222968,222973,257243,257248,257253,290407,290413,290427,290450,323675,323678,323687,339835,361408,361411,195575,219714,223023,323704,323715,339857,339860,339865,339889,323831,323834,195626,195629,195657,195662,223032,223048,323751,339912,339916,339918,339919,339923,339932,339939,339982,340006,340007,361427,361496,195678,223095,223098,223099,223101,340118,340126,339845,219737,340084,340102,340111,290477,323763,323787,340021,340022,340026,340051,340054,340059,340064,340072,340074,361443,361447,361462,361464,50137,222995,257252,257260,257264,257267,290435,323680,323682,339800,371071,257287,323702,339855,339871,339896,339898,339911,361423,371076,340166,340170,223040,223054,223060,257228,290399,323725,323733,323744,339941,339956,339958,340005,219742,223089,223093,323814,340131,340140,371094,323694,339851,223082,323801,340085,340088,340089,49987,257284,323753,323784,340015,340016,340030,340048,340071,340078,361448,361470,195518,222965,257257,257271,290433,290442,323676,323677,339803,339814,339821,339825,257291,323698,339853,339868,339892,340172,195640,223055,323723,323738,323739,323743,339927,339931,339950,339959,339994,339997,340000,340181,195682,323809,323810,323818,340136,371097,340110,49887,257281,323754,323755,323756,323782,323785,323790,323792,340023,340032,340053,361436,361439,361458,361466,195496,222969,222971,257247,257249,257269,290411,290429,323685,339802,339811,339836,339837,361404,257290,323713,339858,339872,361422,361489,323752,339921,339964,339990,361431,361433,195685,323811,323823,361485,339849,361412,219735,323797,340114,323772,323783,340057,361449,361459,371089,195504,257265,257268,290421,290449,323674,323681,339809,339810,339834,371070,339910,361420,223061,339940,339955,323837,323838,323807,323813,323817,340129,340135,340141,323798,323803,340093,340099,340104,340112,361473,361476,361477,290468,323774,340018,340039,257263,290431,323673,339820,361410,323705,323714,339877,339887,339905,361414,361415,323722,323730,323735,323740,339933,339943,339970,361429,361432,380250,323816,340133,340143,340083,340117,361480,323767,323778,340065,290434,323672,339799,339807,339827,323716,339863,195636,323721,323737,339920,339926,339951,340012,323841,361495,257217,290364,323819,323793,340081,340108,340115,323758,323770,340043,340055,361440,361454,257250,290414,323679,339813,339818,361407,257294,323703,339861,339870,361490,323732,339965,340008,290362,323821,340105,340113,340075,361419,223056,361425,340144,340090,323762,323779,290439,339823,339824,339830,339909,323748,340107,340017,361445,323712,339968,340002,340101,361455,361438,361481,381143,380885,380798,75655,244981,245007) AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_PR DESC,firms.VIEWS_COUNT DESC LIMIT 10
9. 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=49424 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
10. 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
11. 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=49468 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
12. 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
13. 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=49462 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
14. 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
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=22641 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=49483 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=188256
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=49434 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=49432 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=49419 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=4125 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=34183 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 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
30. 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
31. 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
32. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738768' AND ip_place.IP_TO>='3488738768'
33. 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
34. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
35. 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
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.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188291 ORDER BY places.NAME ASC
37. 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)
38. 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
39. 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)
40. 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
41. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8155,8156)
42. 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)
43. 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
44. 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)
45. 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
46. 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)
47. 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
48. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (42636,42637,42685,42638,42884,43017,43078)
49. 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
50. 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)
51. 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
52. 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)
53. 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
54. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (44843,44844,44852,44856,44851)
55. 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
56. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (6815,7276,7807,7129,7471,6851,6816)
57. 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
58. 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)
59. 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
60. 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)
61. 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
62. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (52458,53664,54095,54772,52459,55621,56155,58268,56921,57693,58267,58986,59487,59881,52461)
63. 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
64. 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)
65. 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
66. 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)
67. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188335,188336,188416)
68. 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)
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 (63755,64306,64397,64567,63756,64961,65088,63989,64962,65765,65764,66001,66160,66430,66552,66726,66825,66980)
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 (10132,10196,10133,10180,10144)
73. 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)
74. 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
75. 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
76. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188667)
77. 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)
78. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (69014,69175,69032,69248,69402,69445,69569,69015,69633,69176,69177,69684,69742,69851,69045,69922,70053,69047,69057,70124,69076,70233)
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 (10421,10447,10506,10422)
81. 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)
82. 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
83. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74500,74428)
84. 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
85. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10892,10985,10705)
86. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (11012,11263,11307,11435,11030,11490,11769,11875,11013,11943,12155,12197,11046,12235)
87. 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
88. 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)
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 (75884,76396,76649,76991,75886,77429,76509,77740,78123,78232,78285,78519,78573,79115,76059,79914,80054,76746,80397,81035)
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 (12236,12252,12279,12553,12857,12308,13133,12332,12365,12238,12395,12419)
93. 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
94. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (81036,81811,81037,82358,82556,81340,82875,82978,83337,83145,84133,84691,84880)
95. 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
96. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (30027,30356,30417,30484,30100,30567,30125,30146,30695,30761,30901,30028,30799,31104,31144,31301,31440,30179,31595,31705,30210,31812,31856,31927,32006,32083,30487)
97. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
98. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (32100,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)
99. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
100. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (84895,85219,85384,84896,85526,85628,85773,84937,86163,86223)
101. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,87696,88167,87697,88168,87232,88393,88394,88539,87233,86497,89222,87873,87234,86919,87109,87110,88096,88395,87499,87978,88656,87979,89055,87610,88848,86920,87980,86345,86346,87111,87348,88396,88157,86741,89748,87419,86347,88397,88158,88241,86593,89223,89056,87693,88398,88097,89057,89527,88242,88399,88243,86429,87611,87612,88756,86430,89749,88159,87112,88657,87981,87982,86594,88849,86742,87235,87349,87113,86922,88540,87236,87420,89757,89058,88244,88541,88160,89059,87237,86498,87421,89750,89541,86348,87238,88161,88542,86925,86431,88757,87114,88658,89751,88850,88659,87874,87613,87875,89528,88245,87876,89529,86743,86349,87350,89224,89060,88758,88759,87422,88400,87614,88543,86928,87239,88162,87877,87115,87983,88760,87615,87694,88660,86744,87507,86740,87116,89061,88661,86350,87984,88246,87117,86499,87500,87501,89225,88401,88098,87240,89355,86893,87241,87351,88761,88762,88851,87695,87352,89530,86500,87118,86595,89531,87985,88662,88663,88402,87616,88763,89062,88163,86432,87626,86351,89342,88764,89226,87986,87987,86352,89752,88403,86939,86501,89532,88099,88765,88852,87878,89227,89753,86596,86502,88404,88247,87502,89063,87423,86353,86354,86921,87424,86503,86355,89533,87504,88405,87988,88248,87242,87252,88544,87243,89343,87425,88545,87698,89534,87617,89064,88406,86745,87699,89535,87618,86504,86597,86292,87498,87700,87244,88766,89754,88546,88853,88854,88547,87245,86505,88664,86929,89344,88100,88407,88408,89228,88249,87609,87883,86433,87426,89065,87879,86434,87503,87353,88665,87619,89229,88409,87354,87989,88767,86356,88548,87701,87620,86506,88768,88769,87355,87246,89536,86746,89230,89066,88549,86930,89345,88410,89755,86357,89067,89756,87702,88250,89231,88550,87356,86747,88411,88412,89346,86598,88551,86435,86937,89758,86507,89347,89068,87880,88164,89069,89232,87505,88413,87506,88101,86599,89537,86938,88414,88770,86600,86748,89759,89348,87119,89760,87977,87427,86358,89538,88552,88415,86359,87428,88165,89233,87621,87248,88666,87703,89539,87990,86749,87881,87882,89761,86360,86750,88166,88553,86361,89234,87884,89349,87357,88771,87429,88667,88102,86751,87249,88855,88772,89235,89350,89762,87991,89763,88416,86752,86508,88773,86956,86753,89540,88417,89236,88251,87358,88252,88253,87704,87430,86940,88254,86942,88554,87120,87705,87706,86436,87707,88856,86437,89237,87992,89351,89070,88774,87993,87359,88392,89764,86944,88255,89238,86438,87431,88775,87708,87121,87360,87122,87709,87622,86754,87250,86509,87123,89239,86439,87432,86947,86755,88555,88857,89071,86601,87124,86602,89072,87885,86603,86604,88256,88556,89352,88169,88858,88103,87361,86756,88668,86605,89353,89240,86440,89241,87994,88418,86948,87710,88669,87623,88755,86510,87125,87886,89542,88859,89543,87433,89765,86952,89544,86953,89354,86606,88776,87995,87251,88860,86757,89054,87126,88104,87624,86758,89073,87247,87625,87508,87887,88670,86759,88105,87362,88257,87996,89766,87434,87127,87363,89074,89767,88671,87364,86362,88419,89768,89526,87365,88258,89075,86607,87711)
102. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
103. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (89769,91335,91405,91407,91409,91569,91430,91572,91576,91330,91772,91756,91585,91593,91595,91597,91667,91674,91446,91185,91193,90258,92964,91162,91200,91602,91789,91246,91348,91559,93190,91310,90526,90820,91033,92412,92440,91536,91551,92726,91608,91676,91063,91265,91646,91274,93242,91534,92449,91678,91276,91680,91518,92931,93345,93454,91525,92727,91288,93036,91165,93086,91648,91167,91503,91641,91169,91544,91684,93650,94377,91523,95420,91541,91415,91293,93107,95419,90821,91695,91791,91261,91172,91516,93132,93455,91720,90263,91333,94504,92459,94688,91305,93166,91343,91267,91663,91139,91312,91782,92480,91174,91056,91495,94855,91320,89774,91499,91342,91512,90822,95105,91563,91776,95418,91180,91413,93216,93024,91337,91787,91566,91339,93456,91322,91785)
104. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
105. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (95421,95604,95776,96157,96292,96598,95422,96939,97096)
106. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
107. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199,97258)
108. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13753,13250,13285)
109. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
110. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (15000,15081,15546,15782,15904,16122,15001,16298)
111. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97312,97319,97390,97397,97324,97325,97327,97328,97353,97354,97393,97356,97362,97365,97366,97368,97392,97391,97371,97372,97375,97376,97396,97380,97381,97401,97383,97387,97389)
112. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
113. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (105825,105830,105916,105833,106017,105834,105860,105940,105986,105864,105829,105873,105922,105923,105924,105883,105891,105895,105899,105920)
114. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
115. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188602 ORDER BY places.NAME ASC
116. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
117. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (106031,106159,106407,109184,106558,109182,106409,106986,107473,107635,109567,107870,109568,108510,106139,108511,106410,108721,106411,106412,109179,109212,109303,109407,109459,106033,109183,109566,109620,109677,106158,110028,110095,109181,110842,109180,111072,111388,106413)
118. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
119. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,111391)
120. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
121. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (115543,115603,115572,115695,115855,116705,116707,115693,115604,116371,116110,116153,116714,115605,116518,115694,116712,115544,116702,115602,116709,115606,116973,117174,117284,115793)
122. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
123. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117884,117940,118383,117286,118966,119099)
124. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
125. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,119261,119270,119236,119280)
126. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
127. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (121215,121737,122109,123001,123094,123373,123545,121485)
128. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
129. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (124340,124349,124341)
130. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
131. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (125933,125956,125944,126000,126007,126017,126183,126196,126578,126317,126324,125936,126393,126394,126489)
132. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
133. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (35102,35109,35110,35152,35103,35155,35156,35163,35119,35128,35161,35162,35142)
134. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
135. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,130965)
136. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
137. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (140423,140757,140920,140425,141035,140434,140454,140478,140518,141388,140530,141715,141800,142119,142225,140572,140590,142610,140424,142750,142787,140614,143090,140666)
138. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
139. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (143212,143835,144232,144544,144766,144959,145022,143213,145351,145494,144116,145634,146015)
140. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
141. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (146138,146149,146180,146944,146156,146164,146165,146178,146139,146174,146169,146166)
142. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
143. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (147530,147891,148008,147583,147646,147649,147944,147650,148573,147893,148665,147903,147673,148744,147681,147917,149005,147682,147929,147683,147688,147533,147689,147582,147691)
144. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
145. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (16462,16517,16648,16676,16750,16877,16479,16966,17057,17255,17084,16519,16878,16464)
146. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,150079,149786,149800,149824,149834,149852,149868,149918,149934,149936,149968,150013,150046,150014,149752)
147. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (150080,150767,152529,150786,150127,150143,150787,150816,150166,150795,150826,151438,150823,150828,150081,150196,150201,150796,150469,150797,150256,150272,150275,150291,150311,150798,150322,150342,151950,150803,151946,150474,150788,150354,151989,150380,150387,150422,150439,152294,150453,150807,150819,150813,152528,150815,152760,152908)
148. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
149. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17399,17411,17520,17295,17419,17507)
150. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,153617,154019,154265,154624,152958,154757,154993,155174,156355,156687,156948,157182,152985,157326,158298)
151. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
152. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (35833,36166,36022,36202,36203,36204,36205,36206,36207,36208,36209,36027,35953,35955,36786,36278,36327,35990,35998,36028,36893,36013,36627,36669,36351,36014,36710,35834)
153. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
154. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (158302,158706,158312,158303,158319,158304,158322,158311,158323)
155. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
156. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17558,17778,17860,18323,18564,18666,21181,18813,18916,19486,19576,19823,17559,20163,20234,20380,20417,20510,17669,20667,20804,21257,21613)
157. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
158. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (160505,167992,163742,161612,164071,162018,162165,162329,164128,164761,168039,164180,162605,167891,160751,165091,164212,164562,168140,163367,167919,163641,167848,165044,163662,164250,164049,164644,168060,160562,165578,164962,165811,165981,168110,164499,166393,165262,165140,167948,160555,163823,167977,164613,167679,164295,164987,164322,165185,160554,163673,164354,169923,163930,165167,164523,160508,164879,160553,170747,171008,164381,165230,164406,164933,164585,164790,164452)
159. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
160. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171258,171165,171462,171173,171191,171119)
161. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
162. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (172125,172399,172689,172777,174120,173010,172184,173452,173917,174119,174123,174617,174889,175905,175043,172126,175281,175044,175903,176077)
163. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
164. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (21655,21657,21656,21937,21846,22056)
165. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (176078,177164,177165,177340,176268,176079,178033,178119)
166. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
167. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (22132,22387,22573,22133,23952,24633,22378)
168. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
169. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178646,178336,179141,178231)
170. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
171. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (36895,36900,36902,37137,36904,36912,37403,36913,36896)
172. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
173. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25705,25452)
174. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
175. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189026,189094,189029,189031,189032,189096,189087,189034,189036,189037,189181,189060,189058,189028,189189)
176. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=1 LIMIT 1
177. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (179428,179705,179881,180164,179478,180974,179499,179516,179773,179828,179850,179527,180987,180463,179538,179552,179604,179702,180552,179646,181016,179887,179703,179653,179656,179673,180779,179657,180935,179430,179669,179848)
178. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
179. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747)
180. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (26154,26178,26179,26746,27091,26180,27507,26155,26181,28057)
181. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
182. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493)
183. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189595,189598,189622,189629,189630,189636,189639,189596,189747)
184. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,183526,184148,184433,184692,181922,186436,186758,187384,187738,188255,181921)
185. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
186. SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
187. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=0
188. SELECT 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='oborudovanie_dlya_sfery_uslug' LIMIT 1
189. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=21
190. SELECT recommend.ID, recommend.FIRM_ID, recommend.RUBRIC_ID, recommend.PLACE_ID, recommend.HEADER, recommend.URL, recommend.DESCRIPTION, recommend.SPECIAL, recommend.VIEWS_COUNT, recommend.TYPE, recommend.SEARCH, recommend.START_DATE, recommend.END_DATE, recommend.ACTIVITY FROM `recommend` WHERE recommend.ACTIVITY=true AND recommend.TYPE IN ('pr','rr') AND recommend.RUBRIC_ID IN (63,21) AND recommend.START_DATE<='2013-09-02' AND recommend.END_DATE>='2013-09-02' ORDER BY recommend.VIEWS_COUNT DESC LIMIT 5
191. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID='oborudovanie_dlya_sfery_uslug'
192. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE (rubrics.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
193. 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
194. SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.ACTIVITY>2
195. 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
196. 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-02' ORDER BY currency_cources.DATE DESC LIMIT 1
197. 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-08-31'
198. 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
199. SELECT currency_cources.ID, currency_cources.VALUE, currency_cources.AMOUNT, currency_cources.CURRENCY_ID, currency_cources.BASE_CURRENCY_ID, currency_cources.DATE, currency_cources.ACTIVITY FROM `currency_cources` WHERE currency_cources.CURRENCY_ID=1 AND currency_cources.BASE_CURRENCY_ID=2 AND currency_cources.ACTIVITY=true ORDER BY currency_cources.DATE DESC LIMIT 2
200. 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
201. SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
202. 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