Create sqlite query to get the image data

[srietkerk]

To populate the page with all of the right data for the guesser, we need to make the right query to get the data from all of the tables.

[bglossner]

The query will look like:

with daily_game as (
   select * from DailyGame where date = <date-str>
),
all_image_counts as (
   select * from ImageCountInstance as ici
   inner join daily_game as dg
   where ici.imageId = dg.imageId
)
select * from Image
inner join
all_image_counts as aic
where
Image.id = aic.imageId

[bglossner]

Would be cool to make a SQL view for this but that's not available unfortunately yet: prisma/prisma#678