Aw: Attribute mit MYSQL >= 5.0.12 anzeigen?
Ohne Gewähr!
aus
$query = "SELECT DISTINCT
valu.value_id,
valu.image,
IFNULL(cur_lang.value_name, def_lang.value_name) AS value_name,
attr_valu.value_id_to_attr_id,
valu.value_ordering,
valu.language
FROM `#__jshopping_attr_values` AS valu,
`#__jshopping_attr` AS attr,
`#__jshopping_attr_to_values` AS attr_valu
LEFT JOIN
`#__jshopping_attr_values` AS cur_lang ON cur_lang.value_id = valu.value_id
AND cur_lang.language = '" . $jshopConfig->cur_lang . "'
LEFT JOIN
`#__jshopping_attr_values` AS def_lang ON def_lang.value_id = valu.value_id
AND def_lang.language = '" . $jshopConfig->defaultLanguage . "'
WHERE valu.value_id = attr_valu.value_id
AND attr_valu.attr_id = attr.attr_id
AND attr.attr_id = '" . $attr_id . "'
GROUP BY valu.value_id
ORDER BY valu.value_ordering, valu.value_id";
wurde bei mir
$query = "SELECT DISTINCT
valu.value_id,
valu.image,
IFNULL(cur_lang.value_name, def_lang.value_name) as value_name,
attr_valu.value_id_to_attr_id,
valu.valu e_ordering,
valu.language
FROM `#__jshopping_attr_values` AS valu
Join `#__jshopping_attr` AS attr
Join `#__jshopping_attr_to_values` AS attr_valu
LEFT Join `#__jshopping_attr_values` AS cur_lang
ON (cur_lang.value_id = valu.value_id AND cur_lang.language = '" . $jshopConfig->cur_lang . "')
LEFT JOIN `#__jshopping_attr_values` AS def_lang
On (def_lang.value_id = valu.value_id AND def_lang.language = '" . $jshopConfig->defaultLanguage . "')
WHERE valu.value_id = attr_valu.value_id
AND attr_valu.attr_id = attr.attr_id
AND attr.attr_id = '" . $attr_id . "'
GROUP BY valu.value_id
ORDER BY valu.value_ordering, valu.value_id";
Ob das in allen Sprachkonfigurationen funktioniert, ist nicht getestet!