Hello!
I want to use SQL Query to get a full path of a product
The following is not working if the default category is a subcategory
Can someone help ?
Actual url
https://www.stickit.gr/en/Posters/series/nothing-worth-having-comes-easy-aesthetic-poster
Query result (Missing "Posters" from url)
https://www.stickit.gr/en/series/nothing-worth-having-comes-easy-aesthetic-poster
I cannot write my sql here, see the screenshot, the code is blocked from prestahop!