SELECT websites_views_flat.label as label, websites_views_flat.label, websites_views_flat.long_label, websites_views_flat.entity_id ,websites_views_entities.id, websites_views_entities.pid as pid, websites_views_entities.label as entity_label, websites_views_entities.level as level, websites_views_entities.website as website_id, websites_views_entities.order_left, websites_views_entities.order_right, websites_views_entities.parent, websites_views_entities.website, websites_views_entities.importation_id, websites_views_entities.creation_date, websites_views_entities.update_date, websites_views_entities.undeletable, websites_views_entities.unupdatable FROM websites_views_flat RIGHT JOIN websites_views_entities ON websites_views_flat.entity_id = websites_views_entities.id WHERE website_folder = "safex" AND view = 2 ORDER BY order_left ASC