SELECT A.lkp_pre_ID, A.lkp_opera, A.lkp_prm_id, A.lkp_motiv, B.prm_ente, B.prm_descr, A.lkp_ediz, A.lkp_anno, A.lkp_media, A.lkp_frazio, C.titolo AS ftit, D.titolo AS ltit FROM lnk_premi AS A LEFT JOIN premi AS B ON (A.lkp_prm_id = B.prm_ID) LEFT JOIN film AS C ON (A.lkp_opera=C.id) LEFT JOIN libri AS D ON (A.lkp_opera=D.ID) WHERE A.lkp_ana_ID='118527' AND A.lkp_vinto='1' ORDER BY A.lkp_anno: OK.
Chandra Wickramasinghe | [] astronomo |
Ha scritto:     La nuvola della vita [1979] . | |
2858