SELECT "content_content"."id","content_content"."signature","content_content"."name","content_content"."autoname","content_content"."location","content_content"."url","content_content"."added_date",(SELECT ROUND(CAST((SELECT COUNT(cf.id) FROM content_filename cf LEFT JOIN content_filename_users_seen cs ON cs.filename_id = cf.id WHERE cs.user_id = 1 AND cf.content_id=content_content.id) AS REAL) / CAST((SELECT COUNT(*) FROM content_filename WHERE content_id=content_content.id) AS REAL) * 100)) AS "percentage_seen",(SELECT COUNT(*) FROM content_filename WHERE content_id=content_content.id) AS "files_total",(SELECT COUNT(cf.id) FROM content_filename cf LEFT JOIN content_filename_users_seen cs ON cs.filename_id = cf.id WHERE cs.user_id = 1 AND cf.content_id=content_content.id) AS "files_seen" FROM "content_content" ORDER BY "files_total" DESC