DELETE `h1`.*
FROM `history` AS `h1`
LEFT JOIN (
SELECT MIN(`id`) AS `min_id`
FROM `history`
GROUP BY `g_id`
) AS `h2` ON `h2`.`min_id` = `h1`.`id`
WHERE `h2`.`min_id` IS NULL... WHERE city_id = 4019 LEFT JOIN ...
SELECT `r`.`ball`
FROM (
(SELECT `ball`, 0 AS `order`
FROM `ratings`
WHERE `type_id` = :priceItemsId
AND `type_name` = 'price_items')
UNION (SELECT `r`.`ball` AS `ball`, 1 AS `order`
FROM `price_items` AS `i`
JOIN `ratings` AS `r`
ON `i`.`id` = :priceItemsId
AND `r`.`type_id` = `i`.`price_id`
AND `r`.`type_name` = `price`)
) AS `r`
ORDER BY `r`.`order`
LIMIT 1