Vergelijk HP Mini 2140 Notebook PC (NN355EA#ABH) met ...

Specificaties HP Mini 2140 Notebook PC (NN355EA#ABH)

toevoegen
Model/productHP Mini 2140 
UitvoeringHP Mini 2140 Notebook PC (NN355EA#ABH)
Wijzig uitvoering
 
Laagste prijzen
     
    Database:0,525 (67) Solr: 0 Other: 0,159 Total: 0,684
    
    -- 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 = '137206' 
    
    -- Query took 0,001sec
    SELECT * FROM subCategories WHERE id = 9
    
    -- Query took 0,001sec
    SELECT * FROM ProductVersions WHERE id = '370326'
    
    -- Query took 0,002sec
    SELECT * FROM youtube WHERE productId = 137206
    
    -- Query took 0,001sec
    SELECT * FROM categories WHERE internalKey = 'hardware'
    
    -- Query took 0,001sec
    SELECT html FROM htmlCache WHERE id = '9d7966bc23d6c130e2ca7908b4b5543f' AND timestamp > '2014-10-01 18:29:23' AND  [group] = 'page137206'
    
    -- Query took 0,001sec
    SELECT * FROM categories WHERE id = 2
    
    -- Query took 0,007sec
    SELECT TOP 201 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 137206 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 = 137206 
    
    -- Query took 0,016sec
    SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 370326 
    
    -- Query took 0,016sec
    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 = 137206 
    			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 = 9
    			 AND searchable = "1"
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,108sec
    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 = 137206 OR
    					productID IN
    						(SELECT productID FROM similarProducts WHERE groupID IN
    							(SELECT groupID FROM similarProducts WHERE productID = 137206)
    						)
    				)
    				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-02 17:29:23' AND  [group] = 'hardware'
    
    -- Query took 0,071sec
    SELECT COUNT(*) AS cnt FROM Reviews
    					WHERE
    				(
    					productID = 137206 OR
    					productID IN
    						(SELECT productID FROM similarProducts WHERE groupID IN
    							(SELECT groupID FROM similarProducts WHERE productID = 137206)
    						)
    				)
    		 AND state & 1 = 1
    
    -- Query took 0,01sec
    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 = 137206 AND review_rates.subCategoryID = 9 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 = 9
    			 AND searchable = "1"
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,013sec
    
    
    
    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 = 9  AND brand_id = 9431  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,028sec
    
    		DECLARE @ids TABLE
    			(
    				id int
    			)
    			
    		INSERT INTO @ids SELECT id FROM productVersions WHERE productID = 137206
    				
    		
    		
    		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 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 = 136788 
    
    -- 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 = 135921 
    
    -- 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 = 133225 
    
    -- 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 = 169493 
    
    -- 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 = 136888 
    
    -- 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 = 137024 
    
    -- 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 = 135633 
    
    -- 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 = 136700 
    
    -- 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 = 160164 
    
    -- 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 = 133555 
    
    -- 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 = 134316 
    
    -- 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 = 169491 
    
    -- 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 = 136551 
    
    -- 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 = 134457 
    
    -- 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 = 134141 
    
    -- 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 = 179503 
    
    -- 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 = 134294 
    
    -- 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 = 132992 
    
    -- 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 = 135985 
    
    -- 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 = 138606 
    
    -- 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 = 137367 
    
    -- 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 = 9
    			 AND searchable = "1"
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,021sec
    
    
    
    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 = 9  AND brand_id = 9431  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,008sec
    SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 136788 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 135921 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 133225 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 169493 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
    
    -- Query took 0,01sec
    SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 136888 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 137024 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 135633 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 136700 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 160164 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 133555 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 134316 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 169491 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 136551 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 134457 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 134141 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 179503 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 134294 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
    
    -- Query took 0,01sec
    SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 132992 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price
    
    -- Query took 0,012sec
    SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 135985 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 138606 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_netbooks AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 137367 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 = 370326 
    
    -- Query took 0,009sec
    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 = 370326 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx
    
    -- Query took 0,02sec
    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 = 9
    			
    			ORDER BY
    				featureGroups.priority DESC, priority DESC, featureLang.name
    			
    
    -- Query took 0,018sec
    
    				DELETE FROM htmlCache WHERE id = '9d7966bc23d6c130e2ca7908b4b5543f' AND [group] = 'page137206';
    				INSERT INTO htmlCache (id, html, [group]) VALUES ('9d7966bc23d6c130e2ca7908b4b5543f', '
    		
    		
    			
    
    
    
    
    
    
    
    
    
    
    			
    			
    			
    			
    			HP Mini 2140 Notebook PC (NN355EA#ABH) - Alle technische specificaties. Vergelijk makkelijk met andere Netbooks
    
    			
    
    
    			
    
    			
    			
    
    			
    			
    			
    
    
    			
    
    			
    						
    			
    
    			
    
    						
    			
    					
    
    					
    		
    		
    		
    ', 'page137206')