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=7873 and faculty=07 and page=1 order by line,ord,siduri

total:29 pages: 3 page: 1

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