0 to 1023WITH RECURSIVE num(n) AS ( SELECT 1 UNION ALL SELECT n + 1 FROM num WHERE n < 1024 ) SELECT * from num;
SELECT T1.SEQ + T2.SEQ + T3.SEQ + T4.SEQ + T5.SEQ + T6.SEQ + T7.SEQ + T8.SEQ + T9.SEQ + T10.SEQ + 0 SEQ FROM (SELECT 0 SEQ UNION ALL SELECT 1) T1 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 2) T2 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 4) T3 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 8) T4 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 16) T5 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 32) T6 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 64) T7 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 128) T8 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 256) T9 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 512) T10
2019-01-01 to 2021-10-20 (+1023) by daySELECT SEQ, DATE_ADD(STR_TO_DATE('2019-01-01', '%Y-%m-%d'), INTERVAL SEQ DAY) date FROM ( SELECT T1.SEQ + T2.SEQ + T3.SEQ + T4.SEQ + T5.SEQ + T6.SEQ + T7.SEQ + T8.SEQ + T9.SEQ + T10.SEQ + 0 SEQ FROM (SELECT 0 SEQ UNION ALL SELECT 1) T1 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 2) T2 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 4) T3 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 8) T4 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 16) T5 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 32) T6 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 64) T7 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 128) T8 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 256) T9 CROSS JOIN (SELECT 0 SEQ UNION ALL SELECT 512) T10 ) Z
Similar pages by cosine similarity. Words after page name are term frequency.