gerelateerde producten

Vergelijk Renault Clio* 1.2 collection met ...

Wat vind je van Renault Clio* (5 deurs) (2005 - 2009)

Ga verder
help
Toch niet gevonden wat je zocht?
Database:0,544 (68) Solr: 0 Other: 0,448 Total: 0,992

-- 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 = '149348' 

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

-- Query took 0,002sec
SELECT * FROM youtube WHERE productId = 149348

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

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

-- Query took 0,001sec
SELECT html FROM htmlCache WHERE id = 'fd031cdb927af2777cfa0a799343d0ca' AND timestamp > '2014-10-20 09:04:30' AND  [group] = 'page149348'

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

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

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

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

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

-- Query took 0,002sec
SELECT html FROM htmlCache WHERE id = 'c57dc692e45eeea978d552e80c7d9844' AND timestamp > '2014-10-21 08:04:30' AND  [group] = 'auto'

-- Query took 0,083sec
SELECT COUNT(*) AS cnt FROM Reviews
					WHERE
				(
					productID = 149348 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 149348)
						)
				)
		 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 = 149348 AND review_rates.subCategoryID = 86 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 = 86
			 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 = 86  AND brand_id = 9256  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,017sec
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 = 149348 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx

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

-- Query took 0,018sec
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 = 149348 AND state & 1 = 1 AND site = 1 ORDER BY flat.score DESC

-- Query took 0,002sec
SELECT * FROM subCategories WHERE id = 87

-- Query took 0,002sec
SELECT * FROM subCategories WHERE id = 89

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

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

-- Query took 0,021sec

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

-- 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 = 86
			 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 = 86  AND brand_id = 9256  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,002sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_y_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72255 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72019 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71820 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72304 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72033 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149426 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72332 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71973 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71814 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72215 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72039 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149151 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149387 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149150 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149318 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 149348 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 71981 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72164 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 272394 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72011 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_hatchback AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 72299 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

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

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

-- Query took 0,01sec
SELECT brands.id, COUNT(DISTINCT productID) AS sum, brands.name, brands.logo, brands.externID, brands.externSource FROM brands, filter_y_hatchback WHERE filter_y_hatchback.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,023sec

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










			
			
			
			
			Vergelijk de Renault Clio* (5 deurs)
 (2005 - 2009) - alle modellen, prijzen, technische specificaties en reviews

			


			

			
			

			
			
			


			

			
						
			

			

						
			
					

					
		
		
		

gerelateerde producten

Vergelijk Renault Clio* 1.2 collection met ...

Wat vind je van Renault Clio* (5 deurs) (2005 - 2009)

Ga verder
help
Toch niet gevonden wat je zocht?
', 'page149348')