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 (23)
			) 
  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 (153,154,1322,1817,2778,2779,2780,2782,2783,6290)
) 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
Best Silk Fabric & Material Store | Charu Creations Best Silk Fabric & Material Store | Charu Creations
X

Showing 1–12 of 46 resultsSorted by latest

Showing 1–12 of 46 resultsSorted by latest

13
    13
    Your Cart
    Black Color Poly Textured Lycra Dress Material Fabric
    Black Color Poly Textured Lycra Dress Material Fabric
    Price: MRP Original price was: ₹592.20.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Geometric Diamond Print Rayon Crepe Fabric | Charu Creation
    Geometric Diamond Print Rayon Crepe Fabric | Charu Creation
    Price: MRP₹99.00 / mtr (incl. of all taxes)
    ₹99.00 (incl. GST)
    Black Base color Nylon Net Embroidered Dress Material Fabric
    Black Base color Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹577.50.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Green Color Net Sequin Dress Material Fabric
    Green Color Net Sequin Dress Material Fabric
    Price: MRP₹1,386.00 / mtr (incl. of all taxes)
    ₹1,386.00 (incl. GST)
    Square Pattern Multi Color Sequin Fabric
    Square Pattern Multi Color Sequin Fabric
    Price: MRP₹1,785.00 / mtr (incl. of all taxes)
    ₹1,785.00 (incl. GST)
    Neon Color Poly Twill Georgette Dress Material Fabric
    Neon Color Poly Twill Georgette Dress Material Fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹218.89. / mtr (incl. of all taxes)
    ₹218.89 (incl. GST)
    Black Color Plain Cotton Dobby Dress Material Fabric
    Black Color Plain Cotton Dobby Dress Material Fabric
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Off White Cotton Lurex Dress Material Fabric
    Off White Cotton Lurex Dress Material Fabric
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Pista Green Color Polyester Tussar Fabric For Women's Kurta
    Pista Green Color Polyester Tussar Fabric For Women's Kurta
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    cotton hakoba fabric
    White Cotton Embroidery Fabric – All Over Animal Design
    Price: MRP₹630.00 / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    COTTON HAKOBA
    Skin Color Cotton Seersucker Embroidery Fabric For Women's Kurta
    Price: MRP₹630.00 / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Blue Color Double Georgette Poly Satin Fabric For Women's Kurta
    Blue Color Double Georgette Poly Satin Fabric For Women's Kurta
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Yellow color Matka Silk fabric for Women's Kurta Jacket
    Yellow color Matka Silk fabric for Women's Kurta Jacket
    Price: MRP₹507.94 / mtr (incl. of all taxes)
    ₹507.94 (incl. GST)