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 (11)
			) 
  AND 
  ujw_term_relationships.term_taxonomy_id IN (1290)
) 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
Elegant Cotton Tussar | Do Shopping For Party Fabrics Now Elegant Cotton Tussar | Do Shopping For Party Fabrics Now
X

Showing 1–12 of 17 resultsSorted by latest

Showing 1–12 of 17 resultsSorted by latest

14
    14
    Your Cart
    White Color Polyester Satin Fabric For Women's Gown
    White Color Polyester Satin Fabric For Women's Gown
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Purple Color Cotton Voile Stripe Fabric For Women's Kurta
    Purple Color Cotton Voile Stripe Fabric For Women's Kurta
    Price: MRP₹259.61 / mtr (incl. of all taxes)
    ₹259.61 (incl. GST)
    Off White color Viscose Georgette Embroidery Dyeable fabric for Home Decor
    Off White color Viscose Georgette Embroidery Dyeable fabric for Home Decor
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    White color Polyester Textured fabric for Women's Kurta
    White color Polyester Textured fabric for Women's Kurta
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (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)
    ₹1,155.00 (incl. GST)
    Multicolor Stripe Print on Cotton Voile Dress Material Fabric
    Multicolor Stripe Print on Cotton Voile Dress Material Fabric
    Price: MRP₹404.25 / mtr (incl. of all taxes)
    ₹404.25 (incl. GST)
    White base color Kids print on Cotton Poplin Fabric For Women's Kurta
    White base color Kids print on Cotton Poplin Fabric For Women's Kurta
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Yellow color Poly Crepe lycra imported fabric for Women's Trousers
    Yellow color Poly Crepe lycra imported fabric for Women's Trousers
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Grey Color Cotton Cambric Lining Dress Material Fabric
    Grey Color 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)
    Multicolor Cotton Poplin Fabric For Women's Top
    Multicolor Cotton Poplin Fabric For Women's Top
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Pink Color Cotton Embroidered Yarn Dyed Check Flower Design Fabric For Women's Kurti
    ₹630.00 (incl. GST)
    Blue Color Floral Print on Cotton Cambric Dress Material Fabric
    Blue Color Floral Print on Cotton Cambric Dress Material Fabric
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    White Color Printed Design on Cotton Poplin Dress Material Fabric
    White Color Printed Design on Cotton Poplin Dress Material Fabric
    Price: MRP₹404.25 / mtr (incl. of all taxes)
    ₹404.25 (incl. GST)
    Pista Green Color Polyester Tussar Fabric For Women's Kurta
    Pista Green Color Polyester Tussar Fabric For Women's Kurta
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)