| |
|
 |
全部分类 |
 |
建筑安装( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=24 114) |
 |
旅游餐饮( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=25 5) |
 |
酒业饮品( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=26 4) |
 |
机动车辆( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=27 6) |
 |
造纸印刷( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=29 8) |
 |
装饰建材( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=30 19) |
 |
家具用品( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=31 4) |
 |
中介组织( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=32 2) |
 |
信息科技( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=33 8) |
 |
农业产业( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=34 1) |
 |
金融保险( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=35 6) |
 |
交运仓储( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=36 11) |
 |
机电化工( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=37 94) |
 |
橡胶塑料( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=38 11) |
 |
农林牧渔( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=39 4) |
 |
粮油食品( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=40 5) |
 |
服装鞋帽( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=41 4) |
 |
广告物业( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=42 3) |
 |
纺织印染( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=43 16) |
 |
商贸流通( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=44 15) |
 |
水电环卫( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=45 22) |
 |
医药保健( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=46 17) |
 |
冶金矿山( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=47 23) |
 |
制 造 业( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=48 114) |
 |
石油资源( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=49 10) |
 |
其他行业( select count(*) as exps from company_manager where id in(select distinct com_id from c_validate where kuaiji=1 and chuna=1 and type=1) and comclass=50 56) |