Ver originalselect * form parcelas as t1left join (select max(superficie),id_cultivo,id_parcela from cultivos group by id_cultivo,id_parcela) as t2 on t1.idparcela=t2.id_parcelaleft join cultivos as t3 on t2.id_cultivo=t3.id_cultivo