Please please copy the query below and contact the administrator about this problem. Thank you.

SELECT * FROM x7d0_smartshop_item WHERE itemid IN ( SELECT DISTINCT x7d0_smartshop_item.itemid FROM x7d0_smartshop_item LEFT JOIN x7d0_smartshop_item_attribut ON x7d0_smartshop_item.itemid = x7d0_smartshop_item_attribut.itemid LEFT JOIN x7d0_smartshop_attribut_option ON (x7d0_smartshop_item_attribut.attributid = x7d0_smartshop_attribut_option.attributid AND x7d0_smartshop_item_attribut.value = x7d0_smartshop_attribut_option.optionid) WHERE status = 3 AND uid = 1 ))