Harounian Rainbow rugs are designed for the decorator who is unafraid of color. This hand-tufted wool collection, rather than relying on intricate patterns, lets their assertive colors speak for them. These aptly named rugs, which can in vivid scarlet, deep cobalt, beguiling lavender and elegant copper are perfect if you want to add a splash of dramatic color to a room. Harounian Rainbow rugs are perfect for the bold, adventurous decorator.
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 (36)
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 = 'rainbow') GROUP BY `e`.`entity_id` ORDER BY `root_position` asc, `cat_index_position` asc, `cat_index`.`product_id` asc LIMIT 28
- Harounian