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