Fatal error: Uncaught [42000] - 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 'GROUP BY sp.id ORDER BY FIELD(plan_id, "4") DESC, FIELD(s.state,'Virginia') DESC' at line 1
trace: #0 /var/www/findingmfg/src/includes/rb.php(1079): RedBeanPHP\Driver\RPDO->runQuery()
#1 /var/www/findingmfg/src/includes/rb.php(4243): RedBeanPHP\Driver\RPDO->GetAll()
#2 /var/www/findingmfg/src/includes/rb.php(11439): RedBeanPHP\Adapter\DBAdapter->get()
#3 /var/www/findingmfg/src/includes/rb.php(12435): RedBeanPHP\Facade::query()
#4 /var/www/findingmfg/src/front_handler/get-product-listings.php(70): RedBeanPHP\Facade::getAll()
#5 /var/www/findingmfg/src/product-listings.php(438): include('/var/www/findin...')
#6 /var/www/findingmfg/index.php(133): include('/var/www/findin...')
#7 {main}
thrown in /var/www/findingmfg/src/includes/rb.php on line 809