Vergelijk Peugeot 308 SW 1.6vti sublime met ...

Vergelijk Peugeot 308 SW 1.6vti sublime met ...

toevoegen
Model/productPeugeot 308 SW (2008 - 2010)Peugeot 308 SW (2008 - 2010) 
UitvoeringPeugeot 308 SW 1.6vti sublime
Wijzig uitvoering
Peugeot 308 SW 1.6vti bluelease
Wijzig uitvoering
 
Laagste prijzen
       
      Prijs

       
      Consumentenprijs 24.250,00 21.550,00 
      Prijs exclusief BTW 20.876,00 18.780,00 
      BPM 3.116,00 4.203,00 
      Kosten rijklaar maken 575,00 645,00 
      Milieu / verbruik

       
      BrandstofetiketBB 
      Gecombineerd verbruik6,7 l/100km6,4 l/100km 
      Verbruik 120 km/u5,3 l/100km4,9 l/100km 
      Verbruik stad9,1 l/100km9,1 l/100km 
      CO2 uitstoot155 g/km147 g/km 
      Brandstofloodvrije benzineloodvrije benzine 
      Motor

       
      Cilinderinhoud1.598 cc1.598 cc 
      Aantal cilinders44 
      Kleppen per cilinder44 
      BrandstofsysteemMPIMPI 
      Compressieverhouding1111 
      TurboNeeNee 
      IntercoolerNeeNee 
      Prestaties

       
      Topsnelheid189 km/u189 km/u 
      Acceleratie 0-100 km/u11,5 sec11,5 sec 
      Vermogen88 kW88 kW 
      Vermogen (tpm)6.0006.000 
      Koppel160 Nm160 Nm 
      Koppel (tpm)4.2504.250 
      Aandrijving / onderstel

       
      Versnellingsbak55 
      Aandrijvingvoorwielvoorwiel 
      Velgmaat1615 
      Banden achter195/65195/65 
      Banden voor195/65195/65 
      Remmen achterschijfschijf 
      Remmen voorschijfschijf 
      Afmetingen

       
      Lengte4.500 mm4.500 mm 
      Breedte1.815 mm1.815 mm 
      Hoogte1.555 mm1.564 mm 
      Tankinhoud60 liter60 liter 
      Spoorbreedte achter1.531 mm1.521 mm 
      Spoorbreedte voor1.536 mm1.526 mm 
      Wielbasis2.708 mm2.708 mm 
      Inhoud bagageruimte min600 liter508 liter 
      Inhoud bagageruimte max2.149 liter1.736 liter 
      Draaicirkel11 m11,1 m 
      Garantie

       
      Garantie algemeen2 jaar2 jaar 
      Garantie carrosserie12 jaar12 jaar 
      Garantie lak3 jaar3 jaar 
      Carrosserie

       
      Carrosserrievormswsw 
      Aantal deuren55 
      Opties

       
      Bandenspan. Ctrl systNeeNee 
      LichtsensorNeeNee 
      LuidsprekersJaJa 
      Metallic lak 550,00 550,00 
      MistlampenJaJa 
      Overig

       
      Gross Vehicle Weight2.100 kg1.922 kg 
      Rijklaar gewicht1.415 kg1.295 kg 
      Maximum laadvermogen..627 kg 
      Aanhanger ongeremd.. kg 
      Aanhanger geremd1.500 kg1.500 kg 
      Database:0,439 (80) Solr: 0 Other: 0,485 Total: 0,924
      
      -- Query took 0,006sec
      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 = '72204' 
      
      -- Query took 0,001sec
      SELECT * FROM subCategories WHERE id = 90
      
      -- Query took 0,002sec
      SELECT * FROM ProductVersions WHERE id = '466980'
      
      -- Query took 0,002sec
      SELECT * FROM youtube WHERE productId = 72204
      
      -- Query took 0,001sec
      SELECT * FROM categories WHERE internalKey = 'auto'
      
      -- Query took 0,001sec
      SELECT html FROM htmlCache WHERE id = '9884fd32bf705a4a3cbe7c3267876fc2' AND timestamp > '2014-10-19 11:42:22' AND  [group] = 'page72204'
      
      -- Query took 0,001sec
      SELECT * FROM categories WHERE id = 1
      
      -- Query took 0,008sec
      SELECT TOP 201 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72204 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 = 72204 
      
      -- Query took 0,001sec
      SELECT * FROM ProductVersions WHERE id = '221735'
      
      -- 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 = 72204 
      
      -- Query took 0,016sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 466980 
      
      -- Query took 0,018sec
      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 = 72204 
      			GROUP BY pvImage.productVersionID
      			ORDER BY COUNT(pvImage.imageID) DESC);
      
      -- 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 = 90
      			 AND searchable = "1"
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,126sec
      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 = 72204 OR
      					productID IN
      						(SELECT productID FROM similarProducts WHERE groupID IN
      							(SELECT groupID FROM similarProducts WHERE productID = 72204)
      						)
      				)
      				AND onlyRating = 0 AND state & 1 = 1 ORDER BY timestamp DESC
      
      -- Query took 0,002sec
      SELECT html FROM htmlCache WHERE id = 'c57dc692e45eeea978d552e80c7d9844' AND timestamp > '2014-10-20 10:42:22' AND  [group] = 'auto'
      
      -- Query took 0,067sec
      SELECT COUNT(*) AS cnt FROM Reviews
      					WHERE
      				(
      					productID = 72204 OR
      					productID IN
      						(SELECT productID FROM similarProducts WHERE groupID IN
      							(SELECT groupID FROM similarProducts WHERE productID = 72204)
      						)
      				)
      		 AND state & 1 = 1
      
      -- Query took 0,014sec
      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 = 72204 AND review_rates.subCategoryID = 90 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 = 90
      			 AND searchable = "1"
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,003sec
      
      
      
      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 = 90  AND brand_id = 9254  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,021sec
      
      		DECLARE @ids TABLE
      			(
      				id int
      			)
      			
      		INSERT INTO @ids SELECT id FROM productVersions WHERE productID = 72204
      				
      		
      		
      		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 = 72035 
      
      -- 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 = 72204 
      
      -- 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 = 71871 
      
      -- 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 = 72273 
      
      -- 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 = 149175 
      
      -- 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 = 149356 
      
      -- 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 = 162608 
      
      -- 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 = 72240 
      
      -- 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 = 149321 
      
      -- 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 = 180171 
      
      -- 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 = 149102 
      
      -- 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 = 72158 
      
      -- 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 = 161444 
      
      -- 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 = 149450 
      
      -- 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 = 149361 
      
      -- 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 = 71974 
      
      -- 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 = 149411 
      
      -- 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 = 72150 
      
      -- 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 = 149331 
      
      -- 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 = 72179 
      
      -- 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 = 72114 
      
      -- 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 = 149135 
      
      -- 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 = 71954 
      
      -- 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 = 149451 
      
      -- 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 = 72305 
      
      -- 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 = 72282 
      
      -- 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 = 162605 
      
      -- 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 = 149414 
      
      -- 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 = 149446 
      
      -- 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 = 149303 
      
      -- Query took 0,002sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72035 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72204 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71871 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,003sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72273 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149175 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149356 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 162608 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72240 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149321 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 180171 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149102 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72158 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 161444 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,007sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149450 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149361 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
      
      -- Query took 0,003sec
      SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71974 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149411 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72150 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149331 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72179 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_station AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72114 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 = '221735'
      
      -- Query took 0,001sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 466980 
      
      -- Query took 0,017sec
      SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 221735 
      
      -- 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 = 72204 
      
      -- 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 = 466980 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 = 221735 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 = 90
      			
      			ORDER BY
      				featureGroups.priority DESC, priority DESC, featureLang.name
      			
      
      -- Query took 0,024sec
      
      				DELETE FROM htmlCache WHERE id = '9884fd32bf705a4a3cbe7c3267876fc2' AND [group] = 'page72204';
      				INSERT INTO htmlCache (id, html, [group]) VALUES ('9884fd32bf705a4a3cbe7c3267876fc2', '
      		
      		
      			
      
      
      
      
      
      
      
      
      
      
      			
      			
      			
      			
      			Vergelijk Peugeot 308 SW 1.6vti sublime  met Peugeot 308 SW 1.6vti bluelease op prijs en technische specificaties
      
      			
      
      
      			
      
      			
      			
      
      			
      			
      			
      
      
      			
      
      			
      			
      			
      			
      
      			
      
      						
      			
      					
      
      					
      		
      		
      		

      Vergelijk Peugeot 308 SW 1.6vti sublime met ...

      Vergelijk Peugeot 308 SW 1.6vti sublime met ...

      toevoegen
      Model/productPeugeot 308 SW (2008 - 2010)Peugeot 308 SW (2008 - 2010) 
      UitvoeringPeugeot 308 SW 1.6vti sublime
      Wijzig uitvoering
      Peugeot 308 SW 1.6vti bluelease
      Wijzig uitvoering
       
      Laagste prijzen
           
          Prijs

           
          Consumentenprijs 24.250,00 21.550,00 
          Prijs exclusief BTW 20.876,00 18.780,00 
          BPM 3.116,00 4.203,00 
          Kosten rijklaar maken 575,00 645,00 
          Milieu / verbruik

           
          BrandstofetiketBB 
          Gecombineerd verbruik6,7 l/100km6,4 l/100km 
          Verbruik 120 km/u5,3 l/100km4,9 l/100km 
          Verbruik stad9,1 l/100km9,1 l/100km 
          CO2 uitstoot155 g/km147 g/km 
          Brandstofloodvrije benzineloodvrije benzine 
          Motor

           
          Cilinderinhoud1.598 cc1.598 cc 
          Aantal cilinders44 
          Kleppen per cilinder44 
          BrandstofsysteemMPIMPI 
          Compressieverhouding1111 
          TurboNeeNee 
          IntercoolerNeeNee 
          Prestaties

           
          Topsnelheid189 km/u189 km/u 
          Acceleratie 0-100 km/u11,5 sec11,5 sec 
          Vermogen88 kW88 kW 
          Vermogen (tpm)6.0006.000 
          Koppel160 Nm160 Nm 
          Koppel (tpm)4.2504.250 
          Aandrijving / onderstel

           
          Versnellingsbak55 
          Aandrijvingvoorwielvoorwiel 
          Velgmaat1615 
          Banden achter195/65195/65 
          Banden voor195/65195/65 
          Remmen achterschijfschijf 
          Remmen voorschijfschijf 
          Afmetingen

           
          Lengte4.500 mm4.500 mm 
          Breedte1.815 mm1.815 mm 
          Hoogte1.555 mm1.564 mm 
          Tankinhoud60 liter60 liter 
          Spoorbreedte achter1.531 mm1.521 mm 
          Spoorbreedte voor1.536 mm1.526 mm 
          Wielbasis2.708 mm2.708 mm 
          Inhoud bagageruimte min600 liter508 liter 
          Inhoud bagageruimte max2.149 liter1.736 liter 
          Draaicirkel11 m11,1 m 
          Garantie

           
          Garantie algemeen2 jaar2 jaar 
          Garantie carrosserie12 jaar12 jaar 
          Garantie lak3 jaar3 jaar 
          Carrosserie

           
          Carrosserrievormswsw 
          Aantal deuren55 
          Opties

           
          Bandenspan. Ctrl systNeeNee 
          LichtsensorNeeNee 
          LuidsprekersJaJa 
          Metallic lak 550,00 550,00 
          MistlampenJaJa 
          Overig

           
          Gross Vehicle Weight2.100 kg1.922 kg 
          Rijklaar gewicht1.415 kg1.295 kg 
          Maximum laadvermogen..627 kg 
          Aanhanger ongeremd.. kg 
          Aanhanger geremd1.500 kg1.500 kg 
          ', 'page72204')