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

total:31 pages: 2 page: 1

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