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='69'
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
I will start my note with quoting a man completely devoted to Khadi,
Mr Bireswar Biswas :
” Khadi is more sensitive than other fabrics, because it is handspun and handwoven .It is an inspiration and a meaningful textile .It is sensual and this sensuality is a gift to the world … ”.
I bought from Mr Biswas divine looking stoles that I chose to print sparingly in order not to hide the exquisite beauty of the weave .
To print regularly on Khadi would have been a dream but I could not imagine wasting any of it with some misprint … the cost being too high as well once added to my printing .
So , I just printed my pretty stoles .
But one day , I could not resist getting some fabric to offer my clients a small collection of whites … and I discovered then the magic 500 count … so fine I decided to stitch it for babies only ! It is woven in the moist of dawn and dusk so that the yarn doesn’t break . In ancient Rome , it was called ‘venti’ or ‘nebula’ as light as a moth wing . I requested Mr Biswas to get square scarves woven in this amazing fine 500 count .
I stitched the rest, very fine too, for us , ladies …
For you, to enjoy and cherish , a treasure from India .
Please login