SELECT a.product_id products_id,
 a.product_quantity products_quantity, 
 a.product_ean products_model,
 a.`name_nl-NL` products_name
, 
concat('img_products/', b.image_name) products_image,  
a.product_price products_price, 
 a.product_date_added products_date_added,
  a.date_modify products_last_modified,  
a.product_date_added products_date_available, 
 a.product_weight products_weight, 
 a.product_publish products_status
, 
 a.product_tax_id products_tax_class_id, 
 a.product_manufacturer_id manufacturers_id,
  0 products_ordered 

 FROM 
<@PREFIX>jshopping_products a
left join <@PREFIX>jshopping_products_images b 
on (a.product_id = b.product_id and b.ordering = 1)
 

  where
 
 ((a.product_date_added >=  <@FROMDATE@>) and (a.date_modify is null  ) or 
a.date_modify >= <@FROMDATE@> ) 
and ((a.product_date_added <=  <@TODATE@>) and (a.date_modify is null  ) 
or a.date_modify <= <@TODATE@> ) 
order by 1

