SELECT t1.IDN, IFNULL(t2.itemName, t1.itemName) AS itemName, t1.priceFrom, t1.priceCcy, t1.itemImageSmall, t1.itemImageMedium, t1.itemImageBig, t1.itemUrl, t1.itemType, t2.itemDesc, t2.langIDN FROM
promo_front_items AS t1
LEFT JOIN
promo_front_items_desc AS t2
ON(t1.IDN = t2.itemIDN)
AND
t2.langIDN = 2
WHERE
t1.vstatus=1
AND
t1.IDN = 649%E2%8C%A9IDN=3