SELECT `e`.*, IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) AS `custom_use_parent_settings` FROM `mg_catalog_category_entity` AS `e` LEFT JOIN `mg_catalog_category_entity_int` AS `at_custom_use_parent_settings_default` ON (`at_custom_use_parent_settings_default`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings_default`.`attribute_id` = '70') AND `at_custom_use_parent_settings_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_int` AS `at_custom_use_parent_settings` ON (`at_custom_use_parent_settings`.`entity_id` = `e`.`entity_id`) AND (`at_custom_use_parent_settings`.`attribute_id` = '70') AND (`at_custom_use_parent_settings`.`store_id` = 1) WHERE (`e`.`entity_id` IN('9', '114', '3', '2', '1')) AND (((IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) = 0) OR (IF(at_custom_use_parent_settings.value_id > 0, at_custom_use_parent_settings.value, at_custom_use_parent_settings_default.value) IS NULL))) AND (`e`.`level` != 0) ORDER BY `e`.`level` DESC, `e`.`position` ASC SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `mg_catalog_category_entity` AS `e` LEFT JOIN `mg_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 `mg_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('3', '114', '9')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ORDER BY `e`.`position` ASC Giftware - Other - Catalogue

Giftware

Items 56-66 of 107

Page
per page
Set Descending Direction
  1. evright.com | Personalised Acrylic Ice Bucket
    3 Piece Cheese Set
    Compare
  2. evright.com | Personalised Acrylic Ice Bucket
    Personalised Silver Plated Flat Top Bottle Stopper
    Compare
  3. evright.com | Personalised Acrylic Ice Bucket
    Polyester Insulated Cooler Bag
    Compare
  4. evright.com | Personalised Acrylic Ice Bucket
    Polyester Insulated Cooler Bag Blue
    Compare
  5. evright.com | Personalised Acrylic Ice Bucket
    Black Two Piece Wine Tool Set
    Compare
  6. evright.com | Personalised Acrylic Ice Bucket
    Black Wine Tool Set
    Compare
  7. Magentic Bottle Openers - Black + Gold
    Magentic Bottle Openers - Black + Gold
    Compare
  8. Magentic Bottle Openers - Rawhide + Black
    Magentic Bottle Openers - Rawhide + Black
    Compare
  9. evright.com | Branded Bottle Opener
    Magentic Bottle Openers - Black + Silver
    Compare
  10. 9 Function Multi-tool and Torch (boxed)
    9 Function Multi-tool and Torch (boxed)
    Compare
  11. Personalised Torch Multi-tool 8-in-1
    Personalised Torch Multi-tool 8-in-1
    Compare

  12. Pushing the boundaries, inspiring the best.

    Custom Laser Engraving + Marking

Items 56-66 of 107

Page
per page
Set Descending Direction
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `mg_url_rewrite`.`request_path` FROM `mg_catalog_category_entity` AS `e` INNER JOIN `mg_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 `mg_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) INNER JOIN `mg_catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '69') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '69') AND (`at_include_in_menu`.`store_id` = 1) LEFT JOIN `mg_url_rewrite` ON (mg_url_rewrite.entity_id =e.entity_id) AND (mg_url_rewrite.is_autogenerated = 1 AND mg_url_rewrite.store_id = 1 AND mg_url_rewrite.entity_type = 'category') WHERE (`e`.`entity_id` = '') AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') ORDER BY `e`.`position` ASC SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `mg_url_rewrite`.`request_path` FROM `mg_catalog_category_entity` AS `e` INNER JOIN `mg_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 `mg_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) LEFT JOIN `mg_url_rewrite` ON (mg_url_rewrite.entity_id =e.entity_id) AND (mg_url_rewrite.is_autogenerated = 1 AND mg_url_rewrite.store_id = 1 AND mg_url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('')) ORDER BY `e`.`position` ASC
Compare Products
  1. Remove This Item
Compare
Clear All
You have no items to compare.