system error diary
SELECT dy.id AS dyid, sokuryo_id, selno, kind, kaidoku, wareki, dtday, elapsed_dt, lodging, ctv, lat, lon, kn.kname, ct.cname, ct.gun, kd.bun, kd.ex_bun FROM days AS dy JOIN daizu AS zu JOIN kens AS kn JOIN cities AS ct JOIN kaidoku AS kd ON ct.ken_id=dy.ken AND ct.citycode=dy.ctv AND zu.id=dy.daizu AND kn.id=dy.ken AND dy.id = kd.day_id WHERE dy.id=3718