Find Vending Machine Sellers and Offers
In Your Area
Discover trusted Vending Machine sellers
near you.
View their products, read reviews, and get in touch directly.
Whether you're looking for the best prices or the closest Vending Machine to you,
browse our listings to find exactly what you need.
Errror executing query: Duplicate column name 'timezone' check
SELECT x.*, ut.type_name
,
COALESCE((
SELECT GROUP_CONCAT(DISTINCT o.offer_category SEPARATOR ';')
FROM offers o
WHERE o.offer_shop = x.shop_id
AND o.offer_active = 1
), '') AS offerCats,
COALESCE((
SELECT GROUP_CONCAT(DISTINCT uoc.soc_category SEPARATOR ';')
FROM shopOfferCategories uoc
WHERE uoc.soc_shop = x.shop_id
), '') AS userOfferCategories,
GREATEST(x.bThirdPartyLocalPickup, COALESCE((
SELECT MAX(o.offer_bLocalPickup)
FROM offers o
WHERE o.offer_shop = x.shop_id AND o.offer_active = 1
), 0)) AS agg_bLocalPickup,
GREATEST(x.bThirdPartyLocalDelivery, COALESCE((
SELECT MAX(o.offer_bLocal)
FROM offers o
WHERE o.offer_shop = x.shop_id AND o.offer_active = 1
), 0)) AS agg_bLocal,
GREATEST(x.bThirdPartyNationalDelivery, COALESCE((
SELECT MAX(o.offer_iCourier)
FROM offers o
WHERE o.offer_shop = x.shop_id AND o.offer_active = 1
), 0)) AS agg_iCourier,
GREATEST(x.bThirdPartyInternationalDelivery, COALESCE((
SELECT MAX(o.offer_bWorldwide)
FROM offers o
WHERE o.offer_shop = x.shop_id AND o.offer_active = 1
), 0)) AS agg_bWorldwide,
GREATEST(x.bThirdPartySchedule, COALESCE((
SELECT MAX(o.offer_bSchedule)
FROM offers o
WHERE o.offer_shop = x.shop_id AND o.offer_active = 1
), 0)) AS agg_bSchedule
FROM (
/* MAIN USER PLACE */
SELECT
u.user_id,
sh.shop_id,
sh.created_at,
sh.postal_code,
sh.city,
u.phone,
sh.shop_type AS user_type,
sh.shop_name AS company_name,
u.company_name AS owner_company_name,
sh.shop_desc AS user_desc,
sh.country,
sh.street,
u.timezone,
sh.open_hours,
u.user_image,
u.user_icon,
sh.payments,
sh.w3w,
sh.fertilizers,
sh.certs,
sh.shipmentDist,
sh.currency,
sh.bMyProducts,
sh.bOrganicProducts,
sh.distUnit,
sh.state,
sh.bWantReview,
u.user_test,
sh.shop_test,
u.bAlwaysFree,
sh.stat_appProfileViews,
sh.stat_appProfileNavs,
sh.stat_appProfileContacts,
sh.stat_appProfileSocials,
sh.stat_appProfileShares,
sh.stat_webs,
sh.stat_webClicksMapPointer,
sh.nearbyCities,
sh.nearbyTowns,
sh.nearbyHamlets,
sh.nearbySuburbs,
sh.nearbyCounties,
sh.nearbyVillages,
sh.addedThirdPerson,
sh.suggestionCategory,
sh.bThirdPartyLocalPickup,
sh.bThirdPartyLocalDelivery,
sh.bThirdPartyNationalDelivery,
sh.bThirdPartyInternationalDelivery,
sh.bThirdPartySchedule,
sh.new_hours,
sh.timezone,
sh.gen_state,
sh.gen_county,
sh.gen_country,
sh.gen_city,
sh.lat AS lat,
sh.lng AS lng,
1 AS is_main_place
FROM shops sh
INNER JOIN users u ON sh.shop_owner = u.user_id
WHERE sh.approved = 1 AND sh.shop_bHidden = 0
) x
INNER JOIN seller_types ut ON ut.type_id = x.user_type
LEFT JOIN categories c ON c.cat_id = x.suggestionCategory
WHERE x.user_test = 0 AND x.shop_test = 0 AND x.user_type = '9' AND (
x.state LIKE '%South Yorkshire%'
OR x.city LIKE '%South Yorkshire%'
OR x.gen_city LIKE '%South Yorkshire%'
OR x.gen_county LIKE '%South Yorkshire%'
OR x.gen_state LIKE '%South Yorkshire%'
OR x.nearbyCities LIKE '%South Yorkshire%'
)
ORDER BY created_at DESC