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 = 430)
- CHEVY S-10 / S-10 BLAZER 98-05 PROJECTOR HEADLIGHTS BLACK W/ HALO SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('430')) AND (entity_type = 1) AND (store_id = 1)
$292.00SKU#111015
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`='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`='55')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('55')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 / S-10 BLAZER 1998 - 2005 PROJECTOR HEADLIGHTS WITH CHROME HOUSING AND HALO RING SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('431')) AND (entity_type = 1) AND (store_id = 1)
$292.00SKU#111016
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`='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))
- CHEVY S-10 / S-10 BLAZER 98-05 CRYSTAL HEADLIGHTS BLACK SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('225')) AND (entity_type = 1) AND (store_id = 1)
$175.00SKU#111156
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`='46')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('46')) 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))
- CHEVY S-10 / S-10 BLAZER 98-05 CRYSTAL HEADLIGHTS CHROME SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('226')) AND (entity_type = 1) AND (store_id = 1)
$175.00SKU#111014
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='5')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('5')) 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`='16')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('16')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 / S-10 BLAZER 98-05 PARKING/SIGNAL LIGHTS CHROME EURO AMBER SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('131')) AND (entity_type = 1) AND (store_id = 1)
$38.00SKU#511038
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 BLAZER 95-05 / GMC S-15 JIMMY 95-05 / ENVOY 98-00 / BRAVADA 96-01 TAIL LIGHTS BLACK SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('956')) AND (entity_type = 1) AND (store_id = 1)
$110.00SKU#211005
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 BLAZER 95-05 / GMC S-15 JIMMY 95-05 / ENVOY 98-00 / BRAVADA 96-01 TAIL LIGHTS DARK SMOKE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('955')) AND (entity_type = 1) AND (store_id = 1)
$110.00SKU#221173
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 BLAZER 95-05 / GMC S-15 JIMMY 95-05 / ENVOY 98-00 / BRAVADA 96-01 TAIL LIGHTS SMOKE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('957')) AND (entity_type = 1) AND (store_id = 1)
$110.00SKU#221174
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='4')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('4')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='13')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('13')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='72')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('72')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 BLAZER 95-05 / GMC S-15 JIMMY 95-05 / ENVOY 98-00 / BRAVADA 96-01 TAIL LIGHTS CHROME SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('954')) AND (entity_type = 1) AND (store_id = 1)
$110.00SKU#211004
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`='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`='71')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('71')) 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`='85')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('85')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 BLAZER/S-15 JIMMY 95-05 / TAHOE 95-99 / SUBURBAN 92-99 / YUKON 92-99 / HUMMER H2 03-05 / ESCALADE 99-00 w/ CARGO DOORS L.E.D 3RD BRAKE LIGHT SMOKE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('780')) AND (entity_type = 1) AND (store_id = 1)
$137.00SKU#531057
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`='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`='71')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('71')) 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`='85')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('85')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- CHEVY S-10 BLAZER/S-15 JIMMY 95-05 / TAHOE 95-99 / SUBURBAN 92-99 / YUKON 92-99 / HUMMER H2 03-05 / ESCALADE 99-00 w/ CARGO DOORS L.E.D 3RD BRAKE LIGHT RED SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2216')) AND (entity_type = 1) AND (store_id = 1)
$137.00SKU#531047
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`='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`='54')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('54')) 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`='64')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('64')) 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`='170')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('170')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))