SELECT q.ims_code,count(q.ims_code) as ims_total_count,M.name,M.score_board_order,M.Id as exam_id,M.view_question_hr , M.section_id,GROUP_CONCAT(DISTINCT M.section_id) as coded_section,GROUP_CONCAT(DISTINCT REPLACE(SUBSTRING_INDEX(M.name,'Sec', 1) ,'New ','') ) as coded_test_name, count(q.ims_code) as ims_code_count,q.question_password,qcat.name as topic_name,qsubcat.name as cat_name, qsubcat.description as sub_cat_name,
  GROUP_CONCAT( DISTINCT UPPER( REPLACE(LOWER(q.question_code),'new','') ) ) as coded_que,GROUP_CONCAT( DISTINCT q.ID ) as coded_que_id,GROUP_CONCAT(q.exam_id) as coded_exam_id
  FROM y2a_watupro_question as q
  INNER JOIN y2a_watupro_master as M on q.exam_id = M.ID
  LEFT JOIN y2a_watupro_qcats as qcat ON q.cat_id = qcat.ID
  LEFT JOIN y2a_watupro_qsub_cats as qsubcat ON q.sub_cat_id = qsubcat.ID
  WHERE q.ID IN (SELECT question_id from y2a_watupro_student_answers WHERE

       CASE is_correct WHEN ims_total_count THEN  '1,0' ELSE '0' END

   AND taking_id IN (SELECT t.ID from y2a_watupro_taken_exams as t INNER JOIN y2a_test_score_board_section as s on s.ID = t.section_id WHERE s.sc_id =0 AND t.user_id=5270 AND t.trial_status = 1 AND t.in_progress = 0 AND t.isActive = 1 ) )  GROUP BY M.score_board_order,q.ims_code ORDER BY M.score_board_order ASC