SQL ERROR ON QUERY:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY B.hardware, B.benchmark_cert_date DESC' at line 1
SQL=SELECT B.benchmark_seq, B.suite, B.platform, B.hardware, B.software,display_company_user_flag, B.benchmark_notes, B.certification_status, B.score_url, B.certified_by_lab, B.benchmark_cert_date, B.power_energy_flag, B.mark1, B.mark2, B.mark3, B.mark4, B.mark5, B.mark6, B.mark7, B.mark8, B.mark9, B.mark10, B.mark11, B.power_mark1, B.power_mark2, B.power_mark3, B.power_mark4, B.power_mark5, B.power_mark6, B.power_mark7, B.power_mark8, B.power_mark9, B.power_mark10, B.power_mark11, U.first_name, U.last_name, M.company, CT.description as certification_type_desc, BT.description as benchmark_type_desc, ST.mark_tm, ST.mark_tm2, ST.mark_tm3, ST.mark_tm4, ST.mark_tm5, ST.mark_tm6, ST.mark_tm7, ST.mark_tm8, ST.mark_tm9, ST.mark_tm10, ST.mark_tm11, ST.power_mark_tm, ST.power_mark_tm2, ST.power_mark_tm3, ST.power_mark_tm4, ST.power_mark_tm5, ST.power_mark_tm6, ST.power_mark_tm7, ST.power_mark_tm8, ST.power_mark_tm9, ST.power_mark_tm10, ST.power_mark_tm11, ST.score_col1_flag, ST.score_col1_pro_desc, ST.score_col1_sim_desc, ST.score_col2_pro_desc, ST.score_col2_sim_desc, ST.score_col5_pro_desc, ST.score_col5_sim_desc, ST.score_col6_pro_desc, ST.score_col6_sim_desc FROM Benchmark B INNER JOIN BenchmarkType BT ON BT.benchmark_type = B.benchmark_type INNER JOIN CertificationType CT ON CT.Certification_type = B.certification_type INNER JOIN Suite ST ON ST.suite = B.suite LEFT JOIN User U ON U.user_seq=B.user_seq LEFT JOIN MemberCompany M ON M.member_seq=U.member_seq WHERE B.benchmark_seq IN () ORDER BY B.hardware, B.benchmark_cert_date DESC