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, a.cat_sub
FROM fs_service AS a
INNER JOIN fs_service_sub AS b
ON b.service_id = a.id
AND b.price > 0
WHERE a.published = 1
AND (a.category_id_wrapper LIKE '%,3016,%'
OR a.cat_sub LIKE '%,3016,%')
and 1=1
GROUP BY a.id
ORDER BY a.id DESC
