string(1273) "SELECT 
		  n.*,
		  nt.news_title, nt.news_title_x, nt.news_title_fb,
		  nu.news_url,
		  nd.news_description,
		  nk.news_keyword,
		  ni.news_images_url,
		  nst.news_short_title, nst.news_short_title_translit,
		  nc.*,
		  nm.*
		  
		  /*,CONVERT_TZ(n.news_date, '+00:00', '-03:00') AS news_date*/
		  
		FROM (
		  SELECT news_id
		  FROM news n
		  
		   
			WHERE news_real_date>NOW()-INTERVAL 7 DAY
		  --ORDER BY n.news_views, n.news_id DESC/*popular_news*/
		  LIMIT 0,8
		) AS filtered_news
		INNER JOIN news n ON filtered_news.news_id = n.news_id
		INNER JOIN news_title nt ON n.news_id = nt.news_title_news_id
		INNER JOIN news_url nu ON n.news_id = nu.news_url_news_id
		INNER JOIN news_description nd ON n.news_id = nd.news_description_news_id
		INNER JOIN news_keyword nk ON n.news_id = nk.news_keyword_news_id
		INNER JOIN news_images ni ON n.news_id = ni.news_images_news_id AND ni.news_images_ok = 1
		INNER JOIN news_short_title nst ON n.news_id = nst.news_short_title_news_id
		INNER JOIN news_category nc ON n.news_category_id = nc.news_category_id AND nc.news_category_status = 1
		INNER JOIN news_menu nm ON nc.news_category_news_menu_id = nm.news_menu_id
		
		ORDER BY n.news_views, n.news_id DESC/*popular_news*/"