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