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

FROM <@PREFIX>vm_product pr join <@PREFIX>vm_product_price pri on pr.product_id =
 pri.product_id 
where pri.Price_quantity_start = 0
and pr.product_publish = 'Y'

and not -1 = %s
and ((from_unixtime(pr.mdate) >=  %s) and (from_unixtime(pr.cdate) is null ) or from_unixtime(pr.cdate) >= %s ) 
and ((from_unixtime(pr.mdate) <=  %s) and (from_unixtime(pr.cdate) is null ) or from_unixtime(pr.cdate) <= %s ) 

order by pr.product_id