(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() ORDER BY e.data_da,e.id ASC LIMIT 30)