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