SELECT * FROM telecom WHERE 1 AND ((nom_marque LIKE '%genius%carte%' OR reference_photo LIKE '%genius%carte%' OR reference_telecommande LIKE '%genius%carte%') OR (nom_marque LIKE '%genius%' AND (reference_photo LIKE '%carte%' OR reference_telecommande LIKE '%carte%')) OR (nom_marque LIKE '%carte%' AND (reference_photo LIKE '%genius%' OR reference_telecommande LIKE '%genius%')) OR (reference_photo LIKE '%carte%' AND (nom_marque LIKE '%genius%' OR reference_telecommande LIKE '%genius%')) OR (reference_photo LIKE '%genius%' AND (nom_marque LIKE '%carte%' OR reference_telecommande LIKE '%carte%')) OR (reference_telecommande LIKE '%genius%' AND (nom_marque LIKE '%carte%' OR reference_photo LIKE '%carte%')) OR (reference_telecommande LIKE '%carte%' AND (nom_marque LIKE '%genius%' OR reference_photo LIKE '%genius%')) OR (nom_marque LIKE '%carte%genius%' OR reference_photo LIKE '%carte%genius%' OR reference_telecommande LIKE '%carte%genius%') OR (nom_marque LIKE '%carte%' AND (reference_photo LIKE '%genius%' OR reference_telecommande LIKE '%genius%')) OR (nom_marque LIKE '%genius%' AND (reference_photo LIKE '%carte%' OR reference_telecommande LIKE '%carte%')) OR (reference_photo LIKE '%genius%' AND (nom_marque LIKE '%carte%' OR reference_telecommande LIKE '%carte%')) OR (reference_photo LIKE '%carte%' AND (nom_marque LIKE '%genius%' OR reference_telecommande LIKE '%genius%')) OR (reference_telecommande LIKE '%carte%' AND (nom_marque LIKE '%genius%' OR reference_photo LIKE '%genius%')) OR (reference_telecommande LIKE '%genius%' AND (nom_marque LIKE '%carte%' OR reference_photo LIKE '%carte%'))) AND nom_marque<>'ZZZ' AND nom_marque<>'LOT' ORDER BY TEL_ORDRE