Your _adoptables table is empty! no wonder nothing shows up...
btw, the structure is missing a few things. Since you have $evolution, $evolutionlevel, amd $evolutionform in the query I take it that you're trying to install HoF's evolution system, correct?
anyways, you have to add 3 more columns into _adotables & _owned_adoptables table.
those 3 columns are:
PHP Code:
`evolution` VARCHAR( 10 ) NULL DEFAULT NULL ,
`evolutionlevel` INT( 11 ) NOT NULL DEFAULT '0',
`evolutionform` VARCHAR ( 40 ) NULL DEFAULT NULL