Edit History

8 minutes ago, idnovate.com said:

Maybe you have a different database prefix than "ps_"?

I wrote the reason why it doesn't work.
When you put the query in phpMyAdmin, it works.
It does not work only in Prestashop SQL manager, because GROUP_CONCAT is not enabled.

https://docs.prestashop-project.org/1.7-documentation/user-guide/configuring-shop/advanced-parameters/database/sql-manager