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.state LIKE '%Colchester%'
OR x.city LIKE '%Colchester%'
OR x.gen_city LIKE '%Colchester%'
OR x.gen_county LIKE '%Colchester%'
OR x.gen_state LIKE '%Colchester%'
OR x.nearbyCities LIKE '%Colchester%'
)
ORDER BY created_at DESC