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

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

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

Все регионы

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

Кафе

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

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

АКАДЕМИЯ

Москва, Бронная Б. ул., д. 2/6
Телефон +7(495) 6978978

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

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

Рейтинг: 66

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

КОКТЕЙЛЬ

Санкт-Петербург, Стачек проспект, д. 75
Телефон +7(812) 784-42-11

Факс: +7(812) 784-42-11

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

Рейтинг: 66

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

Китайский дом, кафе ООО "Фора"

Смоленск, Пригородная ул. 10
Телефон (4812) 31-99-66(4812)63-69-96

E-mail: esaul1951@hotmail.com

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

Рейтинг: 66

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

НА НЕВСКОЙ

Егорьевск, Александра Невского ул., д. 2
Телефон +7(49640) 37878

Факс: +7(495) 6999642

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

Рейтинг: 65

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

ДОЛЬЧЕ МОМЕНТО

Москва, МКАД , 71 км, ТРЦ Вэйпарк
Телефон +7(495) 7414617

Факс: +7(495) 6826727

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

Рейтинг: 65

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

СНЕЖНАЯ ДЖЕЛАТЕРИЯ

Санкт-Петербург, Науки проспект, д. 17, корп. 2
Телефон +7(812) 497-40-85

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

Рейтинг: 65

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

В гостях у Айшан, кафе ООО "Ректус"

Екатеринбург, Ткачей ул. 18
Телефон (343) 261-67-08

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

Рейтинг: 65

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

ШАТО

Железнодорожный, Пионерская ул., д. 5А
Телефон +7(903) 2741800

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

Рейтинг: 64

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

МОКА-ЛОКА

Новосибирск, Карла Маркса пл. 2
Телефон +7(383) 354-99-38

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

Рейтинг: 64

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

CHOKKOLATTA

Москва, Цветной бул., д. 11/2
Телефон +7(495) 6249696

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

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

Рейтинг: 64

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

БОГАРТ'С

Санкт-Петербург, Конюшенная Малая улица, д. 14/19
Телефон +7(812) 312-03-39

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

Рейтинг: 64

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

КЭТИНО

Санкт-Петербург, 8-я линия, д. 23
Телефон +7(812) 326-01-96

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

Рейтинг: 64

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

Ты и Я, кафе, ИП Бобрикова А. Г.

Ростов-на-Дону, Б. Садовая ул. 131
Телефон (863) 263-56-28

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

Рейтинг: 64

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

BARhat, кафе, ИП Любченко С. С.

Екатеринбург, Дублер Сибирского тракта 2
Телефон 8-904-545-56-27

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

Рейтинг: 64

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

Академический, кафетерий, ООО

Екатеринбург, Комсомольская ул. 17
Телефон (343) 374-09-33

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

Рейтинг: 64

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

Славяночка, кафе ООО "РВА"

Смоленск, 2-я Садовая ул. 25 а
Телефон (4812) 21-81-19(4812)20-30-40

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

Рейтинг: 64

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

БОТАН

Новосибирск, Кошурникова ул. 45
Телефон +7(383) 267-84-55

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

Рейтинг: 63

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

Амад, ЗАО

Смоленск, Попова ул. 84
Телефон (4812) 52-37-78

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

Рейтинг: 63

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

Б-55

Новосибирск, Хмельницкого Богдана ул. 55
Телефон +7(383) 271-02-95

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

Рейтинг: 62

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

GOODWIN

Нижний Новгород, Горького Максима ул. 143
Телефон +7(831) 230-33-88

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

Рейтинг: 62

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

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

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_111457: '1379482152'
  firm_rating_111469: '1379463969'
  firm_rating_111500: '1379482127'
  firm_rating_111512: '1379469337'
  firm_rating_111547: '1379482179'
  firm_rating_118227: '1379538318'
  firm_rating_119296: '1379538155'
  firm_rating_120165: '1379469219'
  firm_rating_120167: '1379461488'
  firm_rating_120169: '1379460675'
  firm_rating_120184: '1379469619'
  firm_rating_120246: '1379469393'
  firm_rating_131893: '1379528569'
  firm_rating_131902: '1379531390'
  firm_rating_131972: '1379536354'
  firm_rating_133227: '1379454925'
  firm_rating_1455: '1379531460'
  firm_rating_146840: '1379516428'
  firm_rating_146869: '1379514112'
  firm_rating_1522: '1379532726'
  firm_rating_1528: '1379529926'
  firm_rating_15600: '1379522965'
  firm_rating_165996: '1379506691'
  firm_rating_18402: '1379500691'
  firm_rating_187469: '1379531699'
  firm_rating_188223: '1379537527'
  firm_rating_188280: '1379535683'
  firm_rating_188508: '1379523783'
  firm_rating_18864: '1379535707'
  firm_rating_18876: '1379527058'
  firm_rating_18919: '1379527974'
  firm_rating_18921: '1379529452'
  firm_rating_193695: '1379469281'
  firm_rating_19560: '1379455284'
  firm_rating_19561: '1379454891'
  firm_rating_19567: '1379455355'
  firm_rating_19616: '1379459149'
  firm_rating_201496: '1379460269'
  firm_rating_206877: '1379519289'
  firm_rating_206884: '1379521578'
  firm_rating_207728: '1379531519'
  firm_rating_212051: '1379513948'
  firm_rating_22657: '1379528629'
  firm_rating_22675: '1379534702'
  firm_rating_227872: '1379464236'
  firm_rating_229197: '1379530594'
  firm_rating_2302: '1379531852'
  firm_rating_233538: '1379536821'
  firm_rating_233545: '1379535917'
  firm_rating_241440: '1379492330'
  firm_rating_242555: '1379493040'
  firm_rating_242581: '1379531942'
  firm_rating_250397: '1379509761'
  firm_rating_250424: '1379521312'
  firm_rating_250450: '1379511201'
  firm_rating_250459: '1379509694'
  firm_rating_2571: '1379529530'
  firm_rating_257280: '1379483561'
  firm_rating_2597: '1379530840'
  firm_rating_263195: '1379520464'
  firm_rating_27720: '1379535312'
  firm_rating_27823: '1379529580'
  firm_rating_27902: '1379487767'
  firm_rating_27904: '1379495822'
  firm_rating_27905: '1379497437'
  firm_rating_279312: '1379507721'
  firm_rating_281013: '1379494927'
  firm_rating_281022: '1379490571'
  firm_rating_281027: '1379492353'
  firm_rating_281715: '1379483307'
  firm_rating_281717: '1379483580'
  firm_rating_287738: '1379531243'
  firm_rating_29088: '1379483333'
  firm_rating_296602: '1379454964'
  firm_rating_298894: '1379503685'
  firm_rating_303600: '1379457579'
  firm_rating_306118: '1379494067'
  firm_rating_306123: '1379491541'
  firm_rating_312856: '1379515991'
  firm_rating_312870: '1379519553'
  firm_rating_316003: '1379482053'
  firm_rating_317469: '1379482076'
  firm_rating_317472: '1379464290'
  firm_rating_317481: '1379465321'
  firm_rating_31754: '1379509592'
  firm_rating_31759: '1379512444'
  firm_rating_31769: '1379514740'
  firm_rating_31783: '1379515390'
  firm_rating_329892: '1379455219'
  firm_rating_330398: '1379522618'
  firm_rating_330617: '1379458997'
  firm_rating_349502: '1379521693'
  firm_rating_349954: '1379528367'
  firm_rating_350387: '1379454988'
  firm_rating_352304: '1379458913'
  firm_rating_361937: '1379467061'
  firm_rating_363381: '1379465210'
  firm_rating_369887: '1379483477'
  firm_rating_373928: '1379536211'
  firm_rating_374061: '1379483287'
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_111457=1379482152; firm_rating_111469=1379463969; firm_rating_111500=1379482127; firm_rating_111512=1379469337; firm_rating_111547=1379482179; firm_rating_118227=1379538318; firm_rating_119296=1379538155; firm_rating_120165=1379469219; firm_rating_120167=1379461488; firm_rating_120169=1379460675; firm_rating_120184=1379469619; firm_rating_120246=1379469393; firm_rating_131893=1379528569; firm_rating_131902=1379531390; firm_rating_131972=1379536354; firm_rating_133227=1379454925; firm_rating_1455=1379531460; firm_rating_146840=1379516428; firm_rating_146869=1379514112; firm_rating_1522=1379532726; firm_rating_1528=1379529926; firm_rating_15600=1379522965; firm_rating_165996=1379506691; firm_rating_18402=1379500691; firm_rating_187469=1379531699; firm_rating_188223=1379537527; firm_rating_188280=1379535683; firm_rating_188508=1379523783; firm_rating_18864=1379535707; firm_rating_18876=1379527058; firm_rating_18919=1379527974; firm_rating_18921=1379529452; firm_rating_193695=1379469281; firm_rating_19560=1379455284; firm_rating_19561=1379454891; firm_rating_19567=1379455355; firm_rating_19616=1379459149; firm_rating_201496=1379460269; firm_rating_206877=1379519289; firm_rating_206884=1379521578; firm_rating_207728=1379531519; firm_rating_212051=1379513948; firm_rating_22657=1379528629; firm_rating_22675=1379534702; firm_rating_227872=1379464236; firm_rating_229197=1379530594; firm_rating_2302=1379531852; firm_rating_233538=1379536821; firm_rating_233545=1379535917; firm_rating_241440=1379492330; firm_rating_242555=1379493040; firm_rating_242581=1379531942; firm_rating_250397=1379509761; firm_rating_250424=1379521312; firm_rating_250450=1379511201; firm_rating_250459=1379509694; firm_rating_2571=1379529530; firm_rating_257280=1379483561; firm_rating_2597=1379530840; firm_rating_263195=1379520464; firm_rating_27720=1379535312; firm_rating_27823=1379529580; firm_rating_27902=1379487767; firm_rating_27904=1379495822; firm_rating_27905=1379497437; firm_rating_279312=1379507721; firm_rating_281013=1379494927; firm_rating_281022=1379490571; firm_rating_281027=1379492353; firm_rating_281715=1379483307; firm_rating_281717=1379483580; firm_rating_287738=1379531243; firm_rating_29088=1379483333; firm_rating_296602=1379454964; firm_rating_298894=1379503685; firm_rating_303600=1379457579; firm_rating_306118=1379494067; firm_rating_306123=1379491541; firm_rating_312856=1379515991; firm_rating_312870=1379519553; firm_rating_316003=1379482053; firm_rating_317469=1379482076; firm_rating_317472=1379464290; firm_rating_317481=1379465321; firm_rating_31754=1379509592; firm_rating_31759=1379512444; firm_rating_31769=1379514740; firm_rating_31783=1379515390; firm_rating_329892=1379455219; firm_rating_330398=1379522618; firm_rating_330617=1379458997; firm_rating_349502=1379521693; firm_rating_349954=1379528367; firm_rating_350387=1379454988; firm_rating_352304=1379458913; firm_rating_361937=1379467061; firm_rating_363381=1379465210; firm_rating_369887=1379483477; firm_rating_373928=1379536211; firm_rating_374061=1379483287; firm_rating_379015=1379530567; firm_rating_379050=1379482246; firm_rating_38092=1379530892; firm_rating_38320=1379527911; firm_rating_38884=1379483501; firm_rating_38888=1379482345; firm_rating_38966=1379482216; firm_rating_39000=1379483451; firm_rating_39001=1379483375; firm_rating_4046=1379526004; firm_rating_422=1379534468; firm_rating_423=1379522463; firm_rating_42648=1379482105; firm_rating_42664=1379463020; firm_rating_42676=1379469450; firm_rating_438=1379524878; firm_rating_440=1379531418; firm_rating_46007=1379532351; firm_rating_461=1379532966; firm_rating_49212=1379506616; firm_rating_49893=1379482275; firm_rating_500=1379524799; firm_rating_50963=1379523099; firm_rating_51055=1379532779; firm_rating_515=1379521959; firm_rating_51864=1379527515; firm_rating_53268=1379503842; firm_rating_53789=1379530365; firm_rating_53823=1379530785; firm_rating_53831=1379529609; firm_rating_53832=1379529036; firm_rating_53890=1379531821; firm_rating_53903=1379524071; firm_rating_54317=1379538191; firm_rating_548=1379530867; firm_rating_56904=1379458970; firm_rating_61053=1379469311; firm_rating_61103=1379460360; firm_rating_61638=1379498483; firm_rating_61643=1379502269; firm_rating_61651=1379503810; firm_rating_61669=1379500283; firm_rating_65479=1379536238; firm_rating_65484=1379532752; firm_rating_65486=1379528122; firm_rating_65495=1379534428; firm_rating_65496=1379530763; firm_rating_65518=1379524743; firm_rating_73513=1379460466; firm_rating_73740=1379465246; firm_rating_78793=1379517852; firm_rating_78795=1379511763; firm_rating_78862=1379516728; firm_rating_78889=1379519436; firm_rating_80789=1379519259; firm_rating_80820=1379514277; firm_rating_81503=1379488629; firm_rating_81509=1379496935; firm_rating_81514=1379487949; firm_rating_81517=1379494900; firm_rating_82634=1379453539; firm_rating_82643=1379457329; firm_rating_82647=1379456247; firm_rating_82726=1379457359; firm_rating_84345=1379528037; firm_rating_84643=1379532639; firm_rating_84682=1379533724; firm_rating_85372=1379503780; firm_rating_85375=1379506539; firm_rating_85452=1379500246; firm_rating_85503=1379501408; firm_rating_85567=1379499254; firm_rating_86370=1379533886; firm_rating_86382=1379531362; firm_rating_86402=1379525776; firm_rating_88040=1379507947; firm_rating_88041=1379503627; firm_rating_88089=1379508492; firm_rating_88193=1379504242; firm_rating_88196=1379497690; firm_rating_89414=1379515566; firm_rating_94055=1379486815; firm_rating_97902=1379482323; firm_rating_97934=1379483404; firm_rating_99696=1379453468; firm_rating_99701=1379455386; symfony=f9jcbp02pnpgl4ljasgp45p977'
  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.208
  HTTP_X_REAL_IP: 207.241.237.208
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /rubric/kafe/page/4/
  PATH_TRANSLATED: 'redirect:/index.php/kafe/page/4/'
  PHP_SELF: /frontend.php/rubric/kafe/page/4/
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.208
  REMOTE_PORT: '35267'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1379539381
  REQUEST_URI: /frontend.php/rubric/kafe/page/4/
  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/4/ with parameters array ( 'module' => 'default', 'action' => 'rubric', 'id' => 'kafe', 'page' => '4',)
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.74	0
Action "default/rubric"	1	9.16	1
View "Success" for "default/rubric"	1	848.48	92
Component "default/rubric"	1	440.35	48
Partial "default/_rubric"	1	52.02	5
Component "default/pager"	1	0.06	0
Partial "default/_pager"	1	1.83	0
Component "default/about"	1	4.68	0
Partial "default/_about"	1	1.85	0
Component "default/controlMenu"	1	0.54	0
Partial "default/_controlMenu"	1	0.17	0
Component "search/siteSearch"	1	6.68	0
Partial "search/_siteSearch"	1	289.76	31
Component "default/statistic"	1	0.90	0
Partial "default/_statistic"	1	0.20	0
Component "news/recommend"	1	5.03	0
Partial "news/_recommend"	1	0.27	0
Component "default/rubricsTree"	1	5.76	0
Partial "default/_rubricsTree"	1	1.01	0
Component "currencies/currencies"	1	8.69	0
Partial "currencies/_currencies"	1	0.75	0
Component "default/personal"	1	4.93	0
Partial "default/_personal"	1	2.67	0
Component "default/footer"	1	2.78	0
Partial "default/_footer"	1	1.41	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>='3488738768' 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<='3488738768' 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<='3488738768' AND ip_place.IP_TO>='3488738768'
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 60, 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=252242 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=284503 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=377785 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=31236 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=98728
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=252017 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=284528 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=356571 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=31225 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=214483 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=251971 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=284416 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=284437 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=335244 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=356507 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=356535 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=377833 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=214426 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=377728 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=214416 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=220826 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=106033
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>='3488738768' 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<='3488738768' 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<='3488738768' AND ip_place.IP_TO>='3488738768'
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

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

Кафе

АКАДЕМИЯ

КОКТЕЙЛЬ

Китайский дом, кафе ООО "Фора"

НА НЕВСКОЙ

ДОЛЬЧЕ МОМЕНТО

СНЕЖНАЯ ДЖЕЛАТЕРИЯ

В гостях у Айшан, кафе ООО "Ректус"

ШАТО

МОКА-ЛОКА

CHOKKOLATTA

БОГАРТ'С

КЭТИНО

Ты и Я, кафе, ИП Бобрикова А. Г.

BARhat, кафе, ИП Любченко С. С.

Академический, кафетерий, ООО

Славяночка, кафе ООО "РВА"

БОТАН

Амад, ЗАО

Б-55

GOODWIN

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