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 (4591)
) AND ((ujw_posts.post_type = 'product' AND (ujw_posts.post_status = 'publish')))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC, ujw_posts.ID DESC
					 LIMIT 0, 12
Mangalgiri Cotton Fabric – Handloom by the Metre | Charu
X

Showing all 11 resultsSorted by latest

Showing all 11 resultsSorted by latest

Mangalgiri is a handloom cotton fabric from Mangalagiri in Andhra Pradesh, known for its fine, tight weave and crisp feel. Our Mangalgiri fabric comes in solid colours and is used for kurtas, suits and sarees. It is durable, breathable and sold by the metre.

0
0
Your Cart
Your cart is emptyReturn to Shop