((SELECT *,e.id as id_foto_ok FROM cataloghi_foto as e INNER JOIN (SELECT id_foto, MIN(ordine) as min_ordine FROM foto_aggiuntive GROUP BY id_foto) as min_fo ON e.id = min_fo.id_foto INNER JOIN foto_aggiuntive as b ON b.id_foto = min_fo.id_foto AND b.ordine = min_fo.min_ordine LEFT JOIN prodotto as c on c.id_foto = e.id WHERE c.id_azienda = '1' AND e.tipo_prod = '1' AND e.se_attivo = '1' AND e.data_da >= CURDATE() AND e.se_monitor = '5' ORDER BY CASE e.tipo_disponibilita WHEN 8 THEN 1 WHEN 9 THEN 2 ELSE 3 END ASC, e.data_da ASC, e.id ASC LIMIT 1000) UNION (SELECT *,e.id as id_foto_ok FROM cataloghi_foto as e INNER JOIN (SELECT id_foto, MIN(ordine) as min_ordine FROM foto_aggiuntive GROUP BY id_foto) as min_fo ON e.id = min_fo.id_foto INNER JOIN foto_aggiuntive as b ON b.id_foto = min_fo.id_foto AND b.ordine = min_fo.min_ordine LEFT JOIN prodotto as c on c.id_foto = e.id WHERE c.id_azienda = '1' AND e.tipo_prod = '1' AND e.se_attivo = '1' AND e.se_cs = '1' AND e.se_monitor = '5' ORDER BY e.mese_cs ASC)) ORDER BY se_cs ASC, CASE tipo_disponibilita WHEN 8 THEN 1 WHEN 9 THEN 2 ELSE 3 END ASC, data_da ASC, mese_cs ASC