• Google Plus
  • twitter
  • Pinterest
  • facebook
  • rss
  • Home
  • Local Deals
  • Blog

SaleCamel.com

DepartmentOfGoods.com DOTD Sale! Check out the great deals below.

Vestal Republics Sunglasses

$79.95

$39.98

50%
off

Source: DepartmentOfGoods.com DOTD

(1 Reviews)

Company Name

Recent Searches

tandem boys alpenglow womens tom patagonia long sleeve cotton shirt north face clement triclimate jacket 1080p tv anon hawkeye goggle mens north face Apex Washoe Short mens carhartt bib sennheiser fix

See more...

© 2012 Joe Ross LTD. All Rights Reserved.

Home | About | Add Your Site | Advertise | Contact | Merchants | Coupons | Notifications | Disclaimer

Array
(
    [0] => Array
        (
            [0] => template
            [1] => mar2013
        )

    [1] => Array
        (
            [api_query] => http://api.salecamel.com?api_key=123456789&show_merchant_name=departmentofgoods_com_dotd&search_start=0&search_limit=25&search_sort=1&do_get=get_merchant_deals
            [execution_time] => 0.24515295028687
            [from_api] => Array
                (
                    [0] => Array
                        (
                            [mysql_query] => SELECT merch_id FROM merchants WHERE merch_local_url = 'merchant_departmentofgoods_com_dotd.html'
                            [execution_time] => 0.14638900756836
                        )

                    [1] => Array
                        (
                            [mysql_query] => UPDATE merchants SET clicks_current_day = clicks_current_day + 1 WHERE merch_id = '180'
                            [execution_time] => 0.090719938278198
                        )

                    [2] => Array
                        (
                            [mysql_query] => SELECT merch_id FROM merchants WHERE merch_local_url = 'merchant_departmentofgoods_com_dotd.html'
                            [execution_time] => 0.0010001659393311
                        )

                    [3] => Array
                        (
                            [mysql_query] => CREATE TEMPORARY TABLE `these_items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_title` varchar(400) NOT NULL,
  `item_manufacturer` varchar(100) NOT NULL DEFAULT '0',
  `merch_id` int(11) NOT NULL,
  `item_key` varchar(255) NOT NULL,
  `item_url` varchar(400) NOT NULL,
  `item_image` varchar(400) NOT NULL,
  `item_reg_price` decimal(8,2) NOT NULL,
  `item_sale_price` decimal(8,2) NOT NULL,
  `item_per_off` smallint(3) NOT NULL,
  `item_added` int(10) NOT NULL,
  `item_per_off_rev` int(11) NOT NULL DEFAULT '0',
  `item_added_rev` int(11) NOT NULL DEFAULT '0',
  `item_ending` int(10) NOT NULL DEFAULT '0',
  `item_cat_1_id` smallint(2) NOT NULL DEFAULT '0',
  `item_cat_2_id` smallint(2) NOT NULL DEFAULT '0',
  `item_price_grp` tinyint(1) NOT NULL,
  `item_per_grp` tinyint(1) NOT NULL,
  `item_views` smallint(5) NOT NULL DEFAULT '0',
  `item_hot_score` decimal(5,2) NOT NULL DEFAULT '0.00',
  `key_matches_count` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  UNIQUE KEY `item_unique` (`item_key`)
 ) ENGINE=Memory
                            [execution_time] => 0.0011508464813232
                        )

                    [4] => Array
                        (
                            [mysql_query] => INSERT `these_items` 
	SELECT *, 0 AS 'key_matches_count' 
		FROM items_dotd WHERE merch_id IN ( 180 ) 
			ORDER BY item_per_off_rev
				ON DUPLICATE KEY UPDATE key_matches_count = key_matches_count + 1
                            [execution_time] => 0.00054311752319336
                        )

                    [5] => Array
                        (
                            [mysql_query] => INSERT `these_items` 
	SELECT *, 0 AS 'key_matches_count' 
		FROM items_reg WHERE merch_id IN ( 180 ) 
			ORDER BY item_per_off_rev
				ON DUPLICATE KEY UPDATE key_matches_count = key_matches_count + 1
                            [execution_time] => 0.00048112869262695
                        )

                    [6] => Array
                        (
                            [mysql_query] => SELECT COUNT(*) AS total FROM these_items WHERE item_id > 0
                            [execution_time] => 0.00033211708068848
                        )

                    [7] => Array
                        (
                            [mysql_query] => SELECT item_key FROM these_items ORDER BY key_matches_count DESC, item_title DESC, LENGTH(item_title), item_added_rev LIMIT 0, 25
                            [execution_time] => 0.00020503997802734
                        )

                    [8] => Array
                        (
                            [mysql_query] => SELECT i.*, m.merch_name, m.merch_url, m.merch_can_ok, m.merch_google_rating, m.merch_google_reviews, m.merch_google_key, m.merch_local_url, m.merch_coupons_count FROM items_dotd i, merchants m WHERE m.merch_local_url = 'merchant_departmentofgoods_com_dotd.html' AND  m.merch_id = i.merch_id AND i.item_key IN ('republicssunglassesvestal') ORDER BY FIELD(i.item_key, 'republicssunglassesvestal'), CASE  i.item_per_off WHEN 0 THEN 1 ELSE 0 END, i.item_sale_price
                            [execution_time] => 0.0008399486541748
                        )

                    [9] => Array
                        (
                            [mysql_query] => SELECT i.*, m.merch_name, m.merch_url, m.merch_can_ok, m.merch_google_rating, m.merch_google_reviews, m.merch_google_key, m.merch_local_url, m.merch_coupons_count FROM items_reg i, merchants m WHERE m.merch_local_url = 'merchant_departmentofgoods_com_dotd.html' AND  m.merch_id = i.merch_id AND i.item_key IN ('republicssunglassesvestal') ORDER BY FIELD(i.item_key, 'republicssunglassesvestal'), CASE  i.item_per_off WHEN 0 THEN 1 ELSE 0 END, i.item_sale_price
                            [execution_time] => 0.00057005882263184
                        )

                    [10] => Array
                        (
                            [mysql_query] => DROP TABLE `these_items`
                            [execution_time] => 0.00022006034851074
                        )

                )

        )

    [2] => Array
        (
            [api_query] => http://api.salecamel.com?api_key=123456789&show_merchant_name=departmentofgoods_com_dotd&do_get=get_merchant_info
            [execution_time] => 0.0028870105743408
            [from_api] => Array
                (
                    [0] => Array
                        (
                            [mysql_query] => SELECT * FROM merchants WHERE merch_local_url = 'merchant_departmentofgoods_com_dotd.html' LIMIT 1
                            [execution_time] => 0.00097393989562988
                        )

                )

        )

)