Data Displays Results & Filters

SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz136.text v136, zz137.text v137, zz508.date v508, zz145.text v145, zz140.text v140, zz141.text v141, zz143.text v143, zz175.text v175, zz144.text v144, zz626.text v626, zz530.text v530 FROM drs LEFT JOIN zz136 ON zz136.dr=drs.id LEFT JOIN zz137 ON zz137.dr=drs.id LEFT JOIN zz508 ON zz508.dr=drs.id LEFT JOIN zz145 ON zz145.dr=drs.id LEFT JOIN zz140 ON zz140.dr=drs.id LEFT JOIN zz141 ON zz141.dr=drs.id LEFT JOIN zz143 ON zz143.dr=drs.id LEFT JOIN zz175 ON zz175.dr=drs.id LEFT JOIN zz144 ON zz144.dr=drs.id LEFT JOIN zz626 ON zz626.dr=drs.id LEFT JOIN zz530 ON zz530.dr=drs.id WHERE module = 321 and drs.hidden = false ORDER BY drs.id NULLS FIRST LIMIT 10

---

[]

---

0.104239940643, 0.125646829605

First Name	Last Name	State	derived
Karen	Smith	Maryland	one 283 karen%40gmail.com
Steve	Green	District of Columbia	one 284 steve%40gmail.com
Charles	Brown	Virginia	one 285 charles%40gmail.com
Marcia	White	Maryland	one 286 marcia%40gmail.com
Rachel	White	Maryland	one 287 rachel%40gmail.com
Karen	Jones	Maryland	one 288 jones%40gmail.com
Steve	Smith	District of Columbia	one 289 smith%40gmail.com
Charles	Green	Virginia	one 290 green%40gmail.com
Marcia	Black	Maryland	one 291 black%40gmail.com
Rachel	Red	Maryland	one 292 red%40gmail.com