SELECT payee, amount, type, date, type_id FROM 
    `expenses` join payees on payees.id = expenses.payee_id 
    join types on payees.type_id = types.id where 1 order by type , date