SELECT c.id_cliente, c.nome_razao, 
c.id_status_cliente AS 'status cli',
**.id_status_plano AS 'statis **',
c.sync_geogrid,
e.id_endereco, e.latitude, e.longitude, e.ativo AS 'end ativo'
FROM radiusnet.cliente c
INNER JOIN radiusnet.geogrid_integrador g ON g.id_geogrid_integrador = c.id_cliente
INNER JOIN radiusnet.endereco e ON e.id_cliente = c.id_cliente
INNER JOIN radiusnet.cliente_has_plano ** ON **.id_cliente = c.id_cliente
WHERE 
c.id_status_cliente IN (1,2,3)
/*
CLIENTE HAS PLANO
id status plano 1 = pendente
id status plano 2 = ativo
id status plano 3 = inativo
id status plano 4 = pre ativo
CLIENTE 
id status cliente 1 = ativo
id status cliente 2 = AVISADO
id status cliente 3 = bloqueado
id status cliente 4 = arquivado
*/ AND
**.id_status_plano IN (1,2,4) AND
e.ativo = 1 AND

/*
lista de id abaixo é da consulta na api do geogrid

curl GET https://zeus.geogridmaps.com.br/rrfiber/api/?exec=7f852198867ffa24fa981c6a7b062d3f8a0cb5dc/clientes/consultar
tras o json com todos os clientes cadastrados no geogrid
*/
c.id_cliente NOT IN (
'222',
'1653',
'3563',
'4327',
'655',
'2073',
'3251',
'2145',
'1847',
'1301',
'3424',
'4533',
'1563',
'1623',
'48',
'336',
'728',
'2705',
'2163',
'4616',
'2105',
'4501',
'1024',
'19',
'1793',
'591',
'396',
'2673',
'4596',
'4444',
'3872',
'1035',
'4617',
'2777',
'1016',
'4036',
'1245',
'3917',
'2733',
'2395',
'3807',
'3203',
'226',
'2665',
'235',
'294',
'78',
'2753',
'3744',
'1999',
'4275',
'1779',
'4467',
'4561',
'2011',
'2287',
'798',
'4421',
'2775',
'690',
'678',
'1589',
'162',
'1645',
'2921',
'630',
'4009',
'277',
'2115',
'954',
'1198',
'4618',
'2679',
'3297',
'2199',
'4394',
'3650',
'4619',
'701',
'4401',
'2941',
'1395',
'2833',
'165',
'3049',
'3570',
'326',
'1755',
'3017',
'1037',
'2677',
'4070',
'3047',
'831',
'2991',
'1549',
'2019',
'647',
'3131',
'986',
'3035',
'1285',
'2159',
'21',
'3554',
'4344',
'2771',
'2783',
'855',
'4540',
'3289',
'64',
'3862',
'4620',
'4621',
'3451',
'3043',
'3572',
'1050',
'668',
'71',
'3309',
'4319',
'1601',
'4281',
'3922',
'3794',
'625',
'136',
'1133',
'3531',
'3510',
'3498',
'1060',
'193',
'104',
'978',
'1469',
'3019',
'4176',
'2089',
'2109',
'1379',
'3896',
'29',
'823',
'2927',
'750',
'4583',
'3332',
'41',
'242',
'4320',
'4572',
'1943',
'1941',
'610',
'3495',
'2023',
'3543',
'1865',
'891',
'245',
'3314',
'4296',
'3449',
'75',
'563',
'3069',
'301',
'2245',
'1739',
'4476',
'114',
'3113',
'129',
'463',
'577',
'3456',
'3173',
'4580',
'1289',
'3727',
'2989',
'3474',
'18',
'3431',
'4251',
'3826',
'2935',
'3378',
'2569',
'597',
'1557',
'4550',
'4622',
'3834',
'92',
'3865',
'1817',
'1098',
'1219',
'2631',
'802',
'3551',
'4514',
'754',
'4623',
'2157',
'1075',
'2711',
'858',
'2707',
'3920',
'1253',
'3750',
'938',
'4589',
'1017',
'1196',
'4049',
'1873',
'1491',
'2055',
'4247',
'3720',
'3972',
'1188',
'4527',
'4624',
'1401',
'4612',
'4615',
'3835',
'3598',
'3737',
'4518',
'4625',
'2243',
'3267',
'317',
'3752',
'2075',
'3530',
'3201',
'398',
'4626',
'2999',
'2813',
'4627',
'3577',
'112',
'2761',
'2187',
'2443',
'1212',
'4515',
'4606',
'4608',
'2183',
'2329',
'2575',
'3829',
'1693',
'2565',
'916',
'905',
'3453',
'4556',
'4007',
'4114',
'4075',
'4628',
'3677',
'3149',
'878',
'715',
'1757',
'4465',
'1014',
'13',
'2859',
'465',
'147',
'4307',
'1603',
'1791',
'3586',
'1927',
'3803',
'2853',
'1769',
'4629',
'3605',
'738',
'1343',
'4137',
'4278',
'25',
'875',
'4630',
'495',
'4565',
'15',
'2197',
'237',
'3430',
'4332',
'52',
'357',
'3624',
'3466',
'779',
'502',
'4095',
'23',
'3735',
'3676',
'4220',
'2217',
'2309',
'3709',
'879',
'3765',
'4597',
'4454',
'4440',
'3827',
'4631',
'1157',
'4313',
'3039',
'3015',
'3005',
'2693',
'1889',
'2149',
'1879',
'1641',
'1321',
'1210',
'1130',
'1127',
'930',
'866',
'756',
'581',
'419',
'302',
'142',
'107',
'79',
'47',
'2',
'4632',
'3429',
'455',
'1150',
'658',
'4633',
'85',
'3984',
'192',
'3489',
'4516',
'585',
'557',
'3293',
'3780',
'219',
'1543',
'236',
'2339',
'1467',
'4045',
'4551',
'81',
'3779',
'3025',
'3603',
'163',
'1605',
'1307',
'2719',
'4634',
'4560',
'2845',
'4369',
'713',
'641',
'4025',
'3792',
'1191',
'1555',
'4635',
'4353',
'4482',
'3682',
'685',
'156',
'3867',
'720',
'3736',
'4636',
'598',
'4011',
'1489',
'4198',
'4637',
'1679',
'2261',
'4536',
'3634',
'3595',
'4461',
'601',
'3083',
'3087',
'3091',
'3081',
'3085',
'3089',
'3095',
'3077',
'3093',
'4484',
'593',
'3981',
'829',
'298',
'1311',
'773',
'274',
'707',
'2079',
'90',
'4164',
'4405',
'3795',
'2388',
'2763',
'2025',
'4522',
'1005',
'3954',
'4638',
'4639',
'2361',
'4640',
'2295',
'4523',
'2173',
'3855',
'3370',
'4289',
'4641',
'1003',
'3343',
'2229',
'9',
'35',
'62',
'82',
'97',
'101',
'109',
'110',
'111',
'117',
'311',
'4395',
'4250',
'4234',
'4207',
'4201',
'3847',
'4184',
'4178',
'4115',
'4642',
'272',
'4073',
'3778',
'3621',
'3581',
'1711',
'3559',
'3556',
'3541',
'3502',
'3496',
'3487',
'3484',
'3445',
'3436',
'3433',
'3432',
'3426',
'3413',
'3406',
'3404',
'548',
'3247',
'3848',
'3637',
'3403',
'3400',
'3394',
'3399',
'3387',
'3385',
'3384',
'3383',
'3371',
'3369',
'1375',
'4575',
'3582',
'2511',
'2111',
'3362',
'3359',
'3352',
'3345',
'3295',
'2865',
'2657',
'3348',
'2651',
'2641',
'2633',
'2625',
'2593',
'2581',
'2579',
'2567',
'2557',
'2551',
'2549',
'2547',
'2537',
'2533',
'2531',
'2525',
'2519',
'2517',
'2515',
'2509',
'2505',
'2493',
'2487',
'2485',
'2477',
'2465',
'2459',
'2455',
'2433',
'2415',
'2411',
'2393',
'2391',
'2382',
'2373',
'2369',
'2367',
'2353',
'2341',
'2315',
'2311',
'2277',
'2253',
'2247',
'2211',
'2185',
'2127',
'1877',
'1577',
'1863',
'1535',
'1517',
'1511',
'1505',
'1485',
'1481',
'1465',
'1459',
'1455',
'1453',
'1449',
'1441',
'1435',
'1429',
'1413',
'1409',
'1403',
'1389',
'1383',
'1373',
'1371',
'1369',
'1365',
'1363',
'1357',
'1349',
'1347',
'1337',
'1327',
'1315',
'315',
'1305',
'1297',
'1295',
'1287',
'1279',
'1267',
'1265',
'1257',
'1243',
'1083',
'987',
'982',
'4286',
'1041',
'3891',
'4480',
'1673',
'955',
'953',
'952',
'950',
'944',
'941',
'940',
'937',
'933',
'931',
'929',
'926',
'3672',
'925',
'703',
'924',
'920',
'918',
'917',
'907',
'904',
'903',
'899',
'896',
'892',
'887',
'863',
'770',
'710',
'862',
'777',
'569',
'560',
'559',
'540',
'535',
'533',
'532',
'521',
'518',
'517',
'3899',
'508',
'507',
'503',
'499',
'496',
'493',
'486',
'484',
'482',
'481',
'480',
'473',
'471',
'464',
'461',
'459',
'453',
'449',
'448',
'443',
'442',
'440',
'433',
'432',
'425',
'423',
'422',
'1925',
'412',
'410',
'393',
'375',
'372',
'371',
'361',
'354',
'333',
'327',
'319',
'4040',
'3467',
'1215',
'468',
'4087',
'2829',
'833',
'2029',
'4643',
'4208',
'2179',
'169',
'1553',
'3243',
'4288',
'4483',
'820',
'3831',
'3448',
'1026',
'4605',
'4273',
'3183',
'3843',
'4614',
'839',
'2091',
'4570',
'4609',
'1176',
'1',
'3',
'12',
'26',
'28',
'39',
'3181',
'57',
'300',
'72',
'73',
'77',
'102',
'4644',
'103',
'3771',
'105',
'146',
'394',
'2165',
'3342',
'3562',
'958',
'4054',
'3854',
'280',
'1823',
'2795',
'3632',
'1008',
'170',
'180',
'509',
'853',
'213',
'4013',
'4030',
'259',
'4414',
'1897',
'3574',
'16',
'309',
'312',
'31',
'30',
'4645',
'3804',
'4646',
'4477',
'2281',
'3850',
'133',
'130',
'1985',
'1323',
'4647',
'4648',
'4068',
'3964',
'4362',
'3828',
'3227',
'3811',
'1717',
'3818',
'3693',
'3388',
'173',
'1829',
'3904',
'3787',
'2289',
'4367',
'3812',
'3441',
'4649',
'3730',
'1095',
'2901',
'485',
'561',
'3768',
'4650',
'181',
'4456',
'4651',
'1559',
'4652',
'919',
'22',
'32',
'43',
'45',
'4653',
'3129',
'53',
'1068',
'4654',
'3161',
'1629',
'1229',
'1143',
'4047',
'67',
'69',
'1066',
'4655',
'70',
'74',
'76',
'87',
'91',
'93',
'3897',
'1733',
'2377',
'2535',
'3908',
'99',
'132',
'144',
'150',
'3762',
'153',
'157',
'158',
'167',
'175',
'183',
'191',
'3895',
'4452',
'1607',
'4343',
'1101',
'3937',
'4271',
'4213',
'4191',
'4138',
'1103',
'2061',
'3105',
'1787',
'196',
'199',
'209',
'210',
'212',
'218',
'221',
'4110',
'2495',
'1057',
'234',
'247',
'248',
'255',
'265',
'2021',
'282',
'408',
'2589',
'626',
'3617',
'273',
'3659',
'296',
'3011',
'611',
'4656',
'286',
'287',
'291',
'295',
'2203',
'4305',
'324',
'1457',
'3821',
'1019',
'338',
'344',
'345',
'347',
'355',
'4657',
'3316',
'4658',
'4173',
'4659',
'3365',
'2961',
'2741',
'4382',
'2851',
'4507',
'3630',
'1763',
'3307',
'3407',
'3869',
'3245',
'895',
'2967',
'4140',
'2645',
'1007',
'994',
'3959',
'1153',
'3221',
'1529',
'4204',
'4660',
'3858',
'1447',
'1138',
'740',
'2007',
'3909',
'330',
'4152',
'1617',
'3473',
'2265',
'4661',
'3824',
'4662',
'766',
'1273',
'624',
'382',
'792',
'2617',
'4663',
'4001',
'4429',
'4664',
'395',
'3860',
'1423',
'956',
'2793',
'3291',
'3819',
'3629',
'3742',
'3889',
'3885',
'4359',
'1461',
'3452',
'2523',
'3469',
'3689',
'4665',
'3509',
'3508',
'3189',
'1961',
'360',
'4506',
'2985',
'3334',
'3856',
'4666',
'4365',
'538',
'3702',
'3171',
'981',
'3988',
'2731',
'964',
'1483',
'633',
'4520',
'2879',
'20',
'3021',
'3890',
'4113',
'4599',
'4072',
'3177',
'4497',
'2691',
'4568',
'4156',
'4541',
'3805',
'1077',
'1078',
'1080',
'1082',
'1093',
'1102',
'1106',
'1108',
'1111',
'1112',
'1114',
'1116',
'1121',
'1137',
'1142',
'1145',
'1147',
'1156',
'1162',
'1166',
'1173',
'3823',
'3249',
'3901',
'1965',
'3881',
'4574',
'4667',
'3939',
'2219',
'4029',
'3071',
'4668',
'3287',
'935',
'477',
'4669',
'2855',
'3766',
'2457',
'3418',
'2215',
'1720',
'4670',
'3774',
'734',
'3969',
'3308',
'4010',
'4547',
'3925',
'1209',
'4510',
'3786',
'4366',
'4360',
'2233',
'1591',
'4671',
'4263',
'4162',
'4519',
'2483',
'4672',
'744',
'4256',
'4673',
'4674',
'2555',
'4517',
'4675',
'4676',
'4403',
'2380',
'4677',
'1054',
'1807',
'3602',
'4678',
'4422',
'961',
'1561',
'4420',
'409',
'3460',
'4071',
'1987',
'898',
'4488',
'967',
'4559',
'450',
'3864',
'4530',
'4679',
'3900',
'4680',
'2507',
'3639',
'2379',
'233',
'4192',
'3871',
'3882',
'3883',
'4681',
'4682',
'4373',
'4274',
'4018',
'3886',
'1475',
'1069',
'4683',
'4684',
'4685',
'3757',
'4211',
'3938',
'3813',
'4686',
'3799',
'1825',
'2331',
'3315',
'2151',
'3590',
'622',
'3875',
'4447',
'3887',
'661',
'4134',
'3609',
'3844',
'2805',
'3670',
'1039',
'4012',
'4309',
'3257',
'2431',
'1771',
'1867',
'2623',
'3361',
'3141',
'3165',
'3694',
'1214',
'4687',
'2461',
'3464',
'3536',
'3704',
'3936',
'3360',
'4564',
'912',
'4688',
'4689',
'4498',
'4690',
'727',
'3905',
'4691',
'1523',
'4505',
'4435',
'4692',
'4693',
'4694',
'4695',
'1749',
'4696',
'4697',
'4393',
'4698',
'3033',
'4699',
'3877',
'4700',
'3919',
'1703',
'2721',
'4093',
'3635',
'522',
'2299',
'639',
'1182',
'1192',
'1194',
'1197',
'1200',
'1202',
'1203',
'1205',
'1206',
'1208',
'1220',
'1222',
'1223',
'1231',
'1237',
'1259',
'1261',
'1281',
'1283',
'1293',
'1299',
'1303',
'1319',
'1325',
'1329',
'1331',
'1335',
'1345',
'1361',
'1351',
'1367',
'1387',
'1419',
'1421',
'1425',
'1437',
'1439',
'1445',
'1451',
'1471',
'1477',
'1493',
'1499',
'1501',
'1507',
'1509',
'1513',
'1527',
'4472',
'1545',
'1565',
'1575',
'1593',
'1595',
'1609',
'1611',
'1621',
'1627',
'1635',
'4701',
'4702',
'4703',
'3421',
'3863',
'4470',
'4006',
'4081',
'3729',
'3866',
'3027',
'1881',
'4101',
'3079',
'3099',
'3137',
'3169',
'3631',
'3339',
'3992',
'3788',
'3962',
'4163',
'4150',
'4464',
'977',
'3967',
'3151',
'808',
'4311',
'2131',
'3903',
'1033',
'783',
'3983',
'4704',
'2669',
'1009',
'3153',
'3911',
'1643',
'1647',
'1649',
'1651',
'1657',
'1661',
'1669',
'1671',
'1675',
'1677',
'4705',
'1789',
'4706',
'4707',
'4708',
'612',
'1839',
'3995',
'692',
'737',
'2175',
'4535',
'3957',
'3978',
'152',
'3857',
'2355',
'3916',
'2313',
'3482',
'4153',
'4109',
'3479',
'4611',
'385',
'4709',
'562',
'1012',
'859',
'1683',
'1695',
'1715',
'1719',
'1723',
'1727',
'1729',
'1731',
'1743',
'1747',
'849',
'4710',
'3504',
'3350',
'686',
'4381',
'2045',
'3215',
'4086',
'4711',
'4712',
'4713',
'4098',
'2481',
'2899',
'4017',
'401',
'3994',
'435',
'4267',
'4027',
'2107',
'4014',
'3319',
'3349',
'4714',
'2409',
'1001',
'66',
'4037',
'1993',
'3304',
'4715',
'4716',
'2629',
'3960',
'3420',
'3279',
'1059',
'4106',
'3913',
'3281',
'3949',
'4569',
'3830',
'3815',
'3336',
'3355',
'4224',
'4717',
'4718',
'765',
'3652',
'4326',
'3935',
'2943',
'4232',
'3500',
'3726',
'4719',
'813',
'2449',
'1785',
'4720',
'3368',
'4033',
'3974',
'4056',
'4613',
'3366',
'3231',
'4721',
'4722',
'3411',
'4723',
'911',
'3955',
'4724',
'189',
'4725',
'4002',
'1168',
'3963',
'3747',
'3622',
'2931',
'4726',
'4107',
'3354',
'3525',
'4727',
'3483',
'654',
'4728',
'3414',
'4729',
'3679',
'4151',
'1011',
'3199',
'4227',
'3998',
'4730',
'3611',
'4731',
'3187',
'4732',
'723',
'4733',
'4026',
'4734',
'4425',
'3233',
'4735',
'4736',
'3539',
'2357',
'4737',
'3980',
'4738',
'2969',
'3982',
'4739',
'4740',
'4741',
'4742',
'4743',
'3255',
'4744',
'2471',
'3968',
'799',
'4745',
'4746',
'4391',
'825',
'4747',
'4748',
'3952',
'4749',
'4269',
'4750',
'3253',
'4751',
'3163',
'4752',
'4753',
'884',
'3511',
'3613',
'4754',
'3914',
'3061',
'3950',
'4092',
'3921',
'4755',
'4756',
'4757',
'288',
'4758',
'2327',
'900',
'4120',
'4759',
'3690',
'4760',
'4034',
'4761',
'4762',
'2205',
'2147',
'4763',
'2619',
'4351',
'4764',
'4022',
'4200',
'4765',
'4766',
'4767',
'4768',
'3367',
'3686',
'4126',
'4769',
'4262',
'4770',
'4496',
'2681',
'4368',
'4005',
'4771',
'2917',
'3575',
'4772',
'3894',
'4773',
'3989',
'4062',
'2529',
'4774',
'3341',
'3649',
'4775',
'1967',
'4776',
'3408',
'4777',
'3395',
'4778',
'2085',
'4779',
'4780',
'4781',
'3947',
'4782',
'4783',
'4784',
'3934',
'2125',
'4475',
'947',
'4306',
'4312',
'4785',
'3718',
'4786',
'2749',
'4787',
'3851',
'4788',
'3997',
'2979',
'3481',
'4789',
'4790',
'881',
'3391',
'4525',
'3941',
'3956',
'2635',
'835',
'4791',
'3516',
'3305',
'386',
'2371',
'4792',
'4504',
'3912',
'4793',
'4020',
'3564',
'3377',
'2965',
'3197',
'949',
'3109',
'4315',
'2343',
'2909',
'4794',
'3951',
'4795',
'1064',
'2919',
'1053',
'2345',
'4179',
'4038',
'1681',
'4796',
'4797',
'2803',
'3874',
'4557',
'4798',
'3753',
'4799',
'2475',
'4800',
'3739',
'4493',
'4222',
'4801',
'3123',
'3285',
'4802',
'4549',
'4803',
'3328',
'4804',
'3405',
'4805',
'4806',
'4044',
'3259',
'4807',
'1773',
'456',
'3338',
'1849',
'3646',
'927',
'2849',
'2807',
'2815',
'2819',
'2823',
'2831',
'2839',
'2841',
'2843',
'2861',
'2863',
'2869',
'2883',
'2885',
'2893',
'2929',
'2947',
'2949',
'2973',
'2981',
'2993',
'2971',
'3001',
'3003',
'3031',
'4808',
'751',
'3323',
'3263',
'4521',
'3838',
'4809',
'989',
'4810',
'3673',
'4811',
'4171',
'3703',
'4236',
'3356',
'3961',
'2997',
'4812',
'4083',
'669',
'3347',
'3458',
'4532',
'4813',
'3683',
'3651',
'4111',
'4225',
'1995',
'2857',
'3820',
'4814',
'3987',
'4588',
'4050',
'1385',
'4815',
'3898',
'1034',
'4816',
'4817',
'377',
'4491',
'3893',
'4818',
'4300',
'4819',
'4820',
'4821',
'3225',
'4822',
'4055',
'4823',
'948',
'4824',
'4595',
'4028',
'778',
'4825',
'4826',
'2101',
'4827',
'4828',
'3973',
'1189',
'4829',
'3654',
'1042',
'976',
'3219',
'475',
'4370',
'3688',
'2097',
'4830',
'4831',
'4080',
'4832',
'4833',
'3159',
'3927',
'3798',
'4834',
'3340',
'566',
'4835',
'4836',
'2269',
'4837',
'809',
'4298',
'4469',
'3322',
'3389',
'4838',
'3666',
'4839',
'980',
'4143',
'4840',
'2065',
'4259',
'4841',
'4842',
'2637',
'2077',
'4843',
'4144',
'4844',
'3825',
'4845',
'4846',
'2643',
'3971',
'4847',
'3966',
'3743',
'3892',
'4848',
'4260',
'4849',
'4850',
'4851',
'3589',
'4852',
'4853',
'4854',
'3754',
'4855',
'4096',
'4856',
'4857',
'4858',
'4859',
'4860',
'4861',
'4862',
'3450',
'722',
'4863',
'2445',
'4864',
'4865',
'4099',
'4866',
'376',
'4867',
'4069',
'3979',
'4868',
'2241',
'438',
'4869',
'4870',
'4871',
'971',
'4135',
'4094',
'2587',
'3321',
'3317',
'4872',
'4873',
'4874',
'4875',
'4876',
'4877',
'4878',
'4879',
'840',
'4145',
'638',
'4463',
'539',
'4880',
'4881',
'4374',
'3472',
'797',
'3311',
'4882',
'4226',
'4292',
'2607',
'4883',
'4884',
'2889',
'3459',
'2167',
'445',
'564',
'4245',
'4230',
'901',
'3470',
'2503',
'3535',
'2169',
'3587',
'1048',
'4885',
'4886',
'3398',
'921',
'4272',
'4411',
'3447',
'4276',
'1032',
'3642',
'4091',
'4205',
'2577',
'4324',
'4231',
'4318',
'4887',
'4039',
'2133',
'4888',
'3273',
'1845',
'4132',
'429',
'4210',
'1851',
'4889',
'4890',
'3313',
'4203',
'894',
'4449',
'4249',
'4258',
'4891',
'3330',
'4892',
'4371',
'4212',
'4893',
'3915',
'902',
'3684',
'4894',
'4895',
'4189',
'4185',
'4147',
'2469',
'4243',
'4330',
'4896',
'1861',
'3239',
'4308',
'4897',
'426',
'4898',
'3692',
'4241',
'776',
'4899',
'4216',
'4252',
'2701',
'4900',
'4901',
'4902',
'351',
'4903',
'4904',
'4304',
'3337',
'4160',
'4434',
'3097',
'4257',
'4905',
'4906',
'3471',
'4907',
'4908',
'996',
'3491',
'3477',
'4909',
'4910',
'3601',
'3701',
'3119',
'1018',
'3942',
'4911',
'3991',
'4912',
'4913',
'4914',
'2727',
'553',
'3478',
'4915',
'4916',
'4917',
'4918',
'4919',
'4410',
'4218',
'3423',
'4356',
'4920',
'3626',
'4133',
'2553',
'1933',
'1931',
'4921',
'3520',
'1989',
'4922',
'4194',
'4923',
'4924',
'3930',
'4552',
'2767',
'3057',
'4581',
'4008',
'3335',
'670',
'4122',
'3929',
'4925',
'2059',
'4926',
'4927',
'771',
'4239',
'4000',
'844',
'3490',
'4928',
'3902',
'4929',
'4244',
'4930',
'4328',
'945',
'3428',
'4078',
'3540',
'3155',
'4303',
'4128',
'3412',
'979',
'652',
'2407',
'4323',
'4931',
'3784',
'4404',
'4932',
'4238',
'4933',
'3513',
'4934',
'4317',
'4935',
'883',
'1079',
'4314',
'4302',
'4936',
'3310',
'3501',
'4937',
'4337',
'4938',
'946',
'4333',
'3928',
'3475',
'2321',
'1973',
'225',
'241',
'411',
'413',
'421',
'547',
'549',
'551',
'558',
'699',
'774',
'822',
'834',
'984',
'1020',
'1038',
'1801',
'1827',
'1899',
'1905',
'1917',
'1921',
'1953',
'2043',
'2333',
'2389',
'2403',
'2413',
'2439',
'2447',
'2463',
'2653',
'2667',
'2713',
'2735',
'2797',
'2827',
'3055',
'3115',
'3143',
'3261',
'3275',
'3312',
'3318',
'3327',
'3331',
'3372',
'3374',
'3376',
'3386',
'3390',
'3392',
'3415',
'3435',
'3446',
'3465',
'3485',
'3486',
'3488',
'3492',
'3512',
'3514',
'3518',
'3521',
'3527',
'3553',
'3557',
'3558',
'3560',
'3576',
'3591',
'3592',
'3596',
'3600',
'3604',
'3615',
'3625',
'3633',
'3647',
'3668',
'3698',
'3706',
'3712',
'3713',
'3715',
'3719',
'3725',
'3731',
'3732',
'3751',
'3767',
'3769',
'3773',
'3781',
'3837',
'3840',
'3868',
'3910',
'3931',
'3933',
'4032',
'4041',
'4046',
'4061',
'4112',
'4123',
'4124',
'4130',
'4146',
'4148',
'4149',
'4167',
'4172',
'4180',
'4182',
'4195',
'4202',
'4214',
'4219',
'4254',
'4280',
'4290',
'4295',
'4316',
'4321',
'4335',
'4338',
'4339',
'4340',
'4345',
'4346',
'4347',
'4348',
'4355',
'4357',
'4375',
'4378',
'4383',
'4385',
'4386',
'4389',
'4392',
'4396',
'4398',
'4409',
'4416',
'4423',
'4424',
'4426',
'4432',
'4437',
'4441',
'4442',
'4443',
'4446',
'4448',
'4450',
'4453',
'4455',
'4457',
'4458',
'4459',
'4460',
'4462',
'4473',
'4474',
'4478',
'4485',
'4486',
'4487',
'4494',
'4495',
'4500',
'4502',
'4513',
'4524',
'4528',
'4529',
'4537',
'4538',
'4545',
'4546',
'4553',
'4554',
'4555',
'4558',
'4566',
'4567',
'4573',
'4578',
'4582',
'4584',
'4585',
'4586',
'4587',
'4591',
'4593',
'4600',
'4603',
'3437',
'4342',
'4331',
'472',
'506',
'4174',
'872',
'4939',
'4940',
'4941',
'4229',
'4942',
'2437',
'4246',
'4310',
'4377',
'4943',
'4944',
'4945',
'4946',
'397',
'414',
'632',
'4125',
'2387',
'4155',
'3503',
'3476',
'4947',
'4301',
'4948',
'437',
'4949',
'526',
'3277',
'4127',
'4430',
'4950',
'3416',
'4951',
'4084',
'4466',
'4952',
'1199',
'139',
'3139',
'645',
'4372',
'4402',
'570',
'4364',
'3524',
'4277',
'4433',
'4412',
'3443',
'4953',
'4954',
'3641',
'4955',
'2451',
'4363',
'1957',
'3497',
'4388',
'513',
'4268',
'4956',
'4576',
'867',
'2725',
'4957',
'827',
'3462',
'2773',
'4287',
'4428',
'4958',
'4445',
'3859',
'4959',
'1333',
'4283',
'4960',
'4961',
'3493',
'4438',
'4270',
'4962',
'4963',
'4964',
'3619',
'4965',
'4966',
'2405',
'643',
'4967',
'4968',
'4969',
'3397',
'716',
'4970',
'4076',
'4971',
'4590',
'4972',
'4973',
'530',
'3357',
'3853',
'4974',
'4975',
'943',
'4976',
'4977',
'4358',
'4190',
'4598',
'1959',
'2189',
'4978',
'4979',
'4980',
'4354',
'4981',
'1397',
'993',
'4982',
'3329',
'1044',
'4492',
'4399',
'4983',
'4349',
'3528',
'828',
'4031',
'592',
'4984',
'178',
'4985',
'3538',
'4121',
'3662',
'4986',
'4987',
'4988',
'1835',
'1113',
'4108',
'2663',
'556',
'3710',
'923',
'843',
'4499',
'3306',
'4989',
'4990',
'184',
'2597',
'4503',
'4991',
'3655',
'2223',
'524',
'4992',
'4993',
'4994',
'3802',
'3608',
'4415',
'4995',
'4284',
'4996',
'4997',
'4998',
'3434',
'4999',
'4136',
'3550',
'4417',
'3344',
'4481',
'5001',
'5003',
'2317',
'5005',
'3454',
'3499',
'4334',
'3468',
'4406',
'1015',
'5007',
'514',
'4431',
'5009',
'5011',
'3117',
'4051',
'5013',
'3616',
'3717',
'4350',
'4489',
'5015',
'5017',
'3588',
'5019',
'5021',
'968',
'2381',
'5023',
'629',
'5025',
'3597',
'5027',
'3685',
'5029',
'4400',
'3009',
'3653',
'5031',
'5033',
'4177',
'5035',
'5037',
'5039',
'3614',
'3996',
'5041',
'5043',
'963',
'5045',
'990',
'5047',
'5049',
'889',
'5051',
'5053',
'972',
'3494',
'5055',
'4509',
'2489',
'2599',
'5057',
'5059',
'5061',
'3533',
'4057',
'5063',
'5065',
'5067',
'5069',
'2003',
'4291',
'4102',
'5071',
'5073',
'5075',
'3185',
'2081',
'3656',
'3948',
'2787',
'3333',
'4077',
'4427',
'3565',
'5077',
'457',
'3636',
'5079',
'5081',
'5083',
'5085',
'5087',
'5089',
'5091',
'5093',
'4390',
'3763',
'5095',
'2378',
'3714',
'3801',
'5099',
'5101',
'5103',
'4352',
'1895',
'3438',
'5105',
'4610',
'5107',
'5109',
'5111',
'5113',
'5115',
'4534',
'5117',
'5119',
'5121',
'3707',
'3547',
'4531',
'4592',
'5123',
'3738',
'466',
'3599',
'5125',
'5127',
'745',
'3579',
'3627',
'3127',
'5129',
'5131',
'4526',
'5133',
'5135',
'5137',
'4577',
'4235',
'635',
'3680',
'5139',
'370',
'743',
'1062',
'4063',
'5141',
'528',
'3583',
'5143',
'5145',
'4542',
'806',
'3777',
'5147',
'4181',
'4543',
'5149',
'3687',
'5151',
'3879',
'5153',
'5155',
'5157',
'5159',
'3101',
'44',
'5161',
'5163',
'2037',
'3839',
'5165',
'5167',
'3658',
'5169',
'3975',
'5171',
'5173',
'5175',
'5177',
'5179',
'3749',
'5181',
'5183',
'3759',
'5185',
'5187',
'5189',
'5191',
'5193',
'790',
'5195',
'5197',
'5199',
'5201',
'5203',
'5205',
'5207',
'5209',
'5211',
'5213',
'5215',
'3841',
'4468',
'5217',
'342',
'5219',
'1251',
'5221',
'788',
'4594',
'5223',
'5225',
'5227',
'2251',
'5229',
'4341',
'5231',
'5233',
'3555',
'3699',
'4604',
'3808',
'5234',
'3147',
'4579',
'656',
'5235',
'5237',
'1027',
'56',
'3764',
'3700',
'4563',
'5239',
'4562',
'5241',
'5243',
'575',
'5245',
'3007',
'5247',
'5249',
'5251',
'5253',
'3620',
'3861',
'4085',
'5255',
'5257',
'520',
'4169',
'583',
'787',
'3888',
'4048',
'5259',
'5261',
'5263',
'5265',
'3567',
'1705',
'2139',
'5267',
'3806',
'5269',
'3325',
'5271',
'5273',
'3797',
'2435',
'5275',
'3816',
'5277',
'5279',
'334',
'4215',
'2739',
'1072',
'2871',
'726',
'2123',
'3195',
'5281',
'2473',
'936',
'4512',
'3207',
'5283',
'5285',
'5287',
'3976',
'5289',
'5291',
'5293',
'3918',
'5295',
'5297',
'2121',
'4067',
'5299',
'5301',
'5303',
'4066',
'5305',
'455',
'5307',
'3878',
'5309',
'5311',
'5313',
'5315',
'5317',
'5319',
'5321',
'5323',
'4161',
'5325',
'5327',
'5329',
'5331',
'5333',
'5335',
'5337',
'5339',
'3945',
'5341',
'5343',
'995',
'5345',
'5347',
'5349',
'5351',
'5353',
'5355',
'4089',
'4233',
'4197',
'5357',
'5359',
'5361',
'5363',
'5365',
'5367',
'5369',
'5371',
'5373',
'5375',
'5377',
'5379',
'5381',
'5383',
'5385',
'5387',
'5389',
'5391',
'5393',
'3663',
'5395',
'2001',
'851',
'5397',
'5399',
'3566',
'5401',
'5403',
'5405',
'5407',
'5409',
'510',
'5411',
'1761',
'5413',
'5415',
'5417',
'5419',
'5421',
'693',
'2271',
'5423',
'5425',
'5427',
'5429',
'5431',
'5433',
'5435',
'5437',
'5439',
'3346',
'5441',
'5443',
'5445',
'3326',
'5447',
'5449',
'5451',
'5453',
'5455',
'5457',
'5459',
'5461',
'2285',
'5463',
'4221',
'5465',
'5467',
'3728',
'5469',
'5471',
'5473',
'5475',
'4088',
'5477',
'5479',
'5481',
'5483',
'5485',
'5487',
'5489',
'5491',
'4188',
'5493',
'5495',
'5497',
'5499',
'5501',
'5503',
'5505',
'5507',
'5509',
'5511',
'5513',
'5515',
'5517',
'5519',
'5521',
'5523',
'5525',
'5527',
'4170',
'5529'
)
AND e.latitude  <> ''
GROUP BY e.id_endereco
ORDER BY c.id_cliente asc