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