 SELECT st.status, l.code, st.translator_id, st.translation_service, i.trid FROM wprb_icl_languages l LEFT JOIN wprb_icl_translations i ON l.code = i.language_code JOIN wprb_icl_translation_status st ON i.translation_id = st.translation_id WHERE l.active = 1 AND 1=1 OR i.trid IS NULL;