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

SaleCamel.com

Find the best prices on isla uggs. Browse below and try the filters on the left to narrow your results.

Related Deals

Try these similar searches

  1. Outdoor Research Isla Hat on Sale
  2. Isla Ugg on Sale
  3. Ugg Isla on Sale

Women's Ugg 'Isla' Boot

$149.95

$149.95

Best Price

Source: Nordstrom

(17 Reviews)

Save item for later

Company Name

Recent Searches

isla ugg uggs short big agnes gear loft smartwool outdoor marker bindings jester chrome jacket climbing boot academy snowboard womens spyder sweater Marmot Tempo Vest danner quarry boot

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&&search_start=0&search_limit=25&search_sort=1&do_get=get_online_deals&search_terms=isla+ugg
            [execution_time] => 0.031241178512573
            [from_api] => Array
                (
                    [0] => Array
                        (
                            [mysql_query] => SELECT keyword_overide FROM past_searches_regular WHERE search_terms = 'isla ugg' LIMIT 1
                            [execution_time] => 0.0005030632019043
                        )

                    [1] => 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.0011870861053467
                        )

                    [2] => Array
                        (
                            [mysql_query] => INSERT `these_items` 
	SELECT *, 0 AS 'key_matches_count' 
		FROM items_reg WHERE MATCH (item_title) AGAINST ('+isla* +ugg*' IN BOOLEAN MODE) 
			ORDER BY item_per_off_rev
				ON DUPLICATE KEY UPDATE key_matches_count = key_matches_count + 1
                            [execution_time] => 0.014998197555542
                        )

                    [3] => Array
                        (
                            [mysql_query] => SELECT MAX( item_per_off ) AS item_per_off FROM these_items
                            [execution_time] => 0.00011491775512695
                        )

                    [4] => Array
                        (
                            [mysql_query] => SELECT m.merch_name FROM these_items i, merchants m WHERE i.merch_id = m.merch_id GROUP BY i.merch_id ORDER BY i.item_per_off_rev LIMIT 3
                            [execution_time] => 0.00015997886657715
                        )

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

                    [6] => 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.00011110305786133
                        )

                    [7] => 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 MATCH (i.item_title) AGAINST ('+isla* +ugg*' IN BOOLEAN MODE) AND m.merch_id = i.merch_id AND i.item_key IN ('bootislauggwomen') ORDER BY FIELD(i.item_key, 'bootislauggwomen'), CASE  i.item_per_off WHEN 0 THEN 1 ELSE 0 END, i.item_sale_price
                            [execution_time] => 0.010202169418335
                        )

                    [8] => Array
                        (
                            [0] => terms for insert
                            [1] => isla ugg
                        )

                    [9] => Array
                        (
                            [mysql_query] => INSERT INTO past_searches_regular ( `search_add_date`, `search_terms`, `ad1`, `ad2` ) VALUES ( '1550751254', 'isla ugg', '', '' ) ON DUPLICATE KEY UPDATE search_add_date = '1550751254', search_clicks = search_clicks+1, no_results = '0'
                            [execution_time] => 0.00026798248291016
                        )

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

                    [11] => Array
                        (
                        )

                )

        )

    [2] => Array
        (
            [api_query] => http://api.salecamel.com?api_key=123456789&search_limit=10&do_get=get_related&search_terms=isla ugg
            [execution_time] => 0.0022878646850586
            [from_api] => Array
                (
                )

        )

)