Уф. Нашёл в старых бэкапах и осилил, таки, загрузить дамп БД от 09.08.2013. Так сказать, до всякого шума и пыли и почти наш период времени. Если интересно, срезы тех, кто отсутствует в течении трёх месяцев:
1000 постов:
select username, id, num_posts, from_unixtime(last_post) from users where num_posts >= 1000 and last_post between 1 and unix_timestamp('2013-03-09') order by last_post desc;
+---------------------------+-------+-----------+--------------------------+
| username | id | num_posts | from_unixtime(last_post) |
+---------------------------+-------+-----------+--------------------------+
| Дм. Журко | 818 | 1673 | 2013-03-05 15:44:28 |
| Bell | 2012 | 5607 | 2013-02-28 11:25:08 |
| STELS | 22214 | 1080 | 2013-02-23 15:04:23 |
| Конструктор | 35 | 5442 | 2013-02-23 11:49:36 |
| Старый | 34 | 20047 | 2013-02-19 13:51:13 |
| Klaus | 5525 | 1128 | 2013-02-10 22:46:47 |
| И76 | 28467 | 1305 | 2013-02-08 18:29:15 |
| Ропот | 7651 | 1902 | 2013-02-03 22:29:15 |
| Jameson | 356 | 1518 | 2013-01-29 18:48:46 |
| uagg | 3945 | 1867 | 2013-01-19 20:04:48 |
| yrok | 29503 | 2962 | 2013-01-07 23:37:15 |
| john5r | 6977 | 17074 | 2013-01-02 11:45:41 |
| sabakka | 5237 | 3472 | 2012-12-30 18:53:37 |
| davex | 26458 | 1760 | 2012-12-23 23:51:54 |
| Просто Зомби | 2804 | 2523 | 2012-12-22 23:44:07 |
| Redav | 6449 | 3276 | 2012-12-21 02:45:36 |
| Фигурант | 5199 | 2175 | 2012-12-19 20:28:02 |
| Yuran | 2167 | 1927 | 2012-12-19 14:38:44 |
| yacc | 26729 | 14027 | 2012-12-19 12:48:51 |
| 140466(ака Нумер) | 1612 | 4969 | 2012-12-17 03:17:18 |
| leon | 102 | 1822 | 2012-12-16 00:31:31 |
| Harsky | 6029 | 1703 | 2012-12-15 05:39:21 |
| Lamm | 3420 | 6137 | 2012-12-12 14:34:24 |
| Иван Тиринов | 6045 | 1328 | 2012-12-06 12:26:49 |
| Atom44 | 7286 | 2350 | 2012-11-29 22:59:13 |
| Tzvk | 8099 | 2032 | 2012-11-22 11:36:49 |
| Savage | 3300 | 1486 | 2012-11-22 09:45:36 |
| MPK | 4432 | 1866 | 2012-11-19 00:28:40 |
| шурави | 5166 | 5408 | 2012-11-15 16:16:33 |
| Дядюшка ВB. | 26553 | 2883 | 2012-11-04 23:12:33 |
| DD | 7107 | 1083 | 2012-10-29 20:32:31 |
| TT | 154 | 7167 | 2012-10-14 20:42:49 |
| lenivec | 4949 | 9333 | 2012-10-03 19:06:17 |
| Guennady | 1675 | 1293 | 2012-09-27 03:35:23 |
| au | 145 | 27790 | 2012-09-17 11:01:45 |
| vvu | 24846 | 1352 | 2012-09-16 17:18:58 |
| 61284 | 3476 | 1053 | 2012-08-30 20:18:10 |
| Deep Blue Sea | 27397 | 3655 | 2012-08-15 05:06:07 |
| TEvg | 60 | 24000 | 2012-08-11 10:36:09 |
| pokos | 3405 | 8797 | 2012-08-10 16:29:28 |
| Dio69 | 6383 | 7661 | 2012-08-10 08:31:17 |
| V.T. | 233 | 2420 | 2012-08-09 23:46:40 |
| БИП1134 | 84625 | 1044 | 2012-07-29 22:58:08 |
| Bredonosec | 2631 | 35139 | 2012-07-28 04:48:29 |
| артём | 4869 | 3239 | 2012-07-26 18:22:27 |
| geograf | 35928 | 1207 | 2012-07-10 14:25:00 |
| zyxman | 30902 | 1238 | 2012-06-25 04:24:40 |
| NewPilot | 144 | 1060 | 2012-05-30 08:48:05 |
| Santey | 211 | 1464 | 2012-04-14 19:13:08 |
| AidarM | 151 | 9446 | 2012-03-18 23:22:42 |
| HolyBoy | 7039 | 4919 | 2012-03-10 23:11:00 |
| dercoolman | 3298 | 1517 | 2011-12-31 20:11:19 |
| hnick | 30352 | 6087 | 2011-12-09 13:05:54 |
| Wyvern | 183 | 5667 | 2011-12-06 16:12:54 |
| asoneofus | 92 | 3477 | 2011-12-06 01:42:57 |
| А. Н. | 4160 | 8264 | 2011-11-25 20:17:54 |
| alef | 26818 | 1347 | 2011-10-21 09:12:01 |
| Darth | 62 | 1962 | 2011-08-04 21:36:57 |
| пираты8 | 28932 | 1363 | 2011-07-28 17:11:31 |
| DOBRENKO | 31621 | 1066 | 2011-07-06 08:47:32 |
| Naturalist | 28241 | 5788 | 2011-07-04 20:22:03 |
| Vyacheslav | 2520 | 1582 | 2011-06-20 14:24:32 |
| alexship | 29976 | 1177 | 2011-05-28 18:38:29 |
| l7pometeu | 29524 | 1146 | 2011-05-15 23:22:12 |
| Sidorov | 25200 | 1356 | 2011-05-09 09:59:59 |
| вантох | 2236 | 2449 | 2011-04-28 17:09:16 |
| Boroda | 2339 | 2902 | 2011-04-04 14:09:11 |
| messer | 5441 | 1351 | 2011-03-29 02:58:39 |
| VooDoo | 153 | 5287 | 2011-03-15 07:54:47 |
| marata | 5788 | 9170 | 2011-02-19 21:03:46 |
| Karev1 | 27679 | 1811 | 2011-02-02 21:17:15 |
| israel | 166 | 19994 | 2011-01-30 00:00:27 |
| Kernel3 | 27104 | 5635 | 2011-01-10 15:57:01 |
| termostat | 833 | 5546 | 2010-12-12 09:23:02 |
| Walera | 6488 | 1523 | 2010-11-04 22:53:56 |
| Melnikov | 96 | 1496 | 2010-09-28 22:32:44 |
| Black Sea | 2160 | 1475 | 2010-09-27 14:53:14 |
| Антefy | 32450 | 1020 | 2010-08-17 23:37:20 |
| Shurik | 252 | 4679 | 2010-08-13 18:12:37 |
| Д.Сергей | 6181 | 1820 | 2010-08-12 11:05:55 |
| Тихон | 236 | 2579 | 2010-08-10 18:10:49 |
| ole-chalij | 33430 | 1000 | 2010-08-05 11:51:21 |
| Cannon | 4430 | 3779 | 2010-07-29 11:47:44 |
| varyag | 6693 | 3153 | 2010-05-25 20:27:28 |
| Murkt | 21761 | 3037 | 2010-05-12 21:36:38 |
| nemos | 7191 | 1439 | 2010-02-09 20:38:02 |
| Baron_Gerlah | 25658 | 1048 | 2009-12-17 11:43:17 |
| Сей | 4109 | 1928 | 2009-12-05 21:06:41 |
| timochka | 361 | 2486 | 2009-12-04 22:39:11 |
| Dutch | 2302 | 3121 | 2009-11-27 00:46:07 |
| Klim | 6495 | 2902 | 2009-11-21 18:30:18 |
| RUS_7777 | 2583 | 4867 | 2009-11-09 17:22:34 |
+---------------------------+-------+-----------+--------------------------+
92 rows in set (0.00 sec)
500 постов:
select username, id, num_posts, from_unixtime(last_post) from users where num_posts >= 500 and last_post between 1 and unix_timestamp('2013-03-09') order by last_post desc;
+------------------------------------------+-------+-----------+--------------------------+
| username | id | num_posts | from_unixtime(last_post) |
+------------------------------------------+-------+-----------+--------------------------+
| Дм. Журко | 818 | 1673 | 2013-03-05 15:44:28 |
| Lans | 6762 | 530 | 2013-03-04 10:52:10 |
| 3 AS | 26257 | 553 | 2013-03-03 00:25:50 |
| Bell | 2012 | 5607 | 2013-02-28 11:25:08 |
| STELS | 22214 | 1080 | 2013-02-23 15:04:23 |
| Конструктор | 35 | 5442 | 2013-02-23 11:49:36 |
| alvik | 29879 | 761 | 2013-02-21 06:05:33 |
| bectep | 26174 | 503 | 2013-02-20 21:22:00 |
| Старый | 34 | 20047 | 2013-02-19 13:51:13 |
| a1tra | 6157 | 533 | 2013-02-16 20:02:43 |
| Klaus | 5525 | 1128 | 2013-02-10 22:46:47 |
| И76 | 28467 | 1305 | 2013-02-08 18:29:15 |
| Ропот | 7651 | 1902 | 2013-02-03 22:29:15 |
| Jameson | 356 | 1518 | 2013-01-29 18:48:46 |
| Leroy | 191 | 770 | 2013-01-25 18:55:06 |
| OlM | 834 | 602 | 2013-01-24 16:12:58 |
| PZ | 84039 | 601 | 2013-01-22 00:49:10 |
| uagg | 3945 | 1867 | 2013-01-19 20:04:48 |
| yrok | 29503 | 2962 | 2013-01-07 23:37:15 |
| john5r | 6977 | 17074 | 2013-01-02 11:45:41 |
| sabakka | 5237 | 3472 | 2012-12-30 18:53:37 |
| davex | 26458 | 1760 | 2012-12-23 23:51:54 |
| Просто Зомби | 2804 | 2523 | 2012-12-22 23:44:07 |
| Pro100Pavlovith | 29478 | 582 | 2012-12-21 21:33:07 |
| kontrbizan | 41901 | 511 | 2012-12-21 17:58:10 |
| Redav | 6449 | 3276 | 2012-12-21 02:45:36 |
| Фигурант | 5199 | 2175 | 2012-12-19 20:28:02 |
| nester65 | 29338 | 626 | 2012-12-19 20:10:42 |
| Yuran | 2167 | 1927 | 2012-12-19 14:38:44 |
| yacc | 26729 | 14027 | 2012-12-19 12:48:51 |
| loderunner | 64900 | 566 | 2012-12-17 16:10:33 |
| 140466(ака Нумер) | 1612 | 4969 | 2012-12-17 03:17:18 |
| leon | 102 | 1822 | 2012-12-16 00:31:31 |
| s.nikolaychik | 85424 | 591 | 2012-12-15 10:59:46 |
| Harsky | 6029 | 1703 | 2012-12-15 05:39:21 |
| Makedon | 86001 | 534 | 2012-12-14 16:41:03 |
| Lamm | 3420 | 6137 | 2012-12-12 14:34:24 |
| вован22 | 33356 | 565 | 2012-12-09 19:39:29 |
| Иван Тиринов | 6045 | 1328 | 2012-12-06 12:26:49 |
| Atom44 | 7286 | 2350 | 2012-11-29 22:59:13 |
| Tzvk | 8099 | 2032 | 2012-11-22 11:36:49 |
| Savage | 3300 | 1486 | 2012-11-22 09:45:36 |
| MPK | 4432 | 1866 | 2012-11-19 00:28:40 |
| шурави | 5166 | 5408 | 2012-11-15 16:16:33 |
| Дядюшка ВB. | 26553 | 2883 | 2012-11-04 23:12:33 |
| DD | 7107 | 1083 | 2012-10-29 20:32:31 |
| Vovaka | 29258 | 550 | 2012-10-28 20:05:18 |
| arnold | 6787 | 511 | 2012-10-23 21:37:20 |
| TT | 154 | 7167 | 2012-10-14 20:42:49 |
| mahown | 29631 | 930 | 2012-10-04 11:17:52 |
| lenivec | 4949 | 9333 | 2012-10-03 19:06:17 |
| Guennady | 1675 | 1293 | 2012-09-27 03:35:23 |
| au | 145 | 27790 | 2012-09-17 11:01:45 |
| vvu | 24846 | 1352 | 2012-09-16 17:18:58 |
| A_E_Z | 173 | 916 | 2012-09-16 16:29:22 |
| oponent | 27458 | 985 | 2012-09-07 17:28:34 |
| 61284 | 3476 | 1053 | 2012-08-30 20:18:10 |
| boiler technician | 47465 | 575 | 2012-08-28 12:15:19 |
| LOT | 30497 | 567 | 2012-08-23 00:45:54 |
| AdmiralHood | 28913 | 590 | 2012-08-21 16:27:37 |
| KROTT | 6673 | 537 | 2012-08-18 20:52:58 |
| Deep Blue Sea | 27397 | 3655 | 2012-08-15 05:06:07 |
| TEvg | 60 | 24000 | 2012-08-11 10:36:09 |
| pokos | 3405 | 8797 | 2012-08-10 16:29:28 |
| Dio69 | 6383 | 7661 | 2012-08-10 08:31:17 |
| V.T. | 233 | 2420 | 2012-08-09 23:46:40 |
| vasilisk | 7412 | 691 | 2012-08-02 23:40:39 |
| БИП1134 | 84625 | 1044 | 2012-07-29 22:58:08 |
| Bredonosec | 2631 | 35139 | 2012-07-28 04:48:29 |
| артём | 4869 | 3239 | 2012-07-26 18:22:27 |
| DSB | 26558 | 603 | 2012-07-25 20:04:54 |
| PSKR | 25274 | 799 | 2012-07-18 14:51:18 |
| geograf | 35928 | 1207 | 2012-07-10 14:25:00 |
| AndreyV | 7255 | 554 | 2012-07-02 11:40:47 |
| zyxman | 30902 | 1238 | 2012-06-25 04:24:40 |
| NewPilot | 144 | 1060 | 2012-05-30 08:48:05 |
| Santey | 211 | 1464 | 2012-04-14 19:13:08 |
| AlexeyOD | 50380 | 528 | 2012-04-13 16:54:14 |
| ZIMI | 11179 | 827 | 2012-04-11 01:43:33 |
| Lev1 | 29594 | 964 | 2012-03-31 03:07:03 |
| Vladyslav Vlad | 51274 | 666 | 2012-03-23 00:03:57 |
| AidarM | 151 | 9446 | 2012-03-18 23:22:42 |
| HolyBoy | 7039 | 4919 | 2012-03-10 23:11:00 |
| Raoo | 65352 | 500 | 2012-02-23 17:45:52 |
| Antoine | 33285 | 965 | 2012-02-14 23:24:47 |
| PSS | 3318 | 651 | 2012-02-14 12:21:59 |
| Skula | 2527 | 595 | 2012-02-02 04:54:41 |
| Кметь | 1972 | 558 | 2012-01-22 19:16:07 |
| dercoolman | 3298 | 1517 | 2011-12-31 20:11:19 |
| Morti | 2972 | 566 | 2011-12-21 12:28:30 |
| hnick | 30352 | 6087 | 2011-12-09 13:05:54 |
| OAS | 26969 | 530 | 2011-12-08 23:54:06 |
| Wyvern | 183 | 5667 | 2011-12-06 16:12:54 |
| asoneofus | 92 | 3477 | 2011-12-06 01:42:57 |
| IDiO | 3472 | 756 | 2011-11-30 14:15:53 |
| max81 | 84035 | 562 | 2011-11-27 20:45:39 |
| А. Н. | 4160 | 8264 | 2011-11-25 20:17:54 |
| bjaka_max | 48336 | 695 | 2011-11-19 19:49:38 |
| alef | 26818 | 1347 | 2011-10-21 09:12:01 |
| Chizh | 118 | 972 | 2011-10-14 21:04:08 |
| Moss | 174 | 757 | 2011-10-06 10:22:09 |
| Darth | 62 | 1962 | 2011-08-04 21:36:57 |
| Retviz@N | 2682 | 512 | 2011-08-01 19:50:02 |
| Danilmaster | 2401 | 581 | 2011-07-28 21:56:27 |
| пираты8 | 28932 | 1363 | 2011-07-28 17:11:31 |
| Rohirrim | 24853 | 706 | 2011-07-26 13:42:20 |
| Vandal | 2353 | 834 | 2011-07-07 15:40:41 |
| DOBRENKO | 31621 | 1066 | 2011-07-06 08:47:32 |
| Naturalist | 28241 | 5788 | 2011-07-04 20:22:03 |
| Black77 | 7220 | 852 | 2011-06-28 02:14:02 |
| Deniska Sergeevich | 25604 | 713 | 2011-06-26 22:29:53 |
| BAT_163 | 80772 | 973 | 2011-06-23 20:02:35 |
| Vyacheslav | 2520 | 1582 | 2011-06-20 14:24:32 |
| ing | 1415 | 789 | 2011-06-16 21:52:09 |
| alexship | 29976 | 1177 | 2011-05-28 18:38:29 |
| 77043 | 31505 | 883 | 2011-05-25 11:07:34 |
| l7pometeu | 29524 | 1146 | 2011-05-15 23:22:12 |
| Sidorov | 25200 | 1356 | 2011-05-09 09:59:59 |
| К-157 | 45234 | 553 | 2011-05-05 21:44:32 |
| вантох | 2236 | 2449 | 2011-04-28 17:09:16 |
| rpk | 4889 | 545 | 2011-04-11 15:17:59 |
| Boroda | 2339 | 2902 | 2011-04-04 14:09:11 |
| фанат Kylie | 29396 | 684 | 2011-04-01 10:44:00 |
| messer | 5441 | 1351 | 2011-03-29 02:58:39 |
| VooDoo | 153 | 5287 | 2011-03-15 07:54:47 |
| marata | 5788 | 9170 | 2011-02-19 21:03:46 |
| Karev1 | 27679 | 1811 | 2011-02-02 21:17:15 |
| israel | 166 | 19994 | 2011-01-30 00:00:27 |
| Kernel3 | 27104 | 5635 | 2011-01-10 15:57:01 |
| Алекс1980 | 5685 | 775 | 2010-12-16 11:13:12 |
| termostat | 833 | 5546 | 2010-12-12 09:23:02 |
| Walera | 6488 | 1523 | 2010-11-04 22:53:56 |
| Melnikov | 96 | 1496 | 2010-09-28 22:32:44 |
| Black Sea | 2160 | 1475 | 2010-09-27 14:53:14 |
| Антefy | 32450 | 1020 | 2010-08-17 23:37:20 |
| Shurik | 252 | 4679 | 2010-08-13 18:12:37 |
| Д.Сергей | 6181 | 1820 | 2010-08-12 11:05:55 |
| Тихон | 236 | 2579 | 2010-08-10 18:10:49 |
| ole-chalij | 33430 | 1000 | 2010-08-05 11:51:21 |
| Cannon | 4430 | 3779 | 2010-07-29 11:47:44 |
| Lioxa | 1746 | 886 | 2010-07-27 20:04:35 |
| Барон Ротшильд | 3916 | 699 | 2010-07-21 00:12:51 |
| varyag | 6693 | 3153 | 2010-05-25 20:27:28 |
| Murkt | 21761 | 3037 | 2010-05-12 21:36:38 |
| sergey_manakov | 5965 | 524 | 2010-02-17 10:26:43 |
| nemos | 7191 | 1439 | 2010-02-09 20:38:02 |
| 9-лшт1263 | 27200 | 789 | 2010-01-31 10:11:45 |
| helicopter | 6652 | 558 | 2010-01-12 21:47:16 |
| flogger11 | 2836 | 982 | 2010-01-10 23:26:28 |
| Хок196 | 28246 | 931 | 2010-01-09 02:37:42 |
| Baron_Gerlah | 25658 | 1048 | 2009-12-17 11:43:17 |
| goodmen59 | 6284 | 615 | 2009-12-16 15:32:50 |
| Сей | 4109 | 1928 | 2009-12-05 21:06:41 |
| timochka | 361 | 2486 | 2009-12-04 22:39:11 |
| Dutch | 2302 | 3121 | 2009-11-27 00:46:07 |
| Klim | 6495 | 2902 | 2009-11-21 18:30:18 |
| RUS_7777 | 2583 | 4867 | 2009-11-09 17:22:34 |
| Марк | 5829 | 532 | 2009-11-07 11:34:17 |
| Инженер-лейтенант-2-ой | 32349 | 648 | 2009-11-01 11:46:00 |
+------------------------------------------+-------+-----------+--------------------------+
159 rows in set (0.00 sec)
Интересно смотреть пересечения с актуальной базой. Например, список «вернувшихся»:
create temporary table lost_users_500 (select username, id, num_posts, from_unixtime(last_post) from users where num_posts >= 500 and last_post between 1 and unix_timestamp('2013-03-09') order by last_post desc);
select username, id from lost_users_500 where id in (select id from AB_FORUMS.users where last_post >= unix_timestamp('2013-03-09'));
+---------------------------+-------+
| username | id |
+---------------------------+-------+
| Дм. Журко | 818 |
| Lans | 6762 |
| Bell | 2012 |
| STELS | 22214 |
| Конструктор | 35 |
| alvik | 29879 |
| Старый | 34 |
| a1tra | 6157 |
| И76 | 28467 |
| Ропот | 7651 |
| Jameson | 356 |
| Leroy | 191 |
| uagg | 3945 |
| sabakka | 5237 |
| davex | 26458 |
| Просто Зомби | 2804 |
| kontrbizan | 41901 |
| yacc | 26729 |
| 140466(ака Нумер) | 1612 |
| leon | 102 |
| Harsky | 6029 |
| Makedon | 86001 |
| Lamm | 3420 |
| вован22 | 33356 |
| Tzvk | 8099 |
| шурави | 5166 |
| Дядюшка ВB. | 26553 |
| DD | 7107 |
| TT | 154 |
| mahown | 29631 |
| lenivec | 4949 |
| Guennady | 1675 |
| vvu | 24846 |
| LOT | 30497 |
| pokos | 3405 |
| V.T. | 233 |
| Bredonosec | 2631 |
| PSKR | 25274 |
| geograf | 35928 |
| AndreyV | 7255 |
| NewPilot | 144 |
| Santey | 211 |
| HolyBoy | 7039 |
| PSS | 3318 |
| OAS | 26969 |
| asoneofus | 92 |
| IDiO | 3472 |
| bjaka_max | 48336 |
| Moss | 174 |
| Black77 | 7220 |
| 77043 | 31505 |
| вантох | 2236 |
| Kernel3 | 27104 |
| Lioxa | 1746 |
| helicopter | 6652 |
| Klim | 6495 |
+---------------------------+-------+
56 rows in set (0.24 sec)
Т.е. на 159 пропавших, 56 потом вернулись.
Из них 28 потом снова не писали в течении трёх месяцев:
select l.username, l.id from lost_users_500 l inner join AB_FORUMS.users u on l.id = u.id where last_post between unix_timestamp('2013-03-09') and unix_timestamp('2015-06-15');
+---------------------------+-------+
| username | id |
+---------------------------+-------+
| Lans | 6762 |
| STELS | 22214 |
| a1tra | 6157 |
| Jameson | 356 |
| Leroy | 191 |
| uagg | 3945 |
| davex | 26458 |
| 140466(ака Нумер) | 1612 |
| Harsky | 6029 |
| Makedon | 86001 |
| вован22 | 33356 |
| Tzvk | 8099 |
| Дядюшка ВB. | 26553 |
| DD | 7107 |
| Guennady | 1675 |
| vvu | 24846 |
| pokos | 3405 |
| PSKR | 25274 |
| AndreyV | 7255 |
| NewPilot | 144 |
| Santey | 211 |
| IDiO | 3472 |
| bjaka_max | 48336 |
| Black77 | 7220 |
| вантох | 2236 |
| Kernel3 | 27104 |
| helicopter | 6652 |
| Klim | 6495 |
+---------------------------+-------+
28 rows in set (0.00 sec)
В общем, я выше привёл данные для графика частоты ухода на 2013-й год. Интересно бы было посмотреть его визуализацию