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 (91,92,95,96,98,99,101,102,103,104,105,106,107,108,110,112,150,155,295,311,374,1052,1067,1117,1118,1119,1191,1200,1225,1233,1289,1290,1316,1438,1439,1440,1441,1442,1443,1444,1445,1477,1478,1500,1501,1502,1503,1504,1505,1506,1507,1523,1525,1532,1738,1844,1847,1861,1885,1944,2185,2449,2471,2586,2624,2625,2628,2670,2707,3029,3032,3040,3041,3042,3043,3044,5553,5569,6512,6607,12651,12652,16075,16076,18168)
) 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 Ladies Dress Material in Delhi NCR | Charu Creation Best Ladies Dress Material in Delhi NCR | Charu Creation
X

Showing 1–12 of 912 resultsSorted by latest

Showing 1–12 of 912 resultsSorted by latest

In stock only
10
    10
    Your Cart
    White color RFD Cotton Hakoba fabric for Women's Kurta
    White color RFD Cotton Hakoba fabric for Women's Kurta
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Multicolor Cotton Cambric print fabric for Women's Maxi Dress
    Multicolor Cotton Cambric print fabric for Women's Maxi Dress
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Brown color Polyester Textured fabric for Women's Western Dress
    Brown color Polyester Textured fabric for Women's Western Dress
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Navy Blue color Polyester Textured fabric for Women's Kurta
    Navy Blue color Polyester Textured fabric for Women's Kurta
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Off White color Nylon net embroidery dyeable fabric for Women's Top
    Off White color Nylon net embroidery dyeable fabric for Women's Top
    Price: MRP Original price was: ₹451.50.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹420.00 (incl. GST)
    White color Rfd Cotton Hakoba Fabric for Women's Cordsets
    White color Rfd Cotton Hakoba Fabric for Women's Cordsets
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Green color Poly texture fabric for Women's Top
    Green color Poly texture fabric for Women's Top
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Multicolor Cotton flex Leopard print fabric for Women's kurta
    Multicolor Cotton flex Leopard print fabric for Women's kurta
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (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 Cotton Poplin fabric for Women's Kurta
    Multicolor Cotton Poplin fabric for Women's Kurta
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)