mysql:research@x1-analytics-slave [flowdb]> select hex(ref_id), count(*) as c from flow_wiki_ref group by ref_id having c>1;
+------------------------+---+
| hex(ref_id)            | c |
+------------------------+---+
| 05464B373A6EE431F9E505 | 2 |
| 05464B373A6EE631F9E505 | 2 |
| 05464B373A72E231F9E505 | 2 |
| 05464B373A72E431F9E505 | 2 |
| 05464B373A72E631F9E505 | 2 |
| 05464B373A76E231F9E505 | 2 |
| 05464B373A76E431F9E505 | 2 |
| 05464B373A76E631F9E505 | 2 |
| 05464B373A7AE231F9E505 | 2 |
| 05464B373A7AE431F9E505 | 2 |
| 05464B373A7AE631F9E505 | 2 |
| 05464B373A7AE831F9E505 | 2 |
| 05464B373A7EE331F9E505 | 2 |
| 05464B373A7EE531F9E505 | 2 |
| 05464B373A7EE731F9E505 | 2 |
| 05464B373A82E331F9E505 | 2 |
| 05464B373A82E531F9E505 | 2 |
| 05464B373A82E731F9E505 | 2 |
| 05464B373A86E231F9E505 | 2 |
| 05464B373A86E431F9E505 | 2 |
| 05464B373A86E631F9E505 | 2 |
| 05464B373A8AE231F9E505 | 2 |
| 05464B373A8AE431F9E505 | 2 |
| 05464B373A8AE631F9E505 | 2 |
| 05464B373A8EE231F9E505 | 2 |
| 05464B373A8EE431F9E505 | 2 |
| 05464B373A8EE631F9E505 | 2 |
| 05464B373A8EE831F9E505 | 2 |
| 05464B373A92E331F9E505 | 2 |
| 05464B373A92E531F9E505 | 2 |
| 05464B373A92E731F9E505 | 2 |
| 05464B373A96E331F9E505 | 2 |
| 05464B373A96E531F9E505 | 2 |
| 05464B373A96E731F9E505 | 2 |
| 05464B373A9AE331F9E505 | 2 |
| 05464B373A9AE531F9E505 | 2 |
| 05464B373A9AE731F9E505 | 2 |
| 05464B373A9EE231F9E505 | 2 |
| 05464B373A9EE431F9E505 | 2 |
| 05464B373A9EE631F9E505 | 2 |
| 05464B373AA2E231F9E505 | 2 |
| 05464B373AA2E431F9E505 | 2 |
| 05464B373AA2E631F9E505 | 2 |
| 05464B373AA6E231F9E505 | 2 |
| 05464B373AA6E431F9E505 | 2 |
| 05464B373AA6E631F9E505 | 2 |
| 05464B373AA6E831F9E505 | 2 |
| 05464B373AAAE331F9E505 | 2 |
| 05464B373AAAE531F9E505 | 2 |
| 05464B373AAAE731F9E505 | 2 |
| 05464B373AAEE331F9E505 | 2 |
| 05464B373AAEE531F9E505 | 2 |
| 05464B373AAEE731F9E505 | 2 |
| 05464B373AB2E231F9E505 | 2 |
| 05464B373AB2E431F9E505 | 2 |
| 05464B373AB2E631F9E505 | 2 |
| 05464B373AB6E231F9E505 | 2 |
| 05464B373AB6E431F9E505 | 2 |
| 05464B373AB6E631F9E505 | 2 |
| 05464B373ABAE231F9E505 | 2 |
| 05464B373ABAE431F9E505 | 2 |
| 05464B373ABAE631F9E505 | 2 |
| 05464B375156E331F9E505 | 2 |
| 05464B37515AE231F9E505 | 2 |
| 05464B37515AE431F9E505 | 2 |
| 05464B37515AE631F9E505 | 2 |
| 05464B37515EE331F9E505 | 2 |
| 05464B37515EE531F9E505 | 2 |
| 05464B37515EE731F9E505 | 2 |
| 05464B375162E331F9E505 | 2 |
| 05464B375162E531F9E505 | 2 |
| 05464B375162E731F9E505 | 2 |
| 05464B375166E331F9E505 | 2 |
| 05464B375166E531F9E505 | 2 |
| 05464B375166E731F9E505 | 2 |
| 05464B37516AE331F9E505 | 2 |
| 05464B37516AE531F9E505 | 2 |
| 05464B37516AE731F9E505 | 2 |
| 05464B37516EE331F9E505 | 2 |
| 05464B37516EE531F9E505 | 2 |
| 05464B37516EE731F9E505 | 2 |
| 05464B375172E331F9E505 | 2 |
| 05464B375172E431F9E505 | 2 |
| 05464B375172E531F9E505 | 2 |
| 05464B375176E431F9E505 | 2 |
| 05464B375176E531F9E505 | 2 |
| 05464B37517AE231F9E505 | 4 |
| 05464B37517AE431F9E505 | 2 |
| 05464B37517EE431F9E505 | 5 |
| 05464B37517EE531F9E505 | 2 |
+------------------------+---+
90 rows in set (4.02 sec)