Array ( [0] => 00000 [1] => [2] => )
SELECT news.*, i18n.title, i18n.textCleared, (select ni.filename from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as filename FROM news LEFT JOIN news_i18n i18n on i18n.newsId = news.id AND i18n.i18nId = 1 LEFT JOIN news_images on news_images.contId = news.id and news_images.ismain = 1 WHERE news.subcat_id = :subcat_id AND (pdate <= '2026-07-21 00:59:59') GROUP BY news.id ORDER BY news.id DESC LIMIT 8