i cant filter no transaction in 30 days
for ex. select * from tblmasterlist where re_order_level = '-1', interval (30) "

how?

Few will guess why you can't do this. Supply a minimal viable example.

commented: for ex. select * from tblmasterlist where re_order_level = '-1', interval (30) " +0