Data Filter Nav
8 records found
SELECT SUM(1) OVER (PARTITION BY 1) total,
drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz754.text v754, zz755.text v755, zz756.text v756 FROM drs LEFT JOIN zz754 ON zz754.dr=drs.id LEFT JOIN zz755 ON zz755.dr=drs.id LEFT JOIN zz756 ON zz756.dr=drs.id WHERE module = 752 and drs.hidden = false AND (drs.id > 0) ORDER BY drs.id NULLS FIRST LIMIT 1000 []
0.0491189956665, 0.089802980423
| Nav1 | Nav2 | Nav3 |
|---|---|---|
| one | A | x |
| one | A | y |
| one | B | x |
| one | B | y |
| two | A | x |
| two | A | y |
| two | B | x |
| two | B | y |
[+] details
one
0.0491189956665
SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz754.text v754, zz755.text v755, zz756.text v756 FROM drs LEFT JOIN zz754 ON zz754.dr=drs.id LEFT JOIN zz755 ON zz755.dr=drs.id LEFT JOIN zz756 ON zz756.dr=drs.id WHERE module = 752 and drs.hidden = false AND (drs.id > 0) ORDER BY drs.id NULLS FIRST LIMIT 1000
0.0491189956665
SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz754.text v754, zz755.text v755, zz756.text v756 FROM drs LEFT JOIN zz754 ON zz754.dr=drs.id LEFT JOIN zz755 ON zz755.dr=drs.id LEFT JOIN zz756 ON zz756.dr=drs.id WHERE module = 752 and drs.hidden = false AND (drs.id > 0) ORDER BY drs.id NULLS FIRST LIMIT 1000