1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 21
SELECT DISTINCT p.products_fsk18, p.products_shippingtime, p.products_model,
p.products_ean, pd.products_name, m.manufacturers_name,
p.products_quantity, p.products_image, p.products_weight,
pd.products_short_description, pd.products_description, p.products_id,
p.manufacturers_id, p.products_price, p.products_vpe,
p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed,
p.products_tax_class_id
FROM products_description pd, products_to_categories p2c, products p
LEFT JOIN manufacturers m
ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN specials s
ON p.products_id = s.products_id
LEFT JOIN personal_offers_by_customers_status_1 po
ON p.products_id = po.products_id
WHERE p.products_status = '1'
AND p.products_id = p2c.products_id
AND pd.products_id = p2c.products_id
AND pd.language_id = '2'
AND p2c.categories_id = '3528' ORDER BY IFNULL(po.personal_offer,p.produ ASC