Loading Product..

SELECT a.id, a.name, a.style,a.structur, c.price, c.notice,c.notice_art,c.id as attributeTableId, b.value, b.addInfos FROM attributes as a, attributes_values as b, products_attributes_values as c WHERE c.prod_id = '56' AND a.id = b.attr_id AND b.id = c.attr_value_id ORDER BY a.sort_nr, b.sort_nr