Actually, the data is stored in the orders_products table as taken from the products and products_description table in the event that you delete, change or otherwise alter the Product itself ...

Trying to pull from the products and products_description table after the fact is risky, and it might be worth the effort to have that information gathered during the Order itself as well ...