https://bugzilla.wikimedia.org/show_bug.cgi?id=53539
--- Comment #2 from Max Semenik <[email protected]> --- Or: select gt_page_id, count(*) as num from geo_tags where gt_primary=1 group by gt_page_id having num > 1; +------------+-----+ | gt_page_id | num | +------------+-----+ | 3985 | 2 | | 4443 | 6 | | 6886 | 2 | | 13774 | 2 | | 36636 | 2 | | 60142 | 2 | | 107752 | 5 | | 147954 | 3 | | 160278 | 3 | | 236843 | 2 | | 361527 | 2 | | 378111 | 3 | | 425258 | 2 | | 532228 | 2 | | 1243036 | 2 | | 1448335 | 2 | | 1819156 | 2 | | 2099624 | 2 | | 3235827 | 2 | | 5180508 | 2 | | 5236504 | 3 | | 5482619 | 8 | | 7811151 | 2 | | 16161886 | 3 | | 19366815 | 2 | | 26374590 | 2 | | 38000270 | 2 | +------------+-----+ 27 rows in set (1.12 sec) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
