How get 'product_name' with Attribute Value, but without Attribute Group?

[JirkaDeLucina]

Hi,

I call in PS 1.7.4:

...

SELECT psod.*, msod.*, pl.`name` as `product_name`, pl.`description`, pl.`link_rewrite` FROM `' . _DB_PREFIX_ . 'order_detail` as psod

and if I want to write it on page, I use:

{$product_detail['product_name']}

There is problem, I get only short product name, without Attribute value (eg.: Mobile phone). If I delete pl.`name` as `product_name` I get long product name with Attribute Group and Attribute Value (eg.: Mobile Phone - Type : for older). 

But my goal is get: Product name - Attribute Value (eg.: Mobile Phone - for older)
(without Attribute Group).

What should I change?

Edited August 13, 2019 by JirkaDeLucina (see edit history)