ÄÅÖÀ ÇÀ ÏÐÈÌÅÐ! 2010-05-02 15:24:50
Äåíÿò â ñíèìêè
Ðîäåí å Äúñòèí Õîôìàí, åäèí îò íàé-èçòúêíàòèòå àêòüîðè íà àìåðèêàíñêîòî êèíî îò êðàÿ íà XX âåê
Îùå ñíèìêè »
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.publishDate DESC, v.publishDate DESC
LIMIT 750,6