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 (130,1668,1669,1670,1671,1672,1673,1674,1676,1677,1678,1679,1680,1681,1682,1684,1686,1688,1690)
) 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
Plain Pattern Fabric | Charu Creation Plain Pattern Fabric | Charu Creation
+91-9971106200
X

Showing 1–12 of 75 resultsSorted by latest

Showing 1–12 of 75 resultsSorted by latest

SELECT   ujw_posts.*
					 FROM ujw_posts 
					 WHERE 1=1  AND ujw_posts.post_name = 'bf0506d4b82e2e6360991c56295a1d5f' AND ujw_posts.post_type = 'oembed_cache' AND ((ujw_posts.post_status = 'publish'))
					 
					 ORDER BY ujw_posts.post_date DESC
In stock only
18
    18
    Your Cart
    Bluish Grey color Poly Olivia Georgette imported fabric for Women's Top
    Bluish Grey color Poly Olivia Georgette imported fabric for Women's Top
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    White Color Cotton Hakoba Embroidery Fabric For Women's Dress
    White Color Cotton Hakoba Embroidery Fabric For Women's Dress
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Blue Color Plain Cotton Cambric Dress Material Fabric
    Blue Color Plain Cotton Cambric Dress Material Fabric
    Price: MRP₹141.10 / mtr (incl. of all taxes)
    ₹141.10 (incl. GST)
    Rust color Poly Dupion fabric for Men's Kurta
    Rust color Poly Dupion fabric for Men's Kurta
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    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)
    White And Blue Yarn Dyed Oxford Stripe Design Shirt Dress Material Fabric
    White And Blue Yarn Dyed Oxford Stripe Design Shirt Dress Material Fabric
    Price: MRP Original price was: ₹375.38.Current price is: ₹346.50. / mtr (incl. of all taxes)
    ₹346.50 (incl. GST)
    White color Cotton Hakoba fabric for Men's Shirt
    White color Cotton Hakoba fabric for Men's Shirt
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    White base color Paisley print on Cotton Poplin fabric for Women's Shirt
    White base color Paisley print on Cotton Poplin fabric for Women's Shirt
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Red base color Kids print on Cotton Poplin Lycra fabric for Kids Nighsuit
    Red base color Kids print on Cotton Poplin Lycra fabric for Kids Nighsuit
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Royal Blue Polyester Textured Fabric
    Royal Blue Polyester Textured Fabric
    Price: MRP Original price was: ₹635.25.Current price is: ₹577.50. / mtr (incl. of all taxes)
    ₹577.50 (incl. GST)
    White Color Cotton Hakoba Embroidery Fabric For Women's Dress
    White Color Cotton Hakoba Embroidery Fabric For Women's Dress
    Price: MRP Original price was: ₹790.13.Current price is: ₹735.00. / mtr (incl. of all taxes)
    ₹735.00 (incl. GST)
    White Color Polyester Textured Fabric For Women's Top
    White Color Polyester Textured Fabric For Women's Top
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Multicolor Polyester Jacquard fabric for Women's dress
    Multicolor Polyester Jacquard fabric for Women's dress
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    Yellow Color Ditsy Floral Printed Satin Fabric Dress Material
    Yellow Color Ditsy Floral Printed Satin Fabric Dress Material
    Price: MRP₹519.75 / mtr (incl. of all taxes)
    ₹519.75 (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)
    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)
    Pink Color Plain Cotton Cambric Dress Material Fabric
    Pink Color Plain Cotton Cambric Dress Material Fabric
    Price: MRP₹141.10 / mtr (incl. of all taxes)
    ₹141.10 (incl. GST)
    Off White Plain Poly Georgette Dress Material Fabric
    Off White Plain Poly Georgette Dress Material Fabric
    Price: MRP₹173.25 / mtr (incl. of all taxes)
    ₹173.25 (incl. GST)
    Subtotal ₹7,220.78 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout