ÈÂÀÉËÎ ÊÀËÔÈÍ: ÏÀÐÒÈÈÒÅ, ÊÎÈÒÎ ÂÍÓØÀÂÀÕÀ, ×Å ÂÎÒÚÒ Å ÊÓÏÅÍ, ÑÏÅ×ÅËÈÕÀ ÈÇÁÎÐÈÒÅ
„Âñå ïàê íèå ñìå åâðîïåéöè, íå áèâà äà ñå äîïóñêàò òàêèâà ñïåêóëàöèè”, êàçà áèâøèÿò ìèíèñòúð íà âúíøíèòå ðàáîòè
Bulgaria News | 06.07.2009 00:18.
Ïðî÷åòè ïúëíèÿ òåêñò„Âñå ïàê íèå ñìå åâðîïåéöè, íå áèâà äà ñå äîïóñêàò òàêèâà ñïåêóëàöèè”, êàçà áèâøèÿò ìèíèñòúð íà âúíøíèòå ðàáîòè
Bulgaria News | 06.07.2009 00:18.
Ïðî÷åòè ïúëíèÿ òåêñò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