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 = 2615)
- H4 7" ROUND L.E.D HEADLIGHT BLACK WITH ANZO LOGO (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2615')) AND (entity_type = 1) AND (store_id = 1)
$495.00SKU#881036
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`='10')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='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`='18')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) 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`='94')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('94')) 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`='98')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('98')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- H4 7" ROUND LED HEADLIGHT CHROME WITH ANZO LOGO (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2589')) AND (entity_type = 1) AND (store_id = 1)
$495.00SKU#881035
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='7')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('7')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='59')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('59')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- H4 7" ROUND UNIVERSAL HEADLIGHT DIAMOND CUT (Single) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('892')) AND (entity_type = 1) AND (store_id = 1)
$35.00SKU#841002
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='70')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('70')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY/GMC C/K 10/15/20/30 PICKUP 73-87 / SUBURBAN/BLAZER/JIMMY 73-91 TAIL LIGHTS BLACK SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2074')) AND (entity_type = 1) AND (store_id = 1)
$100.00SKU#211016
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='70')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('70')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY/GMC C/K 10/15/20/30 PICKUP 73-87 / SUBURBAN/BLAZER/JIMMY 73-91 TAIL LIGHTS SMOKE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2084')) AND (entity_type = 1) AND (store_id = 1)
$100.00SKU#211153
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='70')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('70')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY/GMC C/K 10/15/20/30 PICKUP 73-87 / SUBURBAN/BLAZER/JIMMY 73-91 TAIL LIGHTS CHROME SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2083')) AND (entity_type = 1) AND (store_id = 1)
$95.00SKU#211014
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='70')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('70')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY/GMC C/K 10/15/20/30 PICKUP 73-87 / SUBURBAN/BLAZER/JIMMY 73-91 TAIL LIGHTS CARBON SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2073')) AND (entity_type = 1) AND (store_id = 1)
$115.00SKU#211015
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`='10')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='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`='18')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) 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`='94')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('94')) 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`='98')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('98')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))