sql - Moodle schema changes? -

with recent upgrade moodle 2.7, customer of ours reporting customsql reports failing. example, this query used report gradeable items, fails now:

select  u.firstname "first", u.lastname "last", c.fullname "course", a.name "assignment"  prefix_assignment_submissions asb join prefix_assignment on a.id = asb.assignment join prefix_user u on u.id = asb.userid join prefix_course c on c.id = a.course join prefix_course_modules cm on c.id = cm.course  asb.grade < 0 , cm.instance = a.id , cm.module = 1 order c.fullname, a.name, u.lastname 

a quick query or 2 db shows there 0 rows in prefix_assignment_submissions , prefix_assignment. suggestions?

the assignment module replaced assign module in moodle 2.2.

the old assignment module disabled default in moodle 2.5 (i think) , removed in moodle 2.7.

the query need rewriting use assign_submissions table (and other assign_* tables relevant).