SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `mgab_catalog_category_entity` AS `e` INNER JOIN `mgab_catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `mgab_catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 1) WHERE (`e`.`entity_id` IN('20', '22')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Bottoms - Women

Bottoms

View as Grid List

8 Items

per page
Set Descending Direction
  1. Erika Running Short
    Erika Running Short
    Rating:
    60%
    $45.00
  2. Mimi All-Purpose Short
    Mimi All-Purpose Short
    Rating:
    67%
    $44.00
  3. Artemis Running Short
    Artemis Running Short
    Rating:
    80%
    $45.00
  4. Fiona Fitness Short
    Fiona Fitness Short
    Rating:
    60%
    $29.00
  5. Portia Capri
    Portia Capri
    $49.00
  6. Deirdre Relaxed-Fit Capri
    Deirdre Relaxed-Fit Capri
    $63.00
  7. Sylvia Capri
    Sylvia Capri
    $42.00
  8. Bardot Capri
    Bardot Capri
    $48.00
View as Grid List

8 Items

per page
Set Descending Direction
Copyright © 2013-2017 Magento, Inc. All rights reserved.