SELECT SPECIES.Genus, SPECIES.Species, SPECIES.FBname, COUNTREF.PAESE, PicturesMain.PicName, PicturesMain.*, COLLABORATORS.WebPage, COLLABORATORS.CollabTypeOrder FROM ((PicturesMain LEFT JOIN COUNTREF ON PicturesMain.C_Code = COUNTREF.C_Code) INNER JOIN SPECIES ON PicturesMain.SpecCode = SPECIES.SpecCode) INNER JOIN COLLABORATORS ON PicturesMain.Entered = COLLABORATORS.Personnel WHERE (((PicturesMain.PictureType)='stamp')) AND PicturesMain.Scanned <> 0
Size (cm): |   |
Locality: | Guinea |
Sex: |   |
Date: | 1980-01-01 |
Reference: | Gibbons, S., 1999 Collect fish on stamps. |
Remark: |