Find Fresh Other Products from Local Sellers
Near You
Browse local sellers offering fresh, quality Other products
in your area.
Compare prices, check availability, and buy directly from producers near you.
Support local farms and businesses while enjoying the freshest Other products available.
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.suggestionCategory = 500 OR EXISTS (SELECT 1 FROM shopOfferCategories uoc WHERE uoc.soc_shop = x.shop_id AND uoc.soc_category = 500))
ORDER BY created_at DESC