queries

Adding Product in Admin
==================================

	SELECT 
		product.*, product_variation.*, product_option.*
	FROM product
	LEFT JOIN product_variation ON product_variation.product_id = product.product_id
	LEFT JOIN product_option ON product_option.product_id = product.product_id
	LEFT JOIN order_product ON order_product.product_id = product.product_id
	LEFT JOIN customer_order ON customer_order.order_id = order_product.order_id
	WHERE customer_order.order_id = 2126;



Adding Product via API
==================================

	
	SELECT 
		product.*, product_variation.*, product_option.*
	FROM product
	LEFT JOIN product_variation ON product_variation.product_id = product.product_id
	LEFT JOIN product_option ON product_option.product_id = product.product_id
	LEFT JOIN order_product ON order_product.product_id = product.product_id
	LEFT JOIN customer_order ON customer_order.order_id = order_product.order_id
	WHERE customer_order.order_id = 2127;
	
	
	
	
	
	
Note: Please run this query to the Sandbox DB. 

Query for creating the new project. Need to compare with Production.

SELECT 
	product.*, product_description.*
FROM product
JOIN product_description ON product_description.product_id = product.product_id
WHERE product.product_id IN (847, 848);