Debug info: SELECT cm.*, m.name, md.name AS modname , cw.section AS sectionnum FROM {course_modules} cm JOIN {modules} md ON md.id = cm.module JOIN {folder} m ON m.id = cm.instance LEFT JOIN {course_sections} cw ON cw.id = cm.section WHERE cm.id = :cmid AND md.name = :modulename