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 = 2032)
- NISSAN ARMADA 04-07 / TITAN 04-15 CRYSTAL HEADLIGHTS WITH BLACK HOUSING SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2032')) AND (entity_type = 1) AND (store_id = 1)
$334.00SKU#111069
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`='173')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('173')) 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`='175')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('175')) 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`='172')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('172')) 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))
- NISSAN ARMADA 04-07 / TITAN 04-15 PROJECTOR HEADLIGHTS BLACK W/ RX HALO SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2030')) AND (entity_type = 1) AND (store_id = 1)
$397.00SKU#111095
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`='173')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('173')) 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`='175')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('175')) 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`='172')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('172')) 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`='266')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('266')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- NISSAN ARMADA 04-07 / TITAN 04-15 PROJECTOR HEADLIGHTS CHROME W/ RX HALO SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2031')) AND (entity_type = 1) AND (store_id = 1)
$397.00SKU#111094
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`='173')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('173')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- NISSAN TITAN 04-15 L.E.D TAIL LIGHTS BLACK SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1485')) AND (entity_type = 1) AND (store_id = 1)
$314.00SKU#311039
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='10')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('10')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='19')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('19')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 6" HID OFF ROAD LIGHTS CHROME w/ LENS PROTECTOR (PAIR) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('901')) AND (entity_type = 1) AND (store_id = 1)
$164.00SKU#861095
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`='30')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('30')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- Universal Bar Mount Clamps - 1.5" (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('878')) AND (entity_type = 1) AND (store_id = 1)
$21.50SKU#851011
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`='30')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('30')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- Universal Bar Mount Clamps - 2.5" (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('881')) AND (entity_type = 1) AND (store_id = 1)
$30.50SKU#851018
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`='30')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('30')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- Universal Bar Mount Clamps - 3" (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('882')) AND (entity_type = 1) AND (store_id = 1)
$33.00SKU#851019
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`='20')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('20')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- H3 8" ROUND SLIMLINE OFF ROAD LIGHT CHROME (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('889')) AND (entity_type = 1) AND (store_id = 1)
$155.00SKU#821004
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`='34')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('34')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 7 Pin Universal Trailer Adapter SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('52')) AND (entity_type = 1) AND (store_id = 1)
$38.00SKU#851010
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))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='173')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('173')) 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`='175')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('175')) 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`='172')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('172')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))