SELECT DISTINCT
SPECIES.Genus AS ResultField1,
SPECIES.Species AS ResultField2,
SPECIES.Author AS ResultField3,
SPECIES.FBname AS ResultField4,
SPECIES.FamCode AS ResultField5,
SPECIES.SpecCode AS ID_Field,
SPECIES.Length AS ResultField6,
SPECIES.LTypeMaxM AS ResultField7,
SPECIES.LengthFemale AS ResultField20,
SPECIES.LTypeMaxF AS ResultField21,
synonyms.year,
FAMILIES.CommonName,
FAMILIES.Family FROM (FAMILIES RIGHT JOIN SPECIES ON FAMILIES.FamCode = SPECIES.FamCode) INNER JOIN COUNTRY ON SPECIES.SpecCode = COUNTRY.SpecCode LEFT JOIN synonyms ON species.speccode = synonyms.speccode WHERE (FAMILIES.FamCode =SPECIES.FamCode) AND (synonyms.valid <> 0) And ((FAMILIES.FamCode)=277) And ((COUNTRY.C_Code)='380') AND (COUNTRY.status <> 'misidentification' OR 'error' OR 'not established') ORDER BY species.genus, species.species