Gorgeous Kaftan Dress By Georgette Fabric

by Tushar Bhatia
15/10/2022

Nice Fabric !!

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

Buy White Cotton Fabric – Delicate Blue Thread Embroidery & Elegant Finish MRP₹672.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

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