SELECT s.subtreatment_name , COUNT(s.subtreatment_name) AS count from subtreatment s join placidway_treatment t on s.treatment_id = t.treatment_id, package_details p where ( p.package_name like CONCAT('%',s.subtreatment_name,'%') or p.h1text like CONCAT('%',s.subtreatment_name,'%')) and t.type like 'Anti%Aging' AND t.live='Yes' and p.live='Yes' and s.live='Yes' and p.country_key like 'Thailand' GROUP BY s.subtreatment_name ORDER BY COUNT(*) DESC, s.subtreatment_name ASC limit 30
