ДЕЦАТА НА ПРЕМИЕРА ЯНЕВ СА НАЗНАЧЕНИ, БЕЗ КОНКУРС, НА ВИСОКИ ДЪРЖАВНИ ПОСТОВЕ ПО ВРЕМЕТО НА ПЪРВИЯ СЛУЖЕБЕН КАБИНЕТ НА РУМЕН РАДЕВ

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