Commits

Dan Connolly committed d53954d

ah... match on a.guid, not a.name

Comments (0)

Files changed (1)

               -- and s9.slot_type = 9
  join slots s3 on s3.obj_guid = s9.guid_val
               -- and s3.slot_type = 3
-              and s3.name = concat(a.name, '/', bi.period_num)
+              and substr(s3.name, 34) = bi.period_num
  set bi.slot_9 = s9.id,
      bi.slot_3 = s3.id,
      bi.guid = s9.guid_val