Sorry, there has been an error on:select CategoryID,  ifnull((select Categoryname from categorynames where languageid=2 and categorynames.categoryid=categories.categoryid) , categories.Category) catname , ifnull((select CategorynameShort from categorynames where languageid=2 and categorynames.categoryid=categories.categoryid) , categories.Category) catnameshort,  ifnull((select CategoryKeywords from categorynames where languageid=2 and categorynames.categoryid=categories.categoryid) , categories.CategoryKeywords) CategoryKeywords  From categories  where CategoryID=