Zend certified PHP/Magento developer

Get all products + product attributes under a category using MYSQL query

Is it possible to formulate an SQL that gets all products along with its product attributes (instead of just name, description, etc as what I have mostly seen on the internet) of a certain category?