SELECT B.izenburua, B.url, C.izenburua AS mota, C.nice_name FROM (loturak AS A INNER JOIN loturak_hizkuntzak AS B ON A.id=B.fk_elem) LEFT JOIN loturamotak_hizkuntzak AS C ON C.fk_elem=A.mota AND C.fk_hizkuntza='1' WHERE B.fk_hizkuntza='1' AND TRIM(B.url)<>'' and C.nice_name='euskal-kantutegia' ORDER BY C.izenburua ASC, B.izenburua ASC
Euskal Kantuzaleen Elkartea
