select * from agorariosettim inner join aginsegnamenti on agimcode=agosimcode inner join agmaterie on agmcode=agimmcode inner join aginsegnanti on agicode=agiminscode inner join agorascolast on agocode=agosoraicode left join agclassi on agccode=agimccode left join (select * from agattclassi left join agattivita on agacode=agacatt and agatipo=0) as lab on agacclasse=agccode and agadata=agosggcode * 86400 and againizio <= extract(HOUR FROM agoorainizio) * 60 + extract (MINUTE FROM agoorainizio) and agafine >= extract(HOUR FROM agoorafine) * 60 + extract (MINUTE FROM agoorafine) left join aglab on aglcode=agaaula where agccode=17485;