SELECT content.*, languages.short, types.name FROM `content` LEFT JOIN `languages` ON content.language_id = languages.id LEFT JOIN `types` ON content.type_id = types.id WHERE content.parent = '16' AND languages.short = 'nl' AND content.active = 'Y' AND content.public = 'Y' ORDER BY `sort` ASC, `date_publish` DESC Ivacon Engineering - Lopende Projecten