Das muß eher so aussehen:
(nicht getestet !)
$export_query = xtc_db_query("SELECT
p.products_id,
pd.products_name,
pd.products_description,
p.products_model,
p.products_ean,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
m.manufacturers_name,
pv.products_vpe_name
FROM
" . TABLE_PRODUCTS . " p
LEFT JOIN
" . TABLE_MANUFACTURERS . " m
ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN
" . TABLE_PRODUCTS_DESCRIPTION . " pd
ON p.products_id = pd.products_id AND
pd.language_id = '".$_SESSION['languages_id']."'
LEFT JOIN
" . TABLE_SPECIALS . " s
ON p.products_id = s.products_id
LEFT JOIN
" . TABLE_PRODUCTS_VPE . " pv
ON p.products_vpe = pv.products_vpe_id
WHERE p.products_status = 1
ORDER BY p.products_date_added DESC,
pd.products_name");
Hab's mal anders formatiert damits übersichtlicher ist.
Gruß,
noRiddle