keeps on reposting already posted skeets
Ran into the same problem, thanks for finding the fix @pixeline
Unfortunately the shared server I'm running on is stuck at SQLite 3.7.17 so I split the SQL query into two so it doesn't use ON...