1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') )) AND
...' at line 4
SELECT id, id_detail, deleted, showcount, delable, partnumber, name, price, priceEUR, priceUSD, supplierPrice, discount, highlighted, storage, adddate, lastVisitDate, orderCount, download, weight, barcode, keywords, specialoffer, taxid, manufacturerId, productid, lang, descr, shortdescr, linedescr, seotitle, seodescription
FROM products
INNER JOIN products_details ON (products_details.productid=products.id)
WHERE products_details.lang=2 AND (id IN (SELECT productid FROM product_vs_category WHERE (categoryid=) )) AND
deleted='NO'
UNION
SELECT id, '' as id_detail, deleted, showcount, delable, partnumber, '' as name, price, priceEUR, priceUSD, supplierPrice, discount, highlighted, storage, adddate, lastVisitDate, orderCount, download, weight, barcode, keywords, specialoffer, taxid, manufacturerId, '' as productid, '' as lang, '' as descr, '' as shortdescr, '' as linedescr, '' as seotitle, '' as seodescription
FROM products
WHERE id not in (
SELECT products.id as id
FROM products
INNER JOIN products_details ON (products_details.productid=products.id)
WHERE products_details.lang=2 AND ( (id IN (SELECT productid FROM product_vs_category WHERE (categoryid=) )) AND
deleted='NO') ) AND ( (id IN (SELECT productid FROM product_vs_category WHERE (categoryid=) )) AND
deleted='NO') ORDER BY name ASC