how to get all the default category of all my products?

[archproject]

hi,

i want to extract all my product's default category either from bo or from database cuz i need to check all my products are in the right default category

how can i do this? Select statement??

[RJGonzalez]

Best way since you mention database is to go in yout phpMyAdmin and download sql with the following:

ps_category
ps_category_group
ps_category_lang
ps_category_product
ps_product
ps_product_attachment
ps_product_attribute
ps_product_attribute_combination
ps_product_attribute_image
ps_product_comment
ps_product_comment_criterion
ps_product_comment_criterion_product
ps_product_comment_grade
ps_product_download
ps_product_lang
ps_product_sale
ps_product_tag

Just make sure you know what you are doing, and please back up database before start playing with it

[archproject]

Thanks for the reply RJGonzalez but all I wanted was a select statement to select all my products with it's default category. I know how to do this in oracle but not in mysql

something like

select product_id, product_name, default_category from products;

Regards
Archproject