select contentType.*, contentTypeMode.addonName, contentTypeMode.template, skins.name AS skins_name, skins.filename FROM contentType LEFT JOIN contentTypeMode ON (contentType.contentMode=contentTypeMode.id) LEFT JOIN skins ON (contentType.skinsID=skins.id) WHERE contentType.id=1108