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

Showing 37–47 of 47 resultsSorted by latest

Showing 37–47 of 47 resultsSorted by latest

13
    13
    Your Cart
    All Over Base Floral Cotton Embroidered Fabric (Eyelet Fabric)
    All Over Base Floral Cotton Embroidered Fabric (Eyelet Fabric)
    Price: MRP Original price was: ₹288.75.Current price is: ₹262.50. / mtr (incl. of all taxes)
    ₹262.50 (incl. GST)
    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)
    ₹395.06 (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)
    Traditional Indian Design Embroidered Georgette Fabric Dress Material (Eyelet Fabric)
    Traditional Indian Design Embroidered Georgette Fabric Dress Material (Eyelet Fabric)
    Price: MRP Original price was: ₹1,617.00.Current price is: ₹1,155.00. / mtr (incl. of all taxes)
    ₹1,155.00 (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)
    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)
    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)
    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 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)
    ₹1,155.00 (incl. GST)