Implemented missing features from maria

find by text and id, list, magic random, pagination