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.0508677959442, 0.142360925674
| 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.0508677959442
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.0508677959442
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