parameterHolder:
  action: rubric
  arrRubricBranch: [654, 655, 658]
  id: fotocentry
  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: '60', 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_214989: '1376244822'
  firm_rating_322789: '1376272646'
  firm_rating_374005: '1376272861'
  firm_rating_41988: '1376244924'
  firm_rating_42166: '1376272718'
  firm_rating_42728: '1376272838'
  firm_rating_49432: '1376272694'
  firm_rating_52045: '1376272816'
  firm_rating_56902: '1376272671'
  firm_rating_61667: '1376272917'
  firm_rating_74606: '1376244766'
  firm_rating_76027: '1376272792'
  firm_rating_82830: '1376246911'
  firm_rating_82890: '1376247108'
  firm_rating_83538: '1376246965'
  firm_rating_85140: '1376244901'
  firm_rating_98583: '1376244845'
  symfony: uik6oftafrlq4nakf43nm64ev4
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_214989=1376244822; firm_rating_322789=1376272646; firm_rating_374005=1376272861; firm_rating_41988=1376244924; firm_rating_42166=1376272718; firm_rating_42728=1376272838; firm_rating_49432=1376272694; firm_rating_52045=1376272816; firm_rating_56902=1376272671; firm_rating_61667=1376272917; firm_rating_74606=1376244766; firm_rating_76027=1376272792; firm_rating_82830=1376246911; firm_rating_82890=1376247108; firm_rating_83538=1376246965; firm_rating_85140=1376244901; firm_rating_98583=1376244845; symfony=uik6oftafrlq4nakf43nm64ev4'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/rubric/potolki'
  HTTP_USER_AGENT: 'Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)'
  HTTP_X_FORWARDED_FOR: 207.241.237.209
  HTTP_X_REAL_IP: 207.241.237.209
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /rubric/fotocentry
  PATH_TRANSLATED: 'redirect:/index.php/fotocentry'
  PHP_SELF: /frontend.php/rubric/fotocentry
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.209
  REMOTE_PORT: '56429'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1376273877
  REQUEST_URI: /frontend.php/rubric/fotocentry
  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: '60', rubrics_sort_type: alphabet } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1376272970

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='fotocentry' 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=655
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=654
5. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.TRANSLIT_NAME='fotocentry' LIMIT 1
6. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=655
7. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=654
8. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID IS NULL
9. SELECT firms.ID, firms.NAME, firms.THUMBNAIL, firms.DESCRIPTION, firms.ADDRESS, firms.PLACE_ID, firms.SUBWAY_STATION_ID, firms.PHONE, firms.FAX, firms.ICQ, firms.SKYPE, firms.SCHEMA, firms.EMAIL, firms.SITE, firms.LOGO, firms.VIEWS_COUNT, firms.FIRM_OWNER_ID, firms.CREATE_DATE, firms.CREATE_DAY, firms.PAGE_TITLE, firms.PAGE_KEYWORDS, firms.PAGE_DESCRIPTION, firms.PRIORITY, firms.ACTIVITY, firms.PRIORITY_RR, firms.DOP_PRIORITY_RR, firms.END_DATE_RR, firms.STATUS_RR, firms.PRIORITY_PR, firms.DOP_PRIORITY_PR, firms.END_DATE_PR, firms.STATUS_PR, firms.PRIORITY_KR, firms.DOP_PRIORITY_KR, firms.END_DATE_KR, firms.STATUS_KR, firms.PRIORITY_S, firms.DOP_PRIORITY_S, firms.END_DATE_S, firms.STATUS_S, firms.OPERATING_SHEDULE_TYPE, firms.SCHEMA_TYPE, firms.UPDATED_AT, firms.LINK_NAME FROM `firms`, `firms__rubrics` WHERE firms__rubrics.RUBRIC_ID IN (658) AND firms.ACTIVITY=true AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.VIEWS_COUNT DESC
10. SELECT COUNT(*) FROM `firms__rubrics`, `firms` WHERE firms__rubrics.RUBRIC_ID IN (658) AND firms.ACTIVITY=true AND firms.ID IN (278655,14885,14756,14662,15014,14968,372846,14978,14701,15047,327494,14847,14713,14764,14898,14840,14995,322787,14709,278701,14788,14821,14700,345884,14835,14776,15072,14984,14689,14729,15029,14896,278587,14775,14651,14745,15090,14848,14931,14929,278674,15109,14971,15068,14695,14659,15004,14770,15045,15111,14755,202473,247757,228684,14736,14932,14945,278610,327542,15115,228747,278642,14883,228703,14716,14922,14992,15118,14749,14806,14853,14950,15058,228733,228746,278583,14685,372853,14715,14742,14771,14794,15050,380264,14706,14751,14996,15007,15016,15042,202476,228709,14664,14784,14888,15089,15126,15129,228750,278694,327500,14688,14759,14766,14831,14999,15018,15022,202459,202533,247859,278653,14732,14738,14750,14801,14838,14923,15031,202437,202471,278632,278695,345891,363713,14767,14818,14826,14829,14890,14891,14911,14947,14964,15125,202540,247811,278687,14656,14744,14814,14887,14976,14981,278670,278697,345893,14792,14856,15023,15103,202438,345935,14851,14852,14914,14949,345843,345939,14679,14720,14726,14761,14777,14846,14872,14901,14905,14917,14998,15032,15038,15039,15074,15077,15106,202458,202460,247818,327506,345937,14663,14691,14711,14779,14798,14811,14844,14902,14919,14921,14933,14951,14953,15010,15100,15110,15124,202470,202507,278582,278586,278627,14690,14748,14762,14805,14808,14812,14876,14878,14904,14913,14944,14963,15026,15114,202484,278644,278667,278692,345839,363719,372864,372866,372867,14705,14721,14722,14743,14769,14789,14793,14795,14800,14817,14825,14845,14858,14980,15028,15043,15049,15076,15079,15092,15123,202464,202512,228724,247784,247800,278680,345865,345898,14655,14694,14707,14799,14803,14813,14855,14875,14912,14972,14979,14985,14997,15003,15069,15075,202431,228760,278604,278661,345838,363699,14658,14660,14666,14675,14683,14686,14714,14717,14740,14747,14791,14816,14842,14862,14884,14928,14930,14966,14975,14994,15036,15081,15086,15098,15099,15105,15130,228679,247850,278594,278602,278668,327516,345897,363720,14653,14677,14678,14704,14718,14727,14730,14765,14796,14802,14810,14830,14832,14834,14839,14850,14863,14881,14882,14889,14900,14910,14918,14989,15009,15082,15093,15095,15127,15128,247756,247836,247848,278620,327511,327518,14657,14665,14668,14681,14687,14693,14712,14719,14723,14728,14772,14780,14822,14874,14906,14908,14916,14939,14943,14961,14969,14973,15012,15019,15054,15057,15091,15101,15107,15119,202455,202503,202511,228731,228762,247749,247752,247768,247864,247893,278603,278640,278659,278663,14674,14682,14697,14724,14737,14746,14754,14758,14768,14787,14790,14807,14824,14841,14871,14907,14957,14958,14959,14983,15001,15020,15027,15035,15041,15052,15053,15078,15088,15108,15116,15120,228675,228680,228739,247773,247785,247806,278648,327496,345877,14667,14696,14698,14733,14739,14760,14778,14785,14797,14823,14836,14849,14879,14886,14893,14894,14897,14927,14941,14955,14974,14987,15030,15040,15046,15060,15063,15083,15113,15121,202465,202481,202494,202518,228785,228796,228799,278584,278591,363712,372854,14661,14684,14735,14809,14819,14820,14828,14873,14877,14880,14899,14903,14915,14926,14940,14946,14960,14965,14988,15017,15048,15051,15066,15067,15070,15102,15112,15122,202463,202523,202530,228687,228690,247871,247883,278658,278664,327539,345918,363698,14652,14654,14670,14671,14676,14703,14708,14710,14734,14827,14833,14854,14864,14866,14868,14869,14892,14895,14924,14925,14934,14935,14942,14954,14970,14977,14982,15064,15080,202452,202535,228725,247774,278590,278660,345904,14673,14680,14731,14752,14837,14865,14937,14956,14962,15025,15033,15085,202504,228674,228676,247812,247838,247872,327499,327519,345837,345847,345856,345883,363725,14699,14815,14870,14938,15000,15005,15008,15037,15044,15055,15056,15062,15073,15087,15096,15097,15104,202435,202439,202457,202462,202501,202515,228672,228689,228706,228765,228771,228772,247781,247797,247833,247856,247878,247884,247890,278671,278676,278677,278689,278693,327503,372859,14702,14725,14741,14782,14783,14867,14948,14967,15002,15021,15034,15065,15071,15117,202433,202472,202487,228685,228726,228769,228773,247755,247779,247788,247814,247820,247845,247863,278608,278651,278654,278665,278688,278699,327509,327536,345845,345933,363729,372860,372861,380043,14672,14692,14753,14774,14781,14786,14936,14986,14991,15013,15015,15061,15084,15094,202434,202441,202446,202453,202490,202496,202513,202527,202531,228670,228671,228686,228721,228741,228751,228763,228770,247791,247807,247817,247853,247858,247868,247879,278589,278621,278682,345886,345905,345910,372872,14669,14763,14804,14857,14952,14990,14993,15011,15059,202443,202454,202461,202488,202498,228681,228695,228719,228723,228735,228743,228749,228792,228798,247772,247794,247795,247834,247846,247861,247867,247881,247882,278593,278611,278645,278673,278684,278685,278686,327523,345848,345857,345864,345870,345922,363700,363715,372857,372862,379890,14757,14773,14843,202432,202451,202478,202483,202492,202524,228699,228722,228728,228732,228740,228756,228757,228761,228791,247750,247758,247762,247771,247823,247825,247829,247831,247837,247855,278605,278637,278641,278656,278657,278691,278700,327513,327524,345861,345926,345927,14860,202436,202456,202467,202469,202480,202499,202505,202506,202509,202537,228673,228702,228707,228708,228729,228742,228759,228795,247767,247777,247803,247835,247843,278581,278613,278614,278647,278652,278672,278678,327498,327505,327530,345851,345855,345887,345911,345930,345940,363721,372869,372871,14861,14909,15006,202479,202485,202486,202493,202502,202525,202526,202528,202529,221324,228694,228696,228698,228710,228730,228781,247746,247751,247754,247759,247775,247780,247790,247792,247801,247816,247827,247844,247887,278580,278585,278622,278623,278624,278696,278698,327515,345841,345873,345902,345919,345924,363702,363708,363726,372851,372868,380049,14859,14920,202445,202450,202482,202514,202521,202536,221323,228688,228692,228704,228711,228758,228793,228794,247748,247760,247786,247804,247808,247813,247819,247840,247873,247886,247888,247889,247891,247895,278592,278596,278597,278598,278619,278636,327507,327525,327531,327535,345852,345863,345907,345925,345929,363716,380050,15024,202517,228717,228787,247747,247761,247765,247766,247769,247793,247802,247815,247841,247847,247849,247860,247875,247876,247877,247892,278615,278626,278630,278690,327520,327529,327537,327540,327541,345849,345899,345906,345932,363714,372849,202508,228714,228748,228788,247764,247828,247862,247869,247880,247885,278595,278599,278600,278607,278628,278631,278635,278646,278662,327495,327510,327512,327527,345833,345840,345853,345854,345860,345872,345874,345882,345890,345896,345903,345912,345915,345920,345938,363728,363733,363734,372850,228716,228720,228784,247798,247824,247830,247842,247851,247857,247874,247894,278588,278606,278618,278650,278683,327504,327508,327517,345859,345894,345895,345908,345916,345921,363709,372847,372852,372858,372863,202539,220142,228776,228777,228786,247763,247776,247778,247796,247821,247852,247854,247865,247896,278601,278609,278612,278625,278629,278633,278639,327497,327532,327534,345868,345909,345913,345917,345923,345934,363722,372848,202477,202489,228715,228755,228768,247782,247799,247805,247832,247839,278638,278649,278666,278679,327501,327502,327528,345835,345869,345871,345889,345892,345914,345928,345931,363705,363707,372870,202541,228678,228700,228712,228778,228779,247753,247787,247826,278617,278643,327538,345844,345858,345888,363704,363724,363731,372856,202447,228718,247770,247783,247789,247810,278616,278669,278675,327533,345842,345850,345866,345875,345880,363703,363711,363717,228677,247822,247866,278681,327514,327521,327522,327526,345836,345862,345879,345885,345900,345936,363706,372865,228693,228713,247809,247870,278634,345878,345881,345901,363701,363723,363730,372855,345834,345846,345867,345876,363710,363718,363727,363732) AND firms__rubrics.FIRM_ID=firms.ID
11. 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 (658) AND firms.ACTIVITY=true AND firms.ID IN (278655,14885,14756,14662,15014,14968,372846,14978,14701,15047,327494,14847,14713,14764,14898,14840,14995,322787,14709,278701,14788,14821,14700,345884,14835,14776,15072,14984,14689,14729,15029,14896,278587,14775,14651,14745,15090,14848,14931,14929,278674,15109,14971,15068,14695,14659,15004,14770,15045,15111,14755,202473,247757,228684,14736,14932,14945,278610,327542,15115,228747,278642,14883,228703,14716,14922,14992,15118,14749,14806,14853,14950,15058,228733,228746,278583,14685,372853,14715,14742,14771,14794,15050,380264,14706,14751,14996,15007,15016,15042,202476,228709,14664,14784,14888,15089,15126,15129,228750,278694,327500,14688,14759,14766,14831,14999,15018,15022,202459,202533,247859,278653,14732,14738,14750,14801,14838,14923,15031,202437,202471,278632,278695,345891,363713,14767,14818,14826,14829,14890,14891,14911,14947,14964,15125,202540,247811,278687,14656,14744,14814,14887,14976,14981,278670,278697,345893,14792,14856,15023,15103,202438,345935,14851,14852,14914,14949,345843,345939,14679,14720,14726,14761,14777,14846,14872,14901,14905,14917,14998,15032,15038,15039,15074,15077,15106,202458,202460,247818,327506,345937,14663,14691,14711,14779,14798,14811,14844,14902,14919,14921,14933,14951,14953,15010,15100,15110,15124,202470,202507,278582,278586,278627,14690,14748,14762,14805,14808,14812,14876,14878,14904,14913,14944,14963,15026,15114,202484,278644,278667,278692,345839,363719,372864,372866,372867,14705,14721,14722,14743,14769,14789,14793,14795,14800,14817,14825,14845,14858,14980,15028,15043,15049,15076,15079,15092,15123,202464,202512,228724,247784,247800,278680,345865,345898,14655,14694,14707,14799,14803,14813,14855,14875,14912,14972,14979,14985,14997,15003,15069,15075,202431,228760,278604,278661,345838,363699,14658,14660,14666,14675,14683,14686,14714,14717,14740,14747,14791,14816,14842,14862,14884,14928,14930,14966,14975,14994,15036,15081,15086,15098,15099,15105,15130,228679,247850,278594,278602,278668,327516,345897,363720,14653,14677,14678,14704,14718,14727,14730,14765,14796,14802,14810,14830,14832,14834,14839,14850,14863,14881,14882,14889,14900,14910,14918,14989,15009,15082,15093,15095,15127,15128,247756,247836,247848,278620,327511,327518,14657,14665,14668,14681,14687,14693,14712,14719,14723,14728,14772,14780,14822,14874,14906,14908,14916,14939,14943,14961,14969,14973,15012,15019,15054,15057,15091,15101,15107,15119,202455,202503,202511,228731,228762,247749,247752,247768,247864,247893,278603,278640,278659,278663,14674,14682,14697,14724,14737,14746,14754,14758,14768,14787,14790,14807,14824,14841,14871,14907,14957,14958,14959,14983,15001,15020,15027,15035,15041,15052,15053,15078,15088,15108,15116,15120,228675,228680,228739,247773,247785,247806,278648,327496,345877,14667,14696,14698,14733,14739,14760,14778,14785,14797,14823,14836,14849,14879,14886,14893,14894,14897,14927,14941,14955,14974,14987,15030,15040,15046,15060,15063,15083,15113,15121,202465,202481,202494,202518,228785,228796,228799,278584,278591,363712,372854,14661,14684,14735,14809,14819,14820,14828,14873,14877,14880,14899,14903,14915,14926,14940,14946,14960,14965,14988,15017,15048,15051,15066,15067,15070,15102,15112,15122,202463,202523,202530,228687,228690,247871,247883,278658,278664,327539,345918,363698,14652,14654,14670,14671,14676,14703,14708,14710,14734,14827,14833,14854,14864,14866,14868,14869,14892,14895,14924,14925,14934,14935,14942,14954,14970,14977,14982,15064,15080,202452,202535,228725,247774,278590,278660,345904,14673,14680,14731,14752,14837,14865,14937,14956,14962,15025,15033,15085,202504,228674,228676,247812,247838,247872,327499,327519,345837,345847,345856,345883,363725,14699,14815,14870,14938,15000,15005,15008,15037,15044,15055,15056,15062,15073,15087,15096,15097,15104,202435,202439,202457,202462,202501,202515,228672,228689,228706,228765,228771,228772,247781,247797,247833,247856,247878,247884,247890,278671,278676,278677,278689,278693,327503,372859,14702,14725,14741,14782,14783,14867,14948,14967,15002,15021,15034,15065,15071,15117,202433,202472,202487,228685,228726,228769,228773,247755,247779,247788,247814,247820,247845,247863,278608,278651,278654,278665,278688,278699,327509,327536,345845,345933,363729,372860,372861,380043,14672,14692,14753,14774,14781,14786,14936,14986,14991,15013,15015,15061,15084,15094,202434,202441,202446,202453,202490,202496,202513,202527,202531,228670,228671,228686,228721,228741,228751,228763,228770,247791,247807,247817,247853,247858,247868,247879,278589,278621,278682,345886,345905,345910,372872,14669,14763,14804,14857,14952,14990,14993,15011,15059,202443,202454,202461,202488,202498,228681,228695,228719,228723,228735,228743,228749,228792,228798,247772,247794,247795,247834,247846,247861,247867,247881,247882,278593,278611,278645,278673,278684,278685,278686,327523,345848,345857,345864,345870,345922,363700,363715,372857,372862,379890,14757,14773,14843,202432,202451,202478,202483,202492,202524,228699,228722,228728,228732,228740,228756,228757,228761,228791,247750,247758,247762,247771,247823,247825,247829,247831,247837,247855,278605,278637,278641,278656,278657,278691,278700,327513,327524,345861,345926,345927,14860,202436,202456,202467,202469,202480,202499,202505,202506,202509,202537,228673,228702,228707,228708,228729,228742,228759,228795,247767,247777,247803,247835,247843,278581,278613,278614,278647,278652,278672,278678,327498,327505,327530,345851,345855,345887,345911,345930,345940,363721,372869,372871,14861,14909,15006,202479,202485,202486,202493,202502,202525,202526,202528,202529,221324,228694,228696,228698,228710,228730,228781,247746,247751,247754,247759,247775,247780,247790,247792,247801,247816,247827,247844,247887,278580,278585,278622,278623,278624,278696,278698,327515,345841,345873,345902,345919,345924,363702,363708,363726,372851,372868,380049,14859,14920,202445,202450,202482,202514,202521,202536,221323,228688,228692,228704,228711,228758,228793,228794,247748,247760,247786,247804,247808,247813,247819,247840,247873,247886,247888,247889,247891,247895,278592,278596,278597,278598,278619,278636,327507,327525,327531,327535,345852,345863,345907,345925,345929,363716,380050,15024,202517,228717,228787,247747,247761,247765,247766,247769,247793,247802,247815,247841,247847,247849,247860,247875,247876,247877,247892,278615,278626,278630,278690,327520,327529,327537,327540,327541,345849,345899,345906,345932,363714,372849,202508,228714,228748,228788,247764,247828,247862,247869,247880,247885,278595,278599,278600,278607,278628,278631,278635,278646,278662,327495,327510,327512,327527,345833,345840,345853,345854,345860,345872,345874,345882,345890,345896,345903,345912,345915,345920,345938,363728,363733,363734,372850,228716,228720,228784,247798,247824,247830,247842,247851,247857,247874,247894,278588,278606,278618,278650,278683,327504,327508,327517,345859,345894,345895,345908,345916,345921,363709,372847,372852,372858,372863,202539,220142,228776,228777,228786,247763,247776,247778,247796,247821,247852,247854,247865,247896,278601,278609,278612,278625,278629,278633,278639,327497,327532,327534,345868,345909,345913,345917,345923,345934,363722,372848,202477,202489,228715,228755,228768,247782,247799,247805,247832,247839,278638,278649,278666,278679,327501,327502,327528,345835,345869,345871,345889,345892,345914,345928,345931,363705,363707,372870,202541,228678,228700,228712,228778,228779,247753,247787,247826,278617,278643,327538,345844,345858,345888,363704,363724,363731,372856,202447,228718,247770,247783,247789,247810,278616,278669,278675,327533,345842,345850,345866,345875,345880,363703,363711,363717,228677,247822,247866,278681,327514,327521,327522,327526,345836,345862,345879,345885,345900,345936,363706,372865,228693,228713,247809,247870,278634,345878,345881,345901,363701,363723,363730,372855,345834,345846,345867,345876,363710,363718,363727,363732) AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.NAME ASC LIMIT 60
12. 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=15075 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
13. 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
14. 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=14843 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
15. 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
16. 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=15118 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
17. 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
18. 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=14798 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
19. 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
20. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=14999 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
21. 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
22. 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=345865 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
23. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=150081
24. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=202458 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
25. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115544
26. 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=15015 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
27. 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
28. 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=247861 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
29. 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
30. 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=372855 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
31. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=152985
32. 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=278694 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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.ID=188291
34. 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=14992 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
35. 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
36. 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=202459 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
37. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115544
38. 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=14976 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
39. 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
40. 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=15047 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
41. 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
42. 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=228730 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
43. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=32102
44. 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=15090 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
45. 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
46. 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=345833 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
47. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=150081
48. 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=15072 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
49. 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
50. 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=14898 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
51. 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=102874
52. 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=14929 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
53. 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
54. 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=228731 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
55. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=32102
56. 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=14806 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
57. 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
58. 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=228732 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
59. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=32102
60. 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=14853 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
61. 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
62. 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=278695 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
63. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188291
64. 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=345866 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
65. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=150081
66. 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=345867 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
67. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=150081
68. 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=228733 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
69. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=32102
70. 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=228670 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
71. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=32102
72. 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=278682 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
73. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188291
74. 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=14896 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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.ID=188256
76. 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=247788 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
77. 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
78. 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=15110 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
79. 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=97866
80. 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=228735 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
81. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=32102
82. 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=202460 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
83. 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=115544
84. 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=14847 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
85. 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
86. 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=247774 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
87. 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
88. 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=247776 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
89. 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
90. 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=247780 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
91. 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
92. 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=247784 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
93. 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
94. 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=247789 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
95. 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
96. 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=247799 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
97. 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
98. 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=247800 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
99. 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
100. 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=247818 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
101. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188256
102. 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=247836 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
103. 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
104. 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=247842 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
105. 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
106. 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=247849 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
107. 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
108. 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=247850 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
109. 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
110. 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=247859 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
111. 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
112. 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=247867 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
113. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=97312
114. 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=247872 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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.ID=188256
116. 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=14995 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
117. 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
118. 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=14764 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
119. 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
120. 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=278697 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
121. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=188291
122. 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=15116 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
123. 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
124. 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=345834 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
125. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=150081
126. 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=14826 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
127. 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
128. 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=14821 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
129. 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
130. 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=345868 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
131. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=150081
132. 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
133. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738769' LIMIT 1
134. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738769' ORDER BY ip_place.IP_FROM DESC LIMIT 1
135. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738769' AND ip_place.IP_TO>='3488738769'
136. 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
137. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
138. 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
139. 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
140. 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)
141. 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
142. 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)
143. 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
144. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8155,8156)
145. 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)
146. 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
147. 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)
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 (38283,38284,39039,39884,38327,40327,40986,38299,38301,41147,41258,38310,40332,42623)
150. 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
151. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (42636,42637,42685,42638,42884,43017,43078)
152. 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
153. 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)
154. 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
155. 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)
156. 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
157. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (44843,46012,46718,45393,47682,46717,46398,47205,47957,46608,47206,45463,48080,45464,46936,45905,45084,46142,44844,45459,46399,46719,46937,47207,46287,46609,45906,45085,46797,45465,45907,46610,46720,46938,47208,47818,45547,45086,47334,47617,45176,48081,46618,45699,47618,46945,44974,45259,45087,45260,47958,46939,46940,45644,46288,47209,47819,46798,45701,47622,47210,45088,47430,44975,46941,47211,44976,45908,45392,45082,47820,45457,45468,45548,45642,45643,44977,45646,46799,47619,47620,45697,45698,48082,45460,46400,46143,47621,46145,45903,45904,46146,46942,46011,44852,46721,45177,47681,46467,46396,46289,47433,48083,46466,46611,47212,45178,45089,45647,47821,46147,45648,46401,45081,47822,46397,46290,45179,46468,46013,46469,45461,46470,46402,46606,46607,46291,47626,45258,46014,46148,44978,47623,46141,46617,45549,47213,47624,46015,45910,46716,46016,48084,47683,45466,44980,47823,44979,44856,47684,46612,46149,44981,46616,46150,47436,45649,47824,45180,46613,44982,48085,44983,45394,47214,46292,46471,45909,45261,46144,46935,45083,47435,47215,47625,46943,47202,47203,46944,46723,47434,47216,47204,45911,46724,45395,47217,45650,47333,45702,46293,45262,45396,46725,46151,44984,47428,47429,47959,47685,47335,44851,47218,47960,45397,47219,45398,46614,46726,45181,45467,46294,46295,44985,45090,46615,46727,45182,45703,46800,48086,47616,46801,48087,45462,44986,46946,45091,46947,47680,44987,47816,47817,46152,45263,47961,47220,47432,45651,46803,47955,47956,47336,48078,48079,45264,46403,47962,45183,47337,45458,46802,45184,45652,47686,46153,45185,46948,47431,44988,46722,46154,47221,46155,45645,47338,46804,46619,46728,45700,46949,47963,46472)
158. 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
159. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (6815,7276,7807,7129,7471,6851,6816)
160. 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
161. 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)
162. 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
163. 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)
164. 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
165. 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)
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 (61110,61616,61672,61712,61757,63566,61111,61476,61995,62253,61475,62488,62636,62693,62837,63247,63457,63754)
168. 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
169. 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)
170. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188335,188336,188416)
171. 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)
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 (63755,64306,64397,64567,63756,64961,65088,63989,64962,65765,65764,66001,66160,66430,66552,66726,66825,66980)
174. 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
175. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10132,10196,10133,10180,10144)
176. 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)
177. 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
178. 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
179. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188667)
180. 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)
181. 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)
182. 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
183. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10421,10447,10506,10422)
184. 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)
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` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74500,74428)
187. 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
188. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10892,10985,10705)
189. 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)
190. 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
191. 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)
192. 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
193. 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)
194. 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
195. 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)
196. 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
197. 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)
198. 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
199. 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)
200. 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
201. 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)
202. 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
203. 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)
204. 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)
205. 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
206. 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)
207. 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
208. 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)
209. 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
210. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199,97258)
211. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13753,13250,13285)
212. 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
213. 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)
214. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97312,101608,97472,102185,102186,97319,99119,99152,101609,100192,97778,97866,99827,102050,102187,99116,97390,98290,97397,98494,102444,97324,98728,99193,102188,102194,97325,97327,98864,102189,97328,99217,97353,99111,99540,97354,99815,97393,97356,99238,100445,100451,97362,100028,104086,97365,102069,102445,102184,102446,97366,105824,100424,99275,97368,100429,100460,101159,101275,102190,101607,102191,102183,99304,101742,99331,102017,102049,99541,102256,100463,99344,97392,99356,102510,104088,97391,97371,102874,97372,103140,97375,97376,103787,104090,97396,99370,104613,104614,104616,104617,104615,101747,104865,105058,100465,97380,102192,97381,97401,104087,102193,101746,105212,105231,105227,105228,105232,105234,105235,105229,105230,105529,105822,97383,102511,97387,101743,97389,99379,98291)
215. 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
216. 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)
217. 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
218. 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
219. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
220. 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)
221. 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
222. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,112127,112346,111391,113343,113910,114261,114634,114635,114946,115278,115410)
223. 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
224. 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)
225. 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
226. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117884,117940,118383,117286,118966,119099)
227. 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
228. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,121209,119437,119902,119482,120014,119261,119270,119236,119280,120171,119584,119649)
229. 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
230. 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)
231. 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
232. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (124340,124578,124754,124349,124945,125126,125520,125580,124341,125678,124444,124755)
233. 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
234. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (125933,125956,125944,127099,127121,126000,126007,126017,126183,128448,126196,126578,126317,126324,128674,128854,129072,129165,125936,126393,129865,126394,130106,127621,130254,126489)
235. 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
236. 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)
237. 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
238. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,132594,133147,134464,134875,135208,135737,136250,137097,137834,130965,138104,138779,139214)
239. 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
240. 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)
241. 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
242. 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)
243. 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
244. 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)
245. 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
246. 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)
247. 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
248. 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)
249. 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)
250. 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)
251. 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
252. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17399,17411,17520,17295,17419,17507)
253. 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)
254. 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
255. 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)
256. 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
257. 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)
258. 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
259. 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)
260. 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
261. 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)
262. 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
263. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171258,171165,171462,171173,171191,171119)
264. 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
265. 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)
266. 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
267. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (21655,21657,21656,21937,21846,22056)
268. 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)
269. 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
270. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (22132,22387,22573,22133,23952,24633,22378)
271. 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
272. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178646,178336,179141,178231)
273. 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
274. 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)
275. 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
276. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25705,25452)
277. 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
278. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189026,189094,189029,189031,189443,189032,189096,189087,189034,189036,189037,189181,189399,189060,189058,189028,189189)
279. 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
280. 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)
281. 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
282. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747,25882,26054)
283. 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)
284. 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
285. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493,189513,189554)
286. 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)
287. 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)
288. 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
289. SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
290. 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
291. 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='fotocentry' LIMIT 1
292. 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=655
293. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID=654
294. SELECT recommend.ID, recommend.FIRM_ID, recommend.RUBRIC_ID, recommend.PLACE_ID, recommend.HEADER, recommend.URL, recommend.DESCRIPTION, recommend.SPECIAL, recommend.VIEWS_COUNT, recommend.TYPE, recommend.SEARCH, recommend.START_DATE, recommend.END_DATE, recommend.ACTIVITY FROM `recommend` WHERE recommend.ACTIVITY=true AND recommend.TYPE IN ('pr','rr','kr') AND recommend.RUBRIC_ID IN (658,655,654) AND recommend.START_DATE<='2013-08-12' AND recommend.END_DATE>='2013-08-12' ORDER BY recommend.VIEWS_COUNT DESC LIMIT 5
295. 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='fotocentry'
296. 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
297. 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
298. SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.ACTIVITY>2
299. 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
300. 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-08-12' ORDER BY currency_cources.DATE DESC LIMIT 1
301. 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-10'
302. 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
303. 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
304. 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
305. SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
306. 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