I have found separate queries that get me some things on their own, but the problem is that the sku order they each have is different, at a given row it changes so I cannot paste the results into a single document. The export tool for Products in magento gives horrendous mixed up rows, it is completely useless. So, since I dont know how the php syntax for magento and its folder architecture is, I cant do it that way, I only am familiar with SQL but not so much with magento tables EAV.
For example the query for price gets me these results
product_id price 1 45 2 56 3 98 etc
but the query for description gets them so
product_id description 3 this is description for item 3 1 this is description for item 1 2 as you see, we cant match up all results
For price I have found in SO
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `cp8_catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
SELECT e.entity_id, e.sku, eav.value AS 'description' FROM cp8_catalog_product_entity e JOIN cp8_catalog_product_entity_text eav ON e.entity_id = eav.entity_id JOIN cp8_eav_attribute ea ON eav.attribute_id = ea.attribute_id WHERE ea.attribute_code = 'description'
So, I am strugling to get one complete result that contains:
product_id, name, description, price, url to the image, meta keywords, etc