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`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` 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) LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 1) WHERE (`e`.`entity_id` IN('13', '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, `name` ASC SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` 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) LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 1) WHERE (`e`.`entity_id` IN('3', '114', '13')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ORDER BY `name` ASC Promotional - Other - Catalogue

Promotional

Items 56-66 of 94

Page
per page
Set Descending Direction
  1. Personalised 3 Piece Stainless Steel BBQ Set
    Personalised 3 Piece Stainless Steel BBQ Set
    Compare
  2. Personalised 13 Function Trekk Multi-tool in Box
    Personalised 13 Function Trekk Multi-tool in Box
    Compare
  3. Personalised Aluminium Trekk Torch With Compass
    Personalised Aluminium Trekk Torch With Compass
    Compare
  4. Personalised Trekk De Luxe Multi-Tool
    Personalised Trekk De Luxe Multi-Tool
    Compare
  5. Personalised Trekk Combo Tool Set
    Personalised Trekk Combo Tool Set
    Compare
  6. Personalised 'The Grip' Drink Bottle - Blue
    Personalised 'The Grip' Drink Bottle - Blue
    Compare
  7. Personalised 'The Grip' Drink Bottle - Grey
    Personalised 'The Grip' Drink Bottle - Grey
    Compare
  8. evright.com | Personalised 'The Grip' Drink Bottle - Grey
    Personalised Polished Stainless Steel Mug
    Compare
  9. evright.com | Personalised 'The Grip' Drink Bottle - Grey
    Personalised Stainless Steel Barrel Mug
    Compare
  10. evright.com | Personalised Copper Insulated Drink Bottles
    Personalised Copper Vacuum Insulated Drink Bottle
    Compare
  11. evright.com | Personalised 'The Grip' Drink Bottle - Grey
    Personalised Duke Copper Vacuum Insulated Tumbler
    Compare

  12. Pushing the boundaries, inspiring the best.

    Custom Laser Engraving + Marking

Items 56-66 of 94

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`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` 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') LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 1) 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 `name` 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`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` 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') LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '45') AND `at_name_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '45') AND (`at_name`.`store_id` = 1) 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, `name` ASC
Compare Products
  1. Remove This Item
Compare
Clear All
You have no items to compare.