SELECT id,
Name,
(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 = c.id) AS seen,
(SELECT count(cf2.id) as totalamt FROM content_filename cf2 WHERE cf2.content_id = c.id) AS totalamt,
( ((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 = c.id) / (SELECT count(cf2.id) as totalamt FROM content_filename cf2 WHERE cf2.content_id = c.id)) * 100 ) as percentage
FROM content_content c;