MySQL queries to pull product info


I don’t know if you can help but I’m trying to pull data about the stock items in MarketPress to display in a stock program I have. It operates on MySQL commands to pull the data.

My issue is pulling the meta_value entries in relation to the meta_key entries such as mp_order_total, mp_payment_info etc from the wp_postmeta table

Then I need to inner join with wp_posts table items. I can do basic MySQL syntax but am at a bit of a loss here.

If you can help it would be appreciated if not then I understand.