Финал VIII Фестиваля Ночная Лига Фестиваль Кубок Легенд НХЛ в регионах Москва Санкт-Петербург Центр Северо-Запад Юг и Северный Кавказ Приволжье Урал Сибирь Дальний Восток

#nhliga   МИНСПОРТ   ФХР

select r.id, r.date as date_time, DATE_FORMAT(r.date, '%d.%m.%y') as date_f, DAY(r.date) as `day`, MONTH(r.date) as `month`, YEAR(r.date) as `year`, HOUR(r.date) as `hour`, MINUTE(r.date) as `minute`, DATE_FORMAT((r.date + INTERVAL (3-re.timezone) HOUR), '%d.%m.%Y %H:%i') as date_relative, UNIX_TIMESTAMP((r.date + INTERVAL (3-re.timezone) HOUR)) as date_stamp, UNIX_TIMESTAMP((NOW() + INTERVAL (3-re.timezone) HOUR)) as now_stamp, TIME_TO_SEC(DATE_FORMAT((NOW() + INTERVAL (3-re.timezone) HOUR), '%H:%i:%s')) as day_time_sec, DATE_FORMAT((NOW() + INTERVAL (3-re.timezone) HOUR), '%Y') as now_year, DATE_FORMAT((NOW() + INTERVAL (3-re.timezone) HOUR), '%m') as now_month, DATE_FORMAT((NOW() + INTERVAL (3-re.timezone) HOUR), '%d') as now_day, r.title, r.title as `name`, r.preview, r.preview_html, r.preview_html_autoplay, r.preview_show, r.views, IF(r.count_comments>0, r.count_comments, 'нет') as `count_comments`, r.author, r.author_name, r.author_link, r.announce, re.`name` as `region_name`, re.`handle` as region_handle, if(r.type_id=5, 1, 0) as `quotation`, if(r.type_id=1, 1, 0) as `official`, r.`related_id`, r.`related1_id`, r.`related_album_id`, r.`related1_album_id`, r.`related_video_id`, r.`related1_video_id`, r.type_id, r.category_id, r.region_id, r.festival_id, r.important, r.section_id, rs.`type` as section_type, rs.`handle` as section_handle, r.rubric_id, rr.name as rubric_name from `reviews` `r` inner join `regions` `re` on (r.region_id=re.id) inner join `reviews_sections` `rs` on (r.section_id=rs.id) inner join `reviews_rubrics` `rr` on (r.rubric_id=rr.id) where r.deleted=0 and r.id in (15458) and r.active='1' and r.date<='2022-08-01 03:54:55' and r.festival_id='8' order by r.date desc, r.id desc