select distinct f_fomenupont_de,f_almenupont_de,f_almenukod,f_almenupont_eng,f_fomenupont_eng,f_fomenuleiras from fomenulacertaoptics join aru on (a_almenu1 = f_almenukod or a_almenu2 = f_almenukod or a_almenu3 = f_almenukod) where f_fomenupont_eng like 'Sun and spectroscopy' and astro= 1 and (select count(*) from aru where a_almenu1 = f_almenukod or a_almenu2 = f_almenukod or a_almenu3 = f_almenukod ) > 0 order by f_sorrend asc