SELECT a.id, a.name, a.alias, a.category_id, a.category_id_wrapper, a.image, a.price, a.price_old, a.repair, a.guarantee, MIN(b.price) as min_price, MIN(b.price_h) as min_price_h
FROM fs_service as a
INNER JOIN fs_service_sub as b
ON a.published = 1
AND b.price > 0 AND b.price_h > 0
AND b.service_id = a.id
AND 2 = 2
GROUP BY a.id ORDER BY a.hits DESC, a.ordering DESC, a.id DESC
