no adm2 has more than one capital

number of errors=165
number of warnings=0

select count(*),countrycode,admincode1,admincode2 from geoname where featurecode = 'PPLA2' and admincode2 is not null and not (countrycode='IT' and admincode2 in ('BT','CI','OG','OT','VS')) group by 2,3,4 having count(*)>1 order by 2,3,4

count	countrycode	admincode1	admincode2	
2	AR	14	54049	
2	BF	08	57	
2	BG	40	DOB12	
2	BG	48	PAZ08	
2	BR	05	2933505	
2	BR	11	5000856	
2	BR	13	2105948	
3	BR	13	2107407	
2	BR	15	3157609	
2	BR	16	1502939	
2	BR	20	2210375	
2	CN	03	3605	
2	CN	12	4206	
2	CN	12	4211	
2	CN	13	6504	
2	CN	26	6109	
2	CO	02	05885	
2	CO	11	27491	
2	CO	16	41770	
2	CO	20	52490	
2	CO	21	54498	
2	CO	24	66687	
2	CO	33	25797	
2	CO	33	25799	
2	CO	35	13647	
2	CO	36	15861	
2	CO	37	17541	
2	CU	03	2502	
2	CU	07	2910	
2	CU	08	2704	
2	CU	12	3209	
2	CU	14	2802	
2	CU	16	2606	
2	EC	06	0607	
2	EC	08	0709	
2	EC	19	1808	
2	EC	22	2107	
2	GB	ENG	G6	
2	GB	NIR	N09000001	
3	GB	NIR	N09000002	
2	GB	NIR	N09000005	
2	GB	NIR	N09000006	
3	GB	NIR	N09000008	
3	GB	NIR	N09000009	
2	GB	NIR	N09000010	
2	GB	NIR	N09000011	
2	GH	05	518	
2	GT	08	1305	
2	GT	08	1308	
2	HR	01	3200709	
2	HR	03	11054957	
2	HR	03	11054968	
5	HR	05	11049267	
2	HR	05	11049283	
2	HR	05	3201029	
2	HR	06	11049323	
2	HR	07	11049011	
2	HR	08	11049289	
4	HR	12	11049431	
3	HR	12	11049452	
2	HR	15	11054617	
4	HR	20	11048984	
2	ID	30	3202	
2	IE	M	04	
2	JP	23	1851345	
2	JP	29	7468179	
2	JP	30	1855742	
2	JP	40	1862768	
2	KH	22	1207	
2	MX	08	007	
2	MX	28	017	
2	NG	05	25016	
2	NG	27	110	
2	NG	35	2004	
2	NI	07	1015	
2	NO	01	3207	
2	NO	04	3301	
2	NO	08	1506	
2	NO	08	1577	
5	NO	13	3118	
2	NO	17	4020	
2	NO	21	5059	
3	NO	46	4618	
2	NO	46	4621	
3	NO	46	4631	
2	NO	46	4640	
2	NO	46	4647	
2	PA	12	1204	
2	PH	NCR	137400000	
2	PK	07	1176775	
4	PK	07	1183615	
2	RO	01	2309	
2	RS	SE	22	
2	RU	23	825118	
2	TH	10	5308	
2	TH	17	4305	
2	TH	22	4008	
2	TH	23	4615	
2	TH	27	3009	
2	TH	28	3112	
2	TH	30	3319	
2	TH	35	1505	
2	TH	46	2004	
2	TH	51	7202	
2	TH	73	4811	
2	TH	74	2507	
2	TW	04	TNN	
2	TW	04	TXG	
6	UA	01	7102	
5	UA	01	7108	
5	UA	03	7306	
3	UA	04	1202	
5	UA	06	2604	
2	UA	08	6506	
2	UA	08	6510	
10	UA	09	6804	
5	UA	09	6806	
5	UA	10	3502	
6	UA	10	3504	
4	UA	10	3506	
4	UA	10	3508	
2	UA	11	0104	
3	UA	11	0114	
4	UA	11	0118	
2	UA	11	0120	
7	UA	13	3202	
2	UA	14	4404	
2	UA	15	4606	
3	UA	15	4608	
4	UA	15	4610	
5	UA	16	4802	
3	UA	16	4806	
2	UA	17	5108	
2	UA	17	5110	
3	UA	17	5112	
4	UA	18	5306	
9	UA	18	5308	
7	UA	22	6104	
7	UA	23	0502	
3	UA	23	0512	
2	UA	26	2306	
4	UA	26	2308	
6	UA	26	2310	
2	UG	C	42	
2	UG	C	F4	
2	UG	E	94	
2	UG	E	G7	
2	UG	N	E3	
2	UG	W	E6	
2	US	AL	083	
2	US	CA	059	
2	US	KS	193	
2	VE	06	0711	
2	VE	12	1207	
2	VE	20	2006	
2	VE	20	2009	
2	VE	23	2309	
2	VN	09	875	
2	VN	23	680	
2	VN	44	005	
2	VN	50	030	
2	VN	50	034	
2	VN	75	725	
2	YE	16	2302	
2	YE	26	1310