REQUEST NOT IN CACHE
SELECT translations_flat.*, translations_entities.id, translations_entities.pid as pid, translations_entities.label as entity_label, translations_entities.level as level, translations_entities.website as website_id, translations_entities.order_left, translations_entities.order_right, translations_entities.parent, translations_entities.website, translations_entities.creation_date, translations_entities.importation_id, translations_entities.update_date, translations_entities.undeletable, translations_entities.unupdatable FROM translations_flat RIGHT JOIN translations_entities ON translations_flat.entity_id = translations_entities.id WHERE active = 1 AND view = 2
 ORDER BY  label ASC

5700