Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT price_price,shop_id,price_product_id, ATAN2(
- SQRT(
- POWER(COS(RADIANS(52.15948046601807)) *SIN(RADIANS(shop_location_long - 4.491133689880371)), 2) +
- POWER(COS(RADIANS(shop_location_lat)) * SIN(RADIANS(52.15948046601807)) -
- SIN(RADIANS(shop_location_lat)) * COS(RADIANS(52.15948046601807)) *
- COS(RADIANS(shop_location_long - 4.491133689880371)), 2)), (SIN(RADIANS(shop_location_lat)) * SIN(RADIANS(52.15948046601807)) + COS(RADIANS(shop_location_lat)) * COS(RADIANS(52.15948046601807)) * COS(RADIANS(shop_location_long - 4.491133689880371)))) * 6372.795 AS distance
- FROM shops
- LEFT OUTER JOIN prices ON price_shop_id = shop_id
- HAVING distance < 0.9 AND price_product_id = 81509
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement