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 (121)
) 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 ikat cotton fabric online | Charu Creation Delhi Best ikat cotton fabric online | Charu Creation Delhi
+91-9971106200
X

Showing all 8 resultsSorted by latest

Showing all 8 resultsSorted by latest

SELECT   ujw_posts.*
					 FROM ujw_posts 
					 WHERE 1=1  AND ujw_posts.post_name = '9fb09e6670a0b898b80c59f1bf364c79' AND ujw_posts.post_type = 'oembed_cache' AND ((ujw_posts.post_status = 'publish'))
					 
					 ORDER BY ujw_posts.post_date DESC
In stock only
17
    17
    Your Cart
    Black base color Floral Print on Silk crepe fabric for Women's Dress
    Black base color Floral Print on Silk crepe fabric for Women's Dress
    Price: MRP₹1,693.13 / mtr (incl. of all taxes)
    ₹1,693.13 (incl. GST)
    Multicolor Printed Design on Net Sequence Dress Material Fabric
    Multicolor Printed Design on Net Sequence Dress Material Fabric
    Price: MRP₹1,386.00 / mtr (incl. of all taxes)
    ₹1,386.00 (incl. GST)
    Blue Color Floral Print Poly Chiffon Satin Dress Material Fabric
    Blue Color Floral Print Poly Chiffon Satin Dress Material Fabric
    Price: MRP₹346.50 / mtr (incl. of all taxes)
    ₹346.50 (incl. GST)
    Blue color Poly Foil fabric for Ladies Part Dresses
    Blue color Poly Foil fabric for Ladies Part Dresses
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Multicolor Rayon fabric for Women's Summer Dress
    Multicolor Rayon fabric for Women's Summer Dress
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Pink Color Plain Cotton cambric Lining Dress Material Fabric
    Pink Color Plain Cotton cambric Lining Dress Material Fabric
    Price: MRP Original price was: ₹346.50.Current price is: ₹197.54. / mtr (incl. of all taxes)
    ₹197.54 (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)
    Multicolor Polyester Jacquard fabric for Women's Midi dress
    Multicolor Polyester Jacquard fabric for Women's Midi dress
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    Black Base floral design on printed velvet dress material fabric
    Black Base floral design on printed velvet dress material fabric
    Price: MRP₹924.00 / mtr (incl. of all taxes)
    ₹924.00 (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)
    Navy Blue Color Nylon Viscose Fabric For Women's Kurta
    Navy Blue Color Nylon Viscose Fabric For Women's Kurta
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (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)
    Designer White Base Net Embroidery Fabric Dress Material
    Designer White Base Net Embroidery Fabric Dress Material
    Price: MRP Original price was: ₹1,848.00.Current price is: ₹1,155.00. / mtr (incl. of all taxes)
    ₹2,310.00 (incl. GST)
    Blue Color Cotton Hakoba Embroidery Fabric For Women's Kurta
    Blue Color Cotton Hakoba Embroidery 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)
    White color Poly Texture Imported fabric for Women's Pants
    White color Poly Texture Imported fabric for Women's Pants
    Price: MRP₹395.06 / mtr (incl. of all taxes)
    ₹395.06 (incl. GST)
    Multicolor Ikat Dress Material Fabric
    Multicolor Ikat Dress Material Fabric
    Price: MRP₹196.91 / mtr (incl. of all taxes)
    ₹196.91 (incl. GST)
    Subtotal ₹10,794.72 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout