1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
|
$rq_cpt=odbc_do($conn,"SELECT E7BUZA,DYEVZE,E7B4ZB from osm_option
WHERE (E7BUZA not like 'MODEM1'
and E7BUZA not like 'DSI%'
and E7BUZA not like 'GC%'
and E7BUZA not like 'GF%'
and E7BUZA not like 'GL%'
and E7BUZA not like 'GU%'
and E7BUZA not like 'MMA%'
and E7BUZA not like 'N2%'
and E7BUZA not like 'PNM%'
and E7BUZA not like 'RAB%'
and E7BUZA not like 'RGF%'
and E7BUZA not like 'SPR%'
and E7BUZA not like 'VVMIL%'
and E7BUZA not like 'VPNGAR'
and E7BUZA not like 'SC024'
and E7BUZA not like 'SAE00%'
and E7BUZA not like 'PROVP4'
and E7BUZA not like 'PRM001'
and E7BUZA not like 'PCM024')
AND (DYEVZE not like '%Assistance%'
and DYEVZE not like '%coff.Itin.%'
and DYEVZE not like '%jumelle%'
and DYEVZE not like '%tel%'
and DYEVZE not like '%Achat%'
and DYEVZE not like '%Alcatel%'
and DYEVZE not like '%Pénalités%'
and DYEVZE not like '%TV%'
and DYEVZE not like '%V66%'
and DYEVZE not like '%15 SMS%'
and DYEVZE not like '%changement%'
and DYEVZE not like '%Europe%'
and DYEVZE not like '%bureau mobile%'
and DYEVZE not like '%vocale%'
and DYEVZE not like '%N°CP%'
and DYEVZE not like '%Fun%'
and DYEVZE not like '%présentation%'
and DYEVZE not like '%secret%'
and DYEVZE not like '%répertoire%'
and DYEVZE not like '%IAS%'
and DYEVZE not like '%frais%'
and DYEVZE not like '%seconde'
and DYEVZE not like '%paiement%'
and DYEVZE not like '%SIM%'
and DYEVZE not like '%migration%'
and DYEVZE not like '%RP%'
and DYEVZE not like '%désimlockage%'
and DYEVZE not like '%Cellway%'
and DYEVZE not like '%prêt%'
and DYEVZE not like '%SAV%'
and DYEVZE not like '%VPN juill. 05%'
and DYEVZE not like '%engagement%'
and DYEVZE not like '%engagt%'
and DYEVZE not like '%tél. mobile%'
and DYEVZE not like '%coffret%'
and DYEVZE not like '%fidl%'
and DYEVZE not like '%promo%'
and DYEVZE not like '%Infos%'
and DYEVZE not like '%bienvenue%'
and DYEVZE not like '%promotion%'
and DYEVZE not like '%couverture%' )
AND (E7B4ZB=0 Or E7B4ZB>'$date_jour')
group by DYEVZE,E7BUZA,E7B4ZB"); |
Partager