Track your order

Track your Order with our Delivery Partner

SELECT   ujw_posts.*
					 FROM ujw_posts 
					 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_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

Latest

Sky Blue Striped Cotton with Banana Embroidery | Charu Creation MRP₹630.00 / mtr (incl. of all taxes)

SELECT   ujw_posts.*
					 FROM ujw_posts  INNER JOIN ujw_postmeta ON ( ujw_posts.ID = ujw_postmeta.post_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_postmeta.meta_key = 'total_sales'
) AND ujw_posts.post_type = 'product' AND ((ujw_posts.post_status = 'publish'))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_postmeta.meta_value+0 DESC
					 LIMIT 0, 1

Best Selling

Multicolor Circle Floral Design Cotton Chemical Lace Print Dress Material Fabric MRP₹98.70 / 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

Sky Blue Cotton Cambric Fabric – Floral Print Design MRP₹315.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