Directory

SELECT COUNT(*) OVER() total, members.id id, members.id member, members.created created, members.modified modified, members.avatar, members.salt, members.handle, status, expires, username, email, handle, name_prefix, name_first, name_middle, name_last, name_suffix, lat, lng, zz143.text v143, zz175.text v175, zz144.text v144, COALESCE(zz503.int, 0) v503 FROM members , drs 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 zz503 ON zz503.dr=drs.id WHERE members.id = member and module = 0 ORDER BY members.id DESC NULLS LAST LIMIT 10

---

[['v143', u'City', u'text'], ['v175', u'State', u'text'], ['v144', u'Zip', u'text'], ['v503', u'Player', 'int']]

---

0.0935258865356, 0.118782997131

ID	Name	First Name	Last Name	City	State	Zip	Latitude	Longitude	Distance
575	575: far far	far	far	hayward	California	94545	0	0	0.0 mi/0.0 km
572	572: jorge romero	jorge	romero	new york	New York	10080	0	0	0.0 mi/0.0 km
570	570: Christian Remisio	Christian	Remisio	Doral	Florida		0	0	0.0 mi/0.0 km
568	568: hello bro www.yandex.ru hktromjjjfrt hello bro www.yandex.ru hktromjjjfrt	hello bro www.yandex.ru hktromjjjfrt	hello bro www.yandex.ru hktromjjjfrt		select...		0	0	0.0 mi/0.0 km
566	566: D Test	D	Test		select...		0	0	0.0 mi/0.0 km
564	564: D2 R	D2	R	a	Alabama	a	0	0	0.0 mi/0.0 km
559	559: Spacka Ca	Spacka	Ca	Alberta	California	T6C0Y7	0	0	0.0 mi/0.0 km
556	556: Lou Geiger	Lou	Geiger	Annapolis	Maryland	21401	0	0	0.0 mi/0.0 km
554	554: Louis Geiger	Louis	Geiger		select...		0	0	0.0 mi/0.0 km
552	552: AR Test	AR	Test		select...		0	0	0.0 mi/0.0 km