SELECT *
FROM `products`
JOIN (
SELECT MAX(`discount_price`) AS `max_price`, `product_id`
FROM `options`
GROUP BY `product_id`
) AS `max` ON `max`.`product_id` = `products`.`id`
ORDER BY `max`.`max_price` ASC
LIMIT 24ORDER BY `stock` = 0, `id`
SELECT COUNT(*)
FROM `table1`
WHERE `DATETIME` >= NOW() - INTERVAL 1 HOUR;