Something
public sql v1 · immutableselect id,name,(SELECT COUNT(*) FROM content_filename WHERE content_id=content_content.id) AS total_files,(SELECT total_files) as xFROM content_content;results in : SQL error: no such column: total_filesselect id,name,(SELECT COUNT(*) FROM content_filename WHERE content_id=content_content.id) AS total_files,(SELECT total_files) as xFROM content_content;results in : SQL error: no such column: total_files