https://www.5gmedia.bg/49025/smeseni-reakcii-sled-koncerta-na-azis-v-arena-8888-sofiya#:~:text=%D0%A1%D0%9A%D0%90%D0%9D%D0%94%D0%90%D0%9B-,%D0%A1%D0%9C%D0%95%D0%A1%D0%95%D0%9D%D0%98%20%D0%A0%D0%95%D0%90%D0%9A%D0%A6%D0%98%D0%98%20%D0%A1%D0%9B%D0%95%D0%94%2

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