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 = %s


