SELECT r.item_id FROM tag_relation r, tag_value v WHERE v.value="1'"" AND v.id=r.tag_id