Trending searches

SELECT t.rank, tp.id AS topic_id, tp.name AS topic, t.volume_label, t.volume_min,
       t.started_utc, t.ended_utc, t.is_active, t.explore_link,
       (SELECT GROUP_CONCAT(term, ', ') FROM
          (SELECT term FROM related_terms WHERE trend_row_id = t.id LIMIT 6)) AS related
FROM trend_rows t
JOIN topics tp ON tp.id = t.topic_id
WHERE t.run_id = (SELECT id FROM latest_runs WHERE time_window = :window)
  AND (:search = '' OR tp.name LIKE '%' || :search || '%')
  AND t.volume_min >= :min_volume
  AND (:active_only = 0 OR t.is_active = 1)
ORDER BY t.volume_min DESC, t.rank;