select id,ffpFullName from BasicAreaEx ex where ex.name like '%前莲%' union ##; ##131191 select id,ffpFullName from BasicAreaEx ex where ex.name like '%魏家荒地村%' union ##; ##131195
select id,ffpFullName from BasicAreaEx ex where ex.name like '%七家子村%' and id=131144 union ##; ##131144 select id,ffpFullName from BasicAreaEx ex where ex.name like '%腰高台子村%' union ##; ##131139
select id,ffpFullName from BasicAreaEx ex where ex.name like '%陈平堡村%' and id=140983 union ##; ##140983 select id,ffpFullName from BasicAreaEx ex where ex.name like '%古城子村%' and id=140974 union ##; ##140974
select id,ffpFullName from BasicAreaEx ex where ex.name like '%二公台村%' and id=141100 union ##; ##141100 select id,ffpFullName from BasicAreaEx ex where ex.name like '%红崖%' and id= 141095 union ##; ##141095
select id,ffpFullName from BasicAreaEx ex where ex.name like '%春满社区%' union ##; ##132243 select id,ffpFullName from BasicAreaEx ex where ex.name like '%大卢社区%' union ##; ##132245
select id,ffpFullName from BasicAreaEx ex where ex.name like '%谷泡社区%' and id=132186 union ##; ##132186 select id,ffpFullName from BasicAreaEx ex where ex.name like '%杏花村%' and id=132196 union ##; ##132196
select id,ffpFullName from BasicAreaEx ex where ex.name like '%房申村民委员会%' and pid = 128601 union ##; ##143544 select id,ffpFullName from BasicAreaEx ex where ex.name like '%高杖子社区%' union ##; ##143532
select id,ffpFullName from BasicAreaEx ex where ex.name like '%老杖子村%' and id=143738 union ##; ##143738 select id,ffpFullName from BasicAreaEx ex where ex.name like '%半里杖子村%' and id=143741; ##143741
('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741')
(一)较大人口规模自然村（组）通硬化路数量大于较大人口规模自然村（组）数量
前者大于后者 是有问题的
select dl.areaid,dl.yhdlsl as '较大人口规模自然村（组）通硬化路数量' ,jb.jdzrcsl as '较大人口规模自然村（组）数量' from DAS_xzc_jbqk jb inner join DAS_xzc_dl dl on jb.areaid= dl.areaid
where jb.AreaId='143738'
where jb.areaid in ('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741')
##！！！！ (二)重度破损需修复养护的硬化道路里程数大于现有硬化道路里程数
后者大于前者 是有问题的
select dl.areaid,dl.yhdllcs, dl.xxfyhdl from DAS_xzc_dl dl
where dl.AreaId='143741'
where dl.areaid in ('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741')
！！！！ 3）重度破损需修复养护的硬化产业路、旅游路、资源路里程数大于现有硬化的产业路、旅游路、资源路里程数
后者大于前者 是有问题的
select dl.xyyhcyl, dl.xypxcyl from DAS_xzc_dl dl where dl.areaid in ('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741')
4）危房列入改造计划的农户数大于危房农户数
有记录的 就是有问题的
select jc.sfwf,wfsflrgzjh from DAS_householdcode_jcss jc
where jc.areaid='143741' and jc.sfwf='0' and jc.wfsflrgzjh='1'
where jc.areaid in ('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741') and jc.sfwf='0' and jc.wfsflrgzjh='1'
5）使用其他清洁能源的农户数大于使用清洁能源的农户数
上面是总数，下面是包含其他的
下面的要是大于上面的 是有问题的
select count() from DAS_householdcode_jcss jc where jc.areaid='143741' and jc.syqjnylx is not null union select count() from DAS_householdcode_jcss jc where jc.areaid='143741' and position("900" in jc.syqjnylx) > 0
1） 同一建设条件，填报不同建设情况
有等于0的 是不是就代表有问题
select * from DAS_householdcode_jcss jc where jc.areaid in ('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741') and jc.sfysaq='0'
有等于0的 是不是就代表有问题
select * from DAS_householdcode_jcss jc where jc.areaid in ('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741') and jc.rhdlsfyh='0'
卫生公厕的数量
有等于0的 是不是就代表有问题
select * from DAS_householdcode_rjhj rj where rj.areaid in ('131191','131195','131144','131139','140983','140974','141100','141095','132243','132245','132186','132196','143544','143532','143738','143741') and rj.sfywshc='0'