A Harounian Crown rug is perfect for a classic interior. These hand-crafted, high-quality wool rugs, with their elegant patterns and subdued, restrained colors, suggest both nobility and the great rug bazaars of the East. They make an excellent complement to furniture made from darker woods but are such a work of art they will go wherever they are placed. Our Crown rugs will enrich the lives of those who buy them, so you are sure to find the perfect match for your home or office.
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 = 'crown') GROUP BY `e`.`entity_id` ORDER BY `root_position` asc, `cat_index_position` asc, `cat_index`.`product_id` asc LIMIT 28
- Harounian