SELECT samor_edx40.ttt_products.*, IF (ttt_products_lng.product IS NOT NULL,ttt_products_lng.product, ttt_products.product) AS product, IF (ttt_products_lng.descr IS NOT NULL,ttt_products_lng.descr, ttt_products.descr) AS descr, IF (ttt_products_lng.full_descr IS NOT NULL,ttt_products_lng.full_descr, ttt_products.fulldescr) AS fulldescr FROM ttt_products LEFT JOIN ttt_products_lng ON ttt_products.productid=ttt_products_lng.productid AND ttt_products_lng.code='US' INNER JOIN ttt_thumbnails ON ttt_products.productid=ttt_thumbnails.productid WHERE ttt_products.productid IN ('31','16143','16136','34','43')