SELECT lists_flat.*, 1 AS sort_group, lists_entities.id, lists_entities.pid as pid, lists_entities.label as entity_label, lists_entities.level as level, lists_entities.website as website_id, lists_entities.order_left, lists_entities.order_right, lists_entities.parent, lists_entities.website, lists_entities.creation_date, lists_entities.update_date, lists_entities.undeletable, lists_entities.unupdatable FROM lists_flat RIGHT JOIN lists_entities ON lists_flat.entity_id = lists_entities.id WHERE active = 1 AND view = 2 UNION SELECT website_lists_flat.*, 2 AS sort_group, website_lists_entities.id, website_lists_entities.pid as pid, website_lists_entities.label as entity_label, website_lists_entities.level as level, website_lists_entities.website as website_id, website_lists_entities.order_left, website_lists_entities.order_right, website_lists_entities.parent, website_lists_entities.website, website_lists_entities.creation_date, website_lists_entities.update_date, website_lists_entities.undeletable, website_lists_entities.unupdatable FROM website_lists_flat RIGHT JOIN website_lists_entities ON website_lists_flat.entity_id = website_lists_entities.id WHERE active = 1 AND view = 2 ORDER BY sort_group ASC, label ASC