PDOStatement::__set_state(array(
'queryString' => 'SELECT /* locate */ product.CLASS_KEY, product.ID, product.PROPERTY_SET_ID, product.NAME, product.SUMMARY, product.TAGLINE, product.DESCRIPTION, product.VISIBLE, product.FEATURED, product.POPULAR, product.DEFAULT_VARIANT_ID, product.DEFAULT_PRICE, product.PRODUCT_AVAILABLE, product.PRODUCT_IN_STOCK, product.PRODUCT_ON_OFFER, product.PER_VARIANT_IMAGES, product.BEST_PRICE, product.EXTRA_PRODUCT_INFO, product.ONE_PRICING, product.ONE_AVAILABILITY, product.ONE_DELIVERY, product.ONE_BUNDLE, product.ONE_STOCK, product.ONE_OPTION_SET, product.PROPORTIONAL_PRICING, product.PRODUCT_PROPORTIONAL_PRICING_ID, product.VARIANT_PRICING_ID, product.BUNDLE_POLICY_ID, product.META_DATA_ID, product.WISHES, product.LIKES, product.RATING, product.SLUG, product.LATITUDE, product.LONGITUDE, product.MAP_ICON, product.CREATED_AT, product.CREATED_BY, product.UPDATED_AT, product.UPDATED_BY, IFNULL(ABS(3959 * ACOS(0.766479829971 * COS(RADIANS(product.LATITUDE)) * COS(RADIANS(product.LONGITUDE) - -1.448602233975) + 0.642268378677 * SIN(RADIANS(product.LATITUDE)))),0) AS Distance FROM `product` WHERE product.VISIBLE=:p1 AND IFNULL(ABS(3959 * ACOS(0.766479829971 * COS(RADIANS(product.LATITUDE)) * COS(RADIANS(product.LONGITUDE) - -1.448602233975) + 0.642268378677 * SIN(RADIANS(product.LATITUDE)))),0) <= :p2 ORDER BY Distance ASC',
))
Find Your Nearest Branch
Search results
Found 0 Branches within 50 miles of Columbus