SELECT item.id
          FROM item
          JOIN item_set ON (item_set.id = item.item_set_id)
         WHERE item_set.name = 'ABC'
           AND item.added_rev_id  3)
         ORDER BY item.id ASC LIMIT 10;