Printed Top with Trousers with Cotton Fabric

by Tushar Bhatia
07/10/202207/10/2022

Amazing Fabric

Latest

Buy White Cotton Fabric – Delicate Blue Thread Embroidery & Elegant Finish MRP₹672.00 / mtr (incl. of all taxes)

Best Selling

Abstract Print On Cotton Voile Dress Material MRP₹89.00 / mtr (incl. of all taxes)

SELECT   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.post_parent = 0  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 (14)
) AND ujw_posts.post_type = 'product' AND ((ujw_posts.post_status = 'publish'))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC
					 LIMIT 0, 1

Featured

Multicolor Check Print on South Cotton Dress Material Fabric MRP₹288.75 / mtr (incl. of all taxes)

SELECT   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.post_parent = 0  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 (14)
) AND ujw_posts.post_type = 'product' AND ((ujw_posts.post_status = 'publish'))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC
					 LIMIT 0, 1