select
a.*,
b.name as s_code_name
from
grades a
inner join grades_codes b on a.l_code = b.l_code and a.m_code = b.m_code and a.s_code = b.s_code and a.lang = b.lang
where a.status = '1' and a.lang = 'ENG' and a.l_code = '03'
order by a.l_code asc, a.m_code asc, a.orders asc, a.idx desc
limit ?, ?