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

11
    11
    Your Cart
    White Color Nylon Net Embroidered Dress Material Fabric
    White Color Nylon Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹462.00.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹840.00 (incl. GST)
    Cream Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    Cream 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)
    Off White Cotton Lurex Dress Material Fabric
    Off White Cotton Lurex Dress Material Fabric
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Black Base Floral Print on Poly Satin Dress Material Fabric
    Black Base Floral Print on Poly Satin Dress Material Fabric
    Price: MRP₹231.00 / mtr (incl. of all taxes)
    ₹231.00 (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)
    ₹577.50 (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)
    ₹840.00 (incl. GST)
    Multicolor Floral Print on Cotton Dobby Dress Material Fabric
    Multicolor Floral Print on Cotton Dobby Dress Material Fabric
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (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)