Solved K 1.7.2 on J! 1.5 to K 3.0.4 on J! 3.2

UPDATE gvrsi_kunena_topics AS tt INNER JOIN ( SELECT m.thread, m.hold, COUNT( DISTINCT m.id ) AS posts, COUNT( a.id ) AS attachments, MIN( m.time ) AS mintime, MAX( m.time ) AS maxtime FROM gvrsi_kunena_messages AS m LEFT JOIN gvrsi_kunena_attachments AS a ON m.id = a.mesid WHERE m.moved =0 GROUP BY m.thread, m.hold ) AS c ON tt.id = c.thread INNER JOIN gvrsi_kunena_messages AS mmin ON c.thread = mmin.thread AND mmin.hold = tt.hold AND mmin.time = c.mintime INNER JOIN gvrsi_kunena_messages AS mmax ON c.thread = mmax.thread AND mmax.hold = tt.hold AND mmax.time = c.maxtime INNER JOIN gvrsi_kunena_messages_text AS tmin ON tmin.mesid = mmin.id INNER JOIN gvrsi_kunena_messages_text AS tmax ON tmax.mesid = mmax.id SET tt.posts = c.posts, tt.attachments = c.attachments, tt.first_post_id = mmin.id, tt.first_post_time = mmin.time, tt.first_post_userid = mmin.userid, tt.first_post_message = tmin.message, tt.first_post_guest_name = mmin.name, tt.last_post_id = mmax.id, tt.last_post_time = mmax.time, tt.last_post_userid = mmax.userid, tt.last_post_message = tmax.message, tt.last_post_guest_name = mmax.name WHERE moved_id =0 AND ( tt.id BETWEEN 1 AND 5056 )