SELECT
core.[id],core.*
, JOINdocument_type_id.[name] AS document_type_idname
FROM [document] AS core
LEFT JOIN [document_type] AS JOINdocument_type_id ON JOINdocument_type_id.[id] = core.[document_type_id]
WHERE
core.[id] = '10'
AND core.[status_id] IN('1','1')