SELECT d_p_pi.*, d_p_pi_t.* FROM `dynpg_portal_profileimage` AS d_p_pi LEFT JOIN `dynpg_portal_profileimage_trans` d_p_pi_t ON d_p_pi_t.profileimage_id_fk = d_p_pi.id AND d_p_pi_t.language_code_fk = 'fr' WHERE `profile_id_fk` = 22972 AND `showimage` = 1 ORDER BY d_p_pi.id ASC