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

FROM <@PREFIX>jshopping_products,<@PREFIX>jshopping_products_description where
<@PREFIX>jshopping_products.products_id = <@PREFIX>jshopping_products_description.products_id
and <@PREFIX>jshopping_products_description.language_id = <@LANGUAGE_ID@>


