LMS Report
2 records found
SELECT SUM(1) OVER (PARTITION BY 1) total,
drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz136.text v136, zz530.text v530 FROM drs LEFT JOIN zz136 ON zz136.dr=drs.id LEFT JOIN zz530 ON zz530.dr=drs.id WHERE module = 921 and drs.hidden = false ORDER BY drs.id NULLS FIRST LIMIT 1000 []
0.0265920162201, 0.0537650585175
| ID | Created | Modified | Derived |
|---|---|---|---|
| 2226 | 2019-12-31 21:01:36.557238 | 2019-12-31 21:01:38.963410 | 2226 |
| 2227 | 2019-12-31 21:01:45.127636 | 2019-12-31 21:01:45.186625 | 2227 |
[+] details
one
0.0265920162201
SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz136.text v136, zz530.text v530 FROM drs LEFT JOIN zz136 ON zz136.dr=drs.id LEFT JOIN zz530 ON zz530.dr=drs.id WHERE module = 921 and drs.hidden = false ORDER BY drs.id NULLS FIRST LIMIT 1000
0.0265920162201
SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz136.text v136, zz530.text v530 FROM drs LEFT JOIN zz136 ON zz136.dr=drs.id LEFT JOIN zz530 ON zz530.dr=drs.id WHERE module = 921 and drs.hidden = false ORDER BY drs.id NULLS FIRST LIMIT 1000