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 0, 12
Border Designs / Scallop Designs Archives - Charu Creation Border Designs / Scallop Designs Archives - Charu Creation
X

Showing 1–12 of 27 resultsSorted by latest

Showing 1–12 of 27 resultsSorted by latest

11
    11
    Your Cart
    Black Georgette Fabric With Double Side Embroidered Fabric Dress Material (Eyelet Fabric)
    Black Georgette Fabric With Double Side Embroidered Fabric Dress Material (Eyelet Fabric)
    Price: MRP Original price was: ₹750.75.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹1,260.00 (incl. GST)
    Bottle Green Color Rayon Moss Boota Fabric For Women's Kurta
    Bottle Green Color Rayon Moss Boota Fabric For Women's Kurta
    Price: MRP₹253.97 / mtr (incl. of all taxes)
    ₹253.97 (incl. GST)
    Poly Bubble Moss Crepe Dress Material Fabrics
    Poly Bubble Moss Crepe Dress Material Fabrics
    Price: MRP Original price was: ₹592.20.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    All Over Design Cotton Embroidery Fabric (Eyelet Fabric)
    All Over Design Cotton Embroidery Fabric (Eyelet Fabric)
    Price: MRP Original price was: ₹519.75.Current price is: ₹367.50. / mtr (incl. of all taxes)
    ₹735.00 (incl. GST)
    White color Poly Texture Imported fabric for Women's Pants
    White color Poly Texture Imported fabric for Women's Pants
    Price: MRP₹395.06 / mtr (incl. of all taxes)
    ₹395.06 (incl. GST)
    Multicolor Rayon fabric for Women's Summer Dress
    Multicolor Rayon fabric for Women's Summer Dress
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Multicolor Printed Design on Net Printed Sequence Dress Material Fabric
    Multicolor Printed Design on Net Printed Sequence Dress Material Fabric
    Price: MRP₹462.00 / mtr (incl. of all taxes)
    ₹462.00 (incl. GST)
    Embroidery Leaf Design On White Color Cotton Fabric
    Embroidery Leaf Design On White Color Cotton Fabric
    Price: MRP₹840.00 / mtr (incl. of all taxes)
    ₹840.00 (incl. GST)
    cotton hakoba fabric
    Blue Cotton Hakoba Fabric – All Over Floral Design
    Price: MRP₹1,050.00 / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)