SELECT `a`.*, `b`.`state` as `state_name`, `c`.`country` as `country_name`, `d`.`action_efective_date`, `e`.`type` as `action_type`
FROM `user__address` `a`
LEFT JOIN `_ref__state` `b` ON `b`.`id` = `a`.`state_id`
LEFT JOIN `_ref__country` `c` ON `c`.`id` = `a`.`country_id`
LEFT JOIN `user__profiling` `d` ON `d`.`id` = `a`.`profiling_id`
LEFT JOIN `_ref__action_type` `e` ON `e`.`id` = `d`.`action_type_id`
WHERE `a`.`is_delete` =0
AND `a`.`profiling_id` = '2'
AND `a`.`user_id` = '3'
ORDER BY `a`.`profiling_id` DESC, `a`.`type` ASC