{"sql":"\nSELECT \n    t.*,\n    s.note as package_info,\n    s.name as package_name,\n    DATE_FORMAT(t.timestamp, '%Y %M %d') as day, \n    TIME_FORMAT(t.timestamp, '%H:%i') as time,\n    format(t.amount,0) as amount_text,\n    IF(t.state = 1, 'true', null) as is_verified\nFROM \n    transactions as t\n    join subscription_packages as s on s.id = t.SID\nwhere \n    t.type = 4 and \n    t.sender = :user\norder by id desc","input":{"user":false},"success":true,"data":[],"count":0,"empty":true}