Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'system, COUNT(NULLIF(TRIM(price), '')) AS listed, SUM(price) as cost from `stell' at line 1 in /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php:359
Stack trace:
#0 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php(359): PDO->prepare()
#1 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php(696): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php(663): Illuminate\Database\Connection->runQueryCallback()
#3 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php(367): Illuminate\Database\Connection->run()
#4 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2352): Illuminate\Database\Connection->select()
#5 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2340): Illuminate\Database\Query\Builder->runSelect()
#6 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2874): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2341): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /opt/bitnami/apache/htdocs/public/stellar/index.php(36): Illuminate\Database\Query\Builder->get()
#9 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 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 'system, COUNT(NULLIF(TRIM(price), '')) AS listed, SUM(price) as cost from `stell' at line 1 (SQL: select SQL_CALC_FOUND_ROWS COUNT(id) as ids, system, COUNT(NULLIF(TRIM(price), '')) AS listed, SUM(price) as cost from `stellar` group by `system` having ids = listed order by `cost` asc limit 12 offset 0) in /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php:703
Stack trace:
#0 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php(663): Illuminate\Database\Connection->runQueryCallback()
#1 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php(367): Illuminate\Database\Connection->run()
#2 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2352): Illuminate\Database\Connection->select()
#3 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2340): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2874): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Query/Builder.php(2341): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /opt/bitnami/apache/htdocs/public/stellar/index.php(36): Illuminate\Database\Query\Builder->get()
#7 {main}
thrown in /opt/bitnami/apache/htdocs/moon/vendor/illuminate/database/Connection.php on line 703