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 24SELECT *
FROM planet_osm_polygon
WHERE st_within(ST_SetSRID(ST_MakePoint(37.601675181742, 55.750958697655), 4326), way);SET @last = 0;
SELECT `ID_1`, @last := `ID_2` AS `ID_2`
FROM (
SELECT `ID_1`, `ID_2`
FROM `table`
ORDER BY `ID_1`, `ID_2`
) AS `t`
WHERE `ID_1` > @last;