MariaDB [enwiki_p]> select rc_title, rc_this_oldid, rc_last_oldid count(*) from ores_classification join recentchanges on oresc_rev = rc_this_oldid where oresc_model = 34 group by rc_title limit 50;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'count(*) from ores_classification join recentchanges on oresc_rev = rc_this_oldi' at line 1
MariaDB [enwiki_p]> select rc_title, rc_this_oldid, rc_last_oldid, count(*) from ores_classification join recentchanges on oresc_rev = rc_this_oldid where oresc_model = 34 group by rc_title limit 50;
+--------------------------------------------------+---------------+---------------+----------+
| rc_title                                         | rc_this_oldid | rc_last_oldid | count(*) |
+--------------------------------------------------+---------------+---------------+----------+
| !!!                                              |     845914759 |     845502280 |        1 |
| !important                                       |     846292191 |     367327381 |        2 |
| "Awaken,_My_Love!"                               |     845821254 |     842938311 |        2 |
| "Freeway"_Rick_Ross                              |     846367982 |     845611327 |        1 |
| "Heroes"_(David_Bowie_album)                     |     845975549 |     844884566 |        1 |
| "Heroes"_(David_Bowie_song)                      |     846346868 |     845185498 |        1 |
| "Master_Harold"...and_the_Boys                   |     845914775 |     837507597 |        1 |
| "Related_ethnic_groups"_needing_confirmation     |     845772969 |     840682147 |       16 |
| "The_Spaghetti_Incident?"                        |     846438346 |     845694655 |        1 |
| "Welding"_Kumar                                  |     846304226 |     798267859 |        1 |
| $2_billion_arms_deal                             |     845958067 |     842537697 |        1 |
| 'Abd_al-Ilah                                     |     845914785 |     843841386 |        1 |
| 'Abd_al-Rahim_ibn_Ja'far_ibn_Sulayman_al-Hashimi |     846056611 |     804874946 |        2 |
| 'Ain_Ghazal_Statues                              |     846104078 |     844727826 |        1 |
| 'Allo_'Allo!_(series_5)                          |     845834505 |     844052035 |        2 |
| 'Encore'_mandarin                                |     845905853 |     837605304 |        1 |
| 'Nduja                                           |     846367070 |     845023720 |        4 |
| 'Round_Midnight_(song)                           |     846209064 |     810896350 |        1 |
| 'Round_Springfield                               |     845837374 |     839053219 |        1 |
| 'S_Up                                            |     846304201 |     822316175 |        1 |
| 'Steel_Man'_Narendra_Chaudhary                   |     846302965 |     806349301 |        1 |
| 'The_Masterwork'_Award_Winning_Fish-Knife        |     845887298 |     811907203 |        1 |
| 'Till_Ireland_a_Nation                           |     846311762 |     812431395 |        1 |
| 'Tis_Pity_She's_a_Whore_(film)                   |     845775643 |     845348111 |        1 |
| 'Tis_So_Sweet_to_Trust_in_Jesus                  |     846073044 |     842479282 |        5 |
| 'Umar_ibn_Ibrahim_ibn_Waqid_al-'Umari            |     846269724 |     804875615 |        1 |
| '_(disambiguation)                               |     845903967 |     844203086 |        1 |
| 'night,_Mother                                   |     845914797 |     820322515 |        1 |
| 's-Hertogenbosch                                 |     846148644 |     845322236 |        2 |
| (+)-Benzo(a)pyrene-7,8-dihydrodiol-9,10-epoxide  |     846302816 |     822949314 |        1 |
| (04:30)_Idler                                    |     846305752 |     845375295 |        1 |
| (11395)_1998_XN77                                |     845993984 |     845102984 |        1 |
| (12126)_1999_RM11                                |     845983011 |             0 |        1 |
| (15436)_1998_VU30                                |     845990912 |     845106371 |        1 |
| (15440)_1998_WX4                                 |     845849579 |     845006236 |        2 |
| (16070)_1999_RB101                               |     845782377 |     845006085 |        3 |
| (23135)_2000_AN146                               |     845995285 |     845102502 |        1 |
| (275809)_2001_QY297                              |     846307945 |     843116221 |        1 |
| (34746)_2001_QE91                                |     846380604 |     845006410 |        2 |
| (3708)_1974_FV1                                  |     845992710 |     845103706 |        1 |
| (38050)_1998_VR38                                |     846388427 |     845006721 |        1 |
| (4035)_1986_WD                                   |     845897472 |     845274928 |        3 |
| (4489)_1988_AK                                   |     845992327 |     845104164 |        3 |
| (4715)_1989_TS1                                  |     845900304 |     807124084 |       10 |
| (514107)_2015_BZ509                              |     845881454 |     843869892 |        3 |
| (5648)_1990_VU1                                  |     846258150 |     807125362 |        1 |
| (6090)_1989_DJ                                   |     846247006 |     834330398 |        1 |
| (7641)_1986_TT6                                  |     845993751 |     845289004 |        1 |
| (84922)_2003_VS2                                 |     846066003 |     822331160 |        1 |
| (9799)_1996_RJ                                   |     845994406 |     845102817 |        1 |
+--------------------------------------------------+---------------+---------------+----------+
50 rows in set (1 min 35.93 sec)