United Weavers Genesis Tarton Loon Rugs Collection
For well-made rugs sure to suit any price point a United Weavers Rugs is an ideal choice. With everything from traditional, to whimsical, to Southwestern and transitional the choices are almost limitless but to purchase one your budget doesn't have to be.
SELECT DISTINCT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`cost`, `e`.`weight`, `e`.`meta_title`, `e`.`meta_keyword`, `e`.`meta_description`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`media_gallery`, `e`.`old_id`, `e`.`tier_price`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`gallery`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`url_path`, `e`.`minimal_price`, `e`.`visibility`, `e`.`custom_design_from`, `e`.`custom_design_to`, `e`.`custom_layout_update`, `e`.`required_options`, `e`.`has_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`created_at`, `e`.`updated_at`, `e`.`enable_googlecheckout`, `e`.`gift_message_available`, `e`.`price_type`, `e`.`sku_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`samples_title`, `e`.`links_title`, `e`.`special`, `e`.`featured`, `e`.`product_month`, `e`.`top_sellers`, `e`.`shape`, `e`.`shape_value`, `e`.`brand`, `e`.`brand_value`, `e`.`collection_name`, `e`.`collection_sku`, `e`.`collection_style`, `e`.`color_display`, `e`.`color_vendor`, `e`.`construction`, `e`.`construction_value`, `e`.`construction_description`, `e`.`country`, `e`.`country_value`, `e`.`description_1`, `e`.`designer`, `e`.`designer_value`, `e`.`discount`, `e`.`in_depth`, `e`.`map_price`, `e`.`material`, `e`.`material_value`, `e`.`material_description`, `e`.`msrp`, `e`.`product_category_number`, `e`.`product_length`, `e`.`product_width`, `e`.`promo_message1`, `e`.`promo_message2`, `e`.`promo_message3`, `e`.`ship_cost`, `e`.`ship_date`, `e`.`ship_height`, `e`.`ship_length`, `e`.`ship_weight`, `e`.`ship_width`, `e`.`size_actual`, `e`.`size_navigation`, `e`.`size_navigation_value`, `e`.`size_shape_msg`, `e`.`sku_pad`, `e`.`special_search`, `e`.`style_main`, `e`.`style_main_value`, `e`.`style_vendor`, `e`.`upc_code`, `e`.`upsell_sku`, `e`.`vendor_number`, `e`.`date_sku_updated`, `e`.`style`, `e`.`landing_pg_url`, `e`.`image_url_feed`, `e`.`product_type`, `e`.`condition`, `e`.`condition_value`, `e`.`max_bid`, `e`.`style_vendor_descr`, `e`.`description_medium`, `e`.`feature_1`, `e`.`feature_2`, `e`.`feature_3`, `e`.`feature_4`, `e`.`feature_5`, `e`.`seo_text1`, `e`.`use_as_default_similar`, `e`.`volume_weight`, `e`.`collection_name_val`, `e`.`style_vendor_descr_val`, `e`.`price_val`, `e`.`color_content`, `e`.`is_recurring`, `e`.`recurring_profile`, `e`.`links_exist`, `e`.`related_targetrule_position_limit`, `e`.`related_targetrule_position_behavior`, `e`.`upsell_targetrule_position_limit`, `e`.`upsell_targetrule_position_behavior`, `e`.`discontinued`, `e`.`round`, `e`.`runner`, `e`.`closeup`, `e`.`rooms`, `e`.`rejected`, `e`.`front_rooms`, `e`.`brand_room`, `e`.`oval`, `e`.`octagon`, `e`.`rooms_blacklisted`, `e`.`square`, `e`.`small_image_x`, `e`.`small_image_y`, `e`.`exclude_by_sku`, `e`.`parent`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, 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`.`collection_style`, `e`.`collection_name`, `e`.`promo_message1`, `e`.`description_1`, `e`.`promo_message2`, `e`.`brand`, `e`.`brand_value`, `e`.`style`, `e`.`exclude_by_sku`, IF(a.position is not null,a.position, 9999) AS `root_position`, `e`.`collection_style`, `e`.`collection_name`, `e`.`promo_message1`, `e`.`description_1`, `e`.`promo_message2`, `e`.`brand`, `e`.`brand_value`, `e`.`style`, `e`.`exclude_by_sku` 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='10'
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 `catalog_category_product_index` AS `cat_filter` ON cat_filter.product_id=e.entity_id AND cat_filter.store_id='1' AND cat_filter.visibility IN(2, 4)
INNER JOIN `catalog_product_index_eav` AS `brand_idx` ON brand_idx.entity_id = e.entity_id AND brand_idx.attribute_id = '510' AND brand_idx.store_id = '1' AND brand_idx.value in (28)
LEFT JOIN `catalog_category_product` AS `a` ON a.product_id=e.entity_id AND a.category_id=25 WHERE (exclude_by_sku != 1) AND (e.collection_name_val = 'genesis') AND (e.style_vendor_descr_val = 'tarton-loon') GROUP BY `e`.`entity_id` ORDER BY `root_position` asc, `cat_index_position` asc, `cat_index`.`product_id` asc LIMIT 28
- United Weavers
