Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [p50380g50752__pb]> SELECT * FROM ( SELECT taking.user_id, taking.user_name, taking.user_verified_since, MAX(cf_timestamp) AS aelteste_best, COUNT(cf_confirmed_user_id) FROM `confirmation` JOIN `user` AS taking ON taking.user_id = cf_confirmed_user_id GROUP BY taking.user_id, taking.user_name HAVING COUNT(cf_confirmed_user_id)>3 ORDER BY MAX(cf_timestamp) ) verf_user WHERE aelteste_best=verf_user.user_verified_since ;
- +---------+-------------------------+---------------------+---------------------+-----------------------------+
- | user_id | user_name | user_verified_since | aelteste_best | COUNT(cf_confirmed_user_id) |
- +---------+-------------------------+---------------------+---------------------+-----------------------------+
- | 1683317 | Konstanze Dobberke | 2014-02-24 12:41:00 | 2014-02-24 12:41:00 | 25 |
- | 1617391 | Vains | 2014-02-24 14:37:00 | 2014-02-24 14:37:00 | 14 |
- | 569112 | Remi Mathis | 2014-02-24 23:10:00 | 2014-02-24 23:10:00 | 18 |
- | 993962 | EdouardHue | 2014-02-24 23:11:00 | 2014-02-24 23:11:00 | 8 |
- | 118028 | Edoderoo | 2014-02-27 11:19:00 | 2014-02-27 11:19:00 | 18 |
- | 92908 | AFBorchert | 2014-02-27 19:32:00 | 2014-02-27 19:32:00 | 76 |
- | 481501 | PLauppert | 2014-02-27 23:05:00 | 2014-02-27 23:05:00 | 15 |
- | 1497497 | Tobiasweissig | 2014-02-28 12:42:00 | 2014-02-28 12:42:00 | 9 |
- | 64758 | Theredmonkey | 2014-02-28 12:44:00 | 2014-02-28 12:44:00 | 69 |
- | 126296 | Martin Kraft | 2014-03-01 12:30:00 | 2014-03-01 12:30:00 | 27 |
- | 330414 | Codeispoetry | 2014-03-01 12:31:00 | 2014-03-01 12:31:00 | 13 |
- | 154798 | Ash Crow | 2014-03-01 12:32:00 | 2014-03-01 12:32:00 | 26 |
- | 28525 | Kulac | 2014-03-01 14:05:00 | 2014-03-01 14:05:00 | 161 |
- | 94465 | Regiomontanus | 2014-03-01 14:08:00 | 2014-03-01 14:08:00 | 126 |
- | 34830 | Plani | 2014-03-01 14:09:00 | 2014-03-01 14:09:00 | 95 |
- | 149453 | Gugerell | 2014-03-01 14:11:00 | 2014-03-01 14:11:00 | 38 |
- | 1267236 | Austriantraveler | 2014-03-01 14:12:00 | 2014-03-01 14:12:00 | 29 |
- | 1296318 | Haeferl | 2014-03-01 14:14:00 | 2014-03-01 14:14:00 | 59 |
- | 253394 | Herzi Pinki | 2014-03-01 14:15:00 | 2014-03-01 14:15:00 | 63 |
- | 3332 | Ralf Roletschek | 2014-03-02 09:40:00 | 2014-03-02 09:40:00 | 283 |
- | 1598557 | Walter W. Weiss | 2014-03-02 09:41:00 | 2014-03-02 09:41:00 | 9 |
- | 1503302 | Claudia.Garad | 2014-03-02 09:41:00 | 2014-03-02 09:41:00 | 35 |
- | 229936 | AleXXw | 2014-03-02 09:42:00 | 2014-03-02 09:42:00 | 126 |
- | 1649886 | P e z i | 2014-03-02 09:43:00 | 2014-03-02 09:43:00 | 8 |
- | 75966 | Pfeifferfranz | 2014-03-02 09:44:00 | 2014-03-02 09:44:00 | 27 |
- | 594728 | ThurnerRupert | 2014-03-02 17:44:00 | 2014-03-02 17:44:00 | 29 |
- | 88446 | GuentherZ | 2014-03-02 22:44:00 | 2014-03-02 22:44:00 | 62 |
- | 1301976 | Isiwal | 2014-03-02 22:45:00 | 2014-03-02 22:45:00 | 27 |
- | 378256 | Pigsonthewing | 2014-03-02 22:46:00 | 2014-03-02 22:46:00 | 7 |
- | 95974 | Braveheart | 2014-03-02 22:53:00 | 2014-03-02 22:53:00 | 42 |
- | 31583 | Ghw | 2014-03-02 22:54:00 | 2014-03-02 22:54:00 | 27 |
- | 1013418 | Alupus | 2014-03-02 22:55:00 | 2014-03-02 22:55:00 | 109 |
- | 661102 | Heide Hard. | 2014-03-03 21:26:00 | 2014-03-03 21:26:00 | 4 |
- | 527528 | Anka Friedrich | 2014-03-04 17:41:00 | 2014-03-04 17:41:00 | 116 |
- | 261473 | Yellowcard | 2014-03-04 17:42:00 | 2014-03-04 17:42:00 | 90 |
- | 1481078 | Jack USER | 2014-03-04 17:42:00 | 2014-03-04 17:42:00 | 28 |
- | 458768 | Emergency doc | 2014-03-04 17:43:00 | 2014-03-04 17:43:00 | 50 |
- | 512619 | NordNordWest | 2014-03-04 17:44:00 | 2014-03-04 17:44:00 | 149 |
- | 1181230 | Mikered | 2014-03-04 17:45:00 | 2014-03-04 17:45:00 | 54 |
- | 96411 | Ephraim33 | 2014-03-04 17:46:00 | 2014-03-04 17:46:00 | 107 |
- | 940524 | Floflo | 2014-03-04 18:38:00 | 2014-03-04 18:38:00 | 24 |
- | 402719 | Ludo29 | 2014-03-04 18:40:00 | 2014-03-04 18:40:00 | 27 |
- | 714064 | M0tty | 2014-03-04 18:41:00 | 2014-03-04 18:41:00 | 16 |
- | 1407180 | Marianne Casamance | 2014-03-04 18:42:00 | 2014-03-04 18:42:00 | 12 |
- | 405207 | Pymouss | 2014-03-04 18:43:00 | 2014-03-04 18:43:00 | 31 |
- | 451149 | Musicaline | 2014-03-04 18:43:00 | 2014-03-04 18:43:00 | 10 |
- | 20203 | Steschke | 2014-03-05 10:46:00 | 2014-03-05 10:46:00 | 178 |
- | 10662 | Superbass | 2014-03-05 11:32:00 | 2014-03-05 11:32:00 | 139 |
- | 89317 | Purodha | 2014-03-05 11:33:00 | 2014-03-05 11:33:00 | 80 |
- | 333372 | Fecchi | 2014-03-05 11:33:00 | 2014-03-05 11:33:00 | 73 |
- | 109890 | Eynre | 2014-03-05 11:33:00 | 2014-03-05 11:33:00 | 16 |
- | 2953 | Elya | 2014-03-05 11:34:00 | 2014-03-05 11:34:00 | 244 |
- | 58919 | Loegge | 2014-03-05 11:34:00 | 2014-03-05 11:34:00 | 101 |
- | 193575 | Pana | 2014-03-05 11:34:00 | 2014-03-05 11:34:00 | 10 |
- | 354372 | Duschgeldrache2 | 2014-03-05 11:35:00 | 2014-03-05 11:35:00 | 107 |
- | 10466 | Stefan64 | 2014-03-05 11:35:00 | 2014-03-05 11:35:00 | 134 |
- | 400176 | Hannibal21 | 2014-03-05 11:35:00 | 2014-03-05 11:35:00 | 39 |
- | 1585042 | Jean11 | 2014-03-05 19:01:00 | 2014-03-05 19:01:00 | 24 |
- | 46100 | Raboe001 | 2014-03-06 09:39:00 | 2014-03-06 09:39:00 | 295 |
- | 983718 | F.Higer | 2014-03-06 19:28:00 | 2014-03-06 19:28:00 | 13 |
- | 455761 | Neozoon | 2014-03-07 01:37:00 | 2014-03-07 01:37:00 | 72 |
- | 3406 | Raymond | 2014-03-07 01:38:00 | 2014-03-07 01:38:00 | 287 |
- | 1418362 | JoeJoeJoe93 | 2014-03-07 07:02:00 | 2014-03-07 07:02:00 | 5 |
- | 69884 | Sven0705 | 2014-03-07 07:02:00 | 2014-03-07 07:02:00 | 15 |
- | 366418 | Memorino | 2014-03-07 07:05:00 | 2014-03-07 07:05:00 | 80 |
- | 608538 | Schniggendiller | 2014-03-07 07:05:00 | 2014-03-07 07:05:00 | 143 |
- | 8392 | Southpark | 2014-03-07 10:06:00 | 2014-03-07 10:06:00 | 271 |
- | 1043240 | Alcide talon | 2014-03-08 19:54:00 | 2014-03-08 19:54:00 | 11 |
- | 226562 | XenonX3 | 2014-03-09 14:37:00 | 2014-03-09 14:37:00 | 154 |
- | 20199 | Hardenacke | 2014-03-09 14:38:00 | 2014-03-09 14:38:00 | 32 |
- | 1665264 | Sujalajus | 2014-03-09 18:20:00 | 2014-03-09 18:20:00 | 11 |
- | 112339 | Arnoldius | 2014-03-09 18:21:00 | 2014-03-09 18:21:00 | 72 |
- | 32254 | 80686 | 2014-03-09 19:27:00 | 2014-03-09 19:27:00 | 232 |
- | 458142 | Se4598 | 2014-03-09 23:57:00 | 2014-03-09 23:57:00 | 38 |
- | 1350030 | Malchen53 | 2014-03-09 23:58:00 | 2014-03-09 23:58:00 | 38 |
- | 236763 | Esprit Fugace | 2014-03-10 09:09:00 | 2014-03-10 09:09:00 | 22 |
- | 239250 | MichaelSchoenitzer | 2014-03-10 09:10:00 | 2014-03-10 09:10:00 | 18 |
- | 42326 | Notafish | 2014-03-10 17:10:00 | 2014-03-10 17:10:00 | 8 |
- | 722511 | JPS68 | 2014-03-10 17:10:00 | 2014-03-10 17:10:00 | 5 |
- | 54643 | Morray | 2014-03-11 02:20:00 | 2014-03-11 02:20:00 | 7 |
- | 1234041 | NacowY | 2014-03-11 02:22:00 | 2014-03-11 02:22:00 | 9 |
- | 10164 | Wiegels | 2014-03-11 18:39:00 | 2014-03-11 18:39:00 | 247 |
- | 838569 | Alraunenstern | 2014-03-11 18:39:00 | 2014-03-11 18:39:00 | 149 |
- | 65998 | Itti | 2014-03-11 18:41:00 | 2014-03-11 18:41:00 | 158 |
- | 674329 | Horst Emscher | 2014-03-11 18:45:00 | 2014-03-11 18:45:00 | 41 |
- | 135386 | J.-H. Janßen | 2014-03-11 20:36:00 | 2014-03-11 20:36:00 | 4 |
- | 1758538 | Prosperpina | 2014-03-11 23:51:00 | 2014-03-11 23:51:00 | 42 |
- | 486365 | Siegfried von Brilon | 2014-03-11 23:51:00 | 2014-03-11 23:51:00 | 40 |
- | 664928 | Pentachlorphenol | 2014-03-11 23:54:00 | 2014-03-11 23:54:00 | 29 |
- | 204466 | Graphikus | 2014-03-11 23:58:00 | 2014-03-11 23:58:00 | 52 |
- | 41136 | Pelz | 2014-03-12 07:56:00 | 2014-03-12 07:56:00 | 132 |
- | 38 | Bubo bubo | 2014-03-12 17:00:00 | 2014-03-12 17:00:00 | 142 |
- | 445977 | Pittimann | 2014-03-12 17:01:00 | 2014-03-12 17:01:00 | 167 |
- | 95589 | Tinne | 2014-03-12 18:12:00 | 2014-03-12 18:12:00 | 9 |
- | 594114 | Krd | 2014-03-12 18:12:00 | 2014-03-12 18:12:00 | 95 |
- | 344331 | Gereon K. | 2014-03-13 18:46:00 | 2014-03-13 18:46:00 | 135 |
- | 197646 | Carol.Christiansen | 2014-03-13 19:27:00 | 2014-03-13 19:27:00 | 51 |
- | 908776 | Schnute22 | 2014-03-14 08:26:00 | 2014-03-14 08:26:00 | 38 |
- | 898423 | Woelle ffm | 2014-03-14 23:15:00 | 2014-03-14 23:15:00 | 4 |
- | 81528 | Geolina163 | 2014-03-14 23:36:00 | 2014-03-14 23:36:00 | 237 |
- | 1443473 | Steinsplitter | 2014-03-14 23:37:00 | 2014-03-14 23:37:00 | 52 |
- | 364688 | Multichill | 2014-03-14 23:37:00 | 2014-03-14 23:37:00 | 24 |
- | 82279 | Syrcro | 2014-03-14 23:38:00 | 2014-03-14 23:38:00 | 100 |
- | 143352 | Holder | 2014-03-14 23:38:00 | 2014-03-14 23:38:00 | 54 |
- | 957263 | Animagus | 2014-03-15 01:11:00 | 2014-03-15 01:11:00 | 19 |
- | 203747 | Karsten11 | 2014-03-15 01:40:00 | 2014-03-15 01:40:00 | 28 |
- | 67338 | Otberg | 2014-03-15 01:40:00 | 2014-03-15 01:40:00 | 37 |
- | 49470 | Hubertl | 2014-03-15 01:44:00 | 2014-03-15 01:44:00 | 206 |
- | 3546 | Karl Gruber | 2014-03-15 01:45:00 | 2014-03-15 01:45:00 | 139 |
- | 1174302 | Graf-Stuhlhofer | 2014-03-15 01:50:00 | 2014-03-15 01:50:00 | 14 |
- | 364070 | JWBE | 2014-03-15 01:55:00 | 2014-03-15 01:55:00 | 63 |
- | 460577 | Giftpflanze | 2014-03-15 02:02:00 | 2014-03-15 02:02:00 | 129 |
- | 14261 | Ziegelbrenner | 2014-03-15 02:03:00 | 2014-03-15 02:03:00 | 46 |
- | 561850 | Robert Schediwy | 2014-03-15 02:05:00 | 2014-03-15 02:05:00 | 40 |
- | 319714 | Reaper35 | 2014-03-15 02:05:00 | 2014-03-15 02:05:00 | 27 |
- | 1685762 | Christina Burger (WMDE) | 2014-03-15 07:01:00 | 2014-03-15 07:01:00 | 62 |
- | 176827 | Stefan Knauf | 2014-03-15 09:49:00 | 2014-03-15 09:49:00 | 81 |
- | 349872 | Bücherwürmlein | 2014-03-15 11:53:00 | 2014-03-15 11:53:00 | 276 |
- | 1588355 | Grijz | 2014-03-15 16:46:00 | 2014-03-15 16:46:00 | 14 |
- | 860604 | Nederlandse Leeuw | 2014-03-15 16:46:00 | 2014-03-15 16:46:00 | 5 |
- | 1671847 | Ter-burg | 2014-03-15 16:47:00 | 2014-03-15 16:47:00 | 16 |
- | 207460 | Siebrand | 2014-03-15 16:47:00 | 2014-03-15 16:47:00 | 22 |
- | 1495706 | Ad Huikeshoven | 2014-03-15 16:47:00 | 2014-03-15 16:47:00 | 28 |
- | 489288 | Romaine | 2014-03-15 16:47:00 | 2014-03-15 16:47:00 | 142 |
- | 90737 | Aschmidt | 2014-03-15 17:47:00 | 2014-03-15 17:47:00 | 74 |
- | 262856 | Wo st 01 | 2014-03-15 17:50:00 | 2014-03-15 17:50:00 | 44 |
- | 1386142 | 1Veertje | 2014-03-15 20:33:00 | 2014-03-15 20:33:00 | 13 |
- | 582087 | Havang(nl) | 2014-03-15 20:33:00 | 2014-03-15 20:33:00 | 11 |
- | 1765863 | Spider | 2014-03-15 20:34:00 | 2014-03-15 20:34:00 | 9 |
- | 421090 | Amodorrado | 2014-03-15 22:43:00 | 2014-03-15 22:43:00 | 79 |
- | 23 | Asio otus | 2014-03-15 23:00:00 | 2014-03-15 23:00:00 | 141 |
- | 29416 | Conny | 2014-03-16 09:10:00 | 2014-03-16 09:10:00 | 155 |
- | 59279 | Atamari | 2014-03-16 09:10:00 | 2014-03-16 09:10:00 | 212 |
- | 167022 | Helfmann | 2014-03-16 09:21:00 | 2014-03-16 09:21:00 | 74 |
- | 174216 | Harry8 | 2014-03-16 09:21:00 | 2014-03-16 09:21:00 | 52 |
- | 87303 | HOPflaume | 2014-03-16 09:22:00 | 2014-03-16 09:22:00 | 125 |
- | 417536 | Lutheraner | 2014-03-16 09:24:00 | 2014-03-16 09:24:00 | 96 |
- | 756 | Ahoerstemeier | 2014-03-16 11:43:00 | 2014-03-16 11:43:00 | 6 |
- | 435025 | Markus Schulenburg | 2014-03-16 14:47:00 | 2014-03-16 14:47:00 | 80 |
- | 1825110 | Raimund Liebert (WMAT) | 2014-03-16 19:10:00 | 2014-03-16 19:10:00 | 12 |
- | 617819 | Kazkaskazkasako | 2014-03-16 20:30:00 | 2014-03-16 20:30:00 | 5 |
- | 1170878 | Fjalnes | 2014-03-16 20:30:00 | 2014-03-16 20:30:00 | 10 |
- | 282797 | Stuby | 2014-03-16 20:31:00 | 2014-03-16 20:31:00 | 32 |
- | 203563 | Stepro | 2014-03-16 21:56:00 | 2014-03-16 21:56:00 | 220 |
- | 285838 | Alchemist-hp | 2014-03-16 22:01:00 | 2014-03-16 22:01:00 | 68 |
- | 636944 | WikiAnika | 2014-03-16 22:33:00 | 2014-03-16 22:33:00 | 74 |
- | 25174 | -jkb- | 2014-03-16 22:34:00 | 2014-03-16 22:34:00 | 119 |
- | 67553 | Wahrerwattwurm | 2014-03-16 22:35:00 | 2014-03-16 22:35:00 | 189 |
- | 472828 | Walter Rademacher | 2014-03-16 22:37:00 | 2014-03-16 22:37:00 | 59 |
- | 50922 | Achim Raschka | 2014-03-17 01:01:00 | 2014-03-17 01:01:00 | 297 |
- | 48964 | Lyzzy | 2014-03-17 01:02:00 | 2014-03-17 01:02:00 | 238 |
- | 127709 | DerHexer | 2014-03-17 01:03:00 | 2014-03-17 01:03:00 | 509 |
- | 174863 | Litlok | 2014-03-17 01:03:00 | 2014-03-17 01:03:00 | 10 |
- | 185929 | Guillom | 2014-03-17 01:04:00 | 2014-03-17 01:04:00 | 23 |
- | 2379 | Seewolf | 2014-03-17 01:05:00 | 2014-03-17 01:05:00 | 278 |
- | 121095 | VIGNERON | 2014-03-17 01:08:00 | 2014-03-17 01:08:00 | 30 |
- | 4720 | Akl | 2014-03-17 01:09:00 | 2014-03-17 01:09:00 | 66 |
- | 54544 | Sebmol | 2014-03-17 01:09:00 | 2014-03-17 01:09:00 | 159 |
- | 536300 | Mich.kramer | 2014-03-17 07:38:00 | 2014-03-17 07:38:00 | 40 |
- | 1293231 | Teta pk | 2014-03-17 08:42:00 | 2014-03-17 08:42:00 | 29 |
- | 336793 | Ireas | 2014-03-17 08:56:00 | 2014-03-17 08:56:00 | 230 |
- | 1428462 | Careerfromhome | 2014-03-17 08:56:00 | 2014-03-17 08:56:00 | 13 |
- | 979378 | Ordercrazy | 2014-03-17 08:57:00 | 2014-03-17 08:57:00 | 40 |
- | 198638 | Frank schubert | 2014-03-17 08:57:00 | 2014-03-17 08:57:00 | 135 |
- | 186948 | Sargoth | 2014-03-17 08:59:00 | 2014-03-17 08:59:00 | 224 |
- | 44825 | Horgner | 2014-03-17 10:22:00 | 2014-03-17 10:22:00 | 138 |
- | 1390607 | Sjoerddebruin | 2014-03-17 10:46:00 | 2014-03-17 10:46:00 | 8 |
- | 1453732 | JurgenNL | 2014-03-17 10:46:00 | 2014-03-17 10:46:00 | 6 |
- | 1342209 | Meerdervoort | 2014-03-17 10:46:00 | 2014-03-17 10:46:00 | 6 |
- | 1486033 | SRientjes | 2014-03-17 10:48:00 | 2014-03-17 10:48:00 | 16 |
- +---------+-------------------------+---------------------+---------------------+-----------------------------+
- 170 ROWS IN SET (0.18 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement