covid-19-uk

Custom SQL query returning 31 rows (hide)

select Date, Country, AreaCode, Area, TotalCases from cases where date("Date") = :p0 and (Country < :p5 or Country is null or (Country = :p5 and ((Date > :p1) or (Date = :p1 and Country > :p2) or (Date = :p1 and Country = :p2 and AreaCode > :p3) or (Date = :p1 and Country = :p2 and AreaCode = :p3 and Area > :p4)))) order by Country desc, Date, Country, AreaCode, Area limit 101

Query parameters

p0

p5

p1

p2

p3

p4