WeatherNews in C

行数: 145

Data generated from these queries:

CREATE TEMP TABLE lmao AS SELECT s.id AS id, seg.n AS title, c.n AS caster, s.video_id AS video_id, s.view_count AS view_count, MAX(m.val) AS mscale, s.jst AS jst, l.njst AS njst FROM schedule s LEFT JOIN (SELECT id, lead(jst) OVER (ORDER BY jst) AS njst FROM schedule WHERE segment_id IS NOT 8) l ON l.id = s.id JOIN segment seg ON seg.id = s.segment_id LEFT JOIN caster c ON c.id = s.caster_id LEFT JOIN mscale m ON m.jst >= s.jst AND m.jst < l.njst WHERE substr(s.jst, 1, 4) IN ('2026') AND caster IN ('kobayashi') GROUP BY s.id ORDER BY jst DESC;

SELECT COUNT(*) FROM lmao;

SELECT * FROM lmao;

Toggle pinning this form to the bottom of the window with Alt-j