```
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)
```