SET NAMES utf8

SHOW TABLE STATUS LIKE 'mgop_store_website'

SELECT `mgop_store_website`.* FROM `mgop_store_website`

SHOW TABLE STATUS LIKE 'mgop_store_group'

SELECT `mgop_store_group`.* FROM `mgop_store_group`

SHOW TABLE STATUS LIKE 'mgop_store'

SELECT `mgop_store`.* FROM `mgop_store`

SELECT `mgop_flag`.* FROM `mgop_flag` WHERE (`mgop_flag`.`flag_code`='config_hash')

SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`request_path` IN ('finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam', 'finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam/')) AND (`store_id` IN ('1'))

SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mgop_url_rewrite` AS `url_rewrite` LEFT JOIN `mgop_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam', 'finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)

SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` 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 LEFT JOIN `mgop_eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0) ORDER BY position ASC

SELECT `main_table`.* FROM `mgop_url_rewrite` AS `main_table` WHERE (`target_path` LIKE 'catalog/category/view%') AND (`request_path` LIKE 'finder%') AND (`store_id` IN('1')) ORDER BY request_path DESC

SELECT `cp`.`page_id` FROM `mgop_cms_page` AS `cp` INNER JOIN `mgop_cms_page_store` AS `cps` ON cp.page_id = cps.page_id WHERE (cp.identifier = 'finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam') AND (cps.store_id IN (0, '1')) AND (cp.is_active = 1) ORDER BY `cps`.`store_id` DESC LIMIT 1

SELECT `main_table`.`storeurl` FROM `mgop_manage_store` AS `main_table`

SELECT `mgop_customer_entity`.* FROM `mgop_customer_entity` WHERE (entity_id ='')

SELECT `main_table`.* FROM `mgop_manage_store` AS `main_table`

SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`request_path` IN ('finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam', 'finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam/')) AND (`store_id` IN ('1'))

SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mgop_url_rewrite` AS `url_rewrite` LEFT JOIN `mgop_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam', 'finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)

SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `additional_table`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` 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 LEFT JOIN `mgop_eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (`additional_table`.`is_filterable` > 0) ORDER BY position ASC

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mgop_eav_attribute_option` AS `main_table` INNER JOIN `mgop_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `mgop_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '92') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mgop_eav_attribute_option` AS `main_table` INNER JOIN `mgop_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `mgop_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '183') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mgop_eav_attribute_option` AS `main_table` INNER JOIN `mgop_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `mgop_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '184') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mgop_eav_attribute_option` AS `main_table` INNER JOIN `mgop_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `mgop_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '185') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `mgop_eav_attribute_option` AS `main_table` INNER JOIN `mgop_eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `mgop_eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (`main_table`.`attribute_id` = '81') AND (`main_table`.`option_id` IN('')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC

SELECT `main_table`.* FROM `mgop_theme_file` AS `main_table` WHERE (`theme_id` = '11') ORDER BY `sort_order` ASC

SELECT `mgop_cms_block`.`block_id` FROM `mgop_cms_block` INNER JOIN `mgop_cms_block_store` AS `cbs` ON mgop_cms_block.block_id = cbs.block_id WHERE (`mgop_cms_block`.`identifier`='header_cms_links') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1

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 `mgop_indexer_state`.* FROM `mgop_indexer_state` WHERE (`mgop_indexer_state`.`indexer_id`='catalog_product_flat')

SELECT COUNT(DISTINCT e.entity_id) 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_search_tmp_669a4e013999e5_31564293` AS `search_result` ON e.entity_id = search_result.entity_id

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`upc`, `e`.`note`, `e`.`swatch_image`, `e`.`feature_new`, `e`.`housing_color_new`, `e`.`lens_color_new`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` 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_search_tmp_669a4e013999e5_31564293` AS `search_result` ON e.entity_id = search_result.entity_id 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 ORDER BY `cat_index_position` asc, `cat_index`.`position` asc, `cat_index_position` asc, `cat_index`.`position` asc, `e`.`entity_id` DESC LIMIT 48

SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mgop_url_rewrite` AS `url_rewrite` LEFT JOIN `mgop_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.entity_type IN ('product')) AND (url_rewrite.entity_id IN ('953', '2232', '2228', '2227', '2239', '2362', '2363', '2178', '901', '2235', '2436', '2257', '2258')) AND (url_rewrite.store_id IN (1)) AND (url_rewrite.is_autogenerated IN (1)) AND (relation.category_id IS NULL)

SELECT `mgop_cms_block`.`block_id` FROM `mgop_cms_block` INNER JOIN `mgop_cms_block_store` AS `cbs` ON mgop_cms_block.block_id = cbs.block_id WHERE (`mgop_cms_block`.`identifier`='footer_contacts') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1

SELECT `t`.* FROM `mgop_cms_block` AS `t` WHERE (block_id = '7')

SELECT `cbs`.`store_id` FROM `mgop_cms_block_store` AS `cbs` INNER JOIN `mgop_cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)

SELECT `mgop_cms_block`.`block_id` FROM `mgop_cms_block` INNER JOIN `mgop_cms_block_store` AS `cbs` ON mgop_cms_block.block_id = cbs.block_id WHERE (`mgop_cms_block`.`identifier`='footer_cms_content') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1

SELECT `t`.* FROM `mgop_cms_block` AS `t` WHERE (block_id = '5')

SELECT `cbs`.`store_id` FROM `mgop_cms_block_store` AS `cbs` INNER JOIN `mgop_cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)

SELECT `mgop_cms_block`.`block_id` FROM `mgop_cms_block` INNER JOIN `mgop_cms_block_store` AS `cbs` ON mgop_cms_block.block_id = cbs.block_id WHERE (`mgop_cms_block`.`identifier`='footer_payments') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1

SELECT `t`.* FROM `mgop_cms_block` AS `t` WHERE (block_id = '6')

SELECT `cbs`.`store_id` FROM `mgop_cms_block_store` AS `cbs` INNER JOIN `mgop_cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)

SELECT `mgop_cms_block`.`block_id` FROM `mgop_cms_block` INNER JOIN `mgop_cms_block_store` AS `cbs` ON mgop_cms_block.block_id = cbs.block_id WHERE (`mgop_cms_block`.`identifier`='argento_scroll_up') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('953'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2232'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2228'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2227'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2239'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2362'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2363'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2178'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('901'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2235'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2436'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2257'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `l`.`product_id`, `l`.`parent_id` FROM `mgop_catalog_product_super_link` AS `l` INNER JOIN `mgop_catalog_product_entity` AS `p` ON p.entity_id = l.parent_id INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = l.product_id AND e.required_options = 0 WHERE (p.entity_id IN ('2258'))

SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `mgop_catalog_product_bundle_selection` AS `tbl_selection` INNER JOIN `mgop_catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0 INNER JOIN `mgop_catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id INNER JOIN `mgop_catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)

SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`request_path` IN ('finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam', 'finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam/')) AND (`store_id` IN ('1'))

SELECT `url_rewrite`.*, `relation`.`category_id`, `relation`.`product_id` FROM `mgop_url_rewrite` AS `url_rewrite` LEFT JOIN `mgop_catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ('finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam', 'finder/1/chevrolet-astro-1989-2530/feature-led/feature-led-bar/feature-switchback/feature-sequential/feature-led-brake/feature-led-reverse/feature-u-bar/feature-led-drl/feature-led-low-beam/')) AND (url_rewrite.store_id IN ('1')) AND (relation.category_id IS NULL)

ANZO USA | Don’t Get Left in The Dark ~ SELECT `mgop_swissup_easybanner_placeholder`.* FROM `mgop_swissup_easybanner_placeholder` WHERE (`mgop_swissup_easybanner_placeholder`.`name`='top-page-slogan')

SELECT `mgop_swissup_easybanner_placeholder_offset`.* FROM `mgop_swissup_easybanner_placeholder_offset` WHERE (placeholder_id='2') ORDER BY `id` DESC LIMIT 1

SELECT `main_table`.*, `placeholder`.* FROM `mgop_swissup_easybanner_banner` AS `main_table` INNER JOIN `mgop_swissup_easybanner_banner_placeholder` AS `placeholder` ON placeholder.banner_id=main_table.banner_id and placeholder.placeholder_id=2 WHERE (status = 1) AND (type = 1)

SELECT `banner_store`.* FROM `mgop_swissup_easybanner_banner_store` AS `banner_store` WHERE (banner_store.banner_id IN ('2'))

SELECT `banner_placeholder`.* FROM `mgop_swissup_easybanner_banner_placeholder` AS `banner_placeholder` WHERE (banner_placeholder.banner_id IN ('2'))

SELECT `mgop_eav_attribute`.* FROM `mgop_eav_attribute` WHERE (`mgop_eav_attribute`.`attribute_code`='url') AND (entity_type_id = :entity_type_id)

INSERT INTO `mgop_swissup_easybanner_banner_statistic` (`banner_id`, `date`, `display_count`) VALUES (?, ?, ?)

Toggle Nav
My Account
Account
My Cart
Search
Advanced Search
SELECT `mgop_indexer_state`.* FROM `mgop_indexer_state` WHERE (`mgop_indexer_state`.`indexer_id`='catalog_category_flat')

SELECT `mgop_catalog_category_flat_store_1`.`entity_id` FROM `mgop_catalog_category_flat_store_1` WHERE (entity_id='2')

SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (entity_id = '2')

SELECT `main_table`.`entity_id`, main_table.`name`, main_table.`path`, `main_table`.`is_active`, `main_table`.`is_anchor`, `url_rewrite`.`request_path` FROM `mgop_catalog_category_flat_store_1` AS `main_table` LEFT JOIN `mgop_url_rewrite` AS `url_rewrite` ON url_rewrite.entity_id = main_table.entity_id AND url_rewrite.is_autogenerated = 1 AND url_rewrite.store_id = '1' AND url_rewrite.entity_type = 'category' WHERE (main_table.is_active = 1) AND (main_table.include_in_menu = '1') AND (main_table.path like '1/2/%') ORDER BY `main_table`.`position` ASC

SELECT `mgop_cms_block`.`block_id` FROM `mgop_cms_block` INNER JOIN `mgop_cms_block_store` AS `cbs` ON mgop_cms_block.block_id = cbs.block_id WHERE (`mgop_cms_block`.`identifier`='rokanthemes_custom_menu_before') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1

SELECT `t`.* FROM `mgop_cms_block` AS `t` WHERE (block_id = '34')

SELECT `cbs`.`store_id` FROM `mgop_cms_block_store` AS `cbs` INNER JOIN `mgop_cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)

SELECT `mgop_cms_block`.`block_id` FROM `mgop_cms_block` INNER JOIN `mgop_cms_block_store` AS `cbs` ON mgop_cms_block.block_id = cbs.block_id WHERE (`mgop_cms_block`.`identifier`='rokanthemes_custom_menu') AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1

Toggle Nav
SELECT `mgop_swissup_easybanner_placeholder`.* FROM `mgop_swissup_easybanner_placeholder` WHERE (`mgop_swissup_easybanner_placeholder`.`name`='argento_stripes_content_top')

SELECT `mgop_swissup_easybanner_placeholder_offset`.* FROM `mgop_swissup_easybanner_placeholder_offset` WHERE (placeholder_id='3') ORDER BY `id` DESC LIMIT 1

SELECT `main_table`.*, `placeholder`.* FROM `mgop_swissup_easybanner_banner` AS `main_table` INNER JOIN `mgop_swissup_easybanner_banner_placeholder` AS `placeholder` ON placeholder.banner_id=main_table.banner_id and placeholder.placeholder_id=3 WHERE (status = 1) AND (type = 1)

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`

Shop By
Shopping Options
Feature
SELECT `mgop_swissup_seourls_attribute_advanced`.* FROM `mgop_swissup_seourls_attribute_advanced` WHERE (`mgop_swissup_seourls_attribute_advanced`.`attribute_id`='183')

  1. Initiation 1 item
  2. Sequential 20 item
  3. Switchback 25 item
  4. LED 118 item
  5. LED High Beam 18 item
  6. LED Low Beam 13 item
  7. LED DRL 7 item
  8. LED Bar 324 item
  9. LED Turn Signal 271 item
  10. LED Brake 259 item
  11. LED Parking 268 item
  12. LED Reverse 25 item
  13. Projector 292 item
  14. LED Halo 15 item
  15. U-Bar 5 item
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`

Housing Color
SELECT `mgop_swissup_seourls_attribute_advanced`.* FROM `mgop_swissup_seourls_attribute_advanced` WHERE (`mgop_swissup_seourls_attribute_advanced`.`attribute_id`='184')

  1. Black 551 item
  2. Chrome 608 item
  3. Carbon Fiber Look 7 item
  4. Red 1 item
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`

Lens Color
SELECT `mgop_swissup_seourls_attribute_advanced`.* FROM `mgop_swissup_seourls_attribute_advanced` WHERE (`mgop_swissup_seourls_attribute_advanced`.`attribute_id`='185')

  1. Clear/Red 11 item
  2. Smoke/Clear 1 item
  3. Clear 908 item
  4. Smoke 151 item
  5. Red 113 item
  6. Amber 1 item
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`='2530')

SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='2522')

SELECT `mgop_magebees_finder_ymm_value`.* FROM `mgop_magebees_finder_ymm_value` WHERE (`mgop_magebees_finder_ymm_value`.`ymm_value_id`='1268')

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`='2530')

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('858001', '858002', '861061 -Edited on 2013-04-02', '861062 -Edited on 2013-04-02', '861093', '861095', '861096 -Edited on 2013-04-24', '861099', '861110 -Edited on 2013-02-21', '861111', '861112 -Edited on 2013-01-16', '861113 -Edited on 2013-01-16', '881001 -Edited on 2013-03-21', '881002 -Edited on 2013-03-21', '881003', '881004', '881005', '881012', '881013', '881014', '881018 ', '881019 ', '881025 -Edited on 2013-01-16', '881026 -Edited on 2013-01-16', '881028 -Edited on 2013-04-19', '881029 -Edited on 2013-01-16', '881030 -Edited on 2013-01-16', '881031 -Edited on 2013-04-02', '211001', '311103 ', '531044 -Edited on 2013-04-02', '881029 -Edited on 2013-04-19', '881030 -Edited on 2013-04-19', '881025 -Edited on 2013-04-19', '881026 -Edited on 2013-04-19', '531005 -Edited on 2013-04-02', '531006 -Edited on 2013-04-02', '531045 -Edited on 2013-04-02', '531059 -Edited on 2013-04-02', '851023', '861112', '861113', '851024', '861134-Edited on 2013-02-21', '861110', '861134-Edited on 2013-05-02', '881001', '881002', '531044', '531005', '531006', '531045', '531048', '531051', '531058', '531059', '531049', '881031', '861061', '861062', '861096', '881025', '881026', '881028', '881029', '881030', '861134'))

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '953') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('953'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '953')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2227') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2227'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2227')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2228') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2228'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2228')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2235') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2235'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2235')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2232') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2232'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2232')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2257') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2257'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2257')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2258') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2258'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2258')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '901') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('901'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '901')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2436') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2436'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2436')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2178') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2178'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2178')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2362') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2362'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2362')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2363') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2363'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2363')

SELECT `mgop_catalog_product_entity_tier_price`.`value_id` AS `price_id`, `mgop_catalog_product_entity_tier_price`.`website_id`, `mgop_catalog_product_entity_tier_price`.`all_groups`, `mgop_catalog_product_entity_tier_price`.`customer_group_id` AS `cust_group`, `mgop_catalog_product_entity_tier_price`.`value` AS `price`, `mgop_catalog_product_entity_tier_price`.`qty` AS `price_qty`, `mgop_catalog_product_entity_tier_price`.`percentage_value` FROM `mgop_catalog_product_entity_tier_price` WHERE (website_id = 0) AND (entity_id = '2239') ORDER BY `qty` ASC

SELECT `mgop_catalogrule_product_price`.`product_id`, `mgop_catalogrule_product_price`.`rule_price` FROM `mgop_catalogrule_product_price` WHERE (rule_date = '2024-07-19') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('2239'))

SELECT `mgop_swissup_prolabels_index`.`label_id` FROM `mgop_swissup_prolabels_index` WHERE (entity_id = '2239')

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 953)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2227)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2228)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2235)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2232)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2257)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2258)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 901)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2436)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2178)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2362)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2363)

SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2239)

SELECT `main_table`.* FROM `mgop_cataloginventory_stock` AS `main_table`

CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e01348339_34837990` ( `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_669a4e01348339_34837990' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci

INSERT INTO `mgop_search_tmp_669a4e01348339_34837990` 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 ('858001', '858002', '861061 -Edited on 2013-04-02', '861062 -Edited on 2013-04-02', '861093', '861095', '861096 -Edited on 2013-04-24', '861099', '861110 -Edited on 2013-02-21', '861111', '861112 -Edited on 2013-01-16', '861113 -Edited on 2013-01-16', '881001 -Edited on 2013-03-21', '881002 -Edited on 2013-03-21', '881003', '881004', '881005', '881012', '881013', '881014', '881018', '881019', '881025 -Edited on 2013-01-16', '881026 -Edited on 2013-01-16', '881028 -Edited on 2013-04-19', '881029 -Edited on 2013-01-16', '881030 -Edited on 2013-01-16', '881031 -Edited on 2013-04-02', '211001', '311103', '531044 -Edited on 2013-04-02', '881029 -Edited on 2013-04-19', '881030 -Edited on 2013-04-19', '881025 -Edited on 2013-04-19', '881026 -Edited on 2013-04-19', '531005 -Edited on 2013-04-02', '531006 -Edited on 2013-04-02', '531045 -Edited on 2013-04-02', '531059 -Edited on 2013-04-02', '851023', '861112', '861113', '851024', '861134-Edited on 2013-02-21', '861110', '861134-Edited on 2013-05-02', '881001', '881002', '531044', '531005', '531006', '531045', '531048', '531051', '531058', '531059', '531049', '881031', '861061', '861062', '861096', '881025', '881026', '881028', '881029', '881030', '861134'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000

SELECT `mgop_search_tmp_669a4e01348339_34837990`.`entity_id`, `mgop_search_tmp_669a4e01348339_34837990`.`score` FROM `mgop_search_tmp_669a4e01348339_34837990`

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 (2436, 2363, 2362, 2258, 2257, 2239, 2235, 2232, 2228, 2227, 2178, 953, 901)) 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 INNER JOIN `mgop_eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4) AND (`entity_attribute`.`attribute_set_id` IN('4')) GROUP BY `main_table`.`attribute_id`

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_669a4e01348339_34837990)) AND (customer_group_id = 0) AND (main_table.website_id = '1')

SELECT IFNULL(FLOOR(min_price / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e01348339_34837990` 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 / 100 ) + 1, 1) AS `range`, COUNT(*) AS `metrix` FROM `mgop_catalog_product_index_price` AS `main_table` INNER JOIN `mgop_search_tmp_669a4e01348339_34837990` 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_669a4e01348339_34837990` 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_669a4e01348339_34837990` 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_669a4e01348339_34837990` 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_669a4e01348339_34837990` 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_669a4e01348339_34837990` 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_669a4e01348339_34837990` 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 ('858001', '858002', '861061 -Edited on 2013-04-02', '861062 -Edited on 2013-04-02', '861093', '861095', '861096 -Edited on 2013-04-24', '861099', '861110 -Edited on 2013-02-21', '861111', '861112 -Edited on 2013-01-16', '861113 -Edited on 2013-01-16', '881001 -Edited on 2013-03-21', '881002 -Edited on 2013-03-21', '881003', '881004', '881005', '881012', '881013', '881014', '881018', '881019', '881025 -Edited on 2013-01-16', '881026 -Edited on 2013-01-16', '881028 -Edited on 2013-04-19', '881029 -Edited on 2013-01-16', '881030 -Edited on 2013-01-16', '881031 -Edited on 2013-04-02', '211001', '311103', '531044 -Edited on 2013-04-02', '881029 -Edited on 2013-04-19', '881030 -Edited on 2013-04-19', '881025 -Edited on 2013-04-19', '881026 -Edited on 2013-04-19', '531005 -Edited on 2013-04-02', '531006 -Edited on 2013-04-02', '531045 -Edited on 2013-04-02', '531059 -Edited on 2013-04-02', '851023', '861112', '861113', '851024', '861134-Edited on 2013-02-21', '861110', '861134-Edited on 2013-05-02', '881001', '881002', '531044', '531005', '531006', '531045', '531048', '531051', '531058', '531059', '531049', '881031', '861061', '861062', '861096', '881025', '881026', '881028', '881029', '881030', '861134'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC ) AS `core_select`

CREATE TEMPORARY TABLE `mgop_search_tmp_669a4e013999e5_31564293` ( `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_669a4e013999e5_31564293' ENGINE=memory charset=utf8 COLLATE=utf8_general_ci

INSERT INTO `mgop_search_tmp_669a4e013999e5_31564293` (`entity_id`,`score`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?)

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')

  1. $0.00 - $999.99 1390 item
  2. $1,000.00 and above 18 item
SELECT `mgop_catalog_category_flat_store_1`.`entity_id` FROM `mgop_catalog_category_flat_store_1` WHERE (entity_id='2')

Category
  1. Tail Lights
  2. Off-Road
  3. Universal Lights
View as Grid List

13 Items

per page
Set Descending Direction
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 953)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  1. CHEVY ASTRO / GMC SAFARI VAN 85-05 TAIL LIGHTS CHROME G2 SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('953')) AND (entity_type = 1) AND (store_id = 1)

    $100.00
    SKU#211001
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2232)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='25')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  2. 60" 6 FUNCTION L.E.D TAILGATE BAR SMD STYLE w/ AMBER SCANNING SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2232')) AND (entity_type = 1) AND (store_id = 1)

    $97.00
    SKU#531058
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2228)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='25')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  3. 60" 5 FUNCTION L.E.D TAILGATE BAR SMD STYLE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2228')) AND (entity_type = 1) AND (store_id = 1)

    $95.00
    SKU#531006
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2227)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='25')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  4. 49" 5 FUNCTION L.E.D TAILGATE BAR SMD STYLE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2227')) AND (entity_type = 1) AND (store_id = 1)

    $81.00
    SKU#531005
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2239)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='10')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='18')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  5. 3"x3" RUGGED HI-INTENSITY 3W L.E.D OFF ROAD LIGHT SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2239')) AND (entity_type = 1) AND (store_id = 1)

    $99.00
    SKU#881031
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2362)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='10')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='18')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  6. 6" RUGGED HI-INTENSITY 3W LED OFF ROAD LIGHT (Spot) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2362')) AND (entity_type = 1) AND (store_id = 1)

    $252.00
    SKU#881025
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2363)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='10')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='18')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  7. 12" RUGGED HI-INTENSITY 3W LED OFF ROAD LIGHT (Spot) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2363')) AND (entity_type = 1) AND (store_id = 1)

    $362.00
    SKU#881026
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2178)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='10')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='18')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  8. Rugged Vision 4.5" Round High Power L.E.D Fog Light (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2178')) AND (entity_type = 1) AND (store_id = 1)

    $269.00
    SKU#881002
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 901)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='10')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='19')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('19')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  9. 6" HID OFF ROAD LIGHTS CHROME w/ LENS PROTECTOR (PAIR) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('901')) AND (entity_type = 1) AND (store_id = 1)

    $164.00
    SKU#861095
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2235)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='26')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('26')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  10. BED RAIL AUXILIARY L.E.D. LIGHTING PODS SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2235')) AND (entity_type = 1) AND (store_id = 1)

    $82.00
    SKU#531049
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2436)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='26')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('26')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  11. L.E.D Utility Light Bar Chrome w/ Rechargeable Flash Lights SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2436')) AND (entity_type = 1) AND (store_id = 1)

    $110.00
    SKU#861134
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2257)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='23')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('23')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  12. LED HITCH LIGHT SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2257')) AND (entity_type = 1) AND (store_id = 1)

    $60.00
    SKU#861061
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2258)

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

    SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='23')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('23')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))

  13. L.E.D MAGNET LIGHT (PAIR) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2258')) AND (entity_type = 1) AND (store_id = 1)

    $54.95
    SKU#861062
View as Grid List

13 Items

per page
Set Descending Direction
SELECT `main_table`.* FROM `mgop_swissup_easybanner_banner` AS `main_table` WHERE (type in (2, 3)) AND (status = 1)