How to tell which products are not catgorized via phpmyadmin

Question

I'm trying to pull a list of all products that are not in categories via php-myadmin, is this possible? What is the best way to go about doing this?

Answer 1

This SQL query will give you a list of all "uncategorized" skus:

select sku 
from catalog_product_entity as e 
left join catalog_category_product as cat 
    on e.entity_id = cat.product_id where  category_id is null

---

EDIT: If you want to fetch more data, you need to pick it up from proper EAV tables, here is a basic sample demonstrating the principle:

set @name_attribute_id =  (SELECT attribute_id FROM  `eav_attribute` INNER JOIN `eav_entity_type` ON entity_type_code = 'catalog_product' AND  eav_entity_type.entity_type_id = `eav_attribute`.entity_type_id where attribute_code in ('name'));

select sku, created_at, updated_at, name_table.value as product_name
from catalog_product_entity as e 
left join catalog_category_product as cat 
    on e.entity_id = cat.product_id 
left join catalog_product_entity_varchar as name_table 
    on e.entity_id = name_table.entity_id and name_table.attribute_id = @name_attribute_id
where category_id is null