select distinct faculty,maslul_id,hug_noten,ord,course,nekudot,line,page,shana_le_toar,toar,missing,siduri,semester ,egedid,sidurieged from mainShnaton as c where maslul_id=1236 and faculty=01 and page=1 order by line,ord,siduri

total:11 pages: 1 page: 1

select COUNT( distinct course) as total , MAX(page) as pages from mainShnaton as c where maslul_id=1236 and faculty=01