u.id AS userid,
ue.timestart AS otimestart,
(ue.timestart + cr.enrolperiod) AS ctimestart,
- ue.timeenrolled AS otimeenrolled,
- (ue.timeenrolled + cr.enrolperiod) AS ctimeenrolled
+ ue.timecreated AS otimeenrolled,
+ (ue.timecreated + cr.enrolperiod) AS ctimeenrolled
FROM
{user} u
INNER JOIN
AND
(
ue.timestart > 0 AND ue.timestart + cr.enrolperiod < ?
- OR ue.timeenrolled > 0 AND ue.timeenrolled + cr.enrolperiod < ?
+ OR ue.timecreated > 0 AND ue.timecreated + cr.enrolperiod < ?
)
';
u.id AS userid,
crc.id AS completionid,
ue.timestart,
- ue.timeenrolled
+ ue.timecreated
FROM
{user} u
INNER JOIN
AND u.deleted = 0
AND ue.timestart < ?
AND (ue.timeend > ? OR ue.timeend = 0)
- AND ue.timeenrolled < ?
- AND (ue.timeenrolled > ? OR ue.timeenrolled = 0)
+ AND ue.timecreated < ?
+ AND (ue.timecreated > ? OR ue.timecreated = 0)
ORDER BY
course,
userid