SQL Query to get all Products?
There isn't an easy solution for this since the field data is stored in multiple tables and is based on configuration which is also stored in the DB.

You're better off trying to use Registry Rebuild and Commerce Repair to get the site working and then using export tools to get the data.