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?
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