SELECT COUNT(id) FROM empresa.empresa WHERE (situacao = 'ATIVA') AND (quantidade_funcionario BETWEEN '29' AND '1000') AND (cnae_primario IN ('0891600','1013901','1020102','1031700','1032501','1032599','1033301','1033302','1041400','1042200','1043100','1052000','1053800','1061902','1062700','1063500','1064300','1065101','1065102','1065103','1066000','1066000','1069400','1071600','1072401','1072402','1081301','1081302','1082100','1082100','1091101','1091102','1092900','1093701','1093702','1094500','1095300','1096100','1099601','1099602','1099603','1099604','1099605','1099606','1099607','1099699','1111901','1111902','1112700','1113501','1113502','1121600','1122401','1122402','1122403','1122404','1122499','1210700','1220401','1220402','1220403','1220499','1311100','1312000','1313800','1314600','1321900','1322700','1323500','1330800','1340501','1340502','1340599','1351100','1353700','1354500','1359600','1411801','1411802','1412601','1412602','1412603','1413401','1413402','1413403','1414200','1421500','1422300','1510600','1521100','1529700','1531901','1531902','1532700','1533500','1539400','1540800','2092401','1621800','1622601','1622602','1622699','1623400','1629301','1629302','1710900','1721400','1722200','1731100','1732000','1733800','1741901','1741902','1742701','1742702','1742799','1749400','1910100','1921700','1922599','1931400','1932200','2011800','2012600','2013401','2014200','2019301','2019399','2021500','2022300','2029100','2031200','2032100','2033900','2040100','2051700','2052500','2061400','2062200','2063100','2071100','2072000','2073800','2091600','2092402','2092403','2093200','2094100','2099101','2099199','2110600','2121101','2121102','2121103','2122000','2123800','2211100','2219600','2221800','2222600','2223400','2229301','2229302','2229303','2229399','2311700','2312500','2319200','2320600','2330302','2330303','2330304','2330305','2330399','2341900','2342701','2342702','2349401','2349499','2349499','2391501','2391502','2391503','2392300','2392300','2399101','2399102','2399199','2411300','2449199','2511000','2512800','2513600','2521700','2522500','2531401','2541100','2542000','2543800','2550101','2550102','2591800','2592601','2592602','2593400','2599301','2599399','2610800','2621300','2622100','2631100','2632900','2640000','2651500','2652300','2660400','2670101','2670102','2680900','2710401','2710402','2710403','2721000','2722801','2722802','2731700','2732500','2733300','2740601','2740602','2751100','2759701','2759799','2790201','2790202','2790299','2811900','2812700','2813500','2814301','2814302','2815101','2815102','2821601','2821602','2822401','2822402','2823200','2824101','2824102','2825900','2829101','2829199','2831300','2832100','2833000','2840200','2851800','2852600','2853400','2854200','2861500','2862300','2863100','2864000','2865800','2866600','2869100','2910701','2910702','2910703','2920401','2920402','2930101','2930102','2930103','2941700','2942500','2943300','2944100','2945000','2949201','2949299','3031800','3032600','3041500','3042300','3050400','3091101','3091102','3092000','3099700','3101200','3102100','3103900','3104700','3211601','3211602','3212400','3220500','3230200','3240001','3240002','3240003','3240099','3250701','3250702','3250703','3250704','3250705','3250707','3291400','3292201','3292202','3299001','3299002','3299003','3299004','3299005','3299006','3299099','3314703','3314705','3314718','3314719','3314720','4663000','1071600','1072401','1072402','4637102','2822401','2822402','3099700','3314708','4223500','4399104','4911600','4912401','4912402','4912403','4921301','4921302','4922101','4922102','4922103','4923002','4924800','4929901','4929902','4929999','4930201','4930202','4930203','4930204','4940000','5011401','5011402','5012201','5012202','5021101','5021102','5022001','5022002','5091201','5091202','5099801','5099899','5111100','5112999','5120000','5130700','5229001','5229099','5240199','5250803','5250804','5250805','6110802','7719599','8012900','4645101','4664800','0891600','2539001','3839401')) AND (uf IN ('SP')) AND (porte_tipo IN ('EMP','GE')) AND (municipio IN ('CAMPINAS','JUNDIAI','LIMEIRA','PIRACICABA','RIBEIRAO PRETO','VALINHOS','VINHEDO'))