SELECT `field`.*, `match_field_name`.`name` AS `matching`, `match_field`.`match_type` AS `matching_type`
FROM `skadate_profile_field` AS `field`
LEFT JOIN `skadate_link_profile_field_match` AS `match_field` ON `field`.`profile_field_id`=`match_field`.`match_profile_field_id`
LEFT JOIN `skadate_profile_field` AS `match_field_name` ON `match_field`.`profile_field_id`=`match_field_name`.`profile_field_id`""