MariaDB [landscapefor]> SELECT wikidata_code, GROUP_CONCAT(poi_ID) FROM poi WHERE wikidata_code <> '' GROUP BY wikidata_code HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC; +---------------+----------------------+ | wikidata_code | GROUP_CONCAT(poi_ID) | +---------------+----------------------+ | Q1033649 | 10112,9581 | | Q10339 | 8970,14599 | | Q1054748 | 15765,15886 | | Q1066935 | 10149,8040 | | Q111942 | 9568,14422 | | Q122476 | 8283,8241 | | Q128202 | 10184,14953 | | Q131148 | 10205,12780 | | Q13145 | 14844,7312 | | Q1324513 | 9269,13529 | | Q1332930 | 11249,11098 | | Q1380173 | 8297,8150 | | Q1585931 | 13493,8101 | | Q162965 | 15266,15071 | | Q16596814 | 8939,11071 | | Q1707242 | 6503,8778 | | Q17798 | 14315,14651 | | Q178813 | 13469,11651 | | Q18040 | 14286,14659 | | Q18356 | 14264,14637 | | Q18365 | 14267,14644 | | Q18368 | 14268,14643 | | Q18416884 | 10661,10770 | | Q18755063 | 8108,7944 | | Q1903 | 12755,16045 | | Q1916826 | 16018,15043 | | Q19840 | 7271,16180 | | Q19846 | 7273,16300 | | Q20099 | 14341,14638 | | Q20109 | 14344,14649 | | Q20191 | 14367,14650 | | Q20251 | 14648,14383 | | Q2034331 | 15070,15268 | | Q2047639 | 8439,8348 | | Q20478 | 14372,14890 | | Q20494 | 15028,14896 | | Q2077168 | 11282,11427 | | Q21013539 | 16553,16579 | | Q21192547 | 14489,14485 | | Q21192550 | 9563,10943 | | Q21552096 | 9265,9266 | | Q21552273 | 9204,9280 | | Q224172 | 14350,14902 | | Q23291 | 14697,14288 | | Q2506967 | 10965,11857 | | Q254139 | 14455,14561 | | Q266604 | 14463,14544 | | Q266794 | 14457,14554 | | Q266941 | 14550,14460 | | Q266975 | 14547,14449 | | Q268067 | 14257,14470 | | Q268995 | 14471,14320 | | Q269516 | 14404,14474 | | Q269823 | 14445,14482 | | Q270032 | 14560,14466 | | Q270189 | 14456,14571 | | Q270320 | 14979,14556 | | Q270328 | 14564,15015 | | Q270492 | 14526,14441 | | Q270548 | 14512,15014 | | Q270613 | 14527,14462 | | Q270782 | 14506,14454 | | Q271152 | 14511,14451 | | Q271236 | 14446,14517 | | Q271358 | 14528,14444 | | Q28001134 | 7041,7065 | | Q2967848 | 9398,7825 | | Q2968191 | 8829,14751 | | Q30159213 | 12387,12642 | | Q3328396 | 9366,15991 | | Q3361323 | 10637,10944 | | Q3364763 | 13187,13299 | | Q34805 | 14994,14708 | | Q35082 | 14754,14340 | | Q35226 | 14226,14718 | | Q358729 | 13328,14696 | | Q3649109 | 8766,10617 | | Q3657503 | 15804,16428 | | Q3662426 | 10052,11652 | | Q3662456 | 9610,9648 | | Q3718646 | 8912,15404 | | Q3757770 | 15285,9066 | | Q3763803 | 9230,9232 | | Q376739 | 8897,9080 | | Q3785099 | 14180,14073 | | Q3867520 | 8925,9025 | | Q3867716 | 9135,16096 | | Q3867764 | 8009,8047 | | Q3867831 | 9173,9172 | | Q3867851 | 8262,8263 | | Q3867963 | 9037,8790 | | Q3867973 | 9024,9005 | | Q3868051 | 8677,9075 | | Q3868253 | 8885,8886 | | Q3868400 | 7993,7994 | | Q3868487 | 9151,9022 | | Q3886621 | 15832,16466 | | Q3886642 | 15944,16441 | | Q3889575 | 16554,15277 | | Q3889607 | 14759,6493 | | Q3889659 | 10800,10632 | | Q3890190 | 15254,15264 | | Q3890261 | 15287,15286 | | Q3890698 | 13602,13612 | | Q3892388 | 14518,14686 | | Q3895631 | 14591,13206 | | Q3895646 | 13216,16177 | | Q3895647 | 13217,14666 | | Q3895726 | 14083,13180 | | Q3934723 | 11345,11336 | | Q3936898 | 10762,10555 | | Q3951389 | 10456,10245 | | Q4011905 | 6985,6977 | | Q47467390 | 15045,13962 | | Q50119 | 15133,15132 | | Q54087650 | 8914,8525 | | Q54874186 | 9059,9058 | | Q55354223 | 8004,8003 | | Q55370383 | 16161,8884 | | Q55372377 | 14812,8944 | | Q55375790 | 8823,8840 | | Q55379362 | 8237,8238 | | Q55391578 | 9733,9732 | | Q55686292 | 11359,11360 | | Q55832719 | 11241,10842 | | Q574879 | 13491,13490 | | Q58844 | 13273,14184 | | Q606494 | 7856,7891 | | Q635414 | 13324,14116 | | Q867361 | 13318,7208 | +---------------+----------------------+ 130 rows in set (0.03 sec)