SELECT languages_flat.label as label, languages_flat.email, languages_flat.phone, languages_flat.contact_branch, languages_flat.warning_email, languages_flat.warning_date, languages_flat.entity_id ,languages_entities.id, languages_entities.pid as pid, languages_entities.label as entity_label, languages_entities.level as level, languages_entities.website as website_id, languages_entities.order_left, languages_entities.order_right, languages_entities.parent, languages_entities.website, languages_entities.importation_id, languages_entities.creation_date, languages_entities.update_date, languages_entities.undeletable, languages_entities.unupdatable FROM languages_flat RIGHT JOIN languages_entities ON languages_flat.entity_id = languages_entities.id WHERE entity_id = 2 AND view = 2 ORDER BY order_left ASC