Error:





SELECT CONCAT(c.FirstName, ' ' , c.LastName) as CustomerName, c.CustomerId,c.StoreConcatLink,ShowStoreHome, StoreBrandName as Name, '5' as Rate ,StoreInfoStartTime,StoreInfoEndTime,StoreLogo,StoreLat,StoreLon, Round(6371 * acos (cos ( radians() ) * cos( radians( StoreLat ) ) * cos( radians(StoreLon) - radians() ) + sin ( radians() ) * sin( radians(StoreLat) )),1) AS distance FROM tbl_gf_customers c LEFT JOIN tbl_gf_store_orders o ON c.CustomerId=o.StoreId AND o.OrderStatusId = 2 LEFT JOIN tbl_gf_store_order_items as oi on oi.OrderId = o.Id LEFT JOIN tbl_gf_countries as ctr on ctr.CountryId = c.CountryId WHERE IsDisableMerchantStore = 0 AND MerchantAccount = 1 AND StoreConcatLink != '' GROUP BY c.CustomerId HAVING distance < 20 ORDER BY distance ASC LIMIT 10

Incorrect parameter count in the call to native function 'radians'