SELECT 
<@PREFIX>products.products_id, 
<@PREFIX>products.products_quantity, 
<@PREFIX>products.products_model, 
<@PREFIX>products.products_image, 
<@PREFIX>products.products_price, 
<@PREFIX>products.products_date_added, 
<@PREFIX>products.products_last_modified, 
<@PREFIX>products.products_date_available, 
<@PREFIX>products.products_weight, 
<@PREFIX>products.products_status, 
<@PREFIX>products.products_tax_class_id, 
<@PREFIX>products.manufacturers_id, 
<@PREFIX>products.products_ordered, 
<@PREFIX>products_description.products_name

FROM <@PREFIX>products,<@PREFIX>products_description where
<@PREFIX>products.products_id = <@PREFIX>products_description.products_id 
and <@PREFIX>products_description.language_id = <@LANGUAGE_ID@>
and ((<@PREFIX>products.products_date_added >=  <@FROMDATE@>) and (<@PREFIX>products.products_last_modified is null or <@PREFIX>products.products_last_modified =  00000000 ) or <@PREFIX>products.products_last_modified >= <@FROMDATE@> ) 
and ((<@PREFIX>products.products_date_added <=  <@TODATE@>) and (<@PREFIX>products.products_last_modified is null or <@PREFIX>products.products_last_modified =  00000000 ) or <@PREFIX>products.products_last_modified <= <@TODATE@> ) 
order by products_id

