Не работает запрос, немогу понять где поставить кавычки.

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`id`='ppv.value_id') as values ' at line 16 SQL=SELECT ppv.id, ppv.property_id, ppv.value_id, ppv.text, prop.edit_price, prop.title, prop.type, prop.view, prop.default, prop.prefix, prop.suffix, (SELECT * FROM `u12bz_ksenmart_product_properties_values` WEHRE `id`='ppv.value_id') as values FROM u12bz_ksenmart_products_relations AS pr INNER JOIN u12bz_ksenmart_products AS p ON pr.relative_id=p.id AND p.title LIKE "%Кольц%" INNER JOIN u12bz_ksenmart_product_properties_values AS ppv ON p.id=ppv.product_id INNER JOIN u12bz_ksenmart_properties AS prop ON ppv.property_id=prop.id WHERE pr.relation_type='set' AND pr.product_id=6191

Запрос

Спасибо. Вчера сам нашел ошибку)

Еще вопрос у меня в подзапросе
Возвращает несколько значений, а мне SQL ругается

"
1242 - Subquery returns more than 1 row SQL=SELECT ppv.id, ppv.property_id, ppv.value_id, ppv.text, prop.edit_price, prop.title, prop.type, prop.view, prop.default, prop.prefix, prop.suffix, ppv.price, pv.title as pv_title, pv.image as pv_image, (SELECT pv.title as pv_title FROM u12bz_ksenmart_property_values) as values2 FROM u12bz_ksenmart_products_relations AS pr INNER JOIN u12bz_ksenmart_products AS p ON pr.relative_id=p.id AND p.title LIKE "%Кольц%" INNER JOIN u12bz_ksenmart_product_properties_values AS ppv ON p.id=ppv.product_id INNER JOIN u12bz_ksenmart_properties AS prop ON ppv.property_id=prop.id INNER JOIN u12bz_ksenmart_property_values AS pv ON ppv.value_id=pv.id WHERE pr.relation_type='set' AND pr.product_id=6281 ORDER BY ppv.property_id ASC

"

мне нужно получать в под запросе несколько значений, чтобы было примерно такого вида ответ


[4] => stdClass Object
(
[id] => 26523
[property_id] => 7
[value_id] => 76
[text] =>
[edit_price] => 0
[title] => Знак зодиака
[type] => select
[view] => radio
[default] =>
[prefix] =>
[suffix] =>
[values2] => Array
(
[76] => stdClass Object
(
[id] => 76
[title] => Телец
[image] => images/properties/telec.jpg
[property_id] => 7
[price] =>
[text] =>
)

[80] => stdClass Object
(
[id] => 80
[title] => Дева
[image] => images/properties/deva.jpg
[property_id] => 7
[price] =>
[text] =>
)

[78] => stdClass Object
(
[id] => 78
[title] => Рак
[image] => images/properties/rak.jpg
[property_id] => 7
[price] =>
[text] =>
)

)

)

Возможно ли такое с помощью MySQL?