Advertisement
Guest User

Untitled

a guest
May 20th, 2017
367
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT price_price,shop_id,price_product_id, ATAN2(
  2. SQRT(  
  3.  POWER(COS(RADIANS(52.15948046601807)) *SIN(RADIANS(shop_location_long - 4.491133689880371)), 2) +    
  4. POWER(COS(RADIANS(shop_location_lat)) * SIN(RADIANS(52.15948046601807)) -
  5. SIN(RADIANS(shop_location_lat)) * COS(RADIANS(52.15948046601807)) *
  6. 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  
  7.  FROM shops
  8. LEFT OUTER JOIN prices ON price_shop_id = shop_id
  9. HAVING distance < 0.9 AND price_product_id = 81509
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement