gerelateerde producten

Vergelijk ION PowerScan (POWERSCAN) met ...

Wat vind je van ION PowerScan

Ga verder
help
Toch niet gevonden wat je zocht?
Database:0,573 (55) Solr: 0 Other: 0,141 Total: 0,714

-- Query took 0,014sec
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 = '244376' 

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

-- Query took 0,006sec
SELECT * FROM youtube WHERE productId = 244376

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

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

-- Query took 0,001sec
SELECT html FROM htmlCache WHERE id = '9dcaefb91bcef71853db14ef787e4230' AND timestamp > '2014-10-01 16:27:48' AND  [group] = 'page244376'

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

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

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

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

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

-- Query took 0,003sec
SELECT html FROM htmlCache WHERE id = 'c57dc692e45eeea978d552e80c7d9844' AND timestamp > '2014-10-02 15:27:48' AND  [group] = 'hardware'

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

-- Query took 0,011sec
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 = 244376 AND review_rates.subCategoryID = 93 GROUP BY review_rates.id, review_rates.name, review_rates.weight ORDER BY review_rates.weight

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

-- Query took 0,004sec



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 = 93  AND brand_id = 10608  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,013sec
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 = 244376 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx

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

-- Query took 0,008sec
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 = 244376 AND state & 1 = 1 AND site = 1 ORDER BY flat.score 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 = 93
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,004sec



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 = 93  AND brand_id = 10608  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,026sec

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

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

-- Query took 0,015sec
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 = 187575 

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

-- Query took 0,004sec



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 = 93  AND brand_id = 10608  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,009sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 256769 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,013sec
SELECT TOP 1 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 188152 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 187575 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 188837 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 244376 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 212958 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 222392 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 256295 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 210473 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 256276 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 256313 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 256314 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 273476 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 294167 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 358542 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 256769 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 188152 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 187575 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 188837 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_scanners AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 244376 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

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

-- Query took 0,004sec
SELECT id, name FROM review_rates WHERE subCategoryID = 93

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

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

				DELETE FROM htmlCache WHERE id = '9dcaefb91bcef71853db14ef787e4230' AND [group] = 'page244376';
				INSERT INTO htmlCache (id, html, [group]) VALUES ('9dcaefb91bcef71853db14ef787e4230', '
		
		
			










			
			
			
			
			Vergelijk de ION PowerScan - alle prijzen, technische specificaties en reviews van alle uitvoeringen.

			


			

			
			

			
			
			


			

			
						
			

			

						
			
					

					
		
		
		

gerelateerde producten

Vergelijk ION PowerScan (POWERSCAN) met ...

Wat vind je van ION PowerScan

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