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〈IDN=2