MySQL error 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC,PMEtable0.Location DESC,PMEtable0.InvestmentDate,PMEtable0.BusinessDescript' at line 1

phpMyEdit error: invalid SQL query


SELECT PMEtable0.InvestmentDate AS qf0,UNIX_TIMESTAMP(PMEtable0.InvestmentDate) AS qf0_timestamp,PMEtable0.ExitDate AS qf1,UNIX_TIMESTAMP(PMEtable0.ExitDate) AS qf1_timestamp,PMEtable0.PortfolioStatus AS qf2,PMEtable0.PortfolioCompany AS qf3,PMEtable0.Industry AS qf4,PMEtable0.BusinessDescription AS qf5,PMEtable0.Location AS qf6 FROM InvestmentHistory AS PMEtable0 ORDER BY PMEtable0.PortfolioStatus,PMEtable0.Industry DESC,PMEtable0. DESC,PMEtable0.Location DESC,PMEtable0.InvestmentDate,PMEtable0.BusinessDescription,PMEtable0.
Investment Date Exit Date Portfolio Status Portfolio Company Industry Business Description Location