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 ')
    LEFT JOIN
        xt_units_details as unit ON(main.unit = unit.id AND unit' at line 35<br><br>
    SELECT
        ad.id,
        img.image_id,
        img.image_version,
        ad.title,
        ad.lead,
        ad.active,
        f.value as field_text,
        f2.value as big_img_id,
        f3.value as anz_anwendungen,
        main.quantity,
        unit.short as unit,
        main.art_nr,
        p.price,
        p.buyable,
        f4.value as subline,
        f5.value as anw_icon
    FROM
        xt_catalog_articles_details as ad
    LEFT JOIN
        xt_catalog_articles_images as img ON (img.article_id = ad.id AND img.is_main_image = 1)
    LEFT JOIN
        xt_shop_articles as p ON(p.article_id = ad.id)
    LEFT JOIN
        xt_catalog_articles as main ON(main.id = ad.id)
    LEFT JOIN
        xt_catalog_articles_fields as f ON(f.article_id = ad.id AND f.lang='fr' AND f.fieldname_id=4)
     LEFT JOIN
        xt_catalog_articles_fields as f2 ON(f2.article_id = ad.id AND f2.lang='fr' AND f2.fieldname_id=33)
     LEFT JOIN
        xt_catalog_articles_fields as f3 ON(f3.article_id = ad.id AND f3.lang='fr' AND f3.fieldname_id=38)
    LEFT JOIN
        xt_catalog_articles_fields as f4 ON(f4.article_id = ad.id AND f4.lang='fr' AND f4.fieldname_id=36)
 	LEFT JOIN
        xt_catalog_articles_fields as f5 ON(f5.article_id = ad.id AND f5.lang='fr' 	AND f5.fieldname_id=)
    LEFT JOIN
        xt_units_details as unit ON(main.unit = unit.id AND unit.lang='fr')
    WHERE
        ad.lang='fr'
    AND
        ad.active=1
    AND
        main.id=<br><br>In File: <span style="color:red;">/var/www/vhosts/just.ch/httpdocs/xt/plugins/ch.iframe.snode.catalog/product_details/index.php</span><br />On Line: <span style="color:red;">52</span>