test.sql

-- 1 milion rows
CREATE TABLE `video` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created` datetime unsigned DEFAULT current_timestamp(),
  `deleted` tinyint NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
)

SELECT `name`
FROM `video`
WHERE `deleted` IS FALSE
ORDER BY `created` DESC