findtruckservice.com Logo
Loading data..

Mention

Find Truck Service! receive discounts from our participating vendors.



Repair Shop Truck Shops in or near Mesa Area, AZ

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*pi()/180 )*COS(latitude*pi()/180) *POWER(SIN((-longitude)*pi()/180' at line 35 SELECT `id`, `service_type`, `adtype`, `name`, `interstate`, `milemarker`, `address`, `city`, `state`, `zip`, `latitude`, `longitude`, `description`, `image`, `category`, `subcategory`, `phone`, `fax`, `afterhours`, `website`, `website2`, `email`, `specials`, `cid`, `247`, `hours`, `special_hours`, `impressions`, `ameneties`, `fuel_price`, `fuel_updated`, `status`, 3956 * 2 * ASIN(SQRT( POWER(SIN(( - latitude)*pi()/180/2),2) +COS(*pi()/180 )*COS(latitude*pi()/180) *POWER(SIN((-longitude)*pi()/180/2),2))) as distance FROM `db487459190`.ads WHERE longitude between (-250/cos(radians())*69) and (+250/cos(radians())*69) and latitude between (-(250/69)) and (+(250/69)) and `approved` != 'suspend' and `status` = 1 and `zip` != 0 and `category` LIKE '%Repair Shops%' and `subcategory` LIKE '%Truck Shops%' having distance < 250 ORDER BY distance limit 100