SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `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 `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('605', '631', '637')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Shooter - Gaming - Software

Shooter

Showing 1-9 of 44 results

Page
per page
Set Descending Direction
  1. Full Spectrum Warrior
    Quick view
    Full Spectrum Warrior
    $9.99

    Quick View

    WishList

    Compare

  2. Dark Fall: The Journal
    Quick view
    Dark Fall: The Journal
    $4.99

    Quick View

    WishList

    Compare

  3. Aquanox 2: Revalation
    Quick view
    Aquanox 2: Revalation
    $4.99

    Quick View

    WishList

    Compare

  4. Alan Wake's American Nightmare
    Quick view
  5. Alan Wake
    Quick view
    Alan Wake
    $29.99

    Quick View

    WishList

    Compare

  6. Painkiller Complete Pack
    Quick view
    Painkiller Complete Pack
    $69.99

    Quick View

    WishList

    Compare

  7. 15 Days
    Quick view
    15 Days
    $9.99

    Quick View

    WishList

    Compare

  8. The Moment Of Silence
    Quick view
    The Moment Of Silence
    $14.99

    Quick View

    WishList

    Compare

  9. Black Mirror III: Final Fear
    Quick view
    Black Mirror III: Final Fear
    $9.99

    Quick View

    WishList

    Compare

Showing 1-9 of 44 results

Page
per page
Set Descending Direction