Courses in numerical order by code

2001-2002 a.y.

Filter the list of courses

GO TO THE CODES...

SELECT DISTINCT dida_ins_codice,dida_ins_desc_ita,dida_ins_desc_eng FROM dida_insegnamenti,tsn_insegnamenti, tsn_t_raggruppamenti,tsn_d_raggruppamenti WHERE tsn_ins_codice_ist NOT IN ('25','000025') AND dida_ins_codice=tsn_ins_codice_ins AND tsn_ins_codice_ins=tsn_trag_codice_ins AND tsn_ins_anno_acc=tsn_trag_anno_acc AND tsn_ins_deleted='n' AND tsn_trag_id= tsn_drag_rif_t_raggrup AND (tsn_trag_codice_ins LIKE '2%' OR tsn_trag_codice_ins LIKE '3%' OR tsn_trag_codice_ins LIKE '5%' OR tsn_trag_fase='p') AND tsn_trag_anno_acc=tsn_drag_anno_acc AND tsn_drag_anno_acc='2002' AND dida_ins_deleted='n' ORDER BY dida_ins_codice ;

0  100  300  400  500  600  700  800  900  5000  



0