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 (2919,2920,2921,2922)
) 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 12, 12
Border Designs / Scallop Designs Archives - Page 2 of 3 - Charu Creation Border Designs / Scallop Designs Archives - Page 2 of 3 - Charu Creation
X

Showing 13–24 of 27 resultsSorted by latest

Showing 13–24 of 27 resultsSorted by latest

11
    11
    Your Cart
    Black Base Color White Cotton Hakoba Embroidery Fabric For Women's Long Dress
    Black Base Color White Cotton Hakoba Embroidery Fabric For Women's Long Dress
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    White Color Cotton Cambric RFD Hakoba Fabric for Women's Kurta
    White Color Cotton Cambric RFD Hakoba Fabric for Women's Kurta
    Price: MRP₹525.00 / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    White Color RFD Cotton Hakoba Fabric for Women's Kurta
    White Color RFD Cotton Hakoba Fabric for Women's Kurta
    Price: MRP Original price was: ₹903.00.Current price is: ₹840.00. / mtr (incl. of all taxes)
    ₹840.00 (incl. GST)
    Brown Cotton Chambray Fabric For Women's Dress
    Brown Cotton Chambray Fabric For Women's Dress
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Purple Color Cotton Voile Stripe Fabric For Women's Kurta
    Purple Color Cotton Voile Stripe Fabric For Women's Kurta
    Price: MRP₹259.61 / mtr (incl. of all taxes)
    ₹259.61 (incl. GST)
    Golden Color Poly Brocade Dress Material Fabric
    Golden Color Poly Brocade Dress Material Fabric
    Price: MRP Original price was: ₹346.50.Current price is: ₹249.00. / mtr (incl. of all taxes)
    ₹249.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)
    Pink Color Plain Cotton cambric Lining Dress Material Fabric
    Pink 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)
    Red Color poly textured lycra dress material fabric
    Red Color poly textured lycra dress material fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹592.20. / mtr (incl. of all taxes)
    ₹592.20 (incl. GST)
    Multicolor Floral Print on Silk Crepe fabric for Women's Kurti
    Multicolor Floral Print on Silk Crepe fabric for Women's Kurti
    Price: MRP₹197.54 / mtr (incl. of all taxes)
    ₹197.54 (incl. GST)
    cotton hakoba
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Shirts
    Price: MRP Original price was: ₹682.50.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)