How to check the last usage of every payment method in Magento 1?

[dmitrii_fediuk]

SELECT MAX(o.created_at) as time, p.method
FROM sales_flat_order o JOIN sales_flat_order_payment p
ON p.parent_id = o.entity_id
GROUP BY p.method
ORDER BY time DESC;