Рсправка - Рубрика Кафе

Поиск по сайту

Регион поиска:

Все регионы

Вы здесь: Главная » ДОСУГ / РАЗВЛЕЧЕНИЯ » Общественное питание » Кафе

Кафе

Сортировать: по посещаемости | по алфавиту
Отбражать на странице: 20 40 60

Компания Рейтинг

CINNABON

Москва, Земляной Вал ул., д. 29, Курский вокзал
Телефон +7(925) 0353043

Факс: +7(495) 7102021
Web:

Свернуть Добавить
в портфель

Рейтинг: 71

Рубрики: Кафе

СТУДЕНЧЕСКОЕ БИСТРО

Балашиха, Леоновское ш., д. 15
Телефон +7(495) 2210719

Факс: +7(495) 9847408

Свернуть Добавить
в портфель

Рейтинг: 70

Рубрики: Кафе

Big Bull Grill, бар-гриль ООО "Маг-Плюс"

Екатеринбург, Восточная ул. 160
Телефон (343) 254-40-20

Свернуть Добавить
в портфель

Рейтинг: 70

Рубрики: Кафе

Домашний очаг, кафе, ООО

Смоленск, Пржевальского ул. 6/25
Телефон (4812) 38-28-78

Свернуть Добавить
в портфель

Рейтинг: 70

Рубрики: Кафе

Шатры, ООО

Смоленск, г. Ярцево Металлургов пр. 14 а
Телефон (48143) 5-54-13

Свернуть Добавить
в портфель

Рейтинг: 70

Рубрики: Кафе

БАРТОН ПАБ

Красноярск, Газеты "Красноярский рабочий" пр. 160/2 2-й этаж
Телефон +7(391) 236-01-26, +7(391) 269-57-61

Свернуть Добавить
в портфель

Рейтинг: 69

Рубрики: Кафе

ЛУИС

Москва, Шереметьево-2 аэропорт
Телефон +7(495) 5784642

Факс: +7(495) 9564633

Свернуть Добавить
в портфель

Рейтинг: 69

Рубрики: Кафе

Б-7

Санкт-Петербург, Богатырский проспект, д. 7, корп. 1
Телефон +7(812) 394-48-09

Свернуть Добавить
в портфель

Рейтинг: 69

Рубрики: Кафе

БАГИРА

Красноярск, Крупской ул. 1 д
Телефон +7(391) 297-10-70

Свернуть Добавить
в портфель

Рейтинг: 68

Рубрики: Кафе

BLOW UP

Санкт-Петербург, канала Грибоедова набережная, д. 22
Телефон +7(812) 314-58-00

Web:

Свернуть Добавить
в портфель

Рейтинг: 68

Рубрики: Кафе

АДАМС

Санкт-Петербург, Балканская площадь, д. 5, корп. 1
Телефон +7(812) 701-76-92

Свернуть Добавить
в портфель

Рейтинг: 68

Рубрики: Кафе

Трактир, кафе ООО "Колибри"

Ростов-на-Дону, Космонавтов пр. 30/22
Телефон (863) 248-77-08

Свернуть Добавить
в портфель

Рейтинг: 68

Рубрики: Кафе

СЕНСЕЙ

Балашиха, Свердлова ул., д. 16/5
Телефон +7(495) 5853039

Свернуть Добавить
в портфель

Рейтинг: 67

Рубрики: Кафе

У РЕЧКИ

Железнодорожный, Центральная ул., д. 1А
Телефон +7(926) 5611034

Факс: +7(495) 9337714

Свернуть Добавить
в портфель

Рейтинг: 67

Рубрики: Кафе

АМБАР

Красноярск, Карла Маркса ул. 149 РК "Луч" 2-й этаж
Телефон +7(391) 266-83-61

Web:

Свернуть Добавить
в портфель

Рейтинг: 67

Рубрики: Кафе

БАГЕТТЕРИЯ

Москва, Арбат ул., д. 1
Телефон +7(495) 5189925

Факс: +7(495) 6502844
Web:

Свернуть Добавить
в портфель

Рейтинг: 67

Рубрики: Кафе

КАРЕ

Москва, Дмитрия Ульянова ул., д. 42, стр. 1
Телефон +7(495) 1292802

Факс: +7(495) 6999642
Web:

Свернуть Добавить
в портфель

Рейтинг: 67

Рубрики: Кафе

КАПРИЧЧИО

Новосибирск, Ленина пл. 10 а
Телефон +7(383) 229-58-60, +7(383) 218-27-23, +7(383) 292-73-70

Web:

Свернуть Добавить
в портфель

Рейтинг: 66

Рубрики: Кафе

АССОРТИ

Красноярск, Мира пр. 131
Телефон +7(391) 254-51-42

Свернуть Добавить
в портфель

Рейтинг: 66

Рубрики: Кафе

РОБИН БОБИН

Красноярск, Свободный пр. 77 д
Телефон +7(391) 252-18-97

Свернуть Добавить
в портфель

Рейтинг: 66

Рубрики: Кафе

Страницы: 1 2 3 4 5

Response

Settings

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: ' &darr;&nbsp;'
sf_validation_error_suffix: ' &nbsp;&darr;'
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'

Globals

cookie:
  firm_rating_110765: '1379460538'
  firm_rating_110766: '1379461907'
  firm_rating_111454: '1379466930'
  firm_rating_111482: '1379481395'
  firm_rating_111486: '1379465108'
  firm_rating_111525: '1379481365'
  firm_rating_119288: '1379538092'
  firm_rating_119290: '1379539472'
  firm_rating_119303: '1379538273'
  firm_rating_120168: '1379469109'
  firm_rating_120191: '1379463896'
  firm_rating_120204: '1379460910'
  firm_rating_120213: '1379470031'
  firm_rating_131869: '1379531801'
  firm_rating_131925: '1379526604'
  firm_rating_131985: '1379522049'
  firm_rating_132005: '1379525002'
  firm_rating_133064: '1379459383'
  firm_rating_133114: '1379454286'
  firm_rating_133575: '1379454683'
  firm_rating_1456: '1379523028'
  firm_rating_146831: '1379511204'
  firm_rating_146841: '1379515365'
  firm_rating_146946: '1379519951'
  firm_rating_1495: '1379524749'
  firm_rating_168490: '1379454075'
  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_199676: '1379481965'
  firm_rating_202831: '1379459178'
  firm_rating_204805: '1379488333'
  firm_rating_206236: '1379459151'
  firm_rating_206253: '1379456129'
  firm_rating_206300: '1379456946'
  firm_rating_206891: '1379510116'
  firm_rating_207747: '1379526976'
  firm_rating_212050: '1379512873'
  firm_rating_221526: '1379528253'
  firm_rating_22658: '1379527168'
  firm_rating_22661: '1379527489'
  firm_rating_22724: '1379530088'
  firm_rating_227869: '1379463277'
  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_310298: '1379539278'
  firm_rating_31226: '1379539055'
  firm_rating_312887: '1379528679'
  firm_rating_312896: '1379530390'
  firm_rating_317470: '1379464672'
  firm_rating_317474: '1379481247'
  firm_rating_31763: '1379514967'
  firm_rating_327065: '1379468645'
  firm_rating_338890: '1379500847'
  firm_rating_349944: '1379531616'
  firm_rating_349961: '1379527538'
  firm_rating_350240: '1379529764'
  firm_rating_350390: '1379459626'
  firm_rating_365763: '1379523559'
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_110765=1379460538; firm_rating_110766=1379461907; firm_rating_111454=1379466930; firm_rating_111482=1379481395; firm_rating_111486=1379465108; firm_rating_111525=1379481365; firm_rating_119288=1379538092; firm_rating_119290=1379539472; firm_rating_119303=1379538273; firm_rating_120168=1379469109; firm_rating_120191=1379463896; firm_rating_120204=1379460910; firm_rating_120213=1379470031; firm_rating_131869=1379531801; firm_rating_131925=1379526604; firm_rating_131985=1379522049; firm_rating_132005=1379525002; firm_rating_133064=1379459383; firm_rating_133114=1379454286; firm_rating_133575=1379454683; firm_rating_1456=1379523028; firm_rating_146831=1379511204; firm_rating_146841=1379515365; firm_rating_146946=1379519951; firm_rating_1495=1379524749; firm_rating_168490=1379454075; 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_199676=1379481965; firm_rating_202831=1379459178; firm_rating_204805=1379488333; firm_rating_206236=1379459151; firm_rating_206253=1379456129; firm_rating_206300=1379456946; firm_rating_206891=1379510116; firm_rating_207747=1379526976; firm_rating_212050=1379512873; firm_rating_221526=1379528253; firm_rating_22658=1379527168; firm_rating_22661=1379527489; firm_rating_22724=1379530088; firm_rating_227869=1379463277; 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_310298=1379539278; firm_rating_31226=1379539055; firm_rating_312887=1379528679; firm_rating_312896=1379530390; firm_rating_317470=1379464672; firm_rating_317474=1379481247; firm_rating_31763=1379514967; firm_rating_327065=1379468645; firm_rating_338890=1379500847; firm_rating_349944=1379531616; firm_rating_349961=1379527538; firm_rating_350240=1379529764; firm_rating_350390=1379459626; 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_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_42714=1379464641; 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_56889=1379454252; firm_rating_56898=1379456465; firm_rating_60974=1379470011; firm_rating_61091=1379469456; firm_rating_61098=1379460347; firm_rating_61176=1379461504; firm_rating_61181=1379481271; firm_rating_61619=1379498167; firm_rating_61635=1379507456; firm_rating_61662=1379500394; firm_rating_62847=1379458036; 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_73072=1379538772; firm_rating_73159=1379538508; firm_rating_73544=1379481336; firm_rating_73545=1379466183; firm_rating_73660=1379481313; firm_rating_75299=1379538187; 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_86442=1379534842; firm_rating_86444=1379533707; firm_rating_88062=1379503776; firm_rating_88067=1379500422; firm_rating_88129=1379503852; firm_rating_91247=1379490709; 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; firm_rating_99680=1379456100; firm_rating_99746=1379454042; symfony=qfaluc0lh45349q10e74pd1b07'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/kafe'
  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: /rubric/kafe/page/3/
  PATH_TRANSLATED: 'redirect:/index.php/kafe/page/3/'
  PHP_SELF: /frontend.php/rubric/kafe/page/3/
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.207
  REMOTE_PORT: '52762'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1379539627
  REQUEST_URI: /frontend.php/rubric/kafe/page/3/
  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

Logs

#	type	message
1	PatternRouting	Connect sfRoute "homepage" (/)
2	PatternRouting	Connect sfRoute "about" (/about)
3	PatternRouting	Connect sfRoute "akciya" (/akciya)
4	PatternRouting	Connect sfRoute "reklama" (/reklama)
5	PatternRouting	Connect sfRoute "contacts" (/contacts)
6	PatternRouting	Connect sfRoute "site_map" (/site_map)
7	PatternRouting	Connect sfRoute "banner" (/click/:h/)
8	PatternRouting	Connect sfRoute "faq" (/faq)
9	PatternRouting	Connect sfRoute "start" (/start)
10	PatternRouting	Connect sfRoute "search_string" (/search/:search/)
11	PatternRouting	Connect sfRoute "search" (/search/:search/type/:type/order/:order/)
12	PatternRouting	Connect sfRoute "search_page" (/search/:search/type/:type/order/:order/page/:page/)
13	PatternRouting	Connect sfRoute "search_context" (/search-context)
14	PatternRouting	Connect sfRoute "services_postalcodes_zipstreethouse" (/services/zipstreethouse)
15	PatternRouting	Connect sfRoute "services_phonecodes" (/services/phone_codes)
16	PatternRouting	Connect sfRoute "services_currencygraph" (/services/currencygraph)
17	PatternRouting	Connect sfRoute "services_update_currency_course" (/services/updateCurrencyCourse)
18	PatternRouting	Connect sfRoute "services_export_barcode" (/services/export_barcode)
19	PatternRouting	Connect sfRoute "rss_news" (/news/rss.:sf_format)
20	PatternRouting	Connect sfRoute "rss_exhibitions" (/exhibitions/rss.:sf_format)
21	PatternRouting	Connect sfRoute "services_code" (/services/:code)
22	PatternRouting	Connect sfRoute "services_all" (/services/)
23	PatternRouting	Connect sfRoute "services_interesno" (/services/:code/interesno/:id)
24	PatternRouting	Connect sfRoute "services" (/services/:code/:action/:page)
25	PatternRouting	Connect sfRoute "exhibitions_new" (/exhibitions/new)
26	PatternRouting	Connect sfRoute "exhibitions" (/exhibitions/:id/:action)
27	PatternRouting	Connect sfRoute "exhibitions_all" (/exhibitions)
28	PatternRouting	Connect sfRoute "articles" (/articles/:code/:action)
29	PatternRouting	Connect sfRoute "news_new" (/news/new/:id)
30	PatternRouting	Connect sfRoute "news_ok" (/news/ok)
31	PatternRouting	Connect sfRoute "news_list_pager" (/news/page/:page)
32	PatternRouting	Connect sfRoute "news_list" (/news)
33	PatternRouting	Connect sfRoute "news" (/news/:id)
34	PatternRouting	Connect sfRoute "registration" (/registration)
35	PatternRouting	Connect sfRoute "rubric_page" (/rubric/:id/page/:page/)
36	PatternRouting	Connect sfRoute "rubric_sorting" (/rubric/:id/sort/:sort/)
37	PatternRouting	Connect sfRoute "rubric_size" (/rubric/:id/size/:size/)
38	PatternRouting	Connect sfRoute "rubric" (/rubric/:id)
39	PatternRouting	Connect sfRoute "firm_add" (/firm/new)
40	PatternRouting	Connect sfRoute "logout" (/logout)
41	PatternRouting	Connect sfRoute "firm" (/firm/:id)
42	PatternRouting	Connect sfRoute "firm_edit_success" (/firm/:id/edit/success/:success)
43	PatternRouting	Connect sfRoute "firm_edit" (/firm/:id/edit)
44	PatternRouting	Connect sfRoute "firm_print_map" (/firm/:id/print/map)
45	PatternRouting	Connect sfRoute "firm_print" (/firm/:id/print)
46	PatternRouting	Connect sfRoute "firm_name" (/:name)
47	PatternRouting	Connect sfRoute "default_index" (/:module)
48	PatternRouting	Connect sfRoute "default" (/:module/:action/*)
49	PatternRouting	Match route "rubric_page" (/rubric/:id/page/:page/) for /rubric/kafe/page/3/ with parameters array ( 'module' => 'default', 'action' => 'rubric', 'id' => 'kafe', 'page' => '3',)
50	FilterChain	Executing filter "sfRenderingFilter"
51	FilterChain	Executing filter "sfCommonFilter"
52	FilterChain	Executing filter "sfExecutionFilter"
53	PHPView	Set component "services_top" (services/servicesTop)
54	PHPView	Set component "messages_top" (default/messagesTop)
55	PHPView	Set component "about" (default/about)
56	PHPView	Set component "control_menu" (default/controlMenu)
57	PHPView	Set component "references" (default/references)
58	PHPView	Set component "firms_search" (search/firmsSearch)
59	PHPView	Set component "rubrics_tree" (default/rubricsTree)
60	PHPView	Set component "footer" (default/footer)
61	PHPView	Set component "statistic" (default/statistic)
62	PHPView	Set component "news" (news/news)
63	PHPView	Set component "news_top" (news/newsTop)
64	PHPView	Set component "recommend" (news/recommend)
65	PHPView	Set component "rubrics_search" (default/rubricsSearch)
66	PHPView	Set component "rubrics" (default/rubrics)
67	PHPView	Set component "currencies" (currencies/currencies)
68	PHPView	Set component "global_search" (search/siteSearch)
69	PHPView	Set component "detail_rubrics" (default/detailRubrics)
70	PHPView	Set component "briefcase" (default/briefcase)
71	PHPView	Set component "personal" (default/personal)
72	PHPView	Set component "rubric" (default/rubric)
73	PHPView	Set component "pager" (default/pager)
74	PHPView	Set component "pager_sphinx" (default/pagerSphinx)
75	PHPView	Set component "article" (articles/article)
76	PHPView	Set component "main_menu" (articles/mainMenu)
77	PHPView	Set component "services_list" (articles/servicesList)
78	PHPView	Set component "exhibitions_top" (exhibitions/exhibitionsTop)
79	PHPView	Set component "exhibition_thumbnail" (exhibitions/exhibitionThumbnail)
80	PHPView	Set component "firm" (default/firm)
81	PHPView	Set component "carousel" (personal/carousel)
82	PHPView	Set component "firmDigest" (default/firmDigest)
83	PHPView	Set component "firms_list_control" (default/firmsListControl)
84	PHPView	Set component "firms_list_item" (default/firmsListItem)
85	PHPView	Set component "firm_contacts" (default/firmContacts)
86	PHPView	Set component "firm_control" (default/firmControl)
87	PHPView	Set component "pager_price_list" (default/pagerPriceList)
88	PHPView	Set component "price_list" (default/priceList)
89	PHPView	Render "sf_app_dir/modules/default/templates/rubricSuccess.php"
90	main	Call "default->execute()"
91	PartialView	Render "sf_app_dir/modules/default/templates/_rubric.php"
92	main	Call "default->execute()"
93	PartialView	Render "sf_app_dir/modules/default/templates/_pager.php"
94	PHPView	Decorate content with "sf_app_dir/templates/firm-list.php"
95	PHPView	Render "sf_app_dir/templates/firm-list.php"
96	main	Call "default->execute()"
97	PartialView	Render "sf_app_dir/modules/default/templates/_about.php"
98	main	Call "default->execute()"
99	PartialView	Render "sf_app_dir/modules/default/templates/_controlMenu.php"
100	main	Call "search->execute()"
101	PartialView	Render "sf_app_dir/modules/search/templates/_siteSearch.php"
102	main	Call "default->execute()"
103	PartialView	Render "sf_app_dir/modules/default/templates/_statistic.php"
104	main	Call "news->execute()"
105	PartialView	Render "sf_app_dir/modules/news/templates/_recommend.php"
106	main	Call "default->execute()"
107	PartialView	Render "sf_app_dir/modules/default/templates/_rubricsTree.php"
108	main	Call "currencies->execute()"
109	PartialView	Render "sf_app_dir/modules/currencies/templates/_currencies.php"
110	main	Call "default->execute()"
111	PartialView	Render "sf_app_dir/modules/default/templates/_personal.php"
112	main	Get slot "firm-left"
113	main	Get slot "full-search-left"
114	main	Call "default->execute()"
115	PartialView	Render "sf_app_dir/modules/default/templates/_footer.php"
116	PartialView	Render "sf_app_dir/modules/personal/templates/_login.php"
117	WebResponse	Send status "HTTP/1.0 200 OK"
118	WebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	21	1.96	0
Action "default/rubric"	1	9.37	1
View "Success" for "default/rubric"	1	858.73	92
Component "default/rubric"	1	440.93	47
Partial "default/_rubric"	1	57.63	6
Component "default/pager"	1	0.06	0
Partial "default/_pager"	1	1.84	0
Component "default/about"	1	4.63	0
Partial "default/_about"	1	1.83	0
Component "default/controlMenu"	1	0.53	0
Partial "default/_controlMenu"	1	0.17	0
Component "search/siteSearch"	1	6.68	0
Partial "search/_siteSearch"	1	292.61	31
Component "default/statistic"	1	0.91	0
Partial "default/_statistic"	1	0.20	0
Component "news/recommend"	1	5.12	0
Partial "news/_recommend"	1	0.24	0
Component "default/rubricsTree"	1	6.02	0
Partial "default/_rubricsTree"	1	1.01	0
Component "currencies/currencies"	1	9.10	0
Partial "currencies/_currencies"	1	0.77	0
Component "default/personal"	1	4.85	0
Partial "default/_personal"	1	2.82	0
Component "default/footer"	1	2.80	0
Partial "default/_footer"	1	1.42	0
Partial "personal/_login"	1	0.20	0

SET NAMES 'utf8'
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='kafe' LIMIT 1
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=581
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=558
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='kafe' LIMIT 1
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=581
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=558
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
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 (589) 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
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
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
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'
SELECT COUNT(*) FROM `firms__rubrics`, `firms` WHERE firms__rubrics.RUBRIC_ID IN (589) AND firms.ACTIVITY=true AND firms.ID IN (377786,377821,31239,377788,377853,377806,377869,214498,214502,31235,377776,31226,31230,31233,335128,31231,31234,31238,356618,377838,31223,214467,335198,356750,356648,377800,31224,252122,284491,214410,284479,377845,31229,368624,377777,377778,214406,31232,240558,377819,252189,31227,356509,377766,377870,240561,252047,284427,240559,284409,284453,335239,31222,31228,240552,252035,252100,214452,240556,240665,252242,284503,377785,31236,252017,284528,356571,31225,214483,251971,284416,284437,335244,356507,356535,377833,214426,377728,214416,220826,240564,252098,284496,368643,377842,214408,240580,251904,252085,252106,335178,377736,377747,377751,377764,377872,214400,240700,251976,252222,284467,284468,284480,335208,368776,240646,252154,284400,284497,335132,335135,335264,356594,377844,214450,240620,252041,252131,252194,284389,284478,335093,335142,335164,335263,356562,377741,377814,377847,214393,214403,214412,214511,240585,251936,284527,335059,335071,335078,335160,356780,377805,214439,214491,240550,252049,252092,252093,284404,284410,284498,284507,335061,335075,335259,356560,377765,214404,214413,240548,240669,252051,252070,252197,284398,284442,284470,284486,284526,335131,356510,356557,368685,377848,220822,240592,251928,252095,252096,252099,335082,356647,356786,356789,377850,240630,251988,252000,252036,284411,284471,284500,284521,284531,335049,335055,335187,335252,356558,368702,377735,214415,214444,214461,240531,251912,251915,252074,252160,252172,252198,284393,284394,284469,284475,335058,335094,356514,356542,356563,356595,377718,377867,214417,214419,214453,214562,240533,240616,240698,251878,251953,252007,252019,252037,252124,252156,284386,284524,284529,335085,335220,335224,368640,368672,377729,377738,377864,214447,214466,214525,214556,240577,240582,240603,251881,251931,252121,252147,335050,335124,335209,335250,356564,368649,377839,377849,377860,214460,214465,214514,214554,240534,240691,251888,284388,335076,377775,377794,214442,214463,240612,240649,240713,251985,252193,335174,356603,356607,356619,356642,356790,377831,214462,214469,214523,214543,240553,251929,252031,284451,335129,335144,335222,356559,356596,368689,377823,240618,240625,252004,252033,252241,284499,284525,335134,335152,335172,335234,335235,356725,368725,377732,377804,377812,214420,214567,251920,251932,251948,251962,251968,251991,252089,252249,335155,335177,356569,356669,356698,356792,377796,377815,377826,240579,240611,240652,240703,251883,251886,251887,251937,251981,251984,252030,252072,252113,252203,284369,284448,356555,356597,356640,356756,356762,356772,356794,377795,377841,214421,240599,240657,240677,240680,240681,251935,251990,252223,284418,335140,335162,335249,356512,356513,356611,356653,368697,377746,377748,377856,377863,31237,214434,214559,240574,240598,240615,240619,240623,252136,252211,252235,252252,252256,252257,335161,335242,335258,356581,356715,368656,368690,368739,377783,377803,377846,377859,377862,214418,214479,214542,214568,240541,240542,240626,240688,251884,251899,251902,251975,251987,251994,252013,252078,252226,252236,284462,284492,335149,335189,335190,368637,368695,368740,377726,377733,377745,377756,377793,214411,214435,214520,214540,214566,240583,240614,240629,240638,240650,240658,240697,240711,251974,252108,252109,252111,252117,252118,252139,252188,252190,252208,252253,284374,284375,284377,284384,284397,284417,284420,284434,284436,284438,284464,284465,284494,284504,284505,335062,335096,335119,335240,356633,356736,368632,368636,368693,377827,377871,379862,214407,214414,214451,221682,240537,240540,240544,240566,240572,240601,240609,240621,240624,240628,240654,240664,240671,240672,240678,240687,240705,240710,251901,251908,251941,251952,251960,252024,252046,252137,252152,252153,252169,252214,252233,252240,284396,284408,284413,284443,284461,284473,284481,284488,284515,284516,284517,284520,284522,335077,335080,335088,335092,335102,335115,335150,335159,335212,335243,335245,335257,356694,356707,356730,356788,368667,368701,368710,377753,377755,377763,377816,377817,377820,377837,377840,214398,214399,214459,214478,214485,214493,214495,214506,214510,214526,214539,220823,240536,240539,240543,240562,240565,240575,240578,240600,240634,240670,240684,251914,251942,251957,251961,251998,252003,252008,252055,252059,252065,252066,252090,252123,252125,252130,252158,252199,252201,252202,252218,252246,284383,284390,284403,284406,284422,284426,284432,284459,284463,284472,284485,284489,284509,335051,335107,335138,335148,335251,356556,356634,356710,356735,356749,356768,368631,368638,368644,368654,368679,368715,368757,368761,368778,377723,377757,377774,377790,377834,377868,377877,214401,214409,214422,214429,214432,214487,214499,214517,214545,214560,214564,214565,214569,240569,240594,240604,240606,240608,240640,240645,240655,240660,240679,251893,251906,251944,251959,251972,251986,252009,252011,252052,252057,252058,252077,252168,252206,252217,252248,284391,284415,284449,284455,284484,284512,284513,284533,335143,335173,335193,335195,335210,356593,356674,356678,356783,368661,368741,368765,368774,377743,377836,377875,214395,214405,214437,214488,214527,214553,240554,240588,240663,240702,251919,251978,251982,251989,251997,251999,252001,252023,252028,252038,252056,252087,252112,252128,252132,252138,252161,252166,252180,252195,252219,284376,284380,284395,284401,284431,284450,284456,284490,284519,335146,335182,335202,335211,356631,356677,368635,368686,368692,368696,368713,368720,368753,368759,368760,368762,377737,377740,377752,377771,377779,377781,377787,377798,377807,377813,377832,377874,214402,214433,214446,214472,214473,214490,214496,214505,214521,214551,214558,240530,240555,240587,240597,240605,240607,240622,240631,240637,240639,240690,240694,251891,251916,251922,251956,251979,252025,252048,252103,252107,252157,252164,252171,252239,252255,284372,284412,284419,284445,284447,284476,284483,284487,284495,284530,284532,335048,335063,335113,335153,335168,335192,335194,335204,335213,335231,356570,356612,356622,356626,356665,356720,356748,356791,368630,368647,368648,368663,368680,368712,368719,368749,368763,377727,377731,377767,377769,377770,377780,377822,377851,377866,214424,214458,214468,214492,214501,214507,214508,214512,214513,214538,214557,240560,240586,240613,240642,240673,240695,251879,251882,251889,251895,251911,251924,251933,251943,251954,251969,251973,252012,252029,252039,252076,252079,252094,252102,252140,252178,252192,252213,252220,252221,252243,252244,252251,284387,284441,284446,284457,284460,284474,284493,335054,335056,335070,335074,335126,335130,335176,335196,335219,335227,335238,335261,356518,356545,356551,356649,356719,356728,356774,356796,368628,368669,368670,368699,368718,368721,368726,368731,368733,368754,368764,368780,377720,377722,377750,377758,377761,377762,377782,377784,377791,377824,377825,377873,214423,214436,214438,214443,214470,214471,214477,214500,214549,240535,240568,240593,240632,240641,240644,240666,240685,240699,240707,251880,251897,251903,251909,251921,251963,251970,251977,251995,252026,252034,252040,252042,252064,252114,252115,252126,252127,252185,252187,252200,252207,252210,252216,252225,252245,252247,284370,284371,284392,284402,284407,284414,284421,284424,284425,284428,284429,284454,284458,284466,284502,284506,284523,335053,335060,335064,335066,335079,335083,335103,335111,335116,335123,335127,335136,335141,335156,335158,335165,335169,335185,335200,335207,335215,335255,356503,356530,356546,356548,356550,356630,356644,356659,356676,356691,356702,356732,356784,368641,368651,368657,368668,368676,368688,368694,368700,368747,368756,368775,377721,377724,377725,377730,377739,377773,377802,377811,377857,214397,214441,214454,214474,214475,214504,214518,214537,214544,214552,220824,220825,240538,240648,240662,240667,240675,240692,240708,240712,251885,251896,251930,251951,251955,251965,251967,251996,252005,252018,252044,252050,252053,252063,252073,252083,252084,252097,252120,252146,252167,252173,252259,284379,284382,284385,284405,284430,284435,284440,284444,284510,284514,335087,335099,335104,335110,335114,335125,335147,335232,335233,335247,335256,356566,356598,356602,356620,356623,356629,356652,356656,356687,356716,356744,356766,368634,368639,368664,368677,368687,368716,368727,368736,368781,377734,377808,377818,377829,377830,377855,214476,214497,214528,214535,240546,240563,240636,240647,240683,251898,251905,251925,251940,252010,252020,252022,252062,252080,252091,252105,252119,252150,252151,252155,252170,252176,252183,252184,252196,252205,252212,252229,252238,252254,252260,284399,284423,284452,335081,335098,335100,335101,335122,335133,335139,335154,335157,335167,335180,335181,335199,335203,335205,335223,335229,335266,356522,356533,356537,356565,356576,356601,356604,356610,356627,356646,356668,356670,356697,356699,356713,356723,356724,356734,356737,356751,356769,368653,368659,368662,368673,368675,368703,368705,368709,368738,368745,368748,368779,377759,377792,377801,377828,377861,214394,214425,214445,214457,214464,214484,214494,214503,214522,214532,240545,240547,240590,240653,240689,251890,251910,251950,251983,251992,251993,252014,252015,252061,252075,252081,252134,252149,252163,252165,252177,252181,252182,252230,252234,252250,284501,335052,335072,335097,335117,335120,335137,335179,335186,335191,335206,335260,335265,356505,356521,356523,356541,356568,356586,356587,356592,356608,356613,356636,356641,356664,356693,356712,356731,356755,356758,368629,368645,368660,368665,368671,368706,368714,368717,368734,368755,368772,377744,377749,377789,377797,377876,214440,214448,240549,240557,240596,240602,240627,240676,251892,251917,251926,251945,251958,251980,252027,252043,252068,252082,252086,252104,252143,252145,252162,252175,252191,252215,252237,284373,284381,284477,284508,335068,335069,335073,335105,335108,335118,335145,335183,335197,335216,335218,335221,335228,335246,335253,335254,335267,356534,356536,356561,356615,356617,356621,356632,356639,356654,356689,356695,356709,356727,356738,356757,356764,356770,356787,356795,368691,368698,368704,368743,368750,368751,368767,368771,368773,368777,377799,214430,214531,214541,214546,214547,214548,240570,240584,251907,251938,251939,251946,251966,252002,252016,252032,252054,252067,252069,252088,252110,252116,252133,252148,252174,252179,252204,252232,252258,284433,284482,335057,335065,335090,335091,335163,335171,335262,356519,356525,356529,356552,356554,356577,356580,356588,356589,356624,356635,356637,356650,356673,356675,356700,356703,356740,356763,356775,356778,356785,368626,368735,368746,368752,368770,377754,377760,377768,377835,377854,377858,214449,214456,214519,214530,240591,240610,240674,240693,251947,252060,252129,252144,252186,335095,335112,335121,335225,335226,335230,356504,356584,356606,356609,356625,356643,356645,356660,356661,356679,356680,356682,356692,356705,356708,356718,356726,356733,356771,356793,368655,368666,368682,368707,368742,368768,368769,377719,377772,377810,377852,377865,214480,214516,214533,214534,214536,214563,220827,240571,240573,240633,240696,240704,240709,251927,252021,252159,252227,284511,335067,335089,335151,335166,335175,335184,335188,335201,335217,335236,335237,335248,356524,356532,356540,356544,356574,356579,356583,356599,356616,356628,356657,356658,356667,356683,356701,356704,356706,356714,356717,356721,356729,356745,356773,368633,368652,368681,368711,368722,368729,368744,214481,214509,214529,240567,240595,240668,240682,252224,252228,252231,284439,284518,335084,335106,335214,335241,356508,356520,356538,356539,356543,356547,356553,356573,356575,356582,356591,356651,356655,356681,356741,356747,356752,356760,356765,368658,368683,368728,368730,368732,377742,377809,214428,240581,240635,240651,240656,251923,356506,356515,356526,356528,356531,356549,356567,356600,356614,356663,356711,356739,356742,356743,356753,356754,356781,368646,368650,368674,368723,368766,214431,240551,240589,240659,240686,252141,335086,335170,356511,356516,356517,356527,356572,356578,356585,356605,356666,356672,356696,356722,356746,356759,356761,356776,368627,368642,368678,368684,368724,368758,214482,240706,335109,356590,356638,356671,356685,356686,356782,368708,368737,214550,356767,356777,368625,377843,214489,284378,356662,356684,356688,356690,356779,380218,28178) AND firms__rubrics.FIRM_ID=firms.ID
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 (589) AND firms.ACTIVITY=true AND firms.ID IN (377786,377821,31239,377788,377853,377806,377869,214498,214502,31235,377776,31226,31230,31233,335128,31231,31234,31238,356618,377838,31223,214467,335198,356750,356648,377800,31224,252122,284491,214410,284479,377845,31229,368624,377777,377778,214406,31232,240558,377819,252189,31227,356509,377766,377870,240561,252047,284427,240559,284409,284453,335239,31222,31228,240552,252035,252100,214452,240556,240665,252242,284503,377785,31236,252017,284528,356571,31225,214483,251971,284416,284437,335244,356507,356535,377833,214426,377728,214416,220826,240564,252098,284496,368643,377842,214408,240580,251904,252085,252106,335178,377736,377747,377751,377764,377872,214400,240700,251976,252222,284467,284468,284480,335208,368776,240646,252154,284400,284497,335132,335135,335264,356594,377844,214450,240620,252041,252131,252194,284389,284478,335093,335142,335164,335263,356562,377741,377814,377847,214393,214403,214412,214511,240585,251936,284527,335059,335071,335078,335160,356780,377805,214439,214491,240550,252049,252092,252093,284404,284410,284498,284507,335061,335075,335259,356560,377765,214404,214413,240548,240669,252051,252070,252197,284398,284442,284470,284486,284526,335131,356510,356557,368685,377848,220822,240592,251928,252095,252096,252099,335082,356647,356786,356789,377850,240630,251988,252000,252036,284411,284471,284500,284521,284531,335049,335055,335187,335252,356558,368702,377735,214415,214444,214461,240531,251912,251915,252074,252160,252172,252198,284393,284394,284469,284475,335058,335094,356514,356542,356563,356595,377718,377867,214417,214419,214453,214562,240533,240616,240698,251878,251953,252007,252019,252037,252124,252156,284386,284524,284529,335085,335220,335224,368640,368672,377729,377738,377864,214447,214466,214525,214556,240577,240582,240603,251881,251931,252121,252147,335050,335124,335209,335250,356564,368649,377839,377849,377860,214460,214465,214514,214554,240534,240691,251888,284388,335076,377775,377794,214442,214463,240612,240649,240713,251985,252193,335174,356603,356607,356619,356642,356790,377831,214462,214469,214523,214543,240553,251929,252031,284451,335129,335144,335222,356559,356596,368689,377823,240618,240625,252004,252033,252241,284499,284525,335134,335152,335172,335234,335235,356725,368725,377732,377804,377812,214420,214567,251920,251932,251948,251962,251968,251991,252089,252249,335155,335177,356569,356669,356698,356792,377796,377815,377826,240579,240611,240652,240703,251883,251886,251887,251937,251981,251984,252030,252072,252113,252203,284369,284448,356555,356597,356640,356756,356762,356772,356794,377795,377841,214421,240599,240657,240677,240680,240681,251935,251990,252223,284418,335140,335162,335249,356512,356513,356611,356653,368697,377746,377748,377856,377863,31237,214434,214559,240574,240598,240615,240619,240623,252136,252211,252235,252252,252256,252257,335161,335242,335258,356581,356715,368656,368690,368739,377783,377803,377846,377859,377862,214418,214479,214542,214568,240541,240542,240626,240688,251884,251899,251902,251975,251987,251994,252013,252078,252226,252236,284462,284492,335149,335189,335190,368637,368695,368740,377726,377733,377745,377756,377793,214411,214435,214520,214540,214566,240583,240614,240629,240638,240650,240658,240697,240711,251974,252108,252109,252111,252117,252118,252139,252188,252190,252208,252253,284374,284375,284377,284384,284397,284417,284420,284434,284436,284438,284464,284465,284494,284504,284505,335062,335096,335119,335240,356633,356736,368632,368636,368693,377827,377871,379862,214407,214414,214451,221682,240537,240540,240544,240566,240572,240601,240609,240621,240624,240628,240654,240664,240671,240672,240678,240687,240705,240710,251901,251908,251941,251952,251960,252024,252046,252137,252152,252153,252169,252214,252233,252240,284396,284408,284413,284443,284461,284473,284481,284488,284515,284516,284517,284520,284522,335077,335080,335088,335092,335102,335115,335150,335159,335212,335243,335245,335257,356694,356707,356730,356788,368667,368701,368710,377753,377755,377763,377816,377817,377820,377837,377840,214398,214399,214459,214478,214485,214493,214495,214506,214510,214526,214539,220823,240536,240539,240543,240562,240565,240575,240578,240600,240634,240670,240684,251914,251942,251957,251961,251998,252003,252008,252055,252059,252065,252066,252090,252123,252125,252130,252158,252199,252201,252202,252218,252246,284383,284390,284403,284406,284422,284426,284432,284459,284463,284472,284485,284489,284509,335051,335107,335138,335148,335251,356556,356634,356710,356735,356749,356768,368631,368638,368644,368654,368679,368715,368757,368761,368778,377723,377757,377774,377790,377834,377868,377877,214401,214409,214422,214429,214432,214487,214499,214517,214545,214560,214564,214565,214569,240569,240594,240604,240606,240608,240640,240645,240655,240660,240679,251893,251906,251944,251959,251972,251986,252009,252011,252052,252057,252058,252077,252168,252206,252217,252248,284391,284415,284449,284455,284484,284512,284513,284533,335143,335173,335193,335195,335210,356593,356674,356678,356783,368661,368741,368765,368774,377743,377836,377875,214395,214405,214437,214488,214527,214553,240554,240588,240663,240702,251919,251978,251982,251989,251997,251999,252001,252023,252028,252038,252056,252087,252112,252128,252132,252138,252161,252166,252180,252195,252219,284376,284380,284395,284401,284431,284450,284456,284490,284519,335146,335182,335202,335211,356631,356677,368635,368686,368692,368696,368713,368720,368753,368759,368760,368762,377737,377740,377752,377771,377779,377781,377787,377798,377807,377813,377832,377874,214402,214433,214446,214472,214473,214490,214496,214505,214521,214551,214558,240530,240555,240587,240597,240605,240607,240622,240631,240637,240639,240690,240694,251891,251916,251922,251956,251979,252025,252048,252103,252107,252157,252164,252171,252239,252255,284372,284412,284419,284445,284447,284476,284483,284487,284495,284530,284532,335048,335063,335113,335153,335168,335192,335194,335204,335213,335231,356570,356612,356622,356626,356665,356720,356748,356791,368630,368647,368648,368663,368680,368712,368719,368749,368763,377727,377731,377767,377769,377770,377780,377822,377851,377866,214424,214458,214468,214492,214501,214507,214508,214512,214513,214538,214557,240560,240586,240613,240642,240673,240695,251879,251882,251889,251895,251911,251924,251933,251943,251954,251969,251973,252012,252029,252039,252076,252079,252094,252102,252140,252178,252192,252213,252220,252221,252243,252244,252251,284387,284441,284446,284457,284460,284474,284493,335054,335056,335070,335074,335126,335130,335176,335196,335219,335227,335238,335261,356518,356545,356551,356649,356719,356728,356774,356796,368628,368669,368670,368699,368718,368721,368726,368731,368733,368754,368764,368780,377720,377722,377750,377758,377761,377762,377782,377784,377791,377824,377825,377873,214423,214436,214438,214443,214470,214471,214477,214500,214549,240535,240568,240593,240632,240641,240644,240666,240685,240699,240707,251880,251897,251903,251909,251921,251963,251970,251977,251995,252026,252034,252040,252042,252064,252114,252115,252126,252127,252185,252187,252200,252207,252210,252216,252225,252245,252247,284370,284371,284392,284402,284407,284414,284421,284424,284425,284428,284429,284454,284458,284466,284502,284506,284523,335053,335060,335064,335066,335079,335083,335103,335111,335116,335123,335127,335136,335141,335156,335158,335165,335169,335185,335200,335207,335215,335255,356503,356530,356546,356548,356550,356630,356644,356659,356676,356691,356702,356732,356784,368641,368651,368657,368668,368676,368688,368694,368700,368747,368756,368775,377721,377724,377725,377730,377739,377773,377802,377811,377857,214397,214441,214454,214474,214475,214504,214518,214537,214544,214552,220824,220825,240538,240648,240662,240667,240675,240692,240708,240712,251885,251896,251930,251951,251955,251965,251967,251996,252005,252018,252044,252050,252053,252063,252073,252083,252084,252097,252120,252146,252167,252173,252259,284379,284382,284385,284405,284430,284435,284440,284444,284510,284514,335087,335099,335104,335110,335114,335125,335147,335232,335233,335247,335256,356566,356598,356602,356620,356623,356629,356652,356656,356687,356716,356744,356766,368634,368639,368664,368677,368687,368716,368727,368736,368781,377734,377808,377818,377829,377830,377855,214476,214497,214528,214535,240546,240563,240636,240647,240683,251898,251905,251925,251940,252010,252020,252022,252062,252080,252091,252105,252119,252150,252151,252155,252170,252176,252183,252184,252196,252205,252212,252229,252238,252254,252260,284399,284423,284452,335081,335098,335100,335101,335122,335133,335139,335154,335157,335167,335180,335181,335199,335203,335205,335223,335229,335266,356522,356533,356537,356565,356576,356601,356604,356610,356627,356646,356668,356670,356697,356699,356713,356723,356724,356734,356737,356751,356769,368653,368659,368662,368673,368675,368703,368705,368709,368738,368745,368748,368779,377759,377792,377801,377828,377861,214394,214425,214445,214457,214464,214484,214494,214503,214522,214532,240545,240547,240590,240653,240689,251890,251910,251950,251983,251992,251993,252014,252015,252061,252075,252081,252134,252149,252163,252165,252177,252181,252182,252230,252234,252250,284501,335052,335072,335097,335117,335120,335137,335179,335186,335191,335206,335260,335265,356505,356521,356523,356541,356568,356586,356587,356592,356608,356613,356636,356641,356664,356693,356712,356731,356755,356758,368629,368645,368660,368665,368671,368706,368714,368717,368734,368755,368772,377744,377749,377789,377797,377876,214440,214448,240549,240557,240596,240602,240627,240676,251892,251917,251926,251945,251958,251980,252027,252043,252068,252082,252086,252104,252143,252145,252162,252175,252191,252215,252237,284373,284381,284477,284508,335068,335069,335073,335105,335108,335118,335145,335183,335197,335216,335218,335221,335228,335246,335253,335254,335267,356534,356536,356561,356615,356617,356621,356632,356639,356654,356689,356695,356709,356727,356738,356757,356764,356770,356787,356795,368691,368698,368704,368743,368750,368751,368767,368771,368773,368777,377799,214430,214531,214541,214546,214547,214548,240570,240584,251907,251938,251939,251946,251966,252002,252016,252032,252054,252067,252069,252088,252110,252116,252133,252148,252174,252179,252204,252232,252258,284433,284482,335057,335065,335090,335091,335163,335171,335262,356519,356525,356529,356552,356554,356577,356580,356588,356589,356624,356635,356637,356650,356673,356675,356700,356703,356740,356763,356775,356778,356785,368626,368735,368746,368752,368770,377754,377760,377768,377835,377854,377858,214449,214456,214519,214530,240591,240610,240674,240693,251947,252060,252129,252144,252186,335095,335112,335121,335225,335226,335230,356504,356584,356606,356609,356625,356643,356645,356660,356661,356679,356680,356682,356692,356705,356708,356718,356726,356733,356771,356793,368655,368666,368682,368707,368742,368768,368769,377719,377772,377810,377852,377865,214480,214516,214533,214534,214536,214563,220827,240571,240573,240633,240696,240704,240709,251927,252021,252159,252227,284511,335067,335089,335151,335166,335175,335184,335188,335201,335217,335236,335237,335248,356524,356532,356540,356544,356574,356579,356583,356599,356616,356628,356657,356658,356667,356683,356701,356704,356706,356714,356717,356721,356729,356745,356773,368633,368652,368681,368711,368722,368729,368744,214481,214509,214529,240567,240595,240668,240682,252224,252228,252231,284439,284518,335084,335106,335214,335241,356508,356520,356538,356539,356543,356547,356553,356573,356575,356582,356591,356651,356655,356681,356741,356747,356752,356760,356765,368658,368683,368728,368730,368732,377742,377809,214428,240581,240635,240651,240656,251923,356506,356515,356526,356528,356531,356549,356567,356600,356614,356663,356711,356739,356742,356743,356753,356754,356781,368646,368650,368674,368723,368766,214431,240551,240589,240659,240686,252141,335086,335170,356511,356516,356517,356527,356572,356578,356585,356605,356666,356672,356696,356722,356746,356759,356761,356776,368627,368642,368678,368684,368724,368758,214482,240706,335109,356590,356638,356671,356685,356686,356782,368708,368737,214550,356767,356777,368625,377843,214489,284378,356662,356684,356688,356690,356779,380218,28178) AND firms__rubrics.FIRM_ID=firms.ID GROUP BY firms.ID ORDER BY firms.PRIORITY_KR DESC,firms.VIEWS_COUNT DESC LIMIT 40, 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=252189 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=31227 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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=97472
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=356509 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=377766 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=377870 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=240561 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=252047 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=284427 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=240559 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=284409 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=284453 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=335239 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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=140424
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=31222 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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=97472
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=31228 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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=97325
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=240552 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=252035 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=252100 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=214452 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=240556 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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=240665 AND firms__rubrics.RUBRIC_ID=rubrics.ID ORDER BY rubrics.PRIORITY ASC
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
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
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
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
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'
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188256,188284)
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
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (1,51,2)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (8155,8156)
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)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (38283,38284,38327,38299,38301,38310)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (42636,42637,42638)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (43097,43098)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (44843,44844,44852,44856,44851)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (6815,6851,6816)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (48088,48089,48114)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (50728,50730,50783)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (52458,52459,52461)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (61110,61111,61476,61475)
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
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)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188335,188336)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181037,181070,181072,181039)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (63755,63756)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10132,10133)
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)
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
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188667)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10200,10201)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (69014,69032,69015,69045,69047,69057,69076)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10421,10447,10506,10422)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (70235,70237,70814)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (74426,74429,74428)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (10704,10801,10892,10985,10705)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (11012,11030,11013,11046)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (75884,75886,76059)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (81036,81037)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (30027,30100,30125,30146,30028,30179,30210)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (84895,84896,84937)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (86290,86292)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (89769,89774)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (95421,95422)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (97198,97199)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (13249,13284,13250,13285)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (15000,15001)
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)
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
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)
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
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (188602,188652)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (106031,106159,106139,106033,106158)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (111390,111391)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (117285,117286)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (119235,119261,119270,119236,119280)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (124340,124349,124341)
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
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)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (130964,131120,130965)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (143212,143213)
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
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)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (16462,16479,16464)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (149751,149752)
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17294,17295)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (152957,152958,152985)
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
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)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (17558,17559,17669)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (160505,160751,160562,160555,160554,160508,160553)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (171118,171165,171173,171191,171119)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (172125,172184,172126)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (21655,21657,21656)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (176078,176268,176079)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (22132,22387,22573,22133,23952,24633,22378)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (178230,178335,178330,178336,178231)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (36895,36900,36902,36904,36912,36913,36896)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25444,25454,25445,25449,25452)
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
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)
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
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)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (25746,25748,25747)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (26154,26178,26179,26180,26155,26181)
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
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (189492,189493)
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)
SELECT COUNT(*) FROM `firms` LEFT JOIN places ON (firms.PLACE_ID=places.ID) WHERE places.ID IN (181920,181922,181921)
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
SELECT COUNT(*) FROM `firms` WHERE firms.ACTIVITY=true
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
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='kafe' LIMIT 1
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=581
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=558
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 (589,581,558) AND recommend.START_DATE<='2013-09-19' AND recommend.END_DATE>='2013-09-19' ORDER BY recommend.VIEWS_COUNT DESC LIMIT 5
SELECT rubrics.ID, rubrics.NAME, rubrics.TRANSLIT_NAME, rubrics.PARENT_ID, rubrics.KEYWORDS, rubrics.ICON, rubrics.PRIORITY, rubrics.ACTIVITY, rubrics.PAGE_TITLE, rubrics.PAGE_DESCRIPTION, rubrics.PAGE_KEYWORDS FROM `rubrics` WHERE rubrics.ID='kafe'
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
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
SELECT currencies.ID, currencies.CODE, currencies.NUM_CODE, currencies.NAME, currencies.NAME_ENG, currencies.SIGN, currencies.ACTIVITY FROM `currencies` WHERE currencies.ACTIVITY>2
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
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
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'
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
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
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
SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
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

Поиск по сайту

Кафе

CINNABON

СТУДЕНЧЕСКОЕ БИСТРО

Big Bull Grill, бар-гриль ООО "Маг-Плюс"

Домашний очаг, кафе, ООО

Шатры, ООО

БАРТОН ПАБ

ЛУИС

Б-7

БАГИРА

BLOW UP

АДАМС

Трактир, кафе ООО "Колибри"

СЕНСЕЙ

У РЕЧКИ

АМБАР

БАГЕТТЕРИЯ

КАРЕ

КАПРИЧЧИО

АССОРТИ

РОБИН БОБИН

Cегодня: 19.09.2013

Рсправка рекомендует

Поиск рубрик

Курсы валют

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries

	Запомнить меня

Поиск по сайту

Кафе

Cегодня: 19.09.2013

Рсправка рекомендует

Поиск рубрик

Превышен лимит добавляемых компаний!

Авторизуйтесь

Забыли пароль

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries