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.0221679210663, 0.0549600124359
| 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.0221679210663
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.0221679210663
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