Vergelijk Ford C-MAX 1.6 trend 74kW met ...

Vergelijk Ford C-MAX 1.6 trend 74kW met ...

toevoegen
Model/productFord C-MAX (2007 - 2010)Opel Zafira* (2005 - 2008) 
UitvoeringFord C-MAX 1.6 trend 74kW
Wijzig uitvoering
Opel Zafira* 2.2 essentia
Wijzig uitvoering
 
Laagste prijzen
       
      Prijs

       
      Consumentenprijs 23.400,00 27.280,00 
      Prijs exclusief BTW 20.512,00 23.958,00 
      BPM 5.313,00 6.475,00 
      Kosten rijklaar maken 600,00 610,00 
      Milieu / verbruik

       
      BrandstofetiketcD 
      Gecombineerd verbruik6,9 l/100km8,2 l/100km 
      Verbruik 120 km/u..6,4 l/100km 
      Verbruik stad..11,3 l/100km 
      CO2 uitstoot166 g/km197 g/km 
      Brandstofloodvrije benzineloodvrije benzine 
      Motor

       
      Cilinderinhoud1.596 cc2.198 cc 
      Aantal cilinders44 
      Kleppen per cilinder44 
      BrandstofsysteemMPIMPI 
      Compressieverhouding1112 
      Prestaties

       
      Topsnelheid175 km/u200 km/u 
      Acceleratie 0-100 km/u12,9 sec10,6 sec 
      Vermogen74 kW110 kW 
      Vermogen (tpm)6.0005.600 
      Koppel150 Nm215 Nm 
      Koppel (tpm)4.0004.000 
      Aandrijving / onderstel

       
      Versnellingsbak56 
      Aandrijvingvoorwielvoorwiel 
      Velgmaat1516 
      Banden achter195/65205/55 
      Banden voor195/65205/55 
      Remmen achterschijfschijf 
      Remmen voorschijfschijf 
      Afmetingen

       
      Lengte4.333 mm4.467 mm 
      Breedte2.022 mm1.801 mm 
      Hoogte1.595 mm1.635 mm 
      Tankinhoud55 liter58 liter 
      Spoorbreedte achter1.530 mm1.510 mm 
      Spoorbreedte voor1.540 mm1.488 mm 
      Wielbasis2.640 mm2.703 mm 
      Inhoud bagageruimte min550 liter140 liter 
      Inhoud bagageruimte max1.620 liter1.820 liter 
      Draaicirkel10,7 m11,5 m 
      Garantie

       
      Garantie algemeen2 jaar2 jaar 
      Garantie carrosserie12 jaar12 jaar 
      Garantie lak2 jaar2 jaar 
      Olie verversen..15.000 km 
      Grote beurt20.000 km30.000 km 
      Carrosserie

       
      Carrosserrievormspsp 
      Aantal deuren55 
      Opties

       
      Airconditioning 0,00 1.100,00 
      Alarm 500,00 500,00 
      Automatic Climate Control 500,00.. 
      Bekleding leder 1.750,00.. 
      Boordcomputer 0,00 250,00 
      Cruise Control 0,00 250,00 
      Koplampsproeiers 150,00.. 
      Lichtmetalen velgen 900,00 1.250,00 
      Luidsprekers11 
      Metallic lak 700,00 575,00 
      Mica lak.. 575,00 
      Parkdistance control achter 500,00.. 
      Parkdistance control voor 500,00.. 
      Radio/cassette.. 475,00 
      Radio/CD-speler 0,00 620,00 
      Regensensor 650,00.. 
      Schuifdak electrisch 900,00.. 
      Stoelen verwarmd 250,00.. 
      Sunroof 900,00.. 
      Traction Control 800,00 0,00 
      Verwarmde voorruit 250,00.. 
      Zijruiten electrisch achter 300,00 300,00 
      Zwarte lak.. 575,00 
      Navigatiesysteem 1.000,00.. 
      Overig

       
      Gross Vehicle Weight..2.075 kg 
      Rijklaar gewicht1.234 kg1.470 kg 
      Maximum laadvermogen521 kg605 kg 
      Aanhanger ongeremd665 kg750 kg 
      Aanhanger geremd1.200 kg1.500 kg 
      Database:0,447 (80) Solr: 0 Other: 0,164 Total: 0,611
      
      -- Query took 0,005sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = '71959' 
      
      -- Query took 0,001sec
      SELECT * FROM subCategories WHERE id = 87
      
      -- Query took 0,001sec
      SELECT * FROM ProductVersions WHERE id = '470544'
      
      -- Query took 0,001sec
      SELECT * FROM youtube WHERE productId = 71959
      
      -- Query took 0,001sec
      SELECT * FROM categories WHERE internalKey = 'auto'
      
      -- Query took 0,001sec
      SELECT html FROM htmlCache WHERE id = 'a99d24d81505d5b23856233026afc55b' AND timestamp > '2014-10-20 07:19:34' AND  [group] = 'page71959'
      
      -- Query took 0,001sec
      SELECT * FROM categories WHERE id = 1
      
      -- Query took 0,011sec
      SELECT TOP 201 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71959 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71959 
      
      -- Query took 0,001sec
      SELECT * FROM ProductVersions WHERE id = '460998'
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149304 
      
      -- Query took 0,02sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 470544 
      
      -- Query took 0,021sec
      SELECT DISTINCT TOP 100 imageID AS id FROM pvImage WHERE productVersionID = (
      			SELECT TOP 1 productVersionID
      			FROM pvImage JOIN productVersions ON (productVersions.id = productVersionID)
      			WHERE productID = 71959 
      			GROUP BY pvImage.productVersionID
      			ORDER BY COUNT(pvImage.imageID) DESC);
      
      -- Query took 0,006sec
      SELECT
      				categoryFeature.*,
      				features.id AS feature_id,
      				features.externID AS feature_externID,
      				measures.id AS measureid,
      				featureGroupLang.name AS featureGroup_name,
      				featureGroups.id AS featureGroup_id,
      				featureGroups.externid AS featureGroup_externid,
      				featureGroups.externsource AS featureGroup_externsource,
      				featureGroups.priority AS featureGroup_priority,
      				featureLang.name,
      				featureLang.description,
      				measures.defaultSign AS measure_defaultSign,
      				measureLang.name AS measure_name,
      				measureLang.description AS measure_description,
      				measureLang.sign AS measure_sign
      			FROM categoryFeature
      				LEFT JOIN features ON features.id = categoryFeature.featureID
      				LEFT JOIN measures ON features.measureID = measures.id
      				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
      				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
      				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
      				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
      			WHERE
      				categoryFeature.subCategoryID = 87
      			 AND searchable = "1"
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,121sec
      SELECT TOP 20 Reviews.*, ReviewRatingsFlat.rate as reviewRating,
      		ReviewRatingsFlat.rate_positive as reviewRatePositive,
      		ReviewRatingsFlat.rate_negative as reviewRateNegative
      			FROM Reviews
      			LEFT JOIN ReviewRatingsFlat ON (ReviewRatingsFlat.reviewID = reviews.id)
      			WHERE
      				(
      					productID = 71959 OR
      					productID IN
      						(SELECT productID FROM similarProducts WHERE groupID IN
      							(SELECT groupID FROM similarProducts WHERE productID = 71959)
      						)
      				)
      				AND onlyRating = 0 AND state & 1 = 1 ORDER BY timestamp DESC
      
      -- Query took 0,001sec
      SELECT html FROM htmlCache WHERE id = 'c57dc692e45eeea978d552e80c7d9844' AND timestamp > '2014-10-21 06:19:35' AND  [group] = 'auto'
      
      -- Query took 0,072sec
      SELECT COUNT(*) AS cnt FROM Reviews
      					WHERE
      				(
      					productID = 71959 OR
      					productID IN
      						(SELECT productID FROM similarProducts WHERE groupID IN
      							(SELECT groupID FROM similarProducts WHERE productID = 71959)
      						)
      				)
      		 AND state & 1 = 1
      
      -- Query took 0,026sec
      SELECT review_rates.id, review_rates.name, AVG(ReviewProductRatings.rate) AS rate FROM ReviewProductRatings JOIN Reviews ON (Reviews.id = ReviewProductRatings.reviewID) JOIN review_rates ON (review_rates.id = ReviewProductRatings.rateID) WHERE Reviews.productID = 71959 AND review_rates.subCategoryID = 87 GROUP BY review_rates.id, review_rates.name, review_rates.weight ORDER BY review_rates.weight
      
      -- Query took 0,005sec
      SELECT
      				categoryFeature.*,
      				features.id AS feature_id,
      				features.externID AS feature_externID,
      				measures.id AS measureid,
      				featureGroupLang.name AS featureGroup_name,
      				featureGroups.id AS featureGroup_id,
      				featureGroups.externid AS featureGroup_externid,
      				featureGroups.externsource AS featureGroup_externsource,
      				featureGroups.priority AS featureGroup_priority,
      				featureLang.name,
      				featureLang.description,
      				measures.defaultSign AS measure_defaultSign,
      				measureLang.name AS measure_name,
      				measureLang.description AS measure_description,
      				measureLang.sign AS measure_sign
      			FROM categoryFeature
      				LEFT JOIN features ON features.id = categoryFeature.featureID
      				LEFT JOIN measures ON features.measureID = measures.id
      				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
      				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
      				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
      				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
      			WHERE
      				categoryFeature.subCategoryID = 87
      			 AND searchable = "1"
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,002sec
      
      
      
      SELECT TOP 7 productsSearch.*, stats_productsFlat.num AS productStats  FROM productsSearch  LEFT JOIN stats_productsFlat ON (stats_productsFlat.productID = products_id AND stats_productsFlat.site = 1)
      			WHERE products_state & 1 = 1  AND subCategories_id = 87  AND brand_id = 9240  ORDER BY (CASE WHEN products_image IS null THEN 1 ELSE 0 END), (CASE WHEN products_endyear IS NULL THEN 3000 ELSE products_endyear END) DESC, stats_productsFlat.num DESC, products_stats DESC, products_id
      
      -- Query took 0,02sec
      
      		DECLARE @ids TABLE
      			(
      				id int
      			)
      			
      		INSERT INTO @ids SELECT id FROM productVersions WHERE productID = 71959
      				
      		
      		
      		SELECT TOP 30 
      			productVersions.productID AS id, SUM(num) 
      		FROM stats_comparedFlat 
      			JOIN @ids AS ids ON (ids.id = productVersionIDA) 
      			JOIN productVersions ON (stats_comparedFlat.productVersionIDB = productVersions.id) 
      		WHERE site = 1 
      		GROUP BY productVersions.productID 
      		ORDER BY SUM(num) DESC 
      		
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71931 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72003 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72180 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149178 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72014 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71964 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71959 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71862 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149304 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72181 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 160559 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71901 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72212 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149312 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71911 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 162594 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 162593 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72040 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149423 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149424 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149333 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149440 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72347 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71998 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71902 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149242 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149353 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 71860 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149381 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 72015 
      
      -- Query took 0,003sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71931 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72003 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72180 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149178 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72014 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71964 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71959 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71862 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149304 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72181 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 160559 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71901 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72212 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149312 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71911 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 162594 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 162593 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72040 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149423 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149424 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_mpv AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149333 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,001sec
      SELECT * FROM ProductVersions WHERE id = '460998'
      
      -- Query took 0,001sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 470544 
      
      -- Query took 0,017sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 460998 
      
      -- Query took 0,001sec
      SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 149304 
      
      -- Query took 0,007sec
      SELECT
      			prices_shopProducts.*,
      			prices_shops.id AS shops_id,
      			prices_shops.name AS shops_name,
      			prices_shops.url AS shops_url,
      			prices_shops.address AS shops_address,
      			prices_shops.postcode AS shops_postcode,
      			prices_shops.city AS shops_city ,
      			prices_shops.phone AS shops_phone,
      			prices_shops.email AS shops_email,
      			prices_shops.description AS shops_description,
      			prices_shops.invoiceCompany AS shops_invoiceCompany,
      			prices_shops.invoiceName AS shops_invoiceName,
      			prices_shops.invoiceAddress AS shops_invoiceAddress,
      			prices_shops.invoicePostcode AS shops_invoicePostcode,
      			prices_shops.invoiceCity AS shops_invoiceCity,
      			prices_shops.invoiceTel AS shops_invoiceTel,
      			prices_shops.invoiceEmail AS shops_invoiceEmail,
      			prices_shops.dateAdded AS shops_dateAdded,
      			prices_shops.logo AS shops_logo,
      			prices_shops.state AS shops_state,
      			prices_shops.cost AS shops_cost,
      			prices_shops.keurmerken AS shops_keurmerken,
      			prices_shops.logoimageid as shops_logoimageid,
      			prices_shops.availabilityType AS shops_availabilitytype
      				FROM prices_shopProducts, prices_shops WHERE prices_shopProducts.shopID = prices_shops.id AND prices_shopProducts.productVersionID = 470544 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx
      
      -- Query took 0,006sec
      SELECT
      			prices_shopProducts.*,
      			prices_shops.id AS shops_id,
      			prices_shops.name AS shops_name,
      			prices_shops.url AS shops_url,
      			prices_shops.address AS shops_address,
      			prices_shops.postcode AS shops_postcode,
      			prices_shops.city AS shops_city ,
      			prices_shops.phone AS shops_phone,
      			prices_shops.email AS shops_email,
      			prices_shops.description AS shops_description,
      			prices_shops.invoiceCompany AS shops_invoiceCompany,
      			prices_shops.invoiceName AS shops_invoiceName,
      			prices_shops.invoiceAddress AS shops_invoiceAddress,
      			prices_shops.invoicePostcode AS shops_invoicePostcode,
      			prices_shops.invoiceCity AS shops_invoiceCity,
      			prices_shops.invoiceTel AS shops_invoiceTel,
      			prices_shops.invoiceEmail AS shops_invoiceEmail,
      			prices_shops.dateAdded AS shops_dateAdded,
      			prices_shops.logo AS shops_logo,
      			prices_shops.state AS shops_state,
      			prices_shops.cost AS shops_cost,
      			prices_shops.keurmerken AS shops_keurmerken,
      			prices_shops.logoimageid as shops_logoimageid,
      			prices_shops.availabilityType AS shops_availabilitytype
      				FROM prices_shopProducts, prices_shops WHERE prices_shopProducts.shopID = prices_shops.id AND prices_shopProducts.productVersionID = 460998 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx
      
      -- Query took 0,018sec
      SELECT
      				categoryFeature.*,
      				features.id AS feature_id,
      				features.externID AS feature_externID,
      				measures.id AS measureid,
      				featureGroupLang.name AS featureGroup_name,
      				featureGroups.id AS featureGroup_id,
      				featureGroups.externid AS featureGroup_externid,
      				featureGroups.externsource AS featureGroup_externsource,
      				featureGroups.priority AS featureGroup_priority,
      				featureLang.name,
      				featureLang.description,
      				measures.defaultSign AS measure_defaultSign,
      				measureLang.name AS measure_name,
      				measureLang.description AS measure_description,
      				measureLang.sign AS measure_sign
      			FROM categoryFeature
      				LEFT JOIN features ON features.id = categoryFeature.featureID
      				LEFT JOIN measures ON features.measureID = measures.id
      				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
      				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
      				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
      				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
      			WHERE
      				categoryFeature.subCategoryID = 87
      			
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,021sec
      
      				DELETE FROM htmlCache WHERE id = 'a99d24d81505d5b23856233026afc55b' AND [group] = 'page71959';
      				INSERT INTO htmlCache (id, html, [group]) VALUES ('a99d24d81505d5b23856233026afc55b', '
      		
      		
      			
      
      
      
      
      
      
      
      
      
      
      			
      			
      			
      			
      			Vergelijk Ford C-MAX 1.6 trend 74kW  met Opel Zafira* 2.2 essentia op prijs en technische specificaties
      
      			
      
      
      			
      
      			
      			
      
      			
      			
      			
      
      
      			
      
      			
      			
      			
      			
      
      			
      
      						
      			
      					
      
      					
      		
      		
      		

      Vergelijk Ford C-MAX 1.6 trend 74kW met ...

      Vergelijk Ford C-MAX 1.6 trend 74kW met ...

      toevoegen
      Model/productFord C-MAX (2007 - 2010)Opel Zafira* (2005 - 2008) 
      UitvoeringFord C-MAX 1.6 trend 74kW
      Wijzig uitvoering
      Opel Zafira* 2.2 essentia
      Wijzig uitvoering
       
      Laagste prijzen
           
          Prijs

           
          Consumentenprijs 23.400,00 27.280,00 
          Prijs exclusief BTW 20.512,00 23.958,00 
          BPM 5.313,00 6.475,00 
          Kosten rijklaar maken 600,00 610,00 
          Milieu / verbruik

           
          BrandstofetiketcD 
          Gecombineerd verbruik6,9 l/100km8,2 l/100km 
          Verbruik 120 km/u..6,4 l/100km 
          Verbruik stad..11,3 l/100km 
          CO2 uitstoot166 g/km197 g/km 
          Brandstofloodvrije benzineloodvrije benzine 
          Motor

           
          Cilinderinhoud1.596 cc2.198 cc 
          Aantal cilinders44 
          Kleppen per cilinder44 
          BrandstofsysteemMPIMPI 
          Compressieverhouding1112 
          Prestaties

           
          Topsnelheid175 km/u200 km/u 
          Acceleratie 0-100 km/u12,9 sec10,6 sec 
          Vermogen74 kW110 kW 
          Vermogen (tpm)6.0005.600 
          Koppel150 Nm215 Nm 
          Koppel (tpm)4.0004.000 
          Aandrijving / onderstel

           
          Versnellingsbak56 
          Aandrijvingvoorwielvoorwiel 
          Velgmaat1516 
          Banden achter195/65205/55 
          Banden voor195/65205/55 
          Remmen achterschijfschijf 
          Remmen voorschijfschijf 
          Afmetingen

           
          Lengte4.333 mm4.467 mm 
          Breedte2.022 mm1.801 mm 
          Hoogte1.595 mm1.635 mm 
          Tankinhoud55 liter58 liter 
          Spoorbreedte achter1.530 mm1.510 mm 
          Spoorbreedte voor1.540 mm1.488 mm 
          Wielbasis2.640 mm2.703 mm 
          Inhoud bagageruimte min550 liter140 liter 
          Inhoud bagageruimte max1.620 liter1.820 liter 
          Draaicirkel10,7 m11,5 m 
          Garantie

           
          Garantie algemeen2 jaar2 jaar 
          Garantie carrosserie12 jaar12 jaar 
          Garantie lak2 jaar2 jaar 
          Olie verversen..15.000 km 
          Grote beurt20.000 km30.000 km 
          Carrosserie

           
          Carrosserrievormspsp 
          Aantal deuren55 
          Opties

           
          Airconditioning 0,00 1.100,00 
          Alarm 500,00 500,00 
          Automatic Climate Control 500,00.. 
          Bekleding leder 1.750,00.. 
          Boordcomputer 0,00 250,00 
          Cruise Control 0,00 250,00 
          Koplampsproeiers 150,00.. 
          Lichtmetalen velgen 900,00 1.250,00 
          Luidsprekers11 
          Metallic lak 700,00 575,00 
          Mica lak.. 575,00 
          Parkdistance control achter 500,00.. 
          Parkdistance control voor 500,00.. 
          Radio/cassette.. 475,00 
          Radio/CD-speler 0,00 620,00 
          Regensensor 650,00.. 
          Schuifdak electrisch 900,00.. 
          Stoelen verwarmd 250,00.. 
          Sunroof 900,00.. 
          Traction Control 800,00 0,00 
          Verwarmde voorruit 250,00.. 
          Zijruiten electrisch achter 300,00 300,00 
          Zwarte lak.. 575,00 
          Navigatiesysteem 1.000,00.. 
          Overig

           
          Gross Vehicle Weight..2.075 kg 
          Rijklaar gewicht1.234 kg1.470 kg 
          Maximum laadvermogen521 kg605 kg 
          Aanhanger ongeremd665 kg750 kg 
          Aanhanger geremd1.200 kg1.500 kg 
          ', 'page71959')