„Çíàå ñå çà îùå åäíà äåïóòàòêà îò „Âúçðàæäàíå“, êîÿòî ñå êàíè äà íàïóñíå ïàðòèÿòà. Åäíà øàõìàòèñòêà“, êàçà ïðåä áÒÂ Äåëÿí Äîáðåâ îò ÃÅÐÁ ïî ïîâîä ïðåãîâîðèòå íà Àñåí Âàñèëåâ çà ïîäêðåïà çà êàáèíåòà.
Ïðî÷åòè ïúëíèÿ òåêñò
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