Database:0,837 (70) Solr: 0,02 Other: 0,182 Total: 1,039

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

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

-- Query took 0,025sec
SELECT productsSearch.* FROM productsSearch WHERE products_id IN (140110,72014,72014,72014,149354,149354,149354,242679,242679,242679,238646,238646,238646,159421,159421,159421,233470,233470,233470,72299,72299,72299,72304,72304,72304)

-- Query took 0,039sec
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 (438635,233629,237611,233705,462674,552200,462668,750180,723964,723961,724001,723989,723983,492564,492565,492563,750171,723867,723879,460004,459996,225325,468455,468437,468438)

-- Query took 0,018sec
DECLARE @sr TABLE (id int, ranking int)
INSERT INTO @sr
					SELECT id, 1 AS ranking
						FROM prices_shopProducts WHERE productVersionID IN (438635,233629,237611,233705,462674,552200,462668,750180,723964,723961,724001,723989,723983,492564,492565,492563,750171,723867,723879,460004,459996,225325,468455,468437,468438)
			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,027sec
DECLARE @sr TABLE (id int, ranking int)
INSERT INTO @sr
					SELECT[KEY], RANK AS ranking
						FROM FREETEXTTABLE (prices_shopProducts, name, 'dagwaarde AND renault AND megane 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,002sec
SELECT html FROM htmlCache WHERE id = '58352d573916e3119fd11a3c5a7a7331' AND timestamp > '2014-10-02 11:25:26' 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 megane scenic 1997'

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

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

-- Query took 0,001sec
SELECT * FROM filter_g_stadscombi WHERE productVersionID = 438635

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

-- Query took 0,001sec
SELECT * FROM filter_y_cabrio WHERE productVersionID = 462674

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

-- Query took 0,001sec
SELECT * FROM filter_y_cabrio WHERE productVersionID = 552200

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

-- Query took 0,001sec
SELECT * FROM filter_y_cabrio WHERE productVersionID = 462668

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

-- Query took 0,001sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 750180

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

-- Query took 0,001sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 723964

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

-- Query took 0,001sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 723961

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

-- Query took 0,002sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 724001

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

-- Query took 0,001sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 723989

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

-- Query took 0,005sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 723983

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

-- Query took 0,001sec
SELECT * FROM filter_g_stadscombi WHERE productVersionID = 492564

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

-- Query took 0,002sec
SELECT * FROM filter_g_stadscombi WHERE productVersionID = 492565

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

-- Query took 0,001sec
SELECT * FROM filter_g_stadscombi WHERE productVersionID = 492563

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

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

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

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

-- Query took 0,001sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 460004

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

-- Query took 0,004sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 459996

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

-- Query took 0,004sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 225325

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

-- Query took 0,001sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 468455

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

-- Query took 0,001sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 468437

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

-- Query took 0,002sec
SELECT * FROM filter_y_hatchback WHERE productVersionID = 468438

-- 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,072sec
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,103sec
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,085sec
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,065sec
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,05sec
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,063sec
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,078sec
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 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 = 265001 

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