gerelateerde producten

Vergelijk Mercedes C-klasse 180 blue efficiency first edition met ...

Reviews Mercedes C-klasse (2007 - 2010)

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door Mischa | | 194.134.164.?

Degelijke wagen, eerste C klasse die mij qua model en vooral qua cockpit kan bekoren. Redelijke goede prestaties, hoogwaardige afwerking. Net iets meer dan mijn vorige wagen BMW 3 serie.

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

1
Review Mercedes C-klasse (2007 - 2010)
door Ben | | 195.121.244.?

Met de nieuwe c-klasse is Mercedes nog oubolliger dan voorheen. Ik begijp niet wie in zo'n ouwemannenwagen zou willen rondrijden. Wegligging en interieur zijn achteruitgegaan in vergelijking tot de voorganger. De stationcarversie heeft iets japans (koreaans) meegekregen.

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door michelle | | 62.216.4.?

super auto!

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door Arno | | 195.121.6.?

De nieuwe C-klasse is niet alleen formidabel vormgegeven, ook onder de motorkap deugt het. Rijden met deze auto blijft een genoegen (kracht, souplesse en stijl)

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door schipper | | 62.59.80.?

gewoon klasse

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door dersantan | | 62.59.80.?

mooi uiterlijk en innerlijk en de prijs is aan de dure kant

help
Toch niet gevonden wat je zocht?
Database:1,189 (77) Solr: 0 Other: 0,575 Total: 1,764

-- Query took 0,007sec
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 = '71969' 

-- Query took 0,001sec
SELECT * FROM subCategories WHERE id = 88

-- Query took 0,004sec
SELECT * FROM youtube WHERE productId = 71969

-- Query took 0,194sec
SELECT COUNT(*) AS cnt FROM Reviews
					WHERE
				(
					productID = 71969 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 71969)
						)
				)
		 AND onlyRating = 0 AND state & 1 = 1

-- Query took 0,001sec
SELECT * FROM categories WHERE id = 1

-- Query took 0,001sec
SELECT * FROM categories WHERE internalKey = 'auto'

-- Query took 0,003sec
SELECT html FROM htmlCache WHERE id = 'c1600d01587ecfa101420593352f2bd7' AND timestamp > '2014-10-01 14:25:38' AND  [group] = 'page71969'

-- Query took 0,028sec
SELECT TOP 201 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71969 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,035sec
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 = 71969 
			GROUP BY pvImage.productVersionID
			ORDER BY COUNT(pvImage.imageID) DESC);

-- Query took 0,008sec
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 = 88
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,203sec
SELECT TOP 170 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 = 71969 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 71969)
						)
				)
				AND onlyRating = 0 AND state & 1 = 1 ORDER BY timestamp DESC

-- Query took 0,003sec
SELECT COUNT(*) AS cnt FROM Reviews
					WHERE
				(
					productID = 71969 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 71969)
						)
				)
		 AND onlyRating = 0 AND state & 1 = 1

-- Query took 0,005sec
SELECT html FROM htmlCache WHERE id = 'c57dc692e45eeea978d552e80c7d9844' AND timestamp > '2014-10-02 13:25:39' AND  [group] = 'auto'

-- Query took 0,147sec
SELECT COUNT(*) AS cnt FROM Reviews
					WHERE
				(
					productID = 71969 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 71969)
						)
				)
		 AND state & 1 = 1

-- Query took 0,023sec
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 = 71969 AND review_rates.subCategoryID = 88 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 = 88
			 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 = 88  AND brand_id = 9250  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,06sec
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.logoimageid as shops_logoimageid,
			prices_shops.keurmerken as shops_keurmerken,
			prices_shops.availabilityType as shops_availabilityType
				FROM prices_shopProducts, productVersions, prices_shops WHERE prices_shopProducts.shopID = prices_shops.id AND productVersions.id = prices_shopProducts.productVersionID AND productID = 71969 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx

-- Query took 0,007sec
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 = 88
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,037sec
SELECT  TOP 4  products.*, brands.id AS brand_id, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource FROM stats_productsRelatedFlat AS flat JOIN Products ON (flat.productIDB = products.id) LEFT JOIN brands ON (brands.id = products.brandID) WHERE productIDA = 71969 AND state & 1 = 1 AND site = 1 ORDER BY flat.score DESC

-- Query took 0,008sec
SELECT * FROM subCategories WHERE id = 90

-- Query took 0,008sec
SELECT * FROM categories WHERE id = 1

-- Query took 0,094sec

		DECLARE @ids TABLE
			(
				id int
			)
			
		INSERT INTO @ids SELECT id FROM productVersions WHERE productID = 71969
				
		
		
		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,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 = 72143 

-- Query took 0,003sec
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 = 149101 

-- 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 = 149443 

-- Query took 0,003sec
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 = 72174 

-- 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 = 72259 

-- 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 = 180176 

-- Query took 0,003sec
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 = 149134 

-- Query took 0,002sec
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 = 72199 

-- Query took 0,008sec
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 = 72194 

-- Query took 0,002sec
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 = 72228 

-- Query took 0,007sec
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 = 149078 

-- Query took 0,002sec
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 = 72281 

-- Query took 0,01sec
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 = 72345 

-- 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 = 72201 

-- Query took 0,004sec
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 = 149412 

-- 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 = 71965 

-- Query took 0,002sec
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 = 72298 

-- Query took 0,009sec
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 = 71969 

-- Query took 0,034sec
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 = 180181 

-- Query took 0,002sec
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 = 228883 

-- 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 = 149247 

-- Query took 0,007sec
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 = 88
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,003sec



SELECT TOP 50 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 = 88  AND brand_id = 9250  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,003sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72143 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149101 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,009sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149443 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72174 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,006sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72259 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 180176 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,008sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149134 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72199 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,004sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72194 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72228 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149078 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72281 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72345 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,005sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72201 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149412 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71965 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72298 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,006sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71969 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 180181 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,004sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 228883 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_sedan AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149247 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,009sec
SELECT ReviewProductRatings.rate, review_rates.name
			FROM
				ReviewProductRatings, reviews, products, review_rates
			WHERE
				reviews.id = 321742 AND
				reviews.productID = products.id AND
				products.subCategoryID = review_rates.subCategoryID AND
				review_rates.id = ReviewProductRatings.rateID AND
				ReviewProductRatings.reviewID = reviews.id
			

-- Query took 0,009sec
SELECT ReviewProductRatings.rate, review_rates.name
			FROM
				ReviewProductRatings, reviews, products, review_rates
			WHERE
				reviews.id = 321629 AND
				reviews.productID = products.id AND
				products.subCategoryID = review_rates.subCategoryID AND
				review_rates.id = ReviewProductRatings.rateID AND
				ReviewProductRatings.reviewID = reviews.id
			

-- Query took 0,008sec
SELECT ReviewProductRatings.rate, review_rates.name
			FROM
				ReviewProductRatings, reviews, products, review_rates
			WHERE
				reviews.id = 321446 AND
				reviews.productID = products.id AND
				products.subCategoryID = review_rates.subCategoryID AND
				review_rates.id = ReviewProductRatings.rateID AND
				ReviewProductRatings.reviewID = reviews.id
			

-- Query took 0,014sec
SELECT ReviewProductRatings.rate, review_rates.name
			FROM
				ReviewProductRatings, reviews, products, review_rates
			WHERE
				reviews.id = 321342 AND
				reviews.productID = products.id AND
				products.subCategoryID = review_rates.subCategoryID AND
				review_rates.id = ReviewProductRatings.rateID AND
				ReviewProductRatings.reviewID = reviews.id
			

-- Query took 0,009sec
SELECT ReviewProductRatings.rate, review_rates.name
			FROM
				ReviewProductRatings, reviews, products, review_rates
			WHERE
				reviews.id = 321255 AND
				reviews.productID = products.id AND
				products.subCategoryID = review_rates.subCategoryID AND
				review_rates.id = ReviewProductRatings.rateID AND
				ReviewProductRatings.reviewID = reviews.id
			

-- Query took 0,007sec
SELECT ReviewProductRatings.rate, review_rates.name
			FROM
				ReviewProductRatings, reviews, products, review_rates
			WHERE
				reviews.id = 321257 AND
				reviews.productID = products.id AND
				products.subCategoryID = review_rates.subCategoryID AND
				review_rates.id = ReviewProductRatings.rateID AND
				ReviewProductRatings.reviewID = reviews.id
			

-- Query took 0,001sec
SELECT id, name FROM review_rates WHERE subCategoryID = 88

-- 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 = 88
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,008sec
SELECT brands.id, COUNT(DISTINCT productID) AS sum, brands.name, brands.logo, brands.externID, brands.externSource FROM brands, filter_y_sedan WHERE filter_y_sedan.brandID = brands.id  AND price IS NOT NULL GROUP BY brands.id, brands.name, brands.logo, brands.externID, brands.externSource ORDER BY sum DESC, name

-- Query took 0,035sec

				DELETE FROM htmlCache WHERE id = 'c1600d01587ecfa101420593352f2bd7' AND [group] = 'page71969';
				INSERT INTO htmlCache (id, html, [group]) VALUES ('c1600d01587ecfa101420593352f2bd7', '
		
		
			










			
			
			
			
			Vergelijk de Mercedes C-klasse (2007 - 2010) - alle modellen, prijzen, technische specificaties en reviews| Pagina 8

			


			

			
			

			
			
			


			

			
						
			

			

						
			
					

					
		
		
		

gerelateerde producten

Vergelijk Mercedes C-klasse 180 blue efficiency first edition met ...

Reviews Mercedes C-klasse (2007 - 2010)

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door Mischa | | 194.134.164.?

Degelijke wagen, eerste C klasse die mij qua model en vooral qua cockpit kan bekoren. Redelijke goede prestaties, hoogwaardige afwerking. Net iets meer dan mijn vorige wagen BMW 3 serie.

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

1
Review Mercedes C-klasse (2007 - 2010)
door Ben | | 195.121.244.?

Met de nieuwe c-klasse is Mercedes nog oubolliger dan voorheen. Ik begijp niet wie in zo''n ouwemannenwagen zou willen rondrijden. Wegligging en interieur zijn achteruitgegaan in vergelijking tot de voorganger. De stationcarversie heeft iets japans (koreaans) meegekregen.

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door michelle | | 62.216.4.?

super auto!

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door Arno | | 195.121.6.?

De nieuwe C-klasse is niet alleen formidabel vormgegeven, ook onder de motorkap deugt het. Rijden met deze auto blijft een genoegen (kracht, souplesse en stijl)

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door schipper | | 62.59.80.?

gewoon klasse

Mercedes C-klasse (2007 - 2010)

Vond je deze review
waardevol?

0
Review Mercedes C-klasse (2007 - 2010)
door dersantan | | 62.59.80.?

mooi uiterlijk en innerlijk en de prijs is aan de dure kant

help
Toch niet gevonden wat je zocht?
', 'page71969')