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 (1189)
) 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
Online Winter Fabric Collection | Charu Creation Online Winter Fabric Collection | Charu Creation
X

Showing 1–12 of 21 resultsSorted by latest

Showing 1–12 of 21 resultsSorted by latest

10
    10
    Your Cart
    Green Color Plain Hand Spun Cotton Dress Material Fabric
    Green Color Plain Hand Spun Cotton Dress Material Fabric
    Price: MRP₹288.75 / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Grey Color Poly Chiffon Boota Dress Fabric Material
    Grey Color Poly Chiffon Boota Dress Fabric Material
    Price: MRP Original price was: ₹190.31.Current price is: ₹169.31. / mtr (incl. of all taxes)
    ₹169.31 (incl. GST)
    White color double side poly textured dress material fabric
    White color double side poly textured dress material fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Poly bubble moss crepe dress material fabric
    Poly bubble moss crepe dress material fabric
    Price: MRP Original price was: ₹592.20.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    White color Polyester Textured fabric for Women's Dress
    White color Polyester Textured fabric for Women's Dress
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Multicolor Polyester Jacquard fabric for Women's kurti
    Multicolor Polyester Jacquard fabric for Women's kurti
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    Multicolor Floral Print on Cotton Dobby Dress Material Fabric
    Multicolor Floral Print on Cotton Dobby Dress Material Fabric
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    White Color Printed Design on Cotton Embroidered Dress Material Fabric
    White Color Printed Design on Cotton 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)
    White color Polyester Textured fabric for Women's cord set
    White color Polyester Textured fabric for Women's cord set
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    All Over Design Yarn Dyed Check , Off White Color Thread Embroidery Fabric (Eyelet Fabric)
    All Over Design Yarn Dyed Check , Off White Color Thread Embroidery Fabric (Eyelet Fabric)
    Price: MRP Original price was: ₹1,270.50.Current price is: ₹1,050.00. / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)