SELECT * FROM video WHERE status = 'published' ORDER BY pubDate LIMIT 1000000 OFFSET 0