SELECT 
p.product_id products_id, 
p.product_quantity products_quantity, 
p.product_code products_model, 
'' products_image, 
pd.price_value products_price, 
p.product_modified products_date_added, 
p.product_modified products_last_modified, 
p.product_sale_start products_date_available, 
p.product_weight products_weight, 
p.product_published products_status, 
p.product_tax_id products_tax_class_id, 
p.product_vendor_id manufacturers_id, 
0 products_ordered, 
p.product_name products_name

FROM <@PREFIX>hikashop_product p,<@PREFIX>hikashop_price pd where
p.product_id = pd.price_product_id 
and pd.price_currency_id = <@LANGUAGE_ID@>
and (from_unixtime(p.product_modified) >=  <@FROMDATE@>) 
and (from_unixtime(p.product_modified) <=  <@TODATE@>) 
order by product_id

