parameterHolder:
  action: firm
  id: career-solutions
  module: default
attributeHolder:
  sf_route: 'sfRoute Object()'

options:
  http_protocol: HTTP/1.0
  logging: '1'
  charset: utf-8
  send_http_headers: true
  content_type: 'text/html; charset=utf-8'
cookies:
  firm_rating_208982: { name: firm_rating_208982, value: 1379558356, expire: 1379644756, path: /, domain: '', secure: false, httpOnly: false }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  jquery.js: {  }
  jquery.reveal.js: {  }
  jquery-spoiler_control.js: {  }
  scripts.js: {  }
  cuselFilter-min-2.3.1.js: {  }
  custom.js: {  }
  gmap.js: {  }
  select.js: {  }
  'http://maps.google.com/maps/api/js?sensor=true': {  }
stylesheets:
  style.css: {  }
  default_firm.css: {  }
  search.css: {  }
metas:
  title: 'CAREER SOLUTIONS. Бизнес-тренинги / Семинары. Новосибирская обл.'
  description: 'Справочная информация о компании CAREER SOLUTIONS расположенной по адресу Новосибирская обл., г. Новосибирск, Комсомольский пр. 24 оф. 209, 8-913-913-69-11. Область деятельности - Бизнес-тренинги / Семинары'
  keywords: 'адреса, телефоны, бесплатный справочник, справочная служба Новосибирская обл., база данных Новосибирская обл., каталог компаний, компания CAREER SOLUTIONS, организация, фирма, бизнес справочник, адреса и телефоны Бизнес-тренинги / Семинары, товары, услуги, желтые страницы'
  language: ru
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

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

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

cookie:
  firm_rating_110561: '1379558224'
  firm_rating_111482: '1379481395'
  firm_rating_111525: '1379481365'
  firm_rating_118208: '1379550239'
  firm_rating_118223: '1379545074'
  firm_rating_118225: '1379540454'
  firm_rating_119288: '1379538092'
  firm_rating_119290: '1379539472'
  firm_rating_119303: '1379538273'
  firm_rating_119304: '1379540708'
  firm_rating_119314: '1379542823'
  firm_rating_131869: '1379531801'
  firm_rating_131925: '1379526604'
  firm_rating_131985: '1379522049'
  firm_rating_132005: '1379525002'
  firm_rating_1456: '1379523028'
  firm_rating_146831: '1379511204'
  firm_rating_146841: '1379515365'
  firm_rating_146946: '1379519951'
  firm_rating_1495: '1379524749'
  firm_rating_161290: '1379557159'
  firm_rating_18403: '1379498354'
  firm_rating_18407: '1379498428'
  firm_rating_18410: '1379500364'
  firm_rating_18414: '1379507892'
  firm_rating_187442: '1379531640'
  firm_rating_187474: '1379531586'
  firm_rating_187480: '1379537133'
  firm_rating_187507: '1379522017'
  firm_rating_188166: '1379525036'
  firm_rating_188355: '1379522143'
  firm_rating_18865: '1379532629'
  firm_rating_18873: '1379527263'
  firm_rating_18875: '1379527748'
  firm_rating_18880: '1379528353'
  firm_rating_18887: '1379528828'
  firm_rating_18891: '1379532223'
  firm_rating_18902: '1379530293'
  firm_rating_193688: '1379511432'
  firm_rating_198124: '1379539857'
  firm_rating_199676: '1379481965'
  firm_rating_203482: '1379548233'
  firm_rating_204805: '1379488333'
  firm_rating_206891: '1379510116'
  firm_rating_207747: '1379526976'
  firm_rating_212050: '1379512873'
  firm_rating_214502: '1379550733'
  firm_rating_221526: '1379528253'
  firm_rating_225336: '1379551634'
  firm_rating_225351: '1379557649'
  firm_rating_22658: '1379527168'
  firm_rating_22661: '1379527489'
  firm_rating_22724: '1379530088'
  firm_rating_2291: '1379536392'
  firm_rating_2330: '1379532193'
  firm_rating_233049: '1379510526'
  firm_rating_233560: '1379534652'
  firm_rating_233579: '1379528650'
  firm_rating_2340: '1379536362'
  firm_rating_241091: '1379506858'
  firm_rating_250395: '1379519430'
  firm_rating_250478: '1379516555'
  firm_rating_250608: '1379513374'
  firm_rating_250674: '1379509184'
  firm_rating_2582: '1379529884'
  firm_rating_2617: '1379534674'
  firm_rating_265139: '1379516627'
  firm_rating_2668: '1379534894'
  firm_rating_279335: '1379527417'
  firm_rating_281023: '1379489412'
  firm_rating_281791: '1379481654'
  firm_rating_281826: '1379483111'
  firm_rating_282827: '1379485984'
  firm_rating_282832: '1379494704'
  firm_rating_282896: '1379492073'
  firm_rating_28885: '1379482010'
  firm_rating_28888: '1379481884'
  firm_rating_28903: '1379481448'
  firm_rating_28951: '1379481611'
  firm_rating_290933: '1379522081'
  firm_rating_298895: '1379500456'
  firm_rating_301746: '1379539747'
  firm_rating_301775: '1379542853'
  firm_rating_301999: '1379548572'
  firm_rating_310298: '1379539278'
  firm_rating_31226: '1379539055'
  firm_rating_31231: '1379544402'
  firm_rating_31235: '1379546942'
  firm_rating_31239: '1379541168'
  firm_rating_312887: '1379528679'
  firm_rating_312896: '1379530390'
  firm_rating_317474: '1379481247'
  firm_rating_31763: '1379514967'
  firm_rating_338890: '1379500847'
  firm_rating_349944: '1379531616'
  firm_rating_349961: '1379527538'
  firm_rating_350240: '1379529764'
  firm_rating_365763: '1379523559'
  firm_rating_36904: '1379504790'
  firm_rating_36931: '1379500994'
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_110561=1379558224; firm_rating_111482=1379481395; firm_rating_111525=1379481365; firm_rating_118208=1379550239; firm_rating_118223=1379545074; firm_rating_118225=1379540454; firm_rating_119288=1379538092; firm_rating_119290=1379539472; firm_rating_119303=1379538273; firm_rating_119304=1379540708; firm_rating_119314=1379542823; firm_rating_131869=1379531801; firm_rating_131925=1379526604; firm_rating_131985=1379522049; firm_rating_132005=1379525002; firm_rating_1456=1379523028; firm_rating_146831=1379511204; firm_rating_146841=1379515365; firm_rating_146946=1379519951; firm_rating_1495=1379524749; firm_rating_161290=1379557159; firm_rating_18403=1379498354; firm_rating_18407=1379498428; firm_rating_18410=1379500364; firm_rating_18414=1379507892; firm_rating_187442=1379531640; firm_rating_187474=1379531586; firm_rating_187480=1379537133; firm_rating_187507=1379522017; firm_rating_188166=1379525036; firm_rating_188355=1379522143; firm_rating_18865=1379532629; firm_rating_18873=1379527263; firm_rating_18875=1379527748; firm_rating_18880=1379528353; firm_rating_18887=1379528828; firm_rating_18891=1379532223; firm_rating_18902=1379530293; firm_rating_193688=1379511432; firm_rating_198124=1379539857; firm_rating_199676=1379481965; firm_rating_203482=1379548233; firm_rating_204805=1379488333; firm_rating_206891=1379510116; firm_rating_207747=1379526976; firm_rating_212050=1379512873; firm_rating_214502=1379550733; firm_rating_221526=1379528253; firm_rating_225336=1379551634; firm_rating_225351=1379557649; firm_rating_22658=1379527168; firm_rating_22661=1379527489; firm_rating_22724=1379530088; firm_rating_2291=1379536392; firm_rating_2330=1379532193; firm_rating_233049=1379510526; firm_rating_233560=1379534652; firm_rating_233579=1379528650; firm_rating_2340=1379536362; firm_rating_241091=1379506858; firm_rating_250395=1379519430; firm_rating_250478=1379516555; firm_rating_250608=1379513374; firm_rating_250674=1379509184; firm_rating_2582=1379529884; firm_rating_2617=1379534674; firm_rating_265139=1379516627; firm_rating_2668=1379534894; firm_rating_279335=1379527417; firm_rating_281023=1379489412; firm_rating_281791=1379481654; firm_rating_281826=1379483111; firm_rating_282827=1379485984; firm_rating_282832=1379494704; firm_rating_282896=1379492073; firm_rating_28885=1379482010; firm_rating_28888=1379481884; firm_rating_28903=1379481448; firm_rating_28951=1379481611; firm_rating_290933=1379522081; firm_rating_298895=1379500456; firm_rating_301746=1379539747; firm_rating_301775=1379542853; firm_rating_301999=1379548572; firm_rating_310298=1379539278; firm_rating_31226=1379539055; firm_rating_31231=1379544402; firm_rating_31235=1379546942; firm_rating_31239=1379541168; firm_rating_312887=1379528679; firm_rating_312896=1379530390; firm_rating_317474=1379481247; firm_rating_31763=1379514967; firm_rating_338890=1379500847; firm_rating_349944=1379531616; firm_rating_349961=1379527538; firm_rating_350240=1379529764; firm_rating_365763=1379523559; firm_rating_36904=1379504790; firm_rating_36931=1379500994; firm_rating_372812=1379501516; firm_rating_372814=1379505118; firm_rating_374700=1379518198; firm_rating_377668=1379482136; firm_rating_377776=1379547060; firm_rating_377853=1379543928; firm_rating_377869=1379544451; firm_rating_379027=1379533556; firm_rating_380135=1379486606; firm_rating_38027=1379501769; firm_rating_38040=1379535046; firm_rating_380840=1379490565; firm_rating_38110=1379530417; firm_rating_38332=1379526416; firm_rating_38361=1379523529; firm_rating_38879=1379483063; firm_rating_38899=1379481570; firm_rating_38913=1379481755; firm_rating_38931=1379481905; firm_rating_38953=1379482079; firm_rating_38973=1379482108; firm_rating_38986=1379481939; firm_rating_4029=1379525656; firm_rating_42691=1379481421; firm_rating_427=1379531768; firm_rating_433=1379528799; firm_rating_44575=1379481518; firm_rating_450=1379523697; firm_rating_490=1379535401; firm_rating_49860=1379481849; firm_rating_49863=1379481784; firm_rating_49871=1379481989; firm_rating_49932=1379481809; firm_rating_51652=1379526335; firm_rating_51658=1379524634; firm_rating_52127=1379522113; firm_rating_52874=1379502165; firm_rating_53302=1379499051; firm_rating_53363=1379503004; firm_rating_534=1379521983; firm_rating_53911=1379531523; firm_rating_54292=1379546771; firm_rating_54342=1379545223; firm_rating_54371=1379541065; firm_rating_54455=1379548035; firm_rating_61181=1379481271; firm_rating_61619=1379498167; firm_rating_61635=1379507456; firm_rating_61662=1379500394; firm_rating_65477=1379526145; firm_rating_65480=1379523765; firm_rating_65487=1379534056; firm_rating_65489=1379536419; firm_rating_65500=1379524105; firm_rating_6822=1379536448; firm_rating_68246=1379544159; firm_rating_73072=1379538772; firm_rating_73123=1379548551; firm_rating_73159=1379538508; firm_rating_73544=1379481336; firm_rating_73660=1379481313; firm_rating_75288=1379539662; firm_rating_75294=1379543962; firm_rating_75296=1379546715; firm_rating_75299=1379538187; firm_rating_75302=1379540182; firm_rating_78805=1379514929; firm_rating_78812=1379515810; firm_rating_78825=1379513711; firm_rating_78914=1379514819; firm_rating_80796=1379515203; firm_rating_80802=1379516439; firm_rating_80812=1379511128; firm_rating_81518=1379493571; firm_rating_81520=1379495985; firm_rating_84416=1379533802; firm_rating_84519=1379522384; firm_rating_84568=1379531554; firm_rating_84604=1379524836; firm_rating_84611=1379524398; firm_rating_84652=1379528192; firm_rating_85389=1379506807; firm_rating_86338=1379557897; firm_rating_86347=1379552314; firm_rating_86362=1379554711; firm_rating_86442=1379534842; firm_rating_86444=1379533707; firm_rating_88062=1379503776; firm_rating_88067=1379500422; firm_rating_88129=1379503852; firm_rating_91247=1379490709; firm_rating_92504=1379540759; firm_rating_92505=1379543889; firm_rating_92506=1379538243; firm_rating_94065=1379491783; firm_rating_97814=1379481731; firm_rating_97959=1379484665; firm_rating_98175=1379481474; firm_rating_98243=1379481546; firm_rating_98261=1379482032; firm_rating_98420=1379482054; symfony=1rpijatk2vpgcj6ak01ajoe274'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/biznes-treningi_seminary'
  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.207
  HTTP_X_REAL_IP: 207.241.237.207
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /firm/career-solutions
  PATH_TRANSLATED: 'redirect:/index.php/career-solutions'
  PHP_SELF: /frontend.php/firm/career-solutions
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.207
  REMOTE_PORT: '54647'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1379558355
  REQUEST_URI: /frontend.php/firm/career-solutions
  SCRIPT_FILENAME: /var/www/rspravkaru/www/frontend.php
  SCRIPT_NAME: /frontend.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: '[no address given]'
  SERVER_NAME: rspravka.ru
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: "<address>Apache/2.2.16 (Debian) Server at rspravka.ru Port 80</address>\n"
  SERVER_SOFTWARE: 'Apache/2.2.16 (Debian)'
session: {  }

php: 5.3.3-7+squeeze13
os: 'Linux cs8195 2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 x86_64'
extensions:
  - 'Core (5.3.3-7+squeeze13)'
  - 'date (5.3.3-7+squeeze13)'
  - ereg
  - libxml
  - openssl
  - pcre
  - 'zlib (1.1)'
  - bcmath
  - bz2
  - calendar
  - ctype
  - dba
  - 'dom (20031129)'
  - 'hash (1.0)'
  - 'fileinfo (1.0.5-dev)'
  - 'filter (0.11.0)'
  - ftp
  - gettext
  - session
  - iconv
  - 'json (1.2.1)'
  - mbstring
  - 'apc (3.1.3p1)'
  - posix
  - 'Reflection ($Revision: 300393 $)'
  - 'standard (5.3.3-7+squeeze13)'
  - shmop
  - 'SPL (0.2)'
  - soap
  - sockets
  - 'SimpleXML (0.1)'
  - 'exif (1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $)'
  - sysvmsg
  - sysvsem
  - sysvshm
  - 'tokenizer (0.1)'
  - wddx
  - xml
  - 'xmlreader (0.1)'
  - 'xmlwriter (0.1)'
  - 'zip (1.9.1)'
  - apache2handler
  - 'Phar (2.0.1)'
  - gd
  - 'geoip (1.0.7)'
  - mcrypt
  - 'memcache (3.0.4)'
  - 'mysql (1.0)'
  - 'mysqli (0.1)'
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_sqlite (1.0.1)'
  - 'SQLite (2.0-dev)'
  - 'sqlite3 (0.7-dev)'
  - 'suhosin (0.9.32.1)'
  - 'xsl (0.1)'
  - mhash

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

1. SET NAMES 'utf8'
2. SELECT firms.ID, firms.NAME, firms.THUMBNAIL, firms.DESCRIPTION, firms.ADDRESS, firms.PLACE_ID, firms.SUBWAY_STATION_ID, firms.PHONE, firms.FAX, firms.ICQ, firms.SKYPE, firms.SCHEMA, firms.EMAIL, firms.SITE, firms.LOGO, firms.VIEWS_COUNT, firms.FIRM_OWNER_ID, firms.CREATE_DATE, firms.CREATE_DAY, firms.PAGE_TITLE, firms.PAGE_KEYWORDS, firms.PAGE_DESCRIPTION, firms.PRIORITY, firms.ACTIVITY, firms.PRIORITY_RR, firms.DOP_PRIORITY_RR, firms.END_DATE_RR, firms.STATUS_RR, firms.PRIORITY_PR, firms.DOP_PRIORITY_PR, firms.END_DATE_PR, firms.STATUS_PR, firms.PRIORITY_KR, firms.DOP_PRIORITY_KR, firms.END_DATE_KR, firms.STATUS_KR, firms.PRIORITY_S, firms.DOP_PRIORITY_S, firms.END_DATE_S, firms.STATUS_S, firms.OPERATING_SHEDULE_TYPE, firms.SCHEMA_TYPE, firms.UPDATED_AT, firms.LINK_NAME FROM `firms` WHERE firms.LINK_NAME='career-solutions' LIMIT 1
3. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=208982 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
4. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115544 LIMIT 1
5. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115543
6. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115543
7. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID IS NULL
8. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115543
9. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115543
10. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID IS NULL
11. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6
12. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115543
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=115543
14. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID IS NULL
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=115543
16. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115543
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 IS NULL
18. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6
19. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
20. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6
21. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6
22. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738767' LIMIT 1
23. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738767' ORDER BY ip_place.IP_FROM DESC LIMIT 1
24. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738767' AND ip_place.IP_TO>='3488738767'
25. SELECT firms.ID, firms.NAME, firms.THUMBNAIL, firms.DESCRIPTION, firms.ADDRESS, firms.PLACE_ID, firms.SUBWAY_STATION_ID, firms.PHONE, firms.FAX, firms.ICQ, firms.SKYPE, firms.SCHEMA, firms.EMAIL, firms.SITE, firms.LOGO, firms.VIEWS_COUNT, firms.FIRM_OWNER_ID, firms.CREATE_DATE, firms.CREATE_DAY, firms.PAGE_TITLE, firms.PAGE_KEYWORDS, firms.PAGE_DESCRIPTION, firms.PRIORITY, firms.ACTIVITY, firms.PRIORITY_RR, firms.DOP_PRIORITY_RR, firms.END_DATE_RR, firms.STATUS_RR, firms.PRIORITY_PR, firms.DOP_PRIORITY_PR, firms.END_DATE_PR, firms.STATUS_PR, firms.PRIORITY_KR, firms.DOP_PRIORITY_KR, firms.END_DATE_KR, firms.STATUS_KR, firms.PRIORITY_S, firms.DOP_PRIORITY_S, firms.END_DATE_S, firms.STATUS_S, firms.OPERATING_SHEDULE_TYPE, firms.SCHEMA_TYPE, firms.UPDATED_AT, firms.LINK_NAME FROM `firms` WHERE firms.LINK_NAME='career-solutions' LIMIT 1
26. UPDATE firms SET `VIEWS_COUNT`=114, `UPDATED_AT`='2013-09-19 06:39:16' WHERE firms.ID=208982
27. SELECT news.ID, news.PARENT_ID, news.NAME, news.THUMBNAIL, news.DESCRIPTION, news.CREATE_DATE, news.CREATE_DAY, news.PAGE_TITLE, news.PAGE_KEYWORDS, news.PAGE_DESCRIPTION, news.FIRM_ID, news.VISITOR_ID, news.SECURITY_CODE, news.PRIORITY, news.ACTIVITY FROM `news` WHERE news.ACTIVITY>0 AND news.FIRM_ID=208982 ORDER BY news.CREATE_DATE DESC LIMIT 3
28. SELECT operating_shedules.ID, operating_shedules.MONDAY_FROM, operating_shedules.MONDAY_TO, operating_shedules.TUESDAY_FROM, operating_shedules.TUESDAY_TO, operating_shedules.WEDNESDAY_FROM, operating_shedules.WEDNESDAY_TO, operating_shedules.THURSDAY_FROM, operating_shedules.THURSDAY_TO, operating_shedules.FRIDAY_FROM, operating_shedules.FRIDAY_TO, operating_shedules.WEEKDAYS_FROM, operating_shedules.WEEKDAYS_TO, operating_shedules.SATURDAY_FROM, operating_shedules.SATURDAY_TO, operating_shedules.SUNDAY_FROM, operating_shedules.SUNDAY_TO, operating_shedules.FIRM_ID FROM `operating_shedules` WHERE operating_shedules.FIRM_ID=208982 LIMIT 1
29. SELECT payment_methods.ID, payment_methods.NAME, payment_methods.PRIORITY, payment_methods.ACTIVITY FROM `payment_methods`, `firms__payment_methods` WHERE firms__payment_methods.FIRM_ID=208982 AND firms__payment_methods.PAYMENT_METHOD_ID=payment_methods.ID
30. SELECT firm_files.ID, firm_files.NAME, firm_files.FILENAME, firm_files.EXTENSION, firm_files.SIZE, firm_files.DOWNLOADS_COUNT, firm_files.FIRM_ID, firm_files.PRIORITY, firm_files.ACTIVITY FROM `firm_files` WHERE firm_files.ACTIVITY=true AND firm_files.FIRM_ID=208982
31. SELECT price_lists.ID, price_lists.NAME, price_lists.DATE, price_lists.FIRM_ID, price_lists.PRIORITY, price_lists.ACTIVITY FROM `price_lists` WHERE price_lists.FIRM_ID=208982
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=208982 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=115544 LIMIT 1
34. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID=115543
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=115543
36. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ID IS NULL
37. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6
38. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
39. SELECT drive_maps.ID, drive_maps.MAP_FILE, drive_maps.MAP_CODE, drive_maps.FIRM_ID FROM `drive_maps` WHERE drive_maps.FIRM_ID=208982 LIMIT 1
40. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=4
41. SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics`, `firms__rubrics` WHERE firms__rubrics.FIRM_ID=208982 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
42. 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
43. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_TO>='3488738767' LIMIT 1
44. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738767' ORDER BY ip_place.IP_FROM DESC LIMIT 1
45. SELECT ip_place.ID, ip_place.IP_FROM, ip_place.IP_TO, ip_place.PLACE_ID FROM `ip_place` WHERE ip_place.IP_FROM<='3488738767' AND ip_place.IP_TO>='3488738767'
46. SELECT places.ID, places.NAME, places.CODE, places.POSTAL_CODE_ID, places.PLACE_TYPE_ID, places.KLADR_LABEL_ID, places.PARENT_ID, places.COUNTRY_ID, places.IS_AREA_CENTER, places.GEOIP_REGION_CODE, places.GEOIP_CITY_CODE, places.ACTIVITY, places.EMPT FROM `places` WHERE places.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188256 ORDER BY places.NAME ASC
47. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
48. 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
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.ACTIVITY=true AND places.PLACE_TYPE_ID=2 AND places.PARENT_ID=188291 ORDER BY places.NAME ASC
50. 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)
51. 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
52. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (1,51,2)
53. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8155,8156)
54. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (28145,28185,28148,28187,28188,28263,28243,28245,28249,28260,28264)
55. 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
56. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (37572,37596,37573,37598,37603,37589,37599,37600,37602)
57. 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
58. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (38283,38284,38327,38299,38301,38310)
59. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
60. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (42636,42637,42638)
61. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
62. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (430,431,457,448,455,453,432,441,456,442,444,458,454)
63. 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
64. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (43097,43098)
65. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
66. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (44843,44844,44852,44856,44851)
67. 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
68. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (6815,6851,6816)
69. 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
70. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (48088,48089,48114)
71. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
72. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (50728,50730,50783)
73. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
74. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (52458,52459,52461)
75. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
76. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (61110,61111,61476,61475)
77. 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
78. 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)
79. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188335,188336)
80. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181037,181070,181072,181039)
81. 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
82. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (63755,63756)
83. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
84. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10132,10133)
85. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (66981,67008,67054,67029,67058,66995,67060,66982,67090,67066,67067,67069,67077,67078,67084,67089)
86. 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
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.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
88. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188667)
89. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10200,10201)
90. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (69014,69032,69015,69045,69047,69057,69076)
91. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
92. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10421,10447,10506,10422)
93. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (70235,70237,70814)
94. 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
95. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74428)
96. 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
97. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10892,10985,10705)
98. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (11012,11030,11013,11046)
99. 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
100. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74567,74569,74672,74586,74606,74648,74610,74696,74656,74681,74616,74662,74634,74659,74669,74640,74671)
101. 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
102. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (75884,75886,76059)
103. 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
104. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (12236,12252,12279,12308,12332,12365,12238,12395,12419)
105. 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
106. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (81036,81037)
107. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (30027,30100,30125,30146,30028,30179,30210)
108. 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
109. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (32100,32360,32362,32108,32113,32363,32124,32364,32346,32365,32373,32102,32352,32366,32368,32355,32372,32358,32369)
110. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=5 LIMIT 1
111. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (84895,84896,84937)
112. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,86292)
113. 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
114. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (89769,89774)
115. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
116. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (95421,95422)
117. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
118. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199)
119. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13250,13285)
120. 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
121. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (15000,15001)
122. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97312,97319,97390,97397,97324,97325,97327,97328,97353,97354,97393,97356,97362,97365,97366,97368,97392,97391,97371,97372,97375,97376,97396,97380,97381,97401,97383,97387,97389)
123. 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
124. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (105825,105830,105916,105833,105834,105860,105864,105829,105873,105922,105923,105924,105883,105891,105895,105899,105920)
125. 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
126. 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
127. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
128. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (106031,106159,106139,106033,106158)
129. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
130. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,111391)
131. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
132. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (115543,115603,115572,115604,115605,115544,115602,115606)
133. 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
134. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117286)
135. 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
136. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,119261,119270,119236,119280)
137. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
138. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (121215,121737,122109,123001,123094,123373,123545,121485)
139. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
140. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (124340,124349,124341)
141. 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
142. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (125933,125956,125944,126000,126007,126017,126183,126196,126578,126317,126324,125936,126393,126394,126489)
143. 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
144. 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)
145. 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
146. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,130965)
147. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
148. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (140423,140757,140425,140434,140454,140478,140518,140530,140572,140590,140424,140614,140666)
149. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
150. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (143212,143213)
151. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
152. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (146138,146149,146180,146156,146164,146165,146178,146139,146174,146169,146166)
153. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
154. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (147530,147583,147646,147649,147650,147673,147681,147682,147683,147688,147533,147689,147582,147691)
155. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
156. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (16462,16479,16464)
157. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,149752)
158. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (150080,150767,150786,150127,150143,150787,150816,150166,150795,150826,150823,150828,150081,150196,150201,150796,150469,150797,150256,150272,150275,150291,150311,150798,150322,150342,150803,150474,150788,150354,150380,150387,150422,150439,150453,150807,150819,150813,150815)
159. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
160. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17295)
161. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,152958,152985)
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 (35833,36022,36027,35953,35955,35990,35998,36028,36013,36014,35834)
164. 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
165. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (158302,158312,158303,158319,158304,158322,158311,158323)
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 (17558,17559,17669)
168. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=3 LIMIT 1
169. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (160505,160751,160562,160555,160554,160508,160553)
170. SELECT kladr_labels.ID, kladr_labels.CODE, kladr_labels.NAME, kladr_labels.SHORT, kladr_labels.ACTIVITY FROM `kladr_labels` WHERE kladr_labels.ID=6 LIMIT 1
171. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171165,171173,171191,171119)
172. 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
173. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (172125,172184,172126)
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 (21655,21657,21656,21937,21846,22056)
176. 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)
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 COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (22132,22387,22573,22133,23952,24633,22378)
179. 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
180. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178336,178231)
181. 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
182. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (36895,36900,36902,36904,36912,36913,36896)
183. 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
184. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25452)
185. 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
186. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189026,189094,189029,189031,189032,189096,189087,189034,189036,189037,189181,189060,189058,189028,189189)
187. 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
188. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (179428,179478,179499,179516,179527,179538,179552,179604,179646,179653,179656,179673,179657,179430,179669)
189. 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
190. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747)
191. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (26154,26178,26179,26180,26155,26181)
192. 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
193. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493)
194. 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)
195. SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,181922,181921)
196. 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
197. SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
198. 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
199. SELECT firms.ID, firms.NAME, firms.THUMBNAIL, firms.DESCRIPTION, firms.ADDRESS, firms.PLACE_ID, firms.SUBWAY_STATION_ID, firms.PHONE, firms.FAX, firms.ICQ, firms.SKYPE, firms.SCHEMA, firms.EMAIL, firms.SITE, firms.LOGO, firms.VIEWS_COUNT, firms.FIRM_OWNER_ID, firms.CREATE_DATE, firms.CREATE_DAY, firms.PAGE_TITLE, firms.PAGE_KEYWORDS, firms.PAGE_DESCRIPTION, firms.PRIORITY, firms.ACTIVITY, firms.PRIORITY_RR, firms.DOP_PRIORITY_RR, firms.END_DATE_RR, firms.STATUS_RR, firms.PRIORITY_PR, firms.DOP_PRIORITY_PR, firms.END_DATE_PR, firms.STATUS_PR, firms.PRIORITY_KR, firms.DOP_PRIORITY_KR, firms.END_DATE_KR, firms.STATUS_KR, firms.PRIORITY_S, firms.DOP_PRIORITY_S, firms.END_DATE_S, firms.STATUS_S, firms.OPERATING_SHEDULE_TYPE, firms.SCHEMA_TYPE, firms.UPDATED_AT, firms.LINK_NAME FROM `firms` WHERE firms.LINK_NAME='career-solutions' LIMIT 1
200. 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=208982 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
201. 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=903
202. 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=852
203. 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
204. SELECT recommend.ID, recommend.FIRM_ID, recommend.RUBRIC_ID, recommend.PLACE_ID, recommend.HEADER, recommend.URL, recommend.DESCRIPTION, recommend.SPECIAL, recommend.VIEWS_COUNT, recommend.TYPE, recommend.SEARCH, recommend.START_DATE, recommend.END_DATE, recommend.ACTIVITY FROM `recommend` WHERE recommend.ACTIVITY=true AND recommend.RUBRIC_ID IN (904,903,852) AND recommend.START_DATE<='2013-09-19' AND recommend.END_DATE>='2013-09-19' ORDER BY recommend.VIEWS_COUNT DESC LIMIT 5
205. 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
206. 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
207. SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.ACTIVITY>2
208. 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
209. SELECT currency_cources.ID, currency_cources.VALUE, currency_cources.AMOUNT, currency_cources.CURRENCY_ID, currency_cources.BASE_CURRENCY_ID, currency_cources.DATE, currency_cources.ACTIVITY FROM `currency_cources` WHERE currency_cources.DATE<='2013-09-19' ORDER BY currency_cources.DATE DESC LIMIT 1
210. SELECT currency_cources.ID, currency_cources.VALUE, currency_cources.AMOUNT, currency_cources.CURRENCY_ID, currency_cources.BASE_CURRENCY_ID, currency_cources.DATE, currency_cources.ACTIVITY FROM `currency_cources` WHERE currency_cources.ACTIVITY=true AND currency_cources.CURRENCY_ID=1 AND currency_cources.DATE='2013-09-19'
211. 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
212. 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
213. 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
214. SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
215. 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