number of errors=3
number of warnings=0
Group=chkGrpUnlocode
select cc,code,name,subdiv,function,state,admincode1 from UNLOCODE20241 where geonameid is null and code is not null and function is not null and function like '%4%' and (function like '1%' or function like '%3%')
cc code name subdiv function state admincode1 XZ SUU Suursaq null 1--4-6-- RL null BS MSK Mastic Point Apt null --34---- RL null IQ BSH Bashur Airfield null --34---- RQ null