职业生涯最复杂sql记录

SELECT teaching_activity_comment_data.*,user_info.avatar,liveclass_relation_id.related_type,COALESCE(user_info.user_name, teaching_activity_visitor.name) as user_name,COALESCE(user_info.login_name, teaching_activity_visitor.login_name) as login_name FROM teaching_activity_comment_data left join user_info on teaching_activity_comment_data.user_id = user_info.id left join liveclass_relation_id on teaching_activity_comment_data.teaching_activity_id = liveclass_relation_id.teaching_activity_id AND teaching_activity_comment_data.user_id = liveclass_relation_id.related_id left join teaching_activity_visitor on teaching_activity_comment_data.teaching_activity_id = teaching_activity_visitor.teaching_activity_id AND teaching_activity_comment_data.visitor_id = teaching_activity_visitor.login_name WHERE teaching_activity_comment_data.teaching_activity_id = 487079574635013 AND user_name LIKE '%王%' AND related_type = 1 AND teaching_activity_comment_data.deleted_at IS NULL AND teaching_activity_comment_data.id < 487085102563845 ORDER BY created_at desc LIMIT 20