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

SaleCamel.com

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

Bogs Malibu Canvas Slip On Shoe Toddler Boys'

$39.99

$27.99

30%
off

Source: Backcountry.com DOTD

(8213 Reviews)

Company Name

Recent Searches

htc evo JanSport Air Cure Backpack mens dalbello ski womens gnu mens dalbello ski boot camper staple pigeon mens cycling vest mens fleece boots moto womens Sidi mountain bike shoe

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

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

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

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

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

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

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

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

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

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

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

                )

        )

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

                )

        )

)