Project banner
[ Home | Genome| Distribution| Habitats | Higher Taxa | Notes | Taxa | Synonyms | Conservation | Bibliography | Metadata ]

Browser - Conservation Status table

MySQL error 1054

Unknown column 'PMEtable0.' in 'ORDER BY'

phpMyEdit error: invalid SQL query

SELECT `PMEtable0`.`ID` AS `qf0`,CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) AS `qf1`,`PMEtable0`.`T_NO` AS `qf1_idx`,`PMEtable0`.`C_STATUS` AS `qf2`,`PMEtable0`.`C_STATUS` AS `qf2_idx`,CONCAT(IFNULL(CAST(`PMEjoin3`.`B_AUTHOR` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin3`.`B_YEAR` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin3`.`B_SEQUENCE` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin3`.`B_TITLE` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin3`.`B_DETAIL` AS CHAR),"")) AS `qf3`,`PMEtable0`.`B_NO` AS `qf3_idx` FROM `status` AS `PMEtable0` LEFT OUTER JOIN `taxa` AS `PMEjoin1` ON (`PMEjoin1`.`T_NO` = `PMEtable0`.`T_NO`) LEFT OUTER JOIN `bibliography` AS `PMEjoin3` ON (`PMEjoin3`.`B_NO` = `PMEtable0`.`B_NO`) ORDER BY CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) DESC,`PMEtable0`.``,`PMEtable0`.`C_STATUS` LIMIT 0, 15

Download as: Excel | CSV

Powered by ACACIA

Taxon name Conservation status Reference