Search:

array ( 'USER' => 'clp', 'HOME' => '/home/cloudpanel', 'HTTP_CF_CONNECTING_IP' => '54.158.212.93', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (http://commoncrawl.org/faq/)', 'HTTP_CF_VISITOR' => '{"scheme":"https"}', 'HTTP_X_FORWARDED_PROTO' => 'https', 'HTTP_CF_RAY' => '3b28d7f518a256bd-FRA', 'HTTP_X_FORWARDED_FOR' => '54.158.212.93', 'HTTP_CF_IPCOUNTRY' => 'US', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'www.sugartrends.com', 'PHP_VALUE' => ' error_log=/home/cloudpanel/logs/sugartrends.com/php/error.log; memory_limit=1024M; max_execution_time=180;', 'GEOIP_LONGITUDE' => '-74.2915', 'GEOIP_LATITUDE' => '40.5525', 'GEOIP_CITY_CONTINENT_CODE' => 'NA', 'GEOIP_POSTAL_CODE' => '07095', 'GEOIP_CITY' => 'Woodbridge', 'GEOIP_REGION' => 'NJ', 'GEOIP_CITY_COUNTRY_NAME' => 'United States', 'GEOIP_CITY_COUNTRY_CODE3' => 'USA', 'GEOIP_CITY_COUNTRY_CODE' => 'US', 'GEOIP_COUNTRY_NAME' => 'United States', 'GEOIP_COUNTRY_CODE3' => 'USA', 'GEOIP_COUNTRY_CODE' => 'US', 'REDIRECT_STATUS' => '200', 'HTTPS' => 'on', 'SERVER_NAME' => '~^(?:www\\.)?(?P.+?)\\.(?Psugartrends\\.com)$', 'SERVER_PORT' => '80', 'SERVER_ADDR' => '172.31.14.42', 'REMOTE_PORT' => '', 'REMOTE_ADDR' => '54.158.212.93', 'SERVER_SOFTWARE' => 'nginx/1.11.1', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/home/cloudpanel/htdocs/www.sugartrends.com', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/en/gifts/all-gifts/gifts-by-occasion/thank-you-gifts', 'SCRIPT_NAME' => '/index.php', 'SCRIPT_FILENAME' => '/home/cloudpanel/htdocs/www.sugartrends.com/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1508805195.1109769, 'REQUEST_TIME' => 1508805195, 'MAGE_RUN_TYPE' => 'website', 'MAGE_RUN_CODE' => 'base', 'FPC_TIME' => 1508805195.144275, 'FPC_SELF_TIME' => 1508805195.1481149, 'FPC_SWITCH_FOR_CRAWLER_TIME' => 1508805195.1481161, 'FPC_SWITCH_FOR_CRAWLER_TIME_RESULT' => 6.198883056640625E-5, 'FPC_CHECK_PROCESS_REQUEST_TIME' => 1508805195.3708401, 'FPC_CHECK_PROCESS_REQUEST_TIME_RESULT' => 0.00049495697021484375, 'FPC_REGISTER_MODEL_TAG_TIME_1' => 1508805195.150629, 'FPC_REGISTER_MODEL_TAG_TIME_1_RESULT' => 0.00028896331787109375, 'FPC_REGISTER_MODEL_TAG_TIME_Mirasvit_Fpc_Model_Index_Process' => 1508805195.3317561, 'FPC_REGISTER_MODEL_TAG_TIME_Mirasvit_Fpc_Model_Index_Process_RESULT' => 8.8214874267578125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_2' => 1508805195.153044, 'FPC_REGISTER_MODEL_TAG_TIME_2_RESULT' => 3.2901763916015625E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Category' => 1508805195.153091, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Category_RESULT' => 4.1961669921875E-5, 'FPC_REGISTER_MODEL_TAG_TIME_3' => 1508805195.154573, 'FPC_REGISTER_MODEL_TAG_TIME_3_RESULT' => 3.3140182495117188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Eav_Model_Entity_Type' => 1508805195.1908531, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Eav_Model_Entity_Type_RESULT' => 6.9141387939453125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_4' => 1508805195.190834, 'FPC_REGISTER_MODEL_TAG_TIME_4_RESULT' => 1.4066696166992188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_5' => 1508805195.192173, 'FPC_REGISTER_MODEL_TAG_TIME_5_RESULT' => 1.4066696166992188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Resource_Eav_Attribute' => 1508805195.357945, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Resource_Eav_Attribute_RESULT' => 2.1457672119140625E-6, 'FPC_REGISTER_MODEL_TAG_TIME_6' => 1508805195.1937499, 'FPC_REGISTER_MODEL_TAG_TIME_6_RESULT' => 1.3113021850585938E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Core_Model_Url_Rewrite' => 1508805195.3486049, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Core_Model_Url_Rewrite_RESULT' => 5.0067901611328125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_7' => 1508805195.3317339, 'FPC_REGISTER_MODEL_TAG_TIME_7_RESULT' => 1.5974044799804688E-5, 'FPC_REGISTER_MODEL_TAG_TIME_8' => 1508805195.332993, 'FPC_REGISTER_MODEL_TAG_TIME_8_RESULT' => 1.5020370483398438E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Product_Flat_Flag' => 1508805195.333014, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Product_Flat_Flag_RESULT' => 8.106231689453125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_9' => 1508805195.3480339, 'FPC_REGISTER_MODEL_TAG_TIME_9_RESULT' => 3.3140182495117188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_10' => 1508805195.3485861, 'FPC_REGISTER_MODEL_TAG_TIME_10_RESULT' => 1.3828277587890625E-5, 'FPC_REGISTER_MODEL_TAG_TIME_11' => 1508805195.3565969, 'FPC_REGISTER_MODEL_TAG_TIME_11_RESULT' => 1.5020370483398438E-5, 'FPC_REGISTER_MODEL_TAG_TIME_12' => 1508805195.3579259, 'FPC_REGISTER_MODEL_TAG_TIME_12_RESULT' => 1.4066696166992188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_13' => 1508805195.3648241, 'FPC_REGISTER_MODEL_TAG_TIME_13_RESULT' => 1.5020370483398438E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Customer_Model_Group' => 1508805195.3648441, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Customer_Model_Group_RESULT' => 2.86102294921875E-6, 'FPC_REGISTER_MODEL_TAG_TIME_14' => 1508805195.3701551, 'FPC_REGISTER_MODEL_TAG_TIME_14_RESULT' => 1.3828277587890625E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Cms_Model_Block' => 1508805195.3701739, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Cms_Model_Block_RESULT' => 2.1457672119140625E-6, )array ( 'USER' => 'clp', 'HOME' => '/home/cloudpanel', 'HTTP_CF_CONNECTING_IP' => '54.158.212.93', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (http://commoncrawl.org/faq/)', 'HTTP_CF_VISITOR' => '{"scheme":"https"}', 'HTTP_X_FORWARDED_PROTO' => 'https', 'HTTP_CF_RAY' => '3b28d7f518a256bd-FRA', 'HTTP_X_FORWARDED_FOR' => '54.158.212.93', 'HTTP_CF_IPCOUNTRY' => 'US', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'www.sugartrends.com', 'PHP_VALUE' => ' error_log=/home/cloudpanel/logs/sugartrends.com/php/error.log; memory_limit=1024M; max_execution_time=180;', 'GEOIP_LONGITUDE' => '-74.2915', 'GEOIP_LATITUDE' => '40.5525', 'GEOIP_CITY_CONTINENT_CODE' => 'NA', 'GEOIP_POSTAL_CODE' => '07095', 'GEOIP_CITY' => 'Woodbridge', 'GEOIP_REGION' => 'NJ', 'GEOIP_CITY_COUNTRY_NAME' => 'United States', 'GEOIP_CITY_COUNTRY_CODE3' => 'USA', 'GEOIP_CITY_COUNTRY_CODE' => 'US', 'GEOIP_COUNTRY_NAME' => 'United States', 'GEOIP_COUNTRY_CODE3' => 'USA', 'GEOIP_COUNTRY_CODE' => 'US', 'REDIRECT_STATUS' => '200', 'HTTPS' => 'on', 'SERVER_NAME' => '~^(?:www\\.)?(?P.+?)\\.(?Psugartrends\\.com)$', 'SERVER_PORT' => '80', 'SERVER_ADDR' => '172.31.14.42', 'REMOTE_PORT' => '', 'REMOTE_ADDR' => '54.158.212.93', 'SERVER_SOFTWARE' => 'nginx/1.11.1', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/home/cloudpanel/htdocs/www.sugartrends.com', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/en/gifts/all-gifts/gifts-by-occasion/thank-you-gifts', 'SCRIPT_NAME' => '/index.php', 'SCRIPT_FILENAME' => '/home/cloudpanel/htdocs/www.sugartrends.com/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1508805195.1109769, 'REQUEST_TIME' => 1508805195, 'MAGE_RUN_TYPE' => 'website', 'MAGE_RUN_CODE' => 'base', 'FPC_TIME' => 1508805195.144275, 'FPC_SELF_TIME' => 1508805195.1481149, 'FPC_SWITCH_FOR_CRAWLER_TIME' => 1508805195.1481161, 'FPC_SWITCH_FOR_CRAWLER_TIME_RESULT' => 6.198883056640625E-5, 'FPC_CHECK_PROCESS_REQUEST_TIME' => 1508805195.3708401, 'FPC_CHECK_PROCESS_REQUEST_TIME_RESULT' => 0.00049495697021484375, 'FPC_REGISTER_MODEL_TAG_TIME_1' => 1508805195.150629, 'FPC_REGISTER_MODEL_TAG_TIME_1_RESULT' => 0.00028896331787109375, 'FPC_REGISTER_MODEL_TAG_TIME_Mirasvit_Fpc_Model_Index_Process' => 1508805195.3317561, 'FPC_REGISTER_MODEL_TAG_TIME_Mirasvit_Fpc_Model_Index_Process_RESULT' => 8.8214874267578125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_2' => 1508805195.153044, 'FPC_REGISTER_MODEL_TAG_TIME_2_RESULT' => 3.2901763916015625E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Category' => 1508805195.153091, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Category_RESULT' => 4.1961669921875E-5, 'FPC_REGISTER_MODEL_TAG_TIME_3' => 1508805195.154573, 'FPC_REGISTER_MODEL_TAG_TIME_3_RESULT' => 3.3140182495117188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Eav_Model_Entity_Type' => 1508805195.1908531, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Eav_Model_Entity_Type_RESULT' => 6.9141387939453125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_4' => 1508805195.190834, 'FPC_REGISTER_MODEL_TAG_TIME_4_RESULT' => 1.4066696166992188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_5' => 1508805195.192173, 'FPC_REGISTER_MODEL_TAG_TIME_5_RESULT' => 1.4066696166992188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Resource_Eav_Attribute' => 1508805195.357945, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Resource_Eav_Attribute_RESULT' => 2.1457672119140625E-6, 'FPC_REGISTER_MODEL_TAG_TIME_6' => 1508805195.1937499, 'FPC_REGISTER_MODEL_TAG_TIME_6_RESULT' => 1.3113021850585938E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Core_Model_Url_Rewrite' => 1508805195.3486049, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Core_Model_Url_Rewrite_RESULT' => 5.0067901611328125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_7' => 1508805195.3317339, 'FPC_REGISTER_MODEL_TAG_TIME_7_RESULT' => 1.5974044799804688E-5, 'FPC_REGISTER_MODEL_TAG_TIME_8' => 1508805195.332993, 'FPC_REGISTER_MODEL_TAG_TIME_8_RESULT' => 1.5020370483398438E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Product_Flat_Flag' => 1508805195.333014, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Catalog_Model_Product_Flat_Flag_RESULT' => 8.106231689453125E-6, 'FPC_REGISTER_MODEL_TAG_TIME_9' => 1508805195.3480339, 'FPC_REGISTER_MODEL_TAG_TIME_9_RESULT' => 3.3140182495117188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_10' => 1508805195.3485861, 'FPC_REGISTER_MODEL_TAG_TIME_10_RESULT' => 1.3828277587890625E-5, 'FPC_REGISTER_MODEL_TAG_TIME_11' => 1508805195.3565969, 'FPC_REGISTER_MODEL_TAG_TIME_11_RESULT' => 1.5020370483398438E-5, 'FPC_REGISTER_MODEL_TAG_TIME_12' => 1508805195.3579259, 'FPC_REGISTER_MODEL_TAG_TIME_12_RESULT' => 1.4066696166992188E-5, 'FPC_REGISTER_MODEL_TAG_TIME_13' => 1508805195.3648241, 'FPC_REGISTER_MODEL_TAG_TIME_13_RESULT' => 1.5020370483398438E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Customer_Model_Group' => 1508805195.3648441, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Customer_Model_Group_RESULT' => 2.86102294921875E-6, 'FPC_REGISTER_MODEL_TAG_TIME_14' => 1508805195.3701551, 'FPC_REGISTER_MODEL_TAG_TIME_14_RESULT' => 1.3828277587890625E-5, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Cms_Model_Block' => 1508805195.3701739, 'FPC_REGISTER_MODEL_TAG_TIME_Mage_Cms_Model_Block_RESULT' => 2.1457672119140625E-6, )

DE EN
Account
Favourites
€ EUR
Cart (0)

You have no items in your shopping cart.

You must log in to view your favorites.

Home /
Gifts /
All Gifts /
Gifts by Occasion /
Thank You Gifts

Thank You Gifts

There are many occasions in our lives when we want to show our appreciation to somebody who is special for us or who helped us during difficult times. If you have no idea what would be the best gift for these special people, SugarTrends can help you with it. We created a selection of perfect thank you gifts to inspire and help you find the perfect gift.

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`weight`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`giftwrap`, `e`.`custom_sort_order`, `e`.`free_shipping`, `e`.`sales_sort_order`, `e`.`selected_categories`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`manufacturer`, `e`.`manufacturer_value`, `percentagerules`.`rule_price`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`manufacturer`, `e`.`manufacturer_value` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_category_product_index` 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 = '227' INNER JOIN `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 LEFT JOIN `percentagepricing_product_price` AS `percentagerules` ON percentagerules.product_id = e.entity_id AND percentagerules.status = 1 AND percentagerules.website_id IN (0,1) AND percentagerules.customer_group_id = 0 AND percentagerules.rule_price IS NOT NULL AND percentagerules.rule_date = CURDATE() WHERE (e.status = 1) AND (e.entity_id NOT IN('52075', '52076', '52077', '52078', '57952', '70534', '70535', '71222', '71223', '71226', '71227', '71228', '71229')) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 24