MariaDB [soelog]> select * from snapshots where servertag = "pub1" and username = "roof" and time = "2018-10-29 20:45:13"\G                               *************************** 1. row ***************************
         id: 1065428
  servertag: pub1
       time: 2018-10-29 20:45:13
   username: Roof
     userid: 28984
     charid: 39770
      event: audit
     detail:
          x: 4116.97
          y: 4922.43
          z: -2.48921
          h: 300.992
    street1: Catfish View
    street2:
       area: Pacific Ocean
   cardinal: NE
   distance: 1.3973679542541504
 teleported: 0
  invisible: 0
 invincible: 1
      vehid: NULL
    vehtype: carnotfound
vehtypename: NULL
   vehcolor: Metallic Black
     livery: -1
      plate: NULL
       seat: NULL
       cash: 170
   cashgain: 0
     weapon: WEAPON_UNARMED
 suspicious: 0
   bannable: 1
      banid: NULL
  narrative: {}
1 row in set (0.08 sec)