Data Filter Nav
4 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 zz754.text ILIKE '%two%' AND zz754.text ILIKE 'two' AND (drs.id > 0) ORDER BY drs.id NULLS FIRST LIMIT 1000 []
0.0253210067749, 0.046003818512
| Nav1 | Nav2 | Nav3 |
|---|---|---|
| two | A | x |
| two | A | y |
| two | B | x |
| two | B | y |
[+] details
one
0.0253210067749
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 zz754.text ILIKE '%two%' AND zz754.text ILIKE 'two' AND (drs.id > 0) ORDER BY drs.id NULLS FIRST LIMIT 1000
0.0253210067749
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 zz754.text ILIKE '%two%' AND zz754.text ILIKE 'two' AND (drs.id > 0) ORDER BY drs.id NULLS FIRST LIMIT 1000