
SELECT Marca, Version, Motor, Modelo, Estado, CO, Denominacion, Id FROM `TURISMOS` WHERE Denominacion = '' AND Estado <> 'CAD' GROUP BY Version ORDER BY `CO` ASCSELECT Version,Motor,Modelo,Estado,FI,Denominacion,Id FROM `TURISMOS` WHERE Denominacion='' group by Version ORDER BY 'FI' ASC