Project banner

Browser - Distribution table

MySQL error 1054

Unknown column 'PMEtable0.P_AREA' in 'field list'

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`.`P_CONTINENT` AS `qf2`,`PMEtable0`.`P_CONTINENT` AS `qf2_idx`,`PMEtable0`.`P_COUNTRY` AS `qf3`,`PMEtable0`.`P_AREA` AS `qf4`,`PMEtable0`.`P_SUBAREA` AS `qf5`,`PMEtable0`.`P_LOCALITY` AS `qf6`,`PMEtable0`.`P_LATITUDE` AS `qf7`,`PMEtable0`.`P_LONGITUDE` AS `qf8`,`PMEtable0`.`P_CODE` AS `qf9`,`PMEtable0`.`P_I_STATUS` AS `qf10`,`PMEtable0`.`P_I_STATUS` AS `qf10_idx`,CONCAT(IFNULL(CAST(`PMEjoin11`.`B_AUTHOR` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin11`.`B_YEAR` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin11`.`B_SEQUENCE` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin11`.`B_TITLE` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin11`.`B_DETAIL` AS CHAR),"")) AS `qf11`,`PMEtable0`.`B_NO` AS `qf11_idx` FROM `distribution` AS `PMEtable0` LEFT OUTER JOIN `taxa` AS `PMEjoin1` ON (`PMEjoin1`.`T_NO` = `PMEtable0`.`T_NO`) LEFT OUTER JOIN `bibliography` AS `PMEjoin11` ON (`PMEjoin11`.`B_NO` = `PMEtable0`.`B_NO`) ORDER BY CONCAT(IFNULL(CAST(`PMEjoin11`.`B_AUTHOR` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin11`.`B_YEAR` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin11`.`B_SEQUENCE` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin11`.`B_TITLE` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin11`.`B_DETAIL` AS CHAR),"")) DESC,`PMEtable0`.`P_AREA`,`PMEtable0`.`P_SUBAREA`,`PMEtable0`.`P_CONTINENT`,CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) LIMIT 0, 15

Download as: Excel | CSV | KML


Powered by ACACIA

Taxon name Continent/Ocean Country State/Province County Locality Latitude Longitude Longitude Occurrence status Reference