这是之前改好的：

select ma.id,ma.title,ma.specification,sum(m.num*p.num) num,o.province,o.city from `order` o 

 join order_product p on p.order_id=o.id 

 join product_template t on p.item_template_id=t.id 

 join product_material m on m.product_id=t.id

 join material ma on ma.id=m.material_id

 where o.created between UNIX_TIMESTAMP('${tstart1}') and UNIX_TIMESTAMP('${tend1}')+86400 

and o.done_time between UNIX_TIMESTAMP('${pstart1}') and UNIX_TIMESTAMP('${pend1}')+86400 

and o.pay_status=2 and o.status=99

 /*and o.province="广东省" and o.city="深圳市"*/

 /* where o.created > 1631281869 */

 group by ma.id,ma.title,ma.specification,o.province,o.city;

-

-

-

但是用户说希望既可以同时使用，又可以单独使用其中一个