SELECT `feature_new_idx`.`value`, COUNT(feature_new_idx.entity_id) AS `count` FROM `mgop_catalog_product_flat_1` AS `e` INNER JOIN `mgop_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 INNER JOIN `mgop_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `mgop_catalog_product_index_eav` AS `feature_new_idx` ON feature_new_idx.entity_id = e.entity_id AND feature_new_idx.attribute_id = '183' AND feature_new_idx.store_id = '1' GROUP BY `feature_new_idx`.`value`
-
SELECT `mgop_catalog_category_product`.`category_id`, `mgop_catalog_category_product`.`position` FROM `mgop_catalog_category_product` WHERE (product_id = 3047)
- TOYOTA TUNDRA 07-13 / SEQUOIA 08-17 HALOGEN PROJECTOR LIGHT BAR HEADLIGHTS BLACK AMBER (LED HIGH BEAM) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('3047')) AND (entity_type = 1) AND (store_id = 1)
$644.00SKU#111447
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`='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`='83')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('83')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- TOYOTA TUNDRA 07-13/ SEQUOIA 08-17 HEADLIGHTS BLACK AMBER (OE STYLE) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2968')) AND (entity_type = 1) AND (store_id = 1)
$495.00SKU#111436
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`='81')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('81')) 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`='83')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('83')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- TOYOTA TUNDRA 07-13 / SEQUOIA 08-17 PROJECTOR HEADLIGHTS IN BLACK HOUSING W/ U-BAR STYLE LIGHT W/ AMBER REFLECTOR SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2536')) AND (entity_type = 1) AND (store_id = 1)
$620.00SKU#111294
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`='81')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('81')) 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`='83')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('83')) 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`='73')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('73')) 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))
- TOYOTA TUNDRA 07-13 / SEQUOIA 08-17 PROJECTOR HEADLIGHTS BLACK W/ RX HALO AND LED BAR SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1740')) AND (entity_type = 1) AND (store_id = 1)
$598.00SKU#111174
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`='81')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('81')) 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`='83')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('83')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- TOYOTA TUNDRA 07-13 /SEQUOIA 08-17 PROJECTOR HEADLIGHTS HALO W/ LED BAR CHROME CLEAR AMBER (RX HALO) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1739')) AND (entity_type = 1) AND (store_id = 1)
$598.00SKU#111173
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`='81')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('81')) 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`='83')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('83')) 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`='73')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('73')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))