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 (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 24, 12
Big Designs Archives - Page 3 of 4 - Charu Creation Big Designs Archives - Page 3 of 4 - Charu Creation
X

Showing 25–36 of 47 resultsSorted by latest

Showing 25–36 of 47 resultsSorted by latest

13
    13
    Your Cart
    White Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    White Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹808.50.Current price is: ₹787.50. / mtr (incl. of all taxes)
    ₹787.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)
    Multicolor Circle Floral Design Cotton Chemical Lace Print Dress Material Fabric
    Multicolor Circle Floral Design Cotton Chemical Lace Print Dress Material Fabric
    Price: MRP Original price was: ₹1,062.60.Current price is: ₹693.00. / mtr (incl. of all taxes)
    ₹693.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)
    ₹1,050.00 (incl. GST)
    Blue Color Base Floral Design Poly Georgette Fabric Dress Material
    Blue Color Base Floral Design Poly Georgette Fabric Dress Material
    Price: MRP Original price was: ₹231.00.Current price is: ₹172.10. / mtr (incl. of all taxes)
    ₹172.10 (incl. GST)
    Black Color Imported Polyester Fabric
    Black Color Imported Polyester Fabric
    Price: MRP Original price was: ₹635.25.Current price is: ₹577.50. / mtr (incl. of all taxes)
    ₹577.50 (incl. GST)
    White Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    White Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    Price: MRP₹577.50 / mtr (incl. of all taxes)
    ₹577.50 (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)
    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)
    Multicolor Stripes on Cotton Slub Yarn Dyed Fabric For Women's Top
    Multicolor Stripes on Cotton Slub Yarn Dyed Fabric For Women's Top
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (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)
    Green Color Nylon Net Embroidered Dress Material Fabric
    Green Color Nylon Net Embroidered Dress Material Fabric
    Price: MRP₹577.50 / mtr (incl. of all taxes)
    ₹577.50 (incl. GST)