Find Fresh Fish Products from Local Sellers in Cornwall (The Lizard)

Browse local sellers offering fresh, quality Fish products in Cornwall (The Lizard) and the surrounding area. Compare prices, check availability, and buy directly from producers near you. Support local farms and businesses while enjoying the freshest Fish 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 = 220 OR EXISTS (SELECT 1 FROM shopOfferCategories uoc WHERE uoc.soc_shop = x.shop_id AND uoc.soc_category = 220)) AND ( x.state LIKE '%Cornwall (The Lizard)%' OR x.city LIKE '%Cornwall (The Lizard)%' OR x.gen_city LIKE '%Cornwall (The Lizard)%' OR x.gen_county LIKE '%Cornwall (The Lizard)%' OR x.gen_state LIKE '%Cornwall (The Lizard)%' OR x.nearbyCities LIKE '%Cornwall (The Lizard)%' ) ORDER BY created_at DESC