Æåðòâàòà å 31-ãîäèøåí ìúæ
Bulgaria-news | 05.04.2020 17:59Ñèãíàëúò â ïîëèöèÿòà å ïîäàäåí êúì 21:00 ÷àñà íà 4 àïðèë.  àïàðòàìåíò â ãðàäà å íàìåðåí ìúðòúâ 31-ãîäèøåí ìúæ.
Ïî-êúñíî å çàäúðæàí ñîáñòâåíèêúò íà àïàðòàìåíòà - 52-ãîäèøåí îò Ïàçàðäæèê. Òîé å êðèìèíàëíî ïðîÿâåí è îñúæäàí.
Îòêðèòè è èççåòè ñà âåùåñòâåíè äîêàçàòåëñòâà, êîèòî èìàò îòíîøåíèå êúì èçâúðøåíîòî ïðåñòúïëåíèå.
Çà ñëó÷àÿ å óâåäîìåíà è Îêðúæíàòà ïðîêóðàòóðà â Ïàçàðäæèê.
Äåíÿò â ñíèìêè
Ðîäåí å Äúñòèí Õîôìàí, åäèí îò íàé-èçòúêíàòèòå àêòüîðè íà àìåðèêàíñêîòî êèíî îò êðàÿ íà XX âåê
Îùå ñíèìêè »
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