DYED CRAFT & HANDLOOM Archives - 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 (18228,18229)
) 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

DYED CRAFT & HANDLOOM Archives - Charu Creation DYED CRAFT & HANDLOOM Archives - Charu Creation

Showing all 2 resultsSorted by latest

Showing all 2 resultsSorted by latest

“Blue Color Cotton Ikat Fabric for Women’s Casuals shorts” has been added to your cart. View cart

Ikat
Black Color Printed design on Cotton Ikat Fabric for Men’s ...
MRP₹282.19 / mtr (incl. of all taxes)
25 Meter left in stock

Buy
Ikat
Blue Color Cotton Ikat Fabric for Women’s Casuals shorts
MRP₹282.19 / mtr (incl. of all taxes)
20.5 Meter left in stock

Buy