Add a field to the result during SQL SELECT statement query,

To avoid table join queries, you need to add a field to the SQL statement results:

The original SQL statement is:

Select C. * From (select rownum as R, B. * From (select T ., T ., T ., T ., T ., t. user_id_encrypt, T ., t. create_time, T ., T ., T ., a. user_type from t_wiki_doc_posts t inner join t_wiki_user A on T. user_id_encrypt =. user_id_encrypt where doc_topics_id_encrypt = 'baarerlfz, x0nyx1oca, 1ldvw'
Order by create_time) B where rownum <= 20) c Where C. R> = 1

To:

Select C. * From (select rownum as R, B. * From (select T ., T ., T ., T ., T ., t. user_id_encrypt, T ., t. create_time, T ., T ., T .,0 as user_typeFrom t_wiki_doc_posts t where doc_topics_id_encrypt = 'jranb?wa1fea0bga0ajxa **'
Order by create_time) B where rownum <= 20) c Where C. R> = 1