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,b.price, b.price_h FROM fs_service as a INNER JOIN fs_service_sub as b ON a.category_id_wrapper like '%,2870,%' AND a.published = 1 AND b.price > 0 AND b.service_id = a.id AND 2 = 2 GROUP BY a.id ORDER BY a.created_time DESC, a.id DESC
