Database:0,628 (74) Solr: 0,018 Other: 0,163 Total: 0,809

-- Query took 0,009sec
SELECT num FROM stats_queriesSearchedFlat JOIN stats_queries ON (stats_queries.id = stats_queriesSearchedFlat.queryID) WHERE query = 'dagwaarde-renault--scenic-1997'

-- Query took 0,001sec
SELECT * FROM brands WHERE id = '9256'

-- Query took 0,001sec
SELECT productsSearch.* FROM productsSearch WHERE products_id IN (72014)

-- Query took 0,003sec
SELECT productsSearch.* FROM productsSearch WHERE products_id IN (72014,72014,72014,233470,233470,233470,72015,72015,72015,149352,149352,149352,149351,149351,149351,149353,149353,149353,149365,149365,149365,149366,149366,149366,149367)

-- Query took 0,006sec
SELECT productVersions.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource  FROM ProductVersions LEFT JOIN brands ON (productVersions.brandID = brands.id) WHERE productVersions.id IN (233629,237611,233705,750171,723867,723879,233744,552009,223252,460698,460699,460778,460545,460464,460546,460923,460881,460890,468598,468623,468587,468676,468669,468699,468720)

-- Query took 0,015sec
DECLARE @sr TABLE (id int, ranking int)
INSERT INTO @sr
					SELECT id, 1 AS ranking
						FROM prices_shopProducts WHERE productVersionID IN (233629,237611,233705,750171,723867,723879,233744,552009,223252,460698,460699,460778,460545,460464,460546,460923,460881,460890,468598,468623,468587,468676,468669,468699,468720)
			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,002sec
SELECT productsSearch.* FROM productsSearch WHERE products_id IN (72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014,72014)

-- Query took 0,006sec
SELECT productVersions.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource  FROM ProductVersions LEFT JOIN brands ON (productVersions.brandID = brands.id) WHERE productVersions.id IN (233629,237611,233705,237522,236662,237612,237524,233631,221681,222337,236411,233632,596060,223075,236659,223076,236660,596063,223077,223244,553415,237688,553411,553416,233703)

-- Query took 0,015sec
DECLARE @sr TABLE (id int, ranking int)
INSERT INTO @sr
					SELECT id, 1 AS ranking
						FROM prices_shopProducts WHERE productVersionID IN (233629,237611,233705,237522,236662,237612,237524,233631,221681,222337,236411,233632,596060,223075,236659,223076,236660,596063,223077,223244,553415,237688,553411,553416,233703)
			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,026sec
DECLARE @sr TABLE (id int, ranking int)
INSERT INTO @sr
					SELECT[KEY], RANK AS ranking
						FROM FREETEXTTABLE (prices_shopProducts, name, 'dagwaarde AND renault AND scenic AND 1997', 5000)
			SELECT TOP 10
				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,003sec
SELECT html FROM htmlCache WHERE id = '58352d573916e3119fd11a3c5a7a7331' AND timestamp > '2014-10-20 22:12:20' AND  [group] = 'auto'

-- Query took 0,005sec
SELECT num FROM stats_queriesSearchedFlat JOIN stats_queries ON (stats_queries.id = stats_queriesSearchedFlat.queryID) WHERE query = 'dagwaarde renault  scenic 1997'

-- Query took 0,004sec
SELECT message, searchString FROM searchMessage WHERE 2 = 1 OR searchString LIKE '%dagwaarde%'  OR searchString LIKE '%renault%'  OR searchString LIKE '%%'  OR searchString LIKE '%scenic%'  OR searchString LIKE '%1997%' 

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 233629

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 237611

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 233705

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 237522

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 236662

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 237612

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 237524

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 233631

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 221681

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 222337

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 236411

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 233632

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 596060

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 223075

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 236659

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 223076

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 236660

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 596063

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 223077

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 223244

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 553415

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 237688

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 553411

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 553416

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

-- Query took 0,001sec
SELECT * FROM filter_y_mpv WHERE productVersionID = 233703

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 183 AND products.externSource = 'shops'

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

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 183 AND products.externSource = 'shops'

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 183 AND products.externSource = 'shops'

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 247 AND products.externSource = 'shops'

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 247 AND products.externSource = 'shops'

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 183 AND products.externSource = 'shops'

-- Query took 0,041sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 183 AND products.externSource = 'shops'

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 183 AND products.externSource = 'shops'

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 247 AND products.externSource = 'shops'

-- Query took 0,04sec
SELECT products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, products_rate AS rate, products_stats AS stats FROM products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN productsSearch ON (products_id = products.id) WHERE products.externID = 183 AND products.externSource = 'shops'