momopin.sql

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,
       m.val        AS mscale,
       s.jst        AS jst
  FROM schedule s
       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
 WHERE c.n = 'aohara2023'
   AND s.jst >= '2024-01-01'
   AND m.val == 1
 ORDER BY view_count DESC
 LIMIT 10;