SELECT 
	ntc.*, 
	DATE_FORMAT(ntc.not_data_cadastro, '%d/%m/%Y - %H:%i') AS dataCADASTRO,
	aut.nome_autor 
FROM 
	not_noticias ntc
INNER JOIN 
	autores aut ON ntc.not_id_autor = aut.idautores
WHERE 
	ntc.idnoticias = :id