My BGA Dashboard

MySQL exception (1055): Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'british_grooms_sql8.orderItems.oiPrId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Query: SELECT orId, orCnId, orDate, orStatus, orDelAd1, orDelAd2, orDelAd3, orDelTown, orDelPostcode, oiPrId, trId, trStatus FROM orders LEFT JOIN transactions on transactions.trOrId = orders.orId, orderItems, contacts WHERE cnId = orCnId AND orCnId='0' AND oiOrId=orId AND trId IS NOT NULL GROUP By orId ORDER by orId desc Called from: /var/www/html/public/widgets/payments-and-receipts-new.php:19