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 (2915)
) 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
Big Designs Archives - Charu Creation Big Designs Archives - Charu Creation
X

Showing 1–12 of 44 resultsSorted by latest

Showing 1–12 of 44 resultsSorted by latest

16
    16
    Your Cart
    Peach Color Plain Cotton Cambric Lining Dress Material fabric
    Peach 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 Cotton Embroidered Dress Material Fabric
    White Color Cotton Embroidered Dress Material Fabric
    Price: MRP₹577.50 / mtr (incl. of all taxes)
    ₹1,155.00 (incl. GST)
    Multicolor Hand Spun Cotton Dress Material Fabric
    Multicolor Hand Spun Cotton Dress Material Fabric
    Price: MRP Original price was: ₹288.75.Current price is: ₹249.00. / mtr (incl. of all taxes)
    ₹249.00 (incl. GST)
    Black Base color Nylon Net Embroidered Dress Material Fabric
    Black Base color Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹577.50.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Off White Floral Print on Nylon Net Embroidered Dress Material Fabric
    Off White Floral Print on Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹462.00.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹420.00 (incl. GST)
    Green Color Hand Spun Cotton Dress Material Fabric
    Green Color Hand Spun Cotton Dress Material Fabric
    Price: MRP Original price was: ₹288.75.Current price is: ₹249.00. / mtr (incl. of all taxes)
    ₹249.00 (incl. GST)
    Off White Color Hand Spun Cotton Dress Material Fabric
    Off White Color Hand Spun Cotton Dress Material Fabric
    Price: MRP Original price was: ₹288.75.Current price is: ₹249.00. / mtr (incl. of all taxes)
    ₹249.00 (incl. GST)
    All Over Design Yarn Dyed Check , Off White Color Thread Embroidery Fabric (Eyelet Fabric)
    All Over Design Yarn Dyed Check , Off White Color Thread Embroidery Fabric (Eyelet Fabric)
    Price: MRP Original price was: ₹1,270.50.Current price is: ₹1,050.00. / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)
    White Color Embroidered Cotton Dress Material Fabric
    White Color Embroidered Cotton Dress Material Fabric
    Price: MRP Original price was: ₹924.00.Current price is: ₹892.50. / mtr (incl. of all taxes)
    ₹892.50 (incl. GST)
    Off White Floral Print on Nylon Net Embroidered Dress Material Fabric
    Off White Floral Print on Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹462.00.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹420.00 (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)
    Multicolor Printed Design on Cotton Poplin Dress Material Fabric
    Multicolor Printed Design on Cotton Poplin Dress Material Fabric
    Price: MRP₹288.75 / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    White color Rayon Dress Material Fabric
    White color Rayon Dress Material Fabric
    Price: MRP₹231.00 / mtr (incl. of all taxes)
    ₹231.00 (incl. GST)
    All Over Design Yellow Color Floral Design Cotton Dobby Embroided Schiffli Fabric
    All Over Design Yellow Color Floral Design Cotton Dobby Embroided Schiffli Fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    white net
    White Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹462.00.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹420.00 (incl. GST)