SELECT count(*) 'No',e.id  from exam_class_info e inner join exam_class ec on ec.exam_info=e.id 
  where e.acedemic_year='' and e.class_id in ('') and ec.subject_id ='' and e.exam_type_id = ''{"no":"1","id":"23"}