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/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear', 'finder/1/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear/')) 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/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear', 'finder/1/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear/')) 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/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear') 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/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear', 'finder/1/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear/')) 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/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear', 'finder/1/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear/')) 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_669a4ded1114e9_52706398` 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_669a4ded1114e9_52706398` 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 ('3184', '3163', '3115', '3114', '3060', '2616', '1738', '1737', '2376', '2375', '2373', '2035', '2034', '810', '2317', '2305', '2306')) 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 ('3184'))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear', 'finder/1/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear/')) 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/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear', 'finder/1/ford-f-250-super-duty-2010-4329/feature-projector/feature-led-parking/lens-color-smoke/feature-sequential/feature-led-reverse/feature-led-bar/housing-color-chrome/feature-led/lens-color-clear/')) 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`='4329')

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

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

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

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('531021', '531050', '111167', '111168', '531076', '531077', '861074', '861075', '861102', '861103', '311050', '311169', '311128', '311127', '851040', '111305', '111306', '311305', '311356', '311358', '311357', '311379'))

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 = '1737') 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('1737'))

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

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 = '1738') 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('1738'))

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

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 = '2616') 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('2616'))

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

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 = '2373') 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('2373'))

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

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 = '2376') 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('2376'))

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

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 = '2375') 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('2375'))

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

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 = '3060') 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('3060'))

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

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 = '3114') 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('3114'))

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

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 = '3163') 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('3163'))

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

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 = '3115') 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('3115'))

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

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 = '3184') 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('3184'))

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

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 = '810') 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('810'))

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

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 = '2034') 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('2034'))

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

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 = '2035') 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('2035'))

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

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 = '2305') 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('2305'))

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

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 = '2306') 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('2306'))

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

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 = '2317') 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('2317'))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `mgop_search_tmp_669a4ded0c4813_27948655` 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 ('531021', '531050', '111167', '111168', '531076', '531077', '861074', '861075', '861102', '861103', '311050', '311169', '311128', '311127', '851040', '111305', '111306', '311305', '311356', '311358', '311357', '311379'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000

SELECT `mgop_search_tmp_669a4ded0c4813_27948655`.`entity_id`, `mgop_search_tmp_669a4ded0c4813_27948655`.`score` FROM `mgop_search_tmp_669a4ded0c4813_27948655`

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 (3184, 3163, 3115, 3114, 3060, 2616, 2376, 2375, 2373, 2317, 2306, 2305, 2035, 2034, 1738, 1737, 810)) 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_669a4ded0c4813_27948655)) 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_669a4ded0c4813_27948655` 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_669a4ded0c4813_27948655` 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_669a4ded0c4813_27948655` 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_669a4ded0c4813_27948655` 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_669a4ded0c4813_27948655` 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_669a4ded0c4813_27948655` 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_669a4ded0c4813_27948655` 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_669a4ded0c4813_27948655` 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 ('531021', '531050', '111167', '111168', '531076', '531077', '861074', '861075', '861102', '861103', '311050', '311169', '311128', '311127', '851040', '111305', '111306', '311305', '311356', '311358', '311357', '311379'))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC ) AS `core_select`

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

INSERT INTO `mgop_search_tmp_669a4ded1114e9_52706398` (`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. Auxiliary Lights
View as Grid List

17 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 = 3184)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('93')) 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`='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`='14')

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

  1. FORD F-250/SUPER DUTY 08-16 LED TAIL LIGHTS BLACK HOUSING SMOKE LENS (W/ C LIGHTS BAR) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('3184')) AND (entity_type = 1) AND (store_id = 1)

    $330.00
    SKU#311379
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 3163)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('93')) 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`='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`='14')

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

  2. FORD F-250/F-350/F-450/F-550 SUPER DUTY 08-16 LED TAIL LIGHTS CHROME HOUSING SMOKE LENS W/ C LIGHTS BAR SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('3163')) AND (entity_type = 1) AND (store_id = 1)

    $330.00
    SKU#311357
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 3115)

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

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

  3. FORD F-250/F-350/F-450/F-550 SUPER DUTY 08-16 LED TAIL LIGHTS CHROME HOUSING RED/CLEAR LENS SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('3115')) AND (entity_type = 1) AND (store_id = 1)

    $330.00
    SKU#311358
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 3114)

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

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

  4. FORD F-250/F-350/F-450/F-550 SUPER DUTY 08-16 LED TAILLIGHTS BLACK HOUSING CLEAR LENS SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('3114')) AND (entity_type = 1) AND (store_id = 1)

    $330.00
    SKU#311356
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 3060)

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

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

  5. FORD F-250/F-350/F-450 SUPER DUTY 08-16 TAILLIGHT RED/CLEAR LENS (OE REPLACEMENT) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('3060')) AND (entity_type = 1) AND (store_id = 1)

    $91.00
    SKU#311305
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2616)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('3')) 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`='12')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('12')) 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`='36')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('36')) 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`='37')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('37')) 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`='79')

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

  6. FORD F-250/350/450/550 SUPERDUTY 2008 - 2010 PROJECTOR HEADLIGHTS WITH U-BAR AND BLACK HOUSING (DOES NOT FIT MODELS WITH SEALED BEAM HEADLIGHTS) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2616')) AND (entity_type = 1) AND (store_id = 1)

    $651.00
    SKU#111305
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 1738)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('3')) 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`='12')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('12')) 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`='79')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('79')) 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`='53')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('53')) 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`='63')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('63')) 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`='66')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('66')) 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`='264')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('264')) 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`='265')

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

  7. FORD F-250/350/450/550 SUPERDUTY 08-10 PROJECTOR HEADLIGHTS BLACK W/ RX HALO SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1738')) AND (entity_type = 1) AND (store_id = 1)

    $585.00
    SKU#111168
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 1737)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('3')) 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`='12')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('12')) 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`='50')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('50')) 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`='52')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('52')) 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`='79')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('79')) 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`='11')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('11')) 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`='45')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('45')) 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`='53')

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

  8. FORD F-250/350/450/550 SUPERDUTY 08-10 PROJECTOR HEADLIGHTS CHROME CLEAR (CCFL) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1737')) AND (entity_type = 1) AND (store_id = 1)

    $585.00
    SKU#111167
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2376)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('14')) 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`='79')

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

  9. FORD F-250/350/450/550 SUPERDUTY 08-16 L.E.D TAIL LIGHTS BLACK SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2376')) AND (entity_type = 1) AND (store_id = 1)

    $400.00
    SKU#311127
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2375)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('14')) 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`='79')

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

  10. FORD F-250/350/450/550 SUPERDUTY 08-16 L.E.D TAIL LIGHTS CHROME SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2375')) AND (entity_type = 1) AND (store_id = 1)

    $400.00
    SKU#311128
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2373)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('14')) 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`='79')

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

  11. FORD F-250/350/450/550 SUPERDUTY 08-16 L.E.D TAIL LIGHTS RED/CLEAR SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2373')) AND (entity_type = 1) AND (store_id = 1)

    $400.00
    SKU#311050
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2035)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('6')) 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`='32')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('32')) 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`='79')

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

  12. FORD SUPERDUTY 99-16 / RANGER 93-11 L.E.D 3RD BRAKE LIGHT SMOKE G2 SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2035')) AND (entity_type = 1) AND (store_id = 1)

    $85.00
    SKU#531077
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2034)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('6')) 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`='32')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('32')) 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`='79')

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

  13. FORD SUPERDUTY 99-16 / RANGER 93-11 L.E.D 3RD BRAKE LIGHT CHROME G2 SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2034')) AND (entity_type = 1) AND (store_id = 1)

    $85.00
    SKU#531076
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 810)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('6')) 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`='32')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('32')) 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`='79')

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

  14. FORD SUPERDUTY 99-16 / RANGER 93-11 LED 3RD BRAKE LIGHT SMOKE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('810')) AND (entity_type = 1) AND (store_id = 1)

    $138.00
    SKU#531050
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2317)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('6')) 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`='24')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('24')) 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`='79')

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

  15. FORD F-250/350/450/550 SUPERDUTY 08-16 L.E.D MIRROR LIGHT SMOKE LENS AMBER (2PC) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2317')) AND (entity_type = 1) AND (store_id = 1)

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

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('6')) 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`='21')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('21')) 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`='79')

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

  16. FORD SUPERDUTY 1999 - 2016 LED CAB LIGHTS WITH SMOKE LENS 5PC (LED REPLACEMENT BULBS INCLUDED) (DOES NOT INCLUDE ELECTRICAL HARNESS LIGHT OR BASE) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2305')) AND (entity_type = 1) AND (store_id = 1)

    $67.00
    SKU#861074
    Out of stock
    SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 2306)

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

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('6')) 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`='21')

    SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('21')) 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`='79')

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

  17. FORD SUPERDUTY 99-16 L.E.D CAB LIGHTS CLEAR 5PC (L.E.D REPLACEMENT BULBS) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2306')) AND (entity_type = 1) AND (store_id = 1)

    $67.00
    SKU#861075
View as Grid List

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