Can anyone tell me what SQL syntax is used to display the product info?

I need an external sql routine that I want to put into Excel to create a catalog.

I want to duplicate my product display info as close as possible with attributes, additional image etc...

I'm looking in the ZenCart code, but I can't really make it out and Easy Populate is not very friendly.