duplicate product attribute problem with the blockwishList moudule

[TiaNex Shopping]

duplicate product attribute problem with the blockwishList  moudule

 

as the image showing in BO,

 

S, Violet, S, Violet, S, Violet, S, Violet, S, Violet, S, Violet, S, Violet, S, Violet

 

 

it seems caused by    Shop::addSqlAssociation('product_attribute', 'pa').'   in

 

 

 

$result = Db::getInstance()->executeS('

SELECT al.`name` AS attribute_name, pa.`quantity` AS "attribute_quantity"

FROM `'._DB_PREFIX_.'product_attribute_combination` pac

LEFT JOIN `'._DB_PREFIX_.'attribute` a ON (a.`id_attribute` = pac.`id_attribute`)

LEFT JOIN `'._DB_PREFIX_.'attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)

LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = '.(int)($id_lang).')

LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = '.(int)($id_lang).')

LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

'.Shop::addSqlAssociation('product_attribute', 'pa').'

 

anybody can solve it?  thank you

[tuk66]

Can you catch the real SQL query string?