343 monthlyMethods.php query SELECT msc.* ,u.username ,vsid ,vsname ,ccourse ,mpc_score FROM et_monthly_score_course msc JOIN et_user u ON u.id=msc.msc_uid LEFT JOIN et_school_members sm ON sm.vsuid=u.id LEFT JOIN et_school vs ON vs.id=sm.vsid JOIN et_course c ON c.id=msc.msc_cid JOIN et_monthly_possible_course mpc ON mpc.mpc_cid=msc.msc_cid AND mpc.mpc_yyyy = msc_yyyy AND mpc.mpc_mm = msc_mm WHERE msc_yyyy = "2020" AND msc_mm = "07" AND msc_uid = "1" ORDER BY msc_yyyy DESC ,msc_mm DESC ,msc_cid ,msc_score DESC

Monthly Grades

Current Month : 2020/08 Not CLOSED YET!