SELECT
                            product_brand.id,
                            product_brand.position,
                            product_brand.name,
                            product_brand.description,
                            product_brand.image,
                            product_brand.url,
                            GROUP_CONCAT(p.name ORDER BY p.left SEPARATOR "|") as parents,
                            product_brand.special,
                            UNIX_TIMESTAMP(product_brand.edit) AS edit
                        FROM
                            product_brand,
                            product_brand as p
                        WHERE
                            1
                            AND p.left <= product_brand.left AND p.right >= product_brand.right
                        GROUP BY
                            product_brand.id
                        ORDER BY
                            product_brand.name asc