SELECT fs.*, fsr.*, fsp.*, tsd.parent_id as discount_parent_id, tsd.discounted_services, tsd.discounts FROM oc_fitter_service fs
            LEFT JOIN oc_fitter_service_price fsp ON (fs.service_id = fsp.service_id)
            LEFT JOIN oc_fitter_service_rel fsr ON (fsp.service_id = fsr.fitter_service_id)
            LEFT JOIN tblservicediscount tsd ON fs.service_id=tsd.parent_id
            WHERE 1 AND fs.status=1 AND fs.service_id = '191'  AND fs.hide_on_website != 1  ORDER BY fs.sort_order ASC