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