SELECT `a`.*, `b`.`type`, `b`.`icon`, `b`.`color`, `c`.`name`, `d`.`title` as `user_title`, `e`.`name` as `religion`, `f`.`race`, `g`.`country` as `issue_country`, `h`.`country` as `nationality`
FROM `user__profiling` `a`
LEFT JOIN `_ref__action_type` `b` ON `b`.`id` = `a`.`action_type_id`
LEFT JOIN `user` `c` ON `c`.`id` = `a`.`user_id`
LEFT JOIN `_ref__title` `d` ON `d`.`id` = `a`.`title_id`
LEFT JOIN `_ref__religion` `e` ON `e`.`id` = `a`.`religion_id`
LEFT JOIN `_ref__race` `f` ON `f`.`id` = `a`.`race_id`
LEFT JOIN `_ref__country` `g` ON `g`.`id` = `a`.`place_issue`
LEFT JOIN `_ref__country` `h` ON `h`.`id` = `a`.`citizen_id`
WHERE `a`.`user_id` = '128'
AND `a`.`is_delete` =0
ORDER BY `a`.`action_efective_date` DESC, `a`.`id` DESC