Vergelijk Princess 242138 (242138) met ...

Specificaties Princess 242138 (242138)

toevoegen
Model/productPrincess 242138 
Laagste prijzen
     
    Gewicht en omvang
     
    Breedte231 mm 
    Diepte292 mm 
    Hoogte392 mm 
    Gewicht2.900 g 
    Design
     
    Koffie technologieDrip 
    KastontwerpFreestanding 
    Kleur van het productBlack 
    Materiaal behuizingGlass, Plastic 
    Ingebouwd displayNee 
    Verlichte aan-/uit knopJa 
    IndicatielampjeJa 
    Energie
     
    Netbelasting1.000 W 
    AC invoer voltage220-240 V 
    Technische details
     
    Capaciteit in kopjes15 
    Koffie invoertypeGround coffee 
    Drank typesCoffee 
    Uitneembare morsplaatJa 
    HotplateJa 
    Database:0,473 (46) Solr: 0 Other: 0,308 Total: 0,781
    
    -- 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 = '189911' 
    
    -- Query took 0,001sec
    SELECT * FROM subCategories WHERE id = 94
    
    -- Query took 0,001sec
    SELECT * FROM ProductVersions WHERE id = '565030'
    
    -- Query took 0,002sec
    SELECT * FROM youtube WHERE productId = 189911
    
    -- Query took 0,001sec
    SELECT * FROM categories WHERE internalKey = 'kantoor'
    
    -- Query took 0,002sec
    SELECT html FROM htmlCache WHERE id = '9c4757073d228afd13888eed2d7ca2e9' AND timestamp > '2014-10-19 11:43:19' AND  [group] = 'page189911'
    
    -- Query took 0,001sec
    SELECT * FROM categories WHERE id = 3
    
    -- Query took 0,007sec
    SELECT TOP 201 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189911 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
    
    -- 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 = 189911 
    
    -- Query took 0,02sec
    SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 565030 
    
    -- 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 = 189911 
    			GROUP BY pvImage.productVersionID
    			ORDER BY COUNT(pvImage.imageID) DESC);
    
    -- Query took 0,004sec
    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 = 94
    			 AND searchable = "1"
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,114sec
    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 = 189911 OR
    					productID IN
    						(SELECT productID FROM similarProducts WHERE groupID IN
    							(SELECT groupID FROM similarProducts WHERE productID = 189911)
    						)
    				)
    				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:43:19' AND  [group] = 'kantoor'
    
    -- Query took 0,069sec
    SELECT COUNT(*) AS cnt FROM Reviews
    					WHERE
    				(
    					productID = 189911 OR
    					productID IN
    						(SELECT productID FROM similarProducts WHERE groupID IN
    							(SELECT groupID FROM similarProducts WHERE productID = 189911)
    						)
    				)
    		 AND state & 1 = 1
    
    -- Query took 0,007sec
    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 = 189911 AND review_rates.subCategoryID = 94 GROUP BY review_rates.id, review_rates.name, review_rates.weight ORDER BY review_rates.weight
    
    -- Query took 0,003sec
    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 = 94
    			 AND searchable = "1"
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,014sec
    
    
    
    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 = 94  AND brand_id = 10448  ORDER BY (CASE WHEN products_image IS null THEN 1 ELSE 0 END), (CASE WHEN products_endyear IS NULL THEN 3000 ELSE products_endyear END) DESC, stats_productsFlat.num DESC, products_stats DESC, products_id
    
    -- Query took 0,02sec
    
    		DECLARE @ids TABLE
    			(
    				id int
    			)
    			
    		INSERT INTO @ids SELECT id FROM productVersions WHERE productID = 189911
    				
    		
    		
    		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,003sec
    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 = 94
    			 AND searchable = "1"
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,02sec
    
    
    
    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 = 94  AND brand_id = 10448  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,007sec
    SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189722 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189109 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189215 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189527 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189214 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189906 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189110 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189427 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 188948 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 190343 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189940 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 209454 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189114 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 224120 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189107 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189108 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189111 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189112 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189113 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189116 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_koffiezetapparaat AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 189117 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
    
    -- Query took 0,001sec
    SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 565030 
    
    -- 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 = 565030 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx
    
    -- Query took 0,021sec
    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 = 94
    			
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,016sec
    
    				DELETE FROM htmlCache WHERE id = '9c4757073d228afd13888eed2d7ca2e9' AND [group] = 'page189911';
    				INSERT INTO htmlCache (id, html, [group]) VALUES ('9c4757073d228afd13888eed2d7ca2e9', '
    		
    		
    			
    
    
    
    
    
    
    
    
    
    
    			
    			
    			
    			
    			Princess 242138 (242138) - Alle technische specificaties. Vergelijk makkelijk met andere Koffiezet automaten
    
    			
    
    
    			
    
    			
    			
    
    			
    			
    			
    
    
    			
    
    			
    						
    			
    
    			
    
    						
    			
    					
    
    					
    		
    		
    		

    Vergelijk Princess 242138 (242138) met ...

    Specificaties Princess 242138 (242138)

    toevoegen
    Model/productPrincess 242138 
    Laagste prijzen
       
      Gewicht en omvang
       
      Breedte231 mm 
      Diepte292 mm 
      Hoogte392 mm 
      Gewicht2.900 g 
      Design
       
      Koffie technologieDrip 
      KastontwerpFreestanding 
      Kleur van het productBlack 
      Materiaal behuizingGlass, Plastic 
      Ingebouwd displayNee 
      Verlichte aan-/uit knopJa 
      IndicatielampjeJa 
      Energie
       
      Netbelasting1.000 W 
      AC invoer voltage220-240 V 
      Technische details
       
      Capaciteit in kopjes15 
      Koffie invoertypeGround coffee 
      Drank typesCoffee 
      Uitneembare morsplaatJa 
      HotplateJa 
      ', 'page189911')