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 (2919,2920,2921,2922)
) 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
Border Designs / Scallop Designs Archives - Charu Creation Border Designs / Scallop Designs Archives - Charu Creation
X

Showing 1–12 of 24 resultsSorted by latest

Showing 1–12 of 24 resultsSorted by latest

11
    11
    Your Cart
    Navy Rayon Crepe Lurex Fabric with Star Print | Charu Creation
    Navy Rayon Crepe Lurex Fabric with Star Print | Charu Creation
    Price: MRP₹99.00 / mtr (incl. of all taxes)
    ₹99.00 (incl. GST)
    Blue color Futki Lurex Fabric for Women's Western Dress
    Blue color Futki Lurex Fabric for Women's Western Dress
    Price: MRP Original price was: ₹472.50.Current price is: ₹451.50. / mtr (incl. of all taxes)
    ₹451.50 (incl. GST)
    White Color Embroidered Cotton Dress Material Fabric
    White Color Embroidered Cotton Dress Material Fabric
    Price: MRP Original price was: ₹924.00.Current price is: ₹892.50. / mtr (incl. of all taxes)
    ₹892.50 (incl. GST)
    Off White Floral Print on Nylon Net Embroidered Dress Material Fabric
    Off White Floral Print on Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹462.00.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹420.00 (incl. GST)
    White Color Cotton Cambric RFD Hakoba Fabric for Women's Long Dress
    White Color Cotton Cambric RFD Hakoba Fabric for Women's Long Dress
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Orange Color Plain Cotton Cambric Shirt Dress Fabric Material
    Orange Color Plain Cotton Cambric Shirt Dress Fabric Material
    Price: MRP Original price was: ₹197.54.Current price is: ₹141.10. / mtr (incl. of all taxes)
    ₹141.10 (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)
    Blue Color Plain Cotton Sheeting Dress Material Fabric
    Blue Color Plain Cotton Sheeting Dress Material Fabric
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Black color Cotton Silk Matka fabric for Women's Short Kurta
    Black color Cotton Silk Matka fabric for Women's Short Kurta
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Multicolor Cotton chambray Fabric for Women's Wear
    Multicolor Cotton chambray Fabric for Women's Wear
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Black Georgette Fabric With Double Side Embroidered Fabric Dress Material (Eyelet Fabric)
    Black Georgette Fabric With Double Side Embroidered Fabric Dress Material (Eyelet Fabric)
    Price: MRP Original price was: ₹750.75.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)