How to find the parent category of a product on Open Cart?

Question

PHP

What sql query can be used to find out the parent category of a product in Open Cart, knowing only the id of the product itself and the id of the subcategory in which it is nested? Open Cart Version 1.5.6

Answer 1

Judging by the diagram , it will be something like:

SELECT p.* FROM category AS c LEFT JOIN category AS p ON c.parent_id = p.id WHERE c.id = :product_category_id