Beste prijzen Dymo LT-100T + Tape:

Database:0,314 (18) Solr: 0 Other: 0,245 Total: 0,559

-- Query took 0,008sec
SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = '204582' 

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

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

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

-- Query took 0,001sec
SELECT html FROM htmlCache WHERE id = '1ae17f91cc50831187a1bff159ad2b38' AND timestamp > '2014-09-30 16:14:10' AND  [group] = 'page204582'

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

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

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

-- Query took 0,116sec
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 = 204582 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 204582)
						)
				)
				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-01 15:14:10' AND  [group] = 'hardware'

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

-- Query took 0,009sec
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 = 204582 AND review_rates.subCategoryID = 102 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 = 102
			 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 = 102  AND brand_id = 12714  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,011sec
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 = 204582 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx

-- Query took 0,027sec
DECLARE @sr TABLE (id int, ranking int)
INSERT INTO @sr
					SELECT[KEY], RANK AS ranking
						FROM CONTAINSTABLE (prices_shopProducts, name, 'Dymo AND LT100T AND Tape', 5000)
			SELECT TOP 100
				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 @sr AS result JOIN prices_shopProducts ON (prices_shopProducts.id = result.id)
			JOIN prices_shops ON (prices_shops.id = prices_shopProducts.shopID) WHERE 1=1 AND prices_shops.state & 2 != 2 ORDER BY CASE WHEN prices_shopProducts.productVersionID IS NULL THEN 1 ELSE 0 END, result.ranking DESC, name, priceIn

-- Query took 0,008sec

				DELETE FROM htmlCache WHERE id = '1ae17f91cc50831187a1bff159ad2b38' AND [group] = 'page204582';
				INSERT INTO htmlCache (id, html, [group]) VALUES ('1ae17f91cc50831187a1bff159ad2b38', '
		
		
			










			
			
			
			
			Dymo LT-100T + Tape - Vind de beste aanbieding van alle shops op TOPPRODUCT.NL.

			


			

			
			

			
			
			


			

			
						
			

			

						
			
					

					
		
		
		

Beste prijzen Dymo LT-100T + Tape:

', 'page204582')