14 lines
393 B
TypeScript
14 lines
393 B
TypeScript
import { sql } from "@core/db/dbNew";
|
|
import type { LatestSnapshotType } from "@core/db/schema.d.ts";
|
|
|
|
export async function getVideosInViewsRange(minViews: number, maxViews: number) {
|
|
return sql<LatestSnapshotType[]>`
|
|
SELECT *
|
|
FROM latest_video_snapshot
|
|
WHERE views >= ${minViews}
|
|
AND views <= ${maxViews}
|
|
ORDER BY views DESC
|
|
LIMIT 5000
|
|
`;
|
|
}
|