I was lucky I didn't lose my 3 ft tank (an aquaone on their stand) it moved off about 5cm and was just hanging on to the base. Lost lots of water from the tank (mostly caused by my eheim filter losing those flimsy clips and seeped out water fromt the top). Male gba was found on the floor as well as lots of plants, lid dropped into the tank, but no other losses, gba was fine as we found him pretty promptly after the quake.
My 5 ft tank lost about 1cm water and hasn't moved at all, it is on a solid mdf stand which has a lip 3/4 around the tank.
Luckily my 2ft tank in the hallway wasn't full and though it has no lip it survived (it is plumbed so that may have contributed to its survival. My other two small tanks were fine, just moved slightly on the shelf but didn't fall.