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 = '5'
AND languages.short = 'nl'
AND content.active = 'Y'
AND content.public = 'Y' ORDER BY `sort` ASC, `date_publish` DESC
Ivacon Engineering - VACATURE