ДЕМОНСТРАЦИИ И СБЛЪСЪЦИ В ХАМБУРГ 2011-08-22 16:55:46
Денят в снимки
SELECT count(v.ID) as records FROM bn_videos v LEFT JOIN bn_videos_meta vm ON vm.VideoID = v.ID WHERE v.enabled = 1 AND v.publishDate <= NOW() AND vm.language_id = 1 ORDER BY v.publishDate DESC, v.publishDate DESC