Вход - Регистрация
  • Facebook
  • RSS
  • PDA Омскпресс
  • Вконтакте
  • Twitter
  • Виджет для браузера Опера
  • LiveJournal
  • Виджет для Яндекс
21
ноября
ср
Вечер −4
Ночь −5
Бензин в Омске
АИ-9237.25АИ-9539.35
АИ-9843.00ДТ40.55
USD65.95 66.25
EUR75.00 75.39
 ПокупкаПродажа
SELECT ((SELECT COUNT(*) FROM jos_content AS c WHERE c.catid != 11 AND c.state = 1 AND LOWER(c.`metakey`) RLIKE LOWER('')) + (SELECT COUNT(*) FROM jos_ratings AS r WHERE r.state = 1 AND LOWER(r.`metakey`) RLIKE LOWER(''))) as amount(SELECT c.*, ci.`hits`, ci.orders, ca.title as catname, ca.alias as catname_alias, i.name as istname, i.title_alias as istname_alias, ii.cid, ii.photo, ii.video, ii.info, ii.podcast, ii.geo, ii.caricature FROM jos_content AS c INNER JOIN jos_content_hits as ci ON ci.id = c.id INNER JOIN jos_content_ico as ii ON ii.cid = c.id LEFT JOIN jos_categories as ca ON ca.id = c.catid LEFT JOIN jos_ist as i ON i.id = c.ist WHERE c.catid != 11 AND c.state = 1 AND LOWER(`metakey`) RLIKE LOWER('')) UNION (SELECT r.id, r.title, r.title2, NULL as hot, NULL as title_alias, r.lead as introtext, NULL as `fulltext`, r.img, r.img_ist, r.state, NULL as sectionid, NULL as catid, r.created, r.created_by, NULL as created_by_alias, r.author, r.modified, r.modified_by, r.checked_out, r.checked_out_time, r.version, NULL as ordering, r.metakey,NULL as metadesc, NULL as ist, NULL as type, r.on_main, r.on_mod, r.ya, r.count_com as count_com, r.vk_count_com as vk_count_com, r.all_com as all_com, NULL as parent, r.rosfirm, r.onmail, NULL as carfile, r.facebot, r.ismain, r.setlinks, NULL as tvTitle, NULL as tvLead, NULL as tvImage, NULL as tvState, rh.hits, NULL as orders, NULL as catname, NULL as catname_alias, NULL as istname, NULL as istname_alias, NULL as cid, NULL as photo, NULL as video, NULL as info, NULL as podcast, NULL as geo, NULL as caricature FROM `jos_ratings` as r JOIN `jos_ratings_hits` as rh ON rh.id = r.id WHERE r.state=1 AND LOWER(`metakey`) RLIKE LOWER('')) ORDER BY `created` DESC LIMIT 15
Новости по Вашему запросу не найдены
Справочник организаций
Организация, телефон, место
Сетевое издание «Омскпресс» (18+).

Зарегистрировано Федеральной службой по надзору в сфере связи, информационных технологий и массовых коммуникаций (Роскомнадзор).

Свидетельство о регистрации СМИ ЭЛ № ФС 77 - 67755 от 17.11.2016 г.

Учредитель: Харитонов Константин Николаевич.
Главный редактор: Чухутова Мария Николаевна.
Адрес редакции: 644042, Омская область, г. Омск, пр-т Карла Маркса, д. 20, офис 501, 8 (988) 253-57-79.
Электронный адрес редакции: redactor@omskpress.ru.
Контактные данные для Роскомнадзора и государственных органов: mary@omskpress.ru.
Для рекламодателей: adv@omskpress.ru
Счетчик