Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. SELECT name, description, latitude, longitude, checkin_count
  2. FROM place
  3. where page_id in ( SELECT page_id from place where name = 'Starbucks' ) and distance(latitude, longitude, "9.961718","-84.054542") < 1000
  4.  
  5. SELECT name, description, latitude, longitude, checkin_count
  6. FROM place
  7. WHERE page_id IN ( SELECT page_id FROM place WHERE name = 'Starbucks' )
  8.  
  9. SELECT name, description, latitude, longitude, checkin_count
  10. FROM place
  11. WHERE name = 'Starbucks'
  12.  
  13. /search?q=Starbucks&type=place&center=9.961718,-84.054542&distance=1000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement