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

SaleCamel.com

Tahoe Mountain Sports DOTD Sale! Check out the great deals below.

Smith Vantage Helmet Women's

$219.95

$142.96

35%
off

Source: Tahoe Mountain Sports DOTD

(63 Reviews)

Company Name

Recent Searches

chaco yampa short ugg burger north face Etip Facet Glove bc ski wanaka verto Reef Ginger Flip Flop womens venture north face jacket cam camelbak carhartt overall

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=tahoemountainsports_com_dotd&search_start=0&search_limit=25&search_sort=1&do_get=get_merchant_deals
            [execution_time] => 0.17306709289551
            [from_api] => Array
                (
                    [0] => Array
                        (
                            [mysql_query] => SELECT merch_id FROM merchants WHERE merch_local_url = 'merchant_tahoemountainsports_com_dotd.html'
                            [execution_time] => 0.00033807754516602
                        )

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

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

                    [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.0015811920166016
                        )

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

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

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

                    [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.00011491775512695
                        )

                    [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_tahoemountainsports_com_dotd.html' AND  m.merch_id = i.merch_id AND i.item_key IN ('helmetsmithvantagewomen') ORDER BY FIELD(i.item_key, 'helmetsmithvantagewomen'), CASE  i.item_per_off WHEN 0 THEN 1 ELSE 0 END, i.item_sale_price
                            [execution_time] => 0.00036787986755371
                        )

                    [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_tahoemountainsports_com_dotd.html' AND  m.merch_id = i.merch_id AND i.item_key IN ('helmetsmithvantagewomen') ORDER BY FIELD(i.item_key, 'helmetsmithvantagewomen'), CASE  i.item_per_off WHEN 0 THEN 1 ELSE 0 END, i.item_sale_price
                            [execution_time] => 0.0003809928894043
                        )

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

                )

        )

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

                )

        )

)