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 (142,143,144,145,146,147,148,149,151,1662,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,2930)
) 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 372, 12
Embroidered Fabrics | Premium Emroidered Fabric | Charu Creation | Page 32 Embroidered Fabrics | Premium Emroidered Fabric | Charu Creation | Page 32
+91-9971106200
X

Showing 373–384 of 620 resultsSorted by latest

Showing 373–384 of 620 resultsSorted by latest

In stock only
4
    4
    Your Cart
    Off White Base Color Blue Embroidery on Cotton Hakoba Fabric For Women's Summer Dress
    Off White Base Color Blue Embroidery on Cotton Hakoba Fabric For Women's Summer Dress
    Price: MRP Original price was: ₹451.50.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹420.00 (incl. GST)
    Georgette Embroidery
    Multicolor Cotton Hakoba Embroidery Fabric For Women's Top
    Price: MRP Original price was: ₹903.00.Current price is: ₹735.00. / mtr (incl. of all taxes)
    ₹735.00 (incl. GST)
    Premium Yellow Cotton Hakoba Fabric – Elegant All Over Design for Stylish Outfits
    Premium Yellow Cotton Hakoba Fabric – Elegant All Over Design for Stylish Outfits
    Price: MRP₹630.00 / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    cotton hakoba
    White Base Color Blue Embroidery on Cotton Hakoba Fabric For Women's Kurti
    Price: MRP₹1,050.00 / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)
    Subtotal ₹2,835.00 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout