ERROR #23 in /srv/mse/src/lib/MSE/Helper/DB.class.php:
SELECT
si.*,
mCP.ID as channelProductId,
sim.title as brandName,
sim.description as brandFullName,
if (nvp.name is not null and nvp.name!='', nvp.name,sit.translation) as productTitle,
sitt.title as productTypeTitle
FROM shop_items as si
LEFT JOIN mseChannelProduct as mCP
ON mCP.productId = si.id_item
AND mCP.channelId = 49
INNER JOIN shop_items_manufacturers as sim
ON si.manufacturer_id = sim.id_manufacturer
LEFT JOIN cms_languages as cl
ON cl.code = 'en'
LEFT JOIN shop_items_translations as sit
ON sit.languageId = cl.id_language
AND sit.itemId = si.id_item
AND sit.typeId = 1
LEFT JOIN shop_items_nvp as nvp
ON nvp.item_id = si.id_item
AND nvp.category_id = 11
AND nvp.language_id = cl.id_language
AND nvp.active = 1
LEFT JOIN shop_itemtypes_titles as sitt
ON sitt.language_id = cl.id_language
AND sitt.itemtype_id = si.itemtype_id
AND sitt.ordering = 1
WHERE
si.id_item =
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 '' at line 38