SELECT `color_idx`.`value`, COUNT(color_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `mgop_catalog_product_index_eav` AS `color_idx` ON color_idx.entity_id = e.entity_id AND color_idx.attribute_id = '92' AND color_idx.store_id = '1' GROUP BY `color_idx`.`value`
SELECT `feature_new_idx`.`value`, COUNT(feature_new_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `mgop_catalog_product_index_eav` AS `feature_new_idx` ON feature_new_idx.entity_id = e.entity_id AND feature_new_idx.attribute_id = '183' AND feature_new_idx.store_id = '1' GROUP BY `feature_new_idx`.`value`
SELECT `mgop_catalog_category_flat_store_1`.`entity_id` FROM `mgop_catalog_category_flat_store_1` WHERE (entity_id='2')
SELECT `feature_new_idx`.`value`, COUNT(feature_new_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `mgop_catalog_product_index_eav` AS `feature_new_idx` ON feature_new_idx.entity_id = e.entity_id AND feature_new_idx.attribute_id = '183' AND feature_new_idx.store_id = '1' GROUP BY `feature_new_idx`.`value`
Shop By
Shopping Options
SELECT `housing_color_new_idx`.`value`, COUNT(housing_color_new_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `mgop_catalog_product_index_eav` AS `housing_color_new_idx` ON housing_color_new_idx.entity_id = e.entity_id AND housing_color_new_idx.attribute_id = '184' AND housing_color_new_idx.store_id = '1' GROUP BY `housing_color_new_idx`.`value`
SELECT `lens_color_new_idx`.`value`, COUNT(lens_color_new_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `mgop_catalog_product_index_eav` AS `lens_color_new_idx` ON lens_color_new_idx.entity_id = e.entity_id AND lens_color_new_idx.attribute_id = '185' AND lens_color_new_idx.store_id = '1' GROUP BY `lens_color_new_idx`.`value`
SELECT `manufacturer_idx`.`value`, COUNT(manufacturer_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e`
INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `mgop_catalog_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '81' AND manufacturer_idx.store_id = '1' GROUP BY `manufacturer_idx`.`value`
SELECT `mgop_magebees_finder`.* FROM `mgop_magebees_finder` WHERE (`mgop_magebees_finder`.`finder_id`='1')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1886')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1348')
SELECT `main_table`.* FROM `mgop_magebees_finder_dropdowns` AS `main_table` WHERE (`finder_id` = '1')
SELECT `mgop_magebees_finder_map_value`.* FROM `mgop_magebees_finder_map_value` WHERE (`mgop_magebees_finder_map_value`.`ymm_value_id`='1886')
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `stock_status_index`.`stock_status` AS `is_salable` FROM `mgop_catalog_product_flat_1` AS `e` LEFT JOIN `mgop_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (e.sku IN(''))
SELECT `main_table`.* FROM `mgop_cataloginventory_stock` AS `main_table`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e179a6f87_06806157` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='mgop_search_tmp_669a4e179a6f87_06806157' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
INSERT INTO `mgop_search_tmp_669a4e179a6f87_06806157` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `mgop_catalog_product_index_eav` AS `search_index` INNER JOIN `mgop_cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `mgop_catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' INNER JOIN `mgop_catalog_product_entity` AS `sku_filter` ON search_index.entity_id = `sku_filter`.`entity_id` WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 102 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id in ('2')) AND (`sku_filter`.`sku` IN (''))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000
SELECT `mgop_search_tmp_669a4e179a6f87_06806157`.`entity_id`, `mgop_search_tmp_669a4e179a6f87_06806157`.`score` FROM `mgop_search_tmp_669a4e179a6f87_06806157`
SELECT `mgop_search_tmp_669a4e179a6f87_06806157`.`entity_id` FROM `mgop_search_tmp_669a4e179a6f87_06806157`
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='2')
SELECT `e`.`attribute_set_id` FROM `mgop_catalog_product_flat_1` AS `e` WHERE (entity_id IN (NULL)) GROUP BY `attribute_set_id`
SELECT `main_table`.`attribute_code` FROM `mgop_eav_attribute` AS `main_table` INNER JOIN `mgop_catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4)
SELECT count(main_table.entity_id) AS `count`, MAX(min_price) AS `max`, MIN(min_price) AS `min`, STDDEV_SAMP(min_price) AS `std` FROM `mgop_catalog_product_index_price` AS `main_table` WHERE (main_table.entity_id in (select entity_id from mgop_search_tmp_669a4e179a6f87_06806157)) AND (customer_group_id = 0) AND (main_table.website_id = '1')
SELECT IFNULL(FLOOR(min_price / 1 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC
SELECT IFNULL(FLOOR(min_price / 1 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC
SELECT `main_table`.*, count(main_table.value) AS `count` FROM (SELECT `main_table`.`category_id` AS `value` FROM `mgop_catalog_category_product_index_store1` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.product_id = entities.entity_id INNER JOIN `mgop_catalog_category_entity` AS `category` ON main_table.category_id = category.entity_id WHERE (main_table.store_id = '1') AND (`category`.`path` LIKE '1/2%') AND (`category`.`level` > '1')) AS `main_table` GROUP BY `value`
SELECT `mgop_eav_attribute`.* FROM `mgop_eav_attribute` WHERE (`mgop_eav_attribute`.`attribute_code`='color') AND (entity_type_id = :entity_type_id)
SELECT `mgop_eav_entity_type`.`additional_attribute_table` FROM `mgop_eav_entity_type` WHERE (entity_type_id = :entity_type_id)
SELECT `mgop_catalog_eav_attribute`.* FROM `mgop_catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 92) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 183) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 184) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 185) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `mgop_eav_attribute`.* FROM `mgop_eav_attribute` WHERE (`mgop_eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)
SELECT `mgop_catalog_eav_attribute`.* FROM `mgop_catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 81) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT COUNT(*) FROM (SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `mgop_catalog_product_index_eav` AS `search_index` INNER JOIN `mgop_cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `mgop_catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' INNER JOIN `mgop_catalog_product_entity` AS `sku_filter` ON search_index.entity_id = `sku_filter`.`entity_id` WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 102 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id in ('2')) AND (`sku_filter`.`sku` IN (''))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC ) AS `core_select`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e17a02bd8_21855120` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='mgop_search_tmp_669a4e17a02bd8_21855120' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(price_index.min_price ) * 1, 2) AS `max`, ROUND(MIN(price_index.min_price ) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((price_index.min_price ) * 1, 2)) AS `std` FROM `mgop_catalog_product_flat_1` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (price_index.min_price IS NOT NULL)
SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `mgop_catalog_product_index_price` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ORDER BY (FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1) ASC
SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `mgop_catalog_product_index_price` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ORDER BY (FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1) ASC
Feature
SELECT `mgop_swissup_seourls_attribute_advanced`.* FROM `mgop_swissup_seourls_attribute_advanced` WHERE (`mgop_swissup_seourls_attribute_advanced`.`attribute_id`='183')
Housing Color
SELECT `mgop_swissup_seourls_attribute_advanced`.* FROM `mgop_swissup_seourls_attribute_advanced` WHERE (`mgop_swissup_seourls_attribute_advanced`.`attribute_id`='184')
Lens Color
SELECT `mgop_swissup_seourls_attribute_advanced`.* FROM `mgop_swissup_seourls_attribute_advanced` WHERE (`mgop_swissup_seourls_attribute_advanced`.`attribute_id`='185')
SELECT `mgop_magebees_finder`.* FROM `mgop_magebees_finder` WHERE (`mgop_magebees_finder`.`finder_id`='1')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1886')
SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1348')
SELECT `main_table`.* FROM `mgop_magebees_finder_dropdowns` AS `main_table` WHERE (`finder_id` = '1')
SELECT `mgop_magebees_finder_map_value`.* FROM `mgop_magebees_finder_map_value` WHERE (`mgop_magebees_finder_map_value`.`ymm_value_id`='1886')
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `stock_status_index`.`stock_status` AS `is_salable` FROM `mgop_catalog_product_flat_1` AS `e` LEFT JOIN `mgop_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (e.sku IN(''))
SELECT `main_table`.* FROM `mgop_cataloginventory_stock` AS `main_table`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e179a6f87_06806157` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='mgop_search_tmp_669a4e179a6f87_06806157' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
INSERT INTO `mgop_search_tmp_669a4e179a6f87_06806157` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `mgop_catalog_product_index_eav` AS `search_index` INNER JOIN `mgop_cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `mgop_catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' INNER JOIN `mgop_catalog_product_entity` AS `sku_filter` ON search_index.entity_id = `sku_filter`.`entity_id` WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 102 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id in ('2')) AND (`sku_filter`.`sku` IN (''))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000
SELECT `mgop_search_tmp_669a4e179a6f87_06806157`.`entity_id`, `mgop_search_tmp_669a4e179a6f87_06806157`.`score` FROM `mgop_search_tmp_669a4e179a6f87_06806157`
SELECT `mgop_search_tmp_669a4e179a6f87_06806157`.`entity_id` FROM `mgop_search_tmp_669a4e179a6f87_06806157`
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='2')
SELECT `e`.`attribute_set_id` FROM `mgop_catalog_product_flat_1` AS `e` WHERE (entity_id IN (NULL)) GROUP BY `attribute_set_id`
SELECT `main_table`.`attribute_code` FROM `mgop_eav_attribute` AS `main_table` INNER JOIN `mgop_catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4)
SELECT count(main_table.entity_id) AS `count`, MAX(min_price) AS `max`, MIN(min_price) AS `min`, STDDEV_SAMP(min_price) AS `std` FROM `mgop_catalog_product_index_price` AS `main_table` WHERE (main_table.entity_id in (select entity_id from mgop_search_tmp_669a4e179a6f87_06806157)) AND (customer_group_id = 0) AND (main_table.website_id = '1')
SELECT IFNULL(FLOOR(min_price / 1 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC
SELECT IFNULL(FLOOR(min_price / 1 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.customer_group_id = 0) AND (main_table.website_id = '1') GROUP BY `range` ORDER BY `range` ASC
SELECT `main_table`.*, count(main_table.value) AS `count` FROM (SELECT `main_table`.`category_id` AS `value` FROM `mgop_catalog_category_product_index_store1` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.product_id = entities.entity_id INNER JOIN `mgop_catalog_category_entity` AS `category` ON main_table.category_id = category.entity_id WHERE (main_table.store_id = '1') AND (`category`.`path` LIKE '1/2%') AND (`category`.`level` > '1')) AS `main_table` GROUP BY `value`
SELECT `mgop_eav_attribute`.* FROM `mgop_eav_attribute` WHERE (`mgop_eav_attribute`.`attribute_code`='color') AND (entity_type_id = :entity_type_id)
SELECT `mgop_eav_entity_type`.`additional_attribute_table` FROM `mgop_eav_entity_type` WHERE (entity_type_id = :entity_type_id)
SELECT `mgop_catalog_eav_attribute`.* FROM `mgop_catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 92) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 183) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 184) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 185) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT `mgop_eav_attribute`.* FROM `mgop_eav_attribute` WHERE (`mgop_eav_attribute`.`attribute_code`='manufacturer') AND (entity_type_id = :entity_type_id)
SELECT `mgop_catalog_eav_attribute`.* FROM `mgop_catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `mgop_catalog_product_index_eav` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e179a6f87_06806157` AS `entities` ON main_table.entity_id = entities.entity_id WHERE (main_table.attribute_id = 81) AND (main_table.store_id = '1' )) AS `main_table` GROUP BY `value`
SELECT COUNT(*) FROM (SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `mgop_catalog_product_index_eav` AS `search_index` INNER JOIN `mgop_cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1 INNER JOIN `mgop_catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' INNER JOIN `mgop_catalog_product_entity` AS `sku_filter` ON search_index.entity_id = `sku_filter`.`entity_id` WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 102 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id in ('2')) AND (`sku_filter`.`sku` IN (''))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC ) AS `core_select`
CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e17a02bd8_21855120` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `score` decimal(32,16) UNSIGNED NULL COMMENT 'Score' , PRIMARY KEY (`entity_id`) ) COMMENT='mgop_search_tmp_669a4e17a02bd8_21855120' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci
SELECT COUNT(DISTINCT e.entity_id), ROUND(MAX(price_index.min_price ) * 1, 2) AS `max`, ROUND(MIN(price_index.min_price ) * 1, 2) AS `min`, STDDEV_SAMP(ROUND((price_index.min_price ) * 1, 2)) AS `std` FROM `mgop_catalog_product_flat_1` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (price_index.min_price IS NOT NULL)
SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `mgop_catalog_product_index_price` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ORDER BY (FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1) ASC
SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `mgop_catalog_product_index_price` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 WHERE ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price IS NOT NULL) GROUP BY FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1 ORDER BY (FLOOR((ROUND((e.min_price) * 1, 2)) / 1000) + 1) ASC
Price
SELECT `mgop_swissup_seourls_attribute_advanced`.* FROM `mgop_swissup_seourls_attribute_advanced` WHERE (`mgop_swissup_seourls_attribute_advanced`.`attribute_id`='75')
We can't find products matching the selection.
