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 (1507)
) AND ((ujw_posts.post_type = 'product' AND (ujw_posts.post_status = 'publish' OR ujw_posts.post_status = 'acf-disabled')))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC, ujw_posts.ID DESC
					 LIMIT 0, 12
Rayon Crepe Fabric | Buy Rayon Online | Charu Creation Rayon Crepe Fabric | Buy Rayon Online | Charu Creation
+91-9971106200
X

Showing all 9 resultsSorted by latest

Showing all 9 resultsSorted by latest

SELECT   ujw_posts.*
					 FROM ujw_posts 
					 WHERE 1=1  AND ujw_posts.post_name = '9631cccd279d970de39e99d2160e88c3' AND ujw_posts.post_type = 'oembed_cache' AND ((ujw_posts.post_status = 'publish'))
					 
					 ORDER BY ujw_posts.post_date DESC
11
    11
    Your Cart
    Multicolor Nylon net sequence fabric for Women's Gown
    Multicolor Nylon net sequence fabric for Women's Gown
    Price: MRP₹1,580.25 / mtr (incl. of all taxes)
    ₹1,580.25 (incl. GST)
    Green Color Plain Poly Taffeta Dress Material Fabric
    Green Color Plain Poly Taffeta Dress Material Fabric
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Mustard color Polyester bubble Textured fabric for Women's Dress
    Mustard color Polyester bubble Textured fabric for Women's Dress
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Brown Color Plain Poly Taffeta Dress Material Fabric
    Brown Color Plain Poly Taffeta Dress Material Fabric
    Price: MRP₹115.50 / mtr (incl. of all taxes)
    ₹115.50 (incl. GST)
    Red Color Georgette Lycra Dress Material Fabric
    Red Color Georgette Lycra Dress Material Fabric
    Price: MRP₹367.50 / mtr (incl. of all taxes)
    ₹367.50 (incl. GST)
    White color Nylon net embroidery dyeable fabric for Women's Western Gowns
    White color Nylon net embroidery dyeable fabric for Women's Western Gowns
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Skin Color Polyester Viscose Boota Fabric For Women's Dress
    Skin Color Polyester Viscose Boota Fabric For Women's Dress
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Poly Bubble Moss Crepe Dress Material Fabric
    Poly Bubble Moss Crepe Dress Material Fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Pink Color Olivia Georgette fabric for Women's Kurti
    Pink Color Olivia Georgette fabric for Women's Kurti
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Off White Color Imported Poly Viscose Textured Fabric
    Off White Color Imported Poly Viscose Textured Fabric
    Price: MRP₹577.50 / mtr (incl. of all taxes)
    ₹577.50 (incl. GST)
    Black Color Rayon Crepe Foil Dress Material Fabric
    Black Color Rayon Crepe Foil Dress Material Fabric
    Price: MRP₹169.31 / mtr (incl. of all taxes)
    ₹169.31 (incl. GST)
    Subtotal ₹5,373.39 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout