Cover Your Car - Tailored and Fitted Car Covers Worldwide

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='252' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products_categories.categoryid='252' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products_categories.categoryid IN (575,576,577,578,579,580,581,582,583,600,601,602,720,845,851,912) AND xcart_products.views_stats>0 AND xcart_products.sales_stats > 0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
Cover Your Car - Tailored and Fitted Car Covers Worldwide :: Lancia

CALL US IN THE UK: +44(0)1744 633985 : Company No 6305502

Home

[ Basket ]

Cover Types

Contact

Instagram

Shipping

Cycle Team

Live Chat

Search:

Advanced search

Secure login

	View cart

	Checkout

If Javascript is disabled in your browser click here

Printable version

	Categories

	Charge Port Kit

	Car Cover Alarm

	Cover Accessories

	Reveal Car Covers

	Wheel Covers

	Abarth

	AC

	Alfa Romeo

	Alpine

	American Classics

	Aston Martin

	Audi

	Austin

	Austin Healey

	Beach Buggy

	Beauford Tourer

	Bentley

	BMW

	Bristol

	Cadillac

	Caterham

	Chevrolet

	Chrysler

	Citroen

	Dacia

	Daihatsu

	Daimler

	Datsun

	DeLorean

	Dodge

	Ferrari

	FIAT

	Ford

	Hearse (Funeral Car)

	Hillman

	Honda

	Hummer

	Hyundai

	Infiniti

	Jaguar

	Jeep

	Jensen

	Kia

	Lamborghini

	Lancia

	Land Rover

	Lexus

	Lincoln & Stretch

	Lomax

	London Taxi

	Lotus

	Marcos

	Marlin

	Maserati

	Mazda

	McLaren

	Mercedes

	MG

	Mini

	Mitsubishi

	Moke

	Morgan

	Morris

	Nissan

	Opel

	Peugeot

	Pontiac Firebird

	Porsche

	Proton

	Range Rover

	Renault

	Riley

	Robin Hood Kit Car

	Rolls Royce

	Rover

	Saab

	Scimitar

	Seat

	Skoda

	Smart Car

	SsangYong

	Subaru

	Sunbeam

	Suzuki

	Tesla

	Toyota

	Triumph

	TVR

	Van Covers

	Vauxhall

	Volvo

	VW

	Westfield

	Wolseley

	Motorcycle Covers

	Cycle Covers

	Pest Deterrents

	Crime Prevention

	Cycle Team

	Contact Us

	Cover Types

	FAQs

	Live Help

	Car Cover Blog

	Price Match

	Shipping Info

	Your cart

	Cart is empty

View cart
Checkout

	Users online

403 unregistered customer(s)

Cover Your Car - Tailored and Fitted Car Covers Worldwide :: Lancia

Fitted and tailored car covers for the Lancia Delta Integrale, Lancia Fulvia, Lancia Thema, Lancia Appia, Lancia Dedra, Lancia Beta and Coupe, Lancia Stratos, Lancia Gamma and more

Recover password

ePrivacy Statement

Terms & Conditions