Wide Range of Fabrics for Wrinkle Free Garments | Charu Creation

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 (2449)
) 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 48, 12

Wide Range of Fabrics for Wrinkle Free Garments | Charu Creation Wide Range of Fabrics for Wrinkle Free Garments | Charu Creation

Showing 49–50 of 50 resultsSorted by latest

Showing 49–50 of 50 resultsSorted by latest

“Grey color Herringbone lycra dress material fabrics” has been added to your cart. View cart

Sale!
Offers
Black Color Poly Textured Lycra Dress Material Fabric
MRP Original price was: ₹592.20.Current price is: ₹288.75. / mtr (incl. of all taxes)
97 Meter left in stock

Buy
Sale!
Offers
Grey color Herringbone lycra dress material fabrics
MRP Original price was: ₹693.00.Current price is: ₹592.20. / mtr (incl. of all taxes)
81.75 Meter left in stock

Buy