SELECT `a`.*, `b`.`action_efective_date`, `c`.`type` as `action_type`
FROM `user__recurring` `a`
LEFT JOIN `user__profiling` `b` ON `b`.`id` = `a`.`profiling_id`
LEFT JOIN `_ref__action_type` `c` ON `c`.`id` = `b`.`action_type_id`
WHERE `a`.`profiling_id` = '3'
AND `a`.`recurring_type` = 1
AND `a`.`is_delete` =0