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 = 1649)
- FORD F-150/BRONCO 92-98 / F-250/350 92-98 PROJECTOR HALO HEADLIGHTS WITH BLACK HOUSING SIDE MARKER & PARKING LIGHTS SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1649')) AND (entity_type = 1) AND (store_id = 1)
$414.00SKU#111184
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))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='76')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('76')) 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`='226')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('226')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- FORD F-150/BRONCO 92-98 / F-250/350 92-98 PROJECTOR HEADLIGHTS CHROME HOUSING WITH HALO & SIDE MARKER & PARKING LIGHTS SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1648')) AND (entity_type = 1) AND (store_id = 1)
$414.00SKU#111183
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))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='76')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('76')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- FORD F-150/BRONCO 92-96 / F-250/350 92-98 CRYSTAL HEADLIGHTS CHROME SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1786')) AND (entity_type = 1) AND (store_id = 1)
$149.00SKU#111247
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))
SELECT `mgop_catalog_category_flat_store_1`.* FROM `mgop_catalog_category_flat_store_1` WHERE (`mgop_catalog_category_flat_store_1`.`entity_id`='76')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('76')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- FORD F-150/BRONCO 1992-1998 / F-250/350 1992-1998 SIDE MARKER CHROME EURO CLEAR SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('55')) AND (entity_type = 1) AND (store_id = 1)
$27.00SKU#511049
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`='76')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('76')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- FORD F-150 89-96 / F-250/350/450 89-98 / BRONCO 89-96 G2 TAIL LIGHTS SMOKE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1899')) AND (entity_type = 1) AND (store_id = 1)
$95.00SKU#211173
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`='76')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('76')) 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`='226')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('226')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- FORD F-150 89-96 / F-250/350/450 89-98 / BRONCO 89-96 TAIL LIGHTS BLACK SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1834')) AND (entity_type = 1) AND (store_id = 1)
$95.00SKU#211062
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`='76')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('76')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- FORD F-150 89-96 / F-250/350/450 89-98 / BRONCO 89-96 TAIL LIGHTS CHROME SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('1833')) AND (entity_type = 1) AND (store_id = 1)
$95.00SKU#211061
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`='25')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 60" 6 FUNCTION L.E.D TAILGATE BAR SMD STYLE w/ AMBER SCANNING SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2232')) AND (entity_type = 1) AND (store_id = 1)
$97.00SKU#531058
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`='25')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 60" 5 FUNCTION L.E.D TAILGATE BAR SMD STYLE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2228')) AND (entity_type = 1) AND (store_id = 1)
$95.00SKU#531006
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`='25')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('25')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 49" 5 FUNCTION L.E.D TAILGATE BAR SMD STYLE SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2227')) AND (entity_type = 1) AND (store_id = 1)
$81.00SKU#531005
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`='18')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 3"x3" RUGGED HI-INTENSITY 3W L.E.D OFF ROAD LIGHT SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2239')) AND (entity_type = 1) AND (store_id = 1)
$99.00SKU#881031
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`='18')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 6" RUGGED HI-INTENSITY 3W LED OFF ROAD LIGHT (Spot) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2362')) AND (entity_type = 1) AND (store_id = 1)
$252.00SKU#881025
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`='18')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- 12" RUGGED HI-INTENSITY 3W LED OFF ROAD LIGHT (Spot) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2363')) AND (entity_type = 1) AND (store_id = 1)
$362.00SKU#881026
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`='18')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('18')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- Rugged Vision 4.5" Round High Power L.E.D Fog Light (Pair) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2178')) AND (entity_type = 1) AND (store_id = 1)
$269.00SKU#881002
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`='26')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('26')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- BED RAIL AUXILIARY L.E.D. LIGHTING PODS SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2235')) AND (entity_type = 1) AND (store_id = 1)
$82.00SKU#531049
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`='26')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('26')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- L.E.D Utility Light Bar Chrome w/ Rechargeable Flash Lights SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2436')) AND (entity_type = 1) AND (store_id = 1)
$110.00SKU#861134
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`='23')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('23')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- LED HITCH LIGHT SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2257')) AND (entity_type = 1) AND (store_id = 1)
$60.00SKU#861061
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`='23')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('23')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))
- L.E.D MAGNET LIGHT (PAIR) SELECT `main_table`.* FROM `mgop_review_entity_summary` AS `main_table` WHERE (entity_pk_value IN('2258')) AND (entity_type = 1) AND (store_id = 1)
$54.95SKU#861062
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`='76')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('76')) 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`='226')
SELECT `mgop_url_rewrite`.* FROM `mgop_url_rewrite` WHERE (`entity_id` IN ('226')) AND (`entity_type` IN ('category')) AND (`store_id` IN (1))