Запрос для расчета процента.. Или его можно как-то преобразовать из mysql в redbean
$percent = \R::getAll ("SELECT product.* SUM(pay.summa)/product.price *100 AS 'percent' FROM product JOIN pay ON product.paysystem_id = pay.pay_id GROUP BY product.id");
Выдает ошибку :
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 'SUM(pay.sum)/product.pricen *100 AS 'percent' FROM product JOIN pay ON pr' at line 1