Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name, description, latitude, longitude, checkin_count
- FROM place
- where page_id in ( SELECT page_id from place where name = 'Starbucks' ) and distance(latitude, longitude, "9.961718","-84.054542") < 1000
- SELECT name, description, latitude, longitude, checkin_count
- FROM place
- WHERE page_id IN ( SELECT page_id FROM place WHERE name = 'Starbucks' )
- SELECT name, description, latitude, longitude, checkin_count
- FROM place
- WHERE name = 'Starbucks'
- /search?q=Starbucks&type=place¢er=9.961718,-84.054542&distance=1000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement