((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.tipo_disponibilita = '9'
ORDER BY e.data_da,e.id ASC
LIMIT 1000,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.tipo_disponibilita = '9'
ORDER BY e.mese_cs ASC)) ORDER BY data_da,se_cs ASC
