Advertisement
NLinker

internal mapping issue

Feb 15th, 2017
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.13 KB | None | 0 0
  1. SELECT im.to_uuid, count(im.from_uuid) as count from internal_mapping AS im
  2. GROUP BY im.to_uuid
  3. ORDER BY count DESC;
  4.  
  5. 01de4eea-c4e3-3249-a895-b47381a621e1 80
  6. 014cb796-ce27-3b5a-b5ab-32ffd37786e4 73
  7. 01e29d11-c160-3914-9549-d4fe764ec809 69
  8. 0134fa3d-b77e-3ec6-99e1-aa2b257348a4 57
  9. 01ba26ab-93a3-365f-9147-c868c6da921a 56
  10. 01b837ec-8cc3-364b-84fc-a2cd5f52705d 50
  11. 01f4b6bc-4b08-374c-8337-97ceb850ad67 48
  12. 015ed825-5c76-39f0-8e58-788e8a658523 48
  13. 017c307a-a9e3-3984-bb95-c581642c8031 48
  14. 01822ac0-779c-3f49-a620-d03a7b7e2199 47
  15. 01e219ea-a307-3dae-bbe8-a5312a58bc0c 44
  16. 0162e5e3-8927-3433-ab1b-ac65ed3e9a8c 41
  17. 01a4d9d7-b8a1-348f-9488-049a5eb81fcc 40
  18. 01e5b2bd-3c5e-3025-a7f2-8192d7469701 40
  19. 01dd16f9-95b0-3b33-8e9a-6d9cee2f0730 40
  20. 01cc8279-9f4f-34f8-8896-bb5985d1b9c2 39
  21. 017ac5bb-9d66-3724-9a35-b4764403cf6d 38
  22. 0197fa13-1b40-3650-bf4f-3160cfb127c2 37
  23. 014aa06a-009e-343b-b791-e41f0d9a4bab 37
  24. 05570167-ae63-3356-8fd8-bc564f2d2aaf 35
  25. 01582c50-fa98-3866-bc1a-82692f10fc1a 35
  26. 0140baed-dbb1-3c14-921f-f560a3e6b644 34
  27. 017c419c-aa5b-315c-a8e9-94a0ca96a654 34
  28. 01430007-f231-3224-b786-a5bef45e9012 34
  29. 01b2ef15-9bbb-340a-accf-c4f46d9be3fd 33
  30. 012103ce-0d22-3f03-a866-b4731e57c94a 33
  31. 01f8cc2e-5fc4-3acf-b0ee-ded70b3b00e3 33
  32. 016b06f7-3975-3ed0-96b9-061185d4c32c 33
  33. 0135f026-3fd9-3431-b1f7-3fa1ff921ab7 33
  34. 01901ffe-8cc1-3b6d-96eb-f48375fef2cf 33
  35. 01a81ed8-6dd7-397a-a4ba-9e1bd39ce0df 32
  36. 0160b760-e924-39dc-8fb1-201c249febc7 32
  37. 0582ac28-1648-3acc-b0be-b76ee8b33af2 30
  38. 0549de85-8853-3c41-9b2e-c0cd6e3c43e0 30
  39. 01baa324-925d-32d2-9eea-f0a30bce9308 30
  40. 0131fff7-217d-3de9-beff-88d3ee468f0d 29
  41. 05fb732e-99b2-37f2-8f8e-3631407b05c8 29
  42. 01004ebb-71ab-3707-b729-054736805e8a 28
  43. 01eca6db-633b-305a-a0ef-575466e1284c 28
  44. 0125ad7e-d382-3a39-b5b3-c917d2c71929 27
  45. 016ed540-1e0c-3a53-87ed-d2c944a444da 27
  46. 057450e4-698f-3068-8273-b36b071af588 27
  47. 0188bce2-2fad-36ef-80b9-80e16d41c837 27
  48. 01b58901-3bfd-3d66-b296-ab36dae71db0 26
  49. 05346456-3563-37e5-8e07-d88ea53a1b02 26
  50. 054f33a0-daf9-329b-a47f-999932dd134b 26
  51. 05325c55-c7a6-3533-ada9-3d15625ade06 26
  52. 051b4cc1-5d65-3af8-b35d-3fef569a1071 26
  53. 0536f180-711e-3426-96a7-42aae58d3fd5 26
  54. 059ddb55-5cd8-350b-acc2-83427e5f7952 26
  55. 054123f9-c32d-36da-893a-3ae7417956c1 26
  56. 05ef34c8-4619-3866-8dab-ab567d0ab1ca 26
  57. 014db700-89a2-3c55-9f98-753b01a66da5 26
  58. 0506550e-aa85-34a1-a4e6-297fb160df5c 26
  59. 05f9a30d-b97d-3960-a3b3-87864197273b 26
  60. 01c3a4a3-3537-375c-93af-46544eb54853 25
  61. 017762f3-ddd9-3024-bfee-b5773bbc231f 25
  62. 01c6b78e-96ca-3d77-913e-d022764e487c 25
  63. 017cf2a8-57a7-3bb4-b4f3-59acfcf2bb3f 25
  64. 017e7f02-4b76-3585-9d41-b67ed161c613 25
  65. 0161df4b-7f26-3f71-8f69-0f88c0423abb 24
  66. 014ba180-a9ee-30c2-ba3c-c5899e3e2029 24
  67. 0113cea7-0a00-335c-b5c8-1b841320e672 23
  68. 015abd5b-f1b4-3a92-b371-416f868c6be2 23
  69. 01233d55-51fc-3a9e-bd67-3acfa85ff2de 23
  70. 0176254a-0fe9-3b31-9ddd-cf096d2a3563 23
  71. 01336732-ba41-3166-987b-46c34765b534 23
  72. 01b08065-728a-3947-9055-80c87f041775 23
  73. 057d13c0-13e3-36e4-a80e-e19a01d7699d 23
  74. 01fccd0d-8b2e-3f6f-84c3-1e2f270b6fe6 22
  75. 0115549a-c2bb-3b2f-a45c-1144bd524b94 22
  76. 01c3e981-9a4d-34b3-b96d-a3d8ff789cc3 22
  77. 01c8726e-f6d1-36d4-a72a-3600eaf9d52d 22
  78. 01be1526-85eb-3114-ab16-f6ae6b2b4ade 22
  79. 01ff8e80-5593-3de4-86e7-9af716982bf8 21
  80. 01de3e37-0068-31d1-bcda-0e9d4a5e3151 21
  81. 05f68179-933d-3ff7-8898-7f306643b8ed 21
  82. 058fc51f-f3c7-3127-996e-403f9ab103d7 21
  83. 05ffcd50-ee5b-33c1-a981-869f88c67412 21
  84. 05259631-195c-306d-8f6c-0d6b976b8d5e 21
  85. 054ea2c6-c649-3007-acf0-06f4b00a2e6f 21
  86. 05ad4d87-23ab-3b23-ad8f-2dcbeeb7005b 21
  87. 0553d552-d8f5-336b-b449-388daf505e7b 21
  88. 05b0744e-9fc1-3cef-bb0f-88340baf3033 21
  89. 05779c74-0e11-36ee-b6e4-2855af368e77 21
  90. 015623ea-2298-35c4-91c5-8a53045f9a6c 21
  91. 05d6d0c6-c881-3089-9e80-2d47fea792b4 21
  92. 0582c029-c649-3a1a-8d8d-cbf2eaf29c1f 21
  93. 05344872-219f-36ad-8a2d-be99895668aa 21
  94. 0536566d-a649-3c39-9b62-0fedb8f36359 21
  95. 010301af-e02d-3583-ac75-f0135ef6b385 20
  96. 0541b955-d96e-31ec-98bf-41c4e95060e3 20
  97. 012b58c0-1693-3672-9707-1ec06545ccb3 20
  98. 01f4f4df-3fc7-3597-9c26-458263d1667a 20
  99. 017a9a98-06aa-3888-baa1-02c6e2d32a98 20
  100. 01f9ea50-a37e-3017-8232-7d263ebc45eb 20
  101. 01803bf8-6272-3e8f-ac68-5882b9e7bb7a 20
  102. 01e01af0-e3ec-3d86-a354-a36b0ed484c5 19
  103. 015888f2-daf1-3fe3-942c-ca2739e54375 19
  104. 01f62ae6-fb62-327a-ac02-103016896862 19
  105. 015c975f-451a-33ca-aad2-b46bfdebb2e2 19
  106. 05c5af4a-f26f-346a-83b6-7cc94d7e54da 19
  107. 016a1740-cf50-3ffb-a93d-308b4931f904 19
  108. 05cce36b-82c3-304d-9e85-711026537a6d 19
  109. 017d906d-40e0-3888-bda7-3e4579ae2aff 19
  110. 05cf5aca-dc1b-3360-8d59-60325c8e15db 19
  111. 056e141c-601e-3d6a-9abc-9c0a3ff87c4f 19
  112. 05d00013-7685-3b5b-8448-8d832dcde94b 19
  113. 0583a4bb-3b38-3650-b17e-55aed5421198 19
  114. 05fd6fa6-cb40-30c5-b109-5e59a2bcf13e 19
  115. 01974f80-e518-3e21-9d26-1e80be7ac8fc 19
  116. 0594ccf3-9258-35d6-9d4f-53c2e3369029 19
  117. 01ac4562-b55d-3b18-9b97-72e79ee963c7 19
  118. 0596913f-7ed2-315b-89a0-50b04af60a98 19
  119. 01b6369c-4246-39eb-9e9c-e2d862690a4b 19
  120. 0101f965-96f2-32ea-af01-e4edd07047f1 19
  121. 05345537-632b-3097-b6e8-f9c5e0042349 19
  122. 054e98b3-89ec-3e70-9348-1bd62bec2681 19
  123. 0115961e-7110-3ef3-8983-4426917f8fc2 19
  124. 05a7a9ce-b0cb-30a0-9d92-22d56493429c 19
  125. 055cb1b2-2bfc-3075-a9f8-0c26f2b2d621 19
  126. 011622fc-f7fe-3f32-ba25-a54ad711b45d 19
  127. 05b33e3f-9949-36ab-8706-11d0a19c16f1 19
  128. 0562fb5f-8762-37e3-9293-6682ef17c450 19
  129. 0128da74-e11f-3301-bae5-de792b2b5438 19
  130. 05b8d5e2-a03e-3dc1-8596-6e95f4256d22 19
  131. 013ec287-5465-3d78-96c8-3e8104c0ca83 19
  132. 05ba7b2f-8e10-34e6-b53e-b9a8786ef4f4 19
  133. 01e30835-4953-3b58-967a-4701dc5b2ba2 18
  134. 015837dd-fd31-3676-9cf2-576dc86af44f 18
  135. 01e7f21d-7e8b-3cd7-a72e-3e0cc019e916 18
  136. 0158f063-413c-3fd8-957d-8b234ed68068 18
  137. 01fbe879-0ecb-3159-adb5-ecfa6777817e 18
  138. 0177dd7d-438f-3989-a0ef-ad3e9cb38468 18
  139. 01a90ba3-d6ca-3259-90ec-e9310e6ff694 18
  140. 0106ebf9-8d75-30b2-8beb-9dfe80ee60b3 18
  141. 016a18c4-9fa8-3649-be61-c1f87c655a2f 18
  142. 01c3749d-1ce4-35e6-94a2-d51dc6a3c14f 18
  143. 012fa63b-79d9-3416-93f6-37c29c3a7469 18
  144. 018aad33-f077-320b-bf56-abdef8f41264 18
  145. 01cf3e25-31c5-321a-937f-45b3e84e26b3 18
  146. 01cc1592-e852-3938-a1f0-5fc88cde350e 18
  147. 01e3d0d0-dce8-339c-9a66-7f677dbab7d2 17
  148. 019b2971-7377-3471-83fb-18ef79170d0b 17
  149. 01542e45-b55b-3ef5-a6a0-2a2d94b6eca8 17
  150. 012f6df5-cbb8-3c7b-a1a6-6671dd8f101a 17
  151. 01a48f63-1339-3fa8-8333-22de049e8190 17
  152. 017d74be-fdd1-3672-936e-516d46a3ce5a 17
  153. 012dc993-5b69-3734-bb3d-09f8af2f132f 17
  154. 01b8f19f-df7c-379b-a7c1-07d515fd5132 17
  155. 01822670-8a4e-36f6-a015-0a51126c2b90 17
  156. 0129dcdc-d6d0-3ecb-88f1-75802d1a860b 17
  157. 01bf83b1-3216-3626-8335-3cc5c8b46578 17
  158. 0185e7da-9b44-3225-981a-d4ac1fdb8f14 17
  159. 01366efb-3f20-3516-b541-dfefd697d883 17
  160. 01b9267f-aac7-3295-a3dd-034da4ca5791 17
  161. 011a7171-64fc-3d0b-a3b4-d20615861d2f 17
  162. 01cdbddf-ae59-34e8-82de-9dcb1257208c 17
  163. 0123fc3c-e03c-3f91-a680-0d7b0b804c6d 17
  164. 01ce156f-6db6-38a8-ad63-c513a2192e23 17
  165. 0128e457-ee3b-30e4-a20f-574c0fa3c80a 17
  166. 01d54dfd-f503-3ceb-a1ae-a12f0c985565 17
  167. 01d87a69-2052-35e2-a791-4a5acb549858 17
  168. 01e2be2d-c3b5-3e26-acfd-cf8fe213a2a1 16
  169. 01a27845-381a-391a-9ef8-574e3c0b36c9 16
  170. 01e3a0ce-8209-33fb-aaca-fe6a42a56e67 16
  171. 01ad4665-970d-3790-8887-664122674227 16
  172. 01e878da-b718-3d44-a7d5-4fd2eddde4a3 16
  173. 01b01a15-bb1c-3153-9c74-c0dfc6f9236f 16
  174. 01edf922-64a0-365a-a5ff-7236956db611 16
  175. 01be591b-df1d-3086-b7ed-06f3764b4285 16
  176. 01f197bb-e61e-3290-bd0b-b2cfc60df148 16
  177. 01b6f17d-de2e-3f30-9e5a-03896a042a42 16
  178. 01f5bfb2-ffcd-3360-85d2-b78e054e03e7 16
  179. 01bdc435-742d-3af5-9f6a-2d36915417cc 16
  180. 01fa5776-a083-39ad-a231-9f1e3923aedf 16
  181. 01bc4db1-ea6b-30ae-8401-d4ee57d702f1 16
  182. 05eb7cec-2b6a-372c-b9d7-4e0b6e4c0a7d 16
  183. 01d968c7-9a20-3daf-b116-b47d06c7e95f 16
  184. 05f138dd-63f2-3708-b456-eaad06c07516 16
  185. 01008ccf-2225-385c-8e45-3cd6c60ba6a6 16
  186. 0581ab71-8c05-355f-a01b-9d0a229cefc9 16
  187. 0105c6fe-8b0a-3814-b3c3-1cc0122a001c 16
  188. 0150f5e9-23e6-36ab-8c25-77843c718945 16
  189. 0545c0d3-dfcd-3b5b-bc62-a9eed2c525e5 16
  190. 010ae1b8-7107-3f76-8d0f-b68883cc6712 16
  191. 0156a120-f15f-36ad-9a77-30d9d91e8c04 16
  192. 0121ed5c-40b6-30c7-8676-abc0df5f36a5 16
  193. 0158b08e-c63b-3cbc-b29c-bdfd8068c0c2 16
  194. 012e26f1-8395-3672-833e-789ff79d7c0a 16
  195. 01604223-4f56-33c8-b274-2c457cfa913c 16
  196. 01293f1f-5311-3509-9b89-99e477f1904e 16
  197. 017963de-a032-3650-a97f-e75f78f80010 16
  198. 0127870a-e9e3-3e6e-ab0a-623a2bc88aa5 16
  199. 016d31d2-b28c-3ef0-824d-43acf1bed015 16
  200. 014902e6-e71b-309e-b34e-f56c1071483b 16
  201. 0179d7b5-98d0-38bc-84e4-db4593871637 16
  202. 014a2e20-64e9-3208-a317-6c56cc059ae0 16
  203. 016efe3c-0eaa-3c55-9738-827aac264750 16
  204. 018bd974-12ef-33b9-a1bf-15ceb4ecb9ff 16
  205. 018d26e8-4f14-33a5-be1c-09bea9fd2bcd 16
  206. 01900fdf-f134-3405-b216-4f0aff4742bf 16
  207. 0108de8f-ccc9-3984-914c-df8c65eee072 15
  208. 014d9e4b-545d-3806-8284-d4f51071a343 15
  209. 011250da-ae57-30d9-9b26-202946e56069 15
  210. 015147d0-63fd-33fe-901a-cc576c483cdc 15
  211. 01184a0c-5692-3712-ac4d-ba9b7eda2ca8 15
  212. 015755da-f9a1-3b79-9d55-f383a2d22f37 15
  213. 011a8018-5b73-3916-9171-053c84560a2b 15
  214. 015a17e9-db7d-329e-b04f-135f400e66c4 15
  215. 0127c7d9-effd-329b-9a06-03cb7ea7a3d1 15
  216. 0173ebf2-5224-3a94-a931-130492f888f3 15
  217. 012d6396-7a2e-39f7-a667-abd65e14b577 15
  218. 0168f0cf-aabd-3d9d-9694-5ffcdfafe3d4 15
  219. 011e86a1-5ff2-38bf-8a74-9f487820e44e 15
  220. 017ecec6-1876-329e-b767-938f54714a3e 15
  221. 012fac5a-b168-3aa7-8e6c-92c4b2e9839d 15
  222. 018b2977-53ce-3754-882e-4f6393fbb0b9 15
  223. 01357a54-1dd4-3bda-9213-a145e242da38 15
  224. 01912346-c0f1-37e2-9b32-bbe2ee11f6d0 15
  225. 013820ca-fa10-3846-86de-88e8182b4377 15
  226. 05ed1a8a-d16b-3136-99d6-62bc848a0cfa 15
  227. 0144a219-cfe0-34f8-8a40-e109bd24784e 15
  228. 05f5bb8b-406e-32fb-bd9c-428984d00889 15
  229. 01e0afc9-70ec-3faa-8854-9f2ec11754fd 15
  230. 0516d358-7265-3e76-96b3-53fcbe9d8a50 15
  231. 01e7bdbb-7d66-3d02-a1a3-76c4e4193969 15
  232. 05176659-1bdb-3e7d-908b-caaf432e8547 15
  233. 01f6c2a5-cbed-3c53-b2fd-8f3d93191de9 15
  234. 051e4d04-51a0-39ac-9c47-86174dbd5f8f 15
  235. 01fa19c6-5a00-347d-bd3a-2bda2502fb10 15
  236. 052416e1-8b0a-34ca-aa23-205eb1b2d644 15
  237. 05024961-e2fb-3c2a-a0c0-ca403a07441e 15
  238. 019b4d96-65f8-3e2b-9bd8-b3c79f8dab06 15
  239. 054c5f3f-0ac5-38d9-8761-6be367865b9b 15
  240. 01a24708-939f-391a-bf32-1daa56faf9c0 15
  241. 0565c87d-2446-3eae-a2b7-2499f4c76dc3 15
  242. 01afdac4-19a8-3619-a03a-22e8cd95d5ad 15
  243. 05cab379-e599-3fff-a1cc-19598b81d4c3 15
  244. 01c5ae0d-98a6-3651-b237-41176ea17405 15
  245. 05d0e3b1-510e-3fb5-92f8-f7dff4508882 15
  246. 01c6929f-5dce-33de-820b-85d2ba05534b 15
  247. 05d88ff6-d78c-3e12-b0cb-8ae9f309f499 15
  248. 01cf3351-c75c-31fa-9166-0db3c1da7fab 15
  249. 0532e542-2fd7-3fec-a7ea-064fd900218d 15
  250. 01d8c503-850e-3c84-b05d-ab894164b7b9 15
  251. 0536c898-4d34-3520-8975-082d41c18974 15
  252. 010079ab-4d65-3bd1-bc89-00390c832028 15
  253. 05a228c0-aa6f-3b65-98c4-5328a6071bdb 15
  254. 0536d25e-f8aa-3e1c-9e89-e0c9ce2050a8 15
  255. 058a5676-78fa-3e12-9b0d-9384a3b30d9c 14
  256. 05314945-22dc-3038-ba5a-2dc1f4631ac3 14
  257. 055f71db-284b-3ff2-ab9a-2189605e3a10 14
  258. 05335c01-b3dd-3491-991e-6afab6f00168 14
  259. 01050d58-539c-3273-b871-d64cc14323d9 14
  260. 05ad9b2a-2e1c-33d7-8723-3e348c57b460 14
  261. 01069f89-97fe-378a-9fe0-27f0ba5bf3b1 14
  262. 01550378-70d9-3685-8155-00e190a7a35e 14
  263. 0106caa9-cbcc-3812-b2d6-b2eaf5431c2b 14
  264. 0157db0a-b1b1-3525-80ef-4fb175b91c8b 14
  265. 010a7bb5-0f3c-3efa-aab3-5d0692d1ba7e 14
  266. 0162456a-2c86-3fb9-b018-cccfc8f00204 14
  267. 010d6802-a7c5-31cf-87b0-604f968b6b8d 14
  268. 016695db-7256-36ca-a3a1-3cbcc8108951 14
  269. 011355d4-cde5-3534-9c20-12876756eadc 14
  270. 017b8eb1-d30e-304d-98fc-ac1db8184a5c 14
  271. 01188172-f2c3-32ee-a140-ffb574d96ccd 14
  272. 01805b63-8ab7-3f97-80e3-5e4534cf4996 14
  273. 01188a62-46e6-3a25-9a66-e543a8f488ff 14
  274. 018aed88-6958-3693-8401-31117e9f9a99 14
  275. 011a2e14-6124-3ee7-8679-d8355c41a810 14
  276. 01905fa5-0367-36bb-9a5f-6a57e5b65701 14
  277. 0124a1af-0191-35f3-a357-7d3347c9503c 14
  278. 01e2aa87-bb47-304f-b4d1-2ffae09ac602 14
  279. 01259e6b-5643-3335-81f8-5bd0b3a5ae99 14
  280. 01ec55f8-5a2c-3a01-b417-d0674f3429fe 14
  281. 012cc998-7de5-3bbd-b335-0c234f59d4da 14
  282. 01ef5862-f0ce-33b0-9e62-d65f15dd870f 14
  283. 012fd310-fcea-319b-883a-f250482031da 14
  284. 01f25aa0-f2d9-3bdd-9dfe-9b0df5153ee8 14
  285. 0135551d-7513-3596-86d8-c1beadd50c53 14
  286. 01f64756-77e3-341b-b585-ed1f77400532 14
  287. 0148099c-3165-35ed-a56f-c861e794d6bc 14
  288. 01f81c0f-aeca-3419-ab73-cb8ee131d1a3 14
  289. 05f12fb7-b17a-3c88-8de1-97d43961aff2 14
  290. 01fb1a38-36e1-3fc7-88b6-52b1cee59588 14
  291. 05f4ef10-8df6-33a2-ba6a-cb8ca83464e9 14
  292. 01df4c19-7d2a-34bc-87ea-3e2257339de3 14
  293. 05fad0bc-05aa-34f1-b59a-a487537ba1bb 14
  294. 01010a32-a1ee-36f7-91ca-f5871e025cd6 14
  295. 05ffd64a-ce1f-3757-b523-9b96a8d33ae5 14
  296. 01966573-f971-3bb8-86d8-54a88e300c8e 14
  297. 05d7be56-1b64-3528-9780-3a7ccd764fde 14
  298. 05708bf7-8253-31c6-b79b-aad6c0a242a6 14
  299. 01980709-2aaa-3dfc-83e9-9076ae9118cf 14
  300. 05d8589e-818c-34f2-923c-3c25fe5ca053 14
  301. 0580294d-1094-38d9-9c43-041be1f1b7bb 14
  302. 019f92f9-a37b-3c56-82e2-63470cf8a62f 14
  303. 05dc314b-ea6a-3d62-adf7-ba23aa1a3a12 14
  304. 01a2c1fe-aed6-3934-bf26-d61e3861062e 14
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement