[Dos and Don’ts #1] frappe.db.get_value - Developers - ERPNext Forum
From the link above stated the frappe.db.sql is not a good way to run the sql query, so:
Expectation result:
i want to replace the frappe.db.sql
(left side) to frappe.db.get_all
(right side) and i cant find out the error for filters
and order_by