AutoSystem S.r.l

SELECT *, CASE WHEN desart_anaart LIKE 'vent%%JEEP%%%Grand%%%%%%%%%%%%%%%%Cherokee%%%%%%%�IT%' THEN 'desart_anaart' WHEN codart_anaart LIKE 'vent%%JEEP%%%Grand%%%%%%%%%%%%%%%%Cherokee%%%%%%%�IT%' THEN 'codart_anaart' WHEN codric_anaart LIKE 'vent%%JEEP%%%Grand%%%%%%%%%%%%%%%%Cherokee%%%%%%%�IT%' THEN 'codric_anaart' ELSE 'Nessuna corrispondenza' END AS RicercaCorrispondente FROM anaart WHERE desart_anaart LIKE 'vent%%JEEP%%%Grand%%%%%%%%%%%%%%%%Cherokee%%%%%%%�IT%' OR codart_anaart LIKE 'vent%%JEEP%%%Grand%%%%%%%%%%%%%%%%Cherokee%%%%%%%�IT%' OR codric_anaart LIKE 'vent%%JEEP%%%Grand%%%%%%%%%%%%%%%%Cherokee%%%%%%%�IT%' ORDER BY (precod_anaart = 'DIE'), codart_anaart, datimp_anaart DESC LIMIT 0,10