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 (97,100,113,114,1288,1526,1775,2686,2760,3037,3038,3039,8571,17667)
) 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
Textured Archives - Charu Creation Textured Archives - Charu Creation
X

Showing 1–12 of 253 resultsSorted by latest

Showing 1–12 of 253 resultsSorted by latest

10
    10
    Your Cart
    Blue base color Floral Print on Silk crepe fabric for Women's Kurti
    Blue base color Floral Print on Silk crepe fabric for Women's Kurti
    Price: MRP₹1,693.13 / mtr (incl. of all taxes)
    ₹1,693.13 (incl. GST)
    Grey color Poly Georgette imported lycra fabric for Women's Trousers
    Grey color Poly Georgette imported lycra fabric for Women's Trousers
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    White color Poly Chiffon fabric for High Fashion Dress
    White color Poly Chiffon fabric for High Fashion Dress
    Price: MRP₹112.88 / mtr (incl. of all taxes)
    ₹112.88 (incl. GST)
    White Color Cotton Foil Dress Material Fabric
    White Color Cotton Foil Dress Material Fabric
    Price: MRP Original price was: ₹288.75.Current price is: ₹149.00. / mtr (incl. of all taxes)
    ₹149.00 (incl. GST)
    Black Color Printed Design on Georgette Sequence Dress Material Fabric
    Black Color Printed Design on Georgette Sequence Dress Material Fabric
    Price: MRP₹462.00 / mtr (incl. of all taxes)
    ₹462.00 (incl. GST)
    Green Color Plain Cotton Cambric Dress Material Fabric
    Green Color Plain Cotton Cambric Dress Material Fabric
    Price: MRP₹141.10 / mtr (incl. of all taxes)
    ₹141.10 (incl. GST)
    Pink color poly textured lycra dress material fabric
    Pink color poly textured lycra dress material fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    cotton hakoba
    Black base White Embroidery Cotton Poplin Border Boota fabric for Women's Dress
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Beige Color Rayon Crepe Fabric For Women's Dress
    Beige Color Rayon Crepe Fabric For Women's Dress
    Price: MRP₹203.18 / mtr (incl. of all taxes)
    ₹203.18 (incl. GST)
    Multicolor Chanderi Fabric for Kurtis
    Multicolor Chanderi Fabric for Kurtis
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)