Skip to content

Instantly share code, notes, and snippets.

@brooly

brooly/node-mysql2bug

Created September 12, 2013 22:15
Show Gist options
  • Save brooly/6544575 to your computer and use it in GitHub Desktop.
Save brooly/6544575 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
node-mysql2bug
SELECT D.ID_DATO, (6371000 * acos(cos(radians(?)) * cos(radians(X(COORDENADAS))) * cos(radians(Y(COORDENADAS))-radians(?)) + sin(radians(?)) * sin(radians(X(COORDENADAS))))) AS DISTANCIA FROM DATOS D, CALLES_PORTALES CP WHERE D.ID_MUNICIPIO=? AND D.ID_TIPOLOGIA IN (7,8) AND ID_DATO NOT IN(?,?) AND D.ID_CALLE=CP.ID_CALLE AND D.ID_MUNICIPIO=CP.ID_MUNICIPIO AND D.NUM_ORDEN=CP.NUM HAVING DISTANCIA>=0 AND DISTANCIA<=300 ORDER BY DISTANCIA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment