SELECT * FROM ( SELECT query_keys FROM ( SELECT query_keys, ROW_NUMBER() OVER(ORDER BY cnt DESC) rn FROM ( SELECT query_keys,COUNT(query_keys) cnt FROM tab_query_log tq WHERE query_person = 'lisi' GROUP BY query_keys) ) WHERE rn <= 5 ) T1, (select distinct tr.url, tr.txt, tr.keys from tab_reads_log tr) T2 WHERE (INSTR(T2.keys,' '||T1.query_keys) > 0 OR INSTR(T2.keys,T1.query_keys||' ') > 0) AND ROWNUM <= 4;
SELECT query_keys FROM (
SELECT query_keys, ROW_NUMBER() OVER(ORDER BY cnt DESC) rn FROM (
SELECT query_keys,COUNT(query_keys) cnt FROM tab_query_log tq WHERE query_person = 'lisi' GROUP BY query_keys)
)
WHERE rn <= 5 ) T1,
(select distinct tr.url, tr.txt, tr.keys from tab_reads_log tr) T2
WHERE (INSTR(T2.keys,' '||T1.query_keys) > 0 OR INSTR(T2.keys,T1.query_keys||' ') > 0)
AND ROWNUM <= 4;