select id,name,
(SELECT COUNT(*) FROM content_filename WHERE content_id=content_content.id) AS total_files,
(SELECT total_files) as x
FROM content_content;

results in : SQL error: no such column: total_files