ДОКЛАД НА СENTRAL EUROPEAN MEDIA ENTERPRISES (CME) РАЗКРИВА, ЧЕ BTV БЕЛЕЖИ ЗАГУБИ ЗА ВТОРОТО ТРИМЕСЕЧИЕ НА ТАЗИ ГОДИНА

SELECT 
									a.ID,
									a.publish as date,
									am.enabled,
									am.Title as title,
									am.Resume as resume,
									DATE_FORMAT(a.publish,"%d-%m-%Y %H:%i") as publish,
									CONCAT("thumb",".",a.extension) as thumb,
									IF(a.tag IS NULL,CONCAT("post",a.ID),a.tag) as path,
									d.category_id as category_id
FROM bn_articles a
													INNER JOIN bn_articles_distribution d
													ON d.ArticleID = a.ID
 INNER JOIN bn_articles_meta am
																		ON am.ArticleID = a.ID
WHERE a.publish <= NOW() AND am.language_id = 1
AND d.category_id = 7
ORDER BY date DESC 
LIMIT 0,3