SELECT 
products.product_id products_id, 
products.product_in_stock products_quantity, 
products.product_sku products_model, 
products.product_thumb_image products_image, 
pri.product_price products_price, 
from_unixtime(products.mdate) products_date_added, 
from_unixtime(products.cdate) products_last_modified, 
from_unixtime(products.mdate) products_date_available, 
products.product_weight products_weight, 
IF(products.product_publish = 'Y',1,0) products_status, 
products.product_tax_id products_tax_class_id, 
products.vendor_id manufacturers_id, 
products.product_sales products_ordered, 
products.product_name products_name

FROM <@PREFIX>vm_product products join <@PREFIX>vm_product_price pri on products.product_id =
 pri.product_id 
where pri.Price_quantity_start = 0

