/*	A revoir car marche pas bien	*/

SELECT DISTINCT CLI.TIERS, CLI.NOM 
FROM CARTOFLEX.dbo.CLI CLI, CARTOFLEX.dbo.ENT ENT, CARTOFLEX.dbo.T2 T2, CARTOFLEX.dbo.TABLE_TITRE_RAISON_SOCIALE_V TABLE_TITRE_RAISON_SOCIALE_V
WHERE ENT.TIERS = CLI.TIERS AND T2.DOS = CLI.DOS AND T2.TIERS = CLI.TIERS 
AND TABLE_TITRE_RAISON_SOCIALE_V.DOSC = CLI.DOS AND TABLE_TITRE_RAISON_SOCIALE_V.TITRE = CLI.TIT 
AND ((CLI.DOS='1') AND (ENT.PIDT>'2020-12-31') AND (ENT.CE4='1')) 
AND (CLI.NOM LIKE '%A2E%' OR CLI.NOM LIKE '%ALTRICS%' OR CLI.NOM LIKE '%OSE%' 
OR CLI.NOM LIKE '%ACCELONIX%' 
OR CLI.NOM LIKE '%ACEA%' 
OR CLI.NOM LIKE '%ADEX ELECTRONIQUE%' 
OR CLI.NOM LIKE '%ALCYON ELECTRONIQUE%' 
OR CLI.NOM LIKE '%ALLIANSYS%' 
OR CLI.NOM LIKE '%ALTRICS%' 
OR CLI.NOM LIKE '%CANON BRETAGNE%' 
OR CLI.NOM LIKE '%CEISTA INTERNATIONAL%' 
OR CLI.NOM LIKE '%CORDON CMS%' 
OR CLI.NOM LIKE '%CREATIVE EURECOM%' 
OR CLI.NOM LIKE '%ESTELEC%' 
OR CLI.NOM LIKE '%EUROPLACER INDUSTRIE%' 
OR CLI.NOM LIKE '%FIRST INDUSTRIES%' 
OR CLI.NOM LIKE '%G4 SOURCING%' 
OR CLI.NOM LIKE '%GERAL%' 
OR CLI.NOM LIKE '%GROUPE ZEKAT%' 
OR CLI.NOM LIKE '%IFTEC%' 
OR CLI.NOM LIKE '%IPC CONCOURS DE BRASAGE%' 
OR CLI.NOM LIKE '%JFIE%' 
OR CLI.NOM LIKE '%KURTZ ERSA FRANCE%' 
OR CLI.NOM LIKE '%LAUDREN%' 
OR CLI.NOM LIKE '%METRONELEC%' 
OR CLI.NOM LIKE '%OC2I%' 
OR CLI.NOM LIKE '%ODU FRANCE%' 
OR CLI.NOM LIKE '%OEM INDUSTRY%' 
OR CLI.NOM LIKE '%PHOENIX CONTACT%' 
OR CLI.NOM LIKE '%PIM INDUSTRIE%' 
OR CLI.NOM LIKE '%SAFE PCB%' 
OR CLI.NOM LIKE '%SECTRONIC%' 
OR CLI.NOM LIKE '%SEICA FRANCE%' 
OR CLI.NOM LIKE '%SEICO%' 
OR CLI.NOM LIKE '%SN SERITECH%' 
OR CLI.NOM LIKE '%SOUDOTIQUE%' 
OR CLI.NOM LIKE '%SYNOV%' 
OR CLI.NOM LIKE '%VILLELEC%' )







SELECT DISTINCT CLI.TIERS, CLI.NOM, CLI.REPR_0001 
FROM CARTOFLEX.dbo.CLI CLI 
WHERE CLI.REPR_0001 <> 'ACS' 
AND (CLI.NOM LIKE '%A2E%' 
OR CLI.NOM LIKE '%ACCELONIX%' 
OR CLI.NOM LIKE '%ACEA%' 
OR CLI.NOM LIKE '%ADEX ELECTRONIQUE%' 
OR CLI.NOM LIKE '%ALCYON ELECTRONIQUE%' 
OR CLI.NOM LIKE '%ALLIANSYS%' 
OR CLI.NOM LIKE '%ALTRICS%' 
OR CLI.NOM LIKE '%CANON BRETAGNE%' 
OR CLI.NOM LIKE '%CEISTA INTERNATIONAL%' 
OR CLI.NOM LIKE '%CORDON CMS%' 
OR CLI.NOM LIKE '%CREATIVE EURECOM%' 
OR CLI.NOM LIKE '%ESTELEC%' 
OR CLI.NOM LIKE '%EUROPLACER INDUSTRIE%' 
OR CLI.NOM LIKE '%FIRST INDUSTRIES%' 
OR CLI.NOM LIKE '%G4 SOURCING%' 
OR CLI.NOM LIKE '%GERAL%' 
OR CLI.NOM LIKE '%GROUPE ZEKAT%' 
OR CLI.NOM LIKE '%IFTEC%' 
OR CLI.NOM LIKE '%IPC CONCOURS DE BRASAGE%' 
OR CLI.NOM LIKE '%JFIE%' 
OR CLI.NOM LIKE '%KURTZ ERSA FRANCE%' 
OR CLI.NOM LIKE '%LAUDREN%' 
OR CLI.NOM LIKE '%METRONELEC%' 
OR CLI.NOM LIKE '%OC2I%' 
OR CLI.NOM LIKE '%ODU FRANCE%' 
OR CLI.NOM LIKE '%OEM INDUSTRY%' 
OR CLI.NOM LIKE '%OSE%' 
OR CLI.NOM LIKE '%PHOENIX CONTACT%' 
OR CLI.NOM LIKE '%PIM INDUSTRIE%' 
OR CLI.NOM LIKE '%SAFE PCB%' 
OR CLI.NOM LIKE '%SECTRONIC%' 
OR CLI.NOM LIKE '%SEICA FRANCE%' 
OR CLI.NOM LIKE '%SEICO%' 
OR CLI.NOM LIKE '%SN SERITECH%' 
OR CLI.NOM LIKE '%SOUDOTIQUE%' 
OR CLI.NOM LIKE '%SYNOV%' 
OR CLI.NOM LIKE '%VILLELEC%' )