I got the attribute ids I want to get from the database, they are 426, 74, 439, 92, 81, 425. In addition to those I want the product name, sku and the categories the product is in. The products visibility should be
This is what I got so far:
SELECT DISTINCT cpev.`value` as Name, cpe.sku as SKU, #cpe.*, #cpev.*, ea.attribute_code FROM catalog_product_entity_varchar cpev INNER JOIN catalog_product_entity cpe ON cpev.entity_id = cpe.entity_id INNER JOIN eav_attribute ea on cpev.attribute_id = ea.attribute_id where ea.attribute_id in (426, 74, 439, 92, 81, 425);
Not exactly what I need, but maybe a start. How could I get the data I need from the DB?