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