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.0233609676361, 0.0431339740753
| 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.0233609676361
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.0233609676361
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