SELECT 
				products.*,
				catalog.name AS cat_name,
				SUM(orders_content.admin_price * orders_content.admin_quantity) AS product_amount,
				SUM(orders_content.admin_quantity) AS product_quantity
			FROM orders_content
			INNER JOIN orders ON orders.oid=orders_content.oid
			INNER JOIN products ON products.pid = orders_content.pid
			
			INNER JOIN catalog ON catalog.cid = products.cid
			WHERE 
				products.is_visible='Yes' AND
				DATE_ADD(orders.create_date, INTERVAL 1 YEAR)>NOW() AND 
				orders.status='Completed' AND 
				orders.payment_status='Received' 
			GROUP BY orders_content.pid
			ORDER BY
				product_quantity DESC
			LIMIT 3