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 percentageFROM content_content c;