Since 1914 Safavieh rugs has been weaving and importing eye-catching rugs based upon three generations of expertise int he industry. While this company prides itself upon the numerous awards it has received lauding its products it never ceases to keep improving upon its offerings. Thanks to hundreds of fine designs, outfitting your home with the perfect floor-covering is easy. Matchless Safavieh area rugs assure you that your floors will come to life with their fine specimens.
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 (46)
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 = 'mandarin') AND (e.style_vendor_descr_val = 'md407a') GROUP BY `e`.`entity_id` ORDER BY `root_position` asc, `cat_index_position` asc, `cat_index`.`product_id` asc LIMIT 28
- Safavieh
