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

17
    17
    Your Cart
    Brown base color Floral boota Print on Cotton Cambric fabric for Women's Kurti
    ₹225.75 (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)
    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)
    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,575.00 (incl. GST)
    white color cotton georgette Dress Material fabric
    white color cotton georgette Dress Material fabric
    Price: MRP₹231.00 / mtr (incl. of all taxes)
    ₹231.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 Original price was: ₹462.00.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹840.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)
    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 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)
    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)
    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 Printed Design on Glass Nylon Embroidered Dress Material Fabric
    White Color Printed Design on Glass Nylon Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)