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

total:148 pages: 11 page: 1

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