By creating an account with our store, you will be able to move through the checkout process faster, store multiple shipping addresses, view and track you orders in your account and more.
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, 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`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='26'
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
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_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '73') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '73') AND (`at_name`.`store_id` = 2) WHERE (stock_status_index.stock_status = 1) ORDER BY `name` ASC
LIMIT 40
Piqués …
Around the planet , for centuries , quilting has been a traditional art to embellish and transform fabric , giving weight , giving strength or giving a new life to fabric , preparing a warm blanket or a garment with layers of fabric , padding them or not , with carded unwoven cotton and wool …
In the process a myriad of amazing textiles have been created …
My hand block printing is renowned for its clarity and for that to be , I need to print on smooth fabric . The heaviest weave I use is a 40 count… a kind of percale , ideal for table linen but too light to turn it into a bed cover and do justice to our beautiful printing . Hence, I thought best would be to quilt our bed spreads the way French ladies did it in Provence . This particular quilting called “piqué” , is made of very fine stitches , fixing a thin layer of unwoven cotton between two layers of printed fabric .
I still use the splendid Jaipur quilting ( see our video on the site ) to prepare very light and cosy blankets called “razai” of cotton wool between two layers of muslin with looser stitches to allow air into the quilt , making it warmer .
Please login