SELECT SQL_CALC_FOUND_ROWS  ujw_posts.*
					 FROM ujw_posts  LEFT JOIN ujw_term_relationships ON (ujw_posts.ID = ujw_term_relationships.object_id)
					 WHERE 1=1  AND ( 
  ujw_posts.ID NOT IN (
				SELECT object_id
				FROM ujw_term_relationships
				WHERE term_taxonomy_id IN (11)
			) 
  AND 
  ujw_term_relationships.term_taxonomy_id IN (2471)
) AND ((ujw_posts.post_type = 'product' AND (ujw_posts.post_status = 'publish')))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC, ujw_posts.ID DESC
					 LIMIT 0, 12
Viscose Fabric Online – Plain, Printed & Satin | Charu
+91-9971106200
X

Showing 1–12 of 61 resultsSorted by latest

Showing 1–12 of 61 resultsSorted by latest

Viscose is one of our picks for summer kurtis. See our kurti fabric guide for how many metres each style needs.

In stock only
0
0
Your Cart
Your cart is emptyReturn to Shop
To find out your shipping cost , Please proceed to checkout.