I'm trying to learn magento but I have to finish the project that I'm working on as fast as I can. So I'm stuck in somewhere. Then I decided to use pure sql. (I know it's really messy)
So is anynone know how can I get all products with sql? I researched database but can't find.
I need product name, thumbnail, price, rating, reviews count and attributes.