МЛАД МИЛИАРДЕР ЛИ Е ПРЕЗИДЕНТЪТ? НЕ Е МЛАД, ОПРЕДЕЛЕНО!
Tue, Mar 2, 2010 14:14
4321 преглеждания
Гледай
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
SELECT
v.ID,
v.ObjectID,
v.type,
v.publishDate,
v.timesPlayed,
v.featured,
vm.title,
vm.description,
CONCAT("videos/video/",v.ID) as address
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.timesPlayed DESC, v.publishDate DESC
LIMIT 0,6