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