ZIP Proximity
3 records found
SELECT SUM(1) OVER (PARTITION BY 1) total,
drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz991.text v991, zz143.text v143, zz175.text v175, zipdistance(zz144.text,'') d_zz144, zz144.text v144 FROM drs LEFT JOIN zz991 ON zz991.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 WHERE module = 990 and drs.hidden = false ORDER BY d_zz144 NULLS FIRST, drs.id NULLS FIRST LIMIT 1000 []
0.0753960609436, 0.100618839264
| ID | City | Zip | Dist. |
|---|---|---|---|
| 2434 | Long Lake | 12847 | -- miles to Long Lake 12847 |
| 2435 | Hanover | 21076 | -- miles to Hanover 21076 |
| 2436 | Annapolis | 21401 | -- miles to Annapolis 21401 |
[+] details
one
0.0753960609436
SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz991.text v991, zz143.text v143, zz175.text v175, zipdistance(zz144.text,'') d_zz144, zz144.text v144 FROM drs LEFT JOIN zz991 ON zz991.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 WHERE module = 990 and drs.hidden = false ORDER BY d_zz144 NULLS FIRST, drs.id NULLS FIRST LIMIT 1000
0.0753960609436
SELECT SUM(1) OVER (PARTITION BY 1) total, drs.id id, drs.member, drs.created, drs.modified, drs.hidden, drs.step, zz991.text v991, zz143.text v143, zz175.text v175, zipdistance(zz144.text,'') d_zz144, zz144.text v144 FROM drs LEFT JOIN zz991 ON zz991.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 WHERE module = 990 and drs.hidden = false ORDER BY d_zz144 NULLS FIRST, drs.id NULLS FIRST LIMIT 1000