running redhat 6.8, mysql 5.7.31 , php 7.2.34.x and moodle 3.9.4+
we are cleaning up our external database enrolments and noticed this in our plugin setting
|External database||1133 / 7652|
Our external db enrolment table is emptied out nightly and renamed as "manual" and that might have posed a problem in cleaning up?
What is the query to find the second one (7652 records)? I think I got the query for the first one but not the 2nd one.
I believe the first one is:
select count(courseid), enrol from mdl_enrol where enrol like '%atabas%' group by courseid, enrol desc;
just need the 2nd one so i can change them to manual LOL
trying to clean this up