From looks like: From temptable, table2 without a join, can someone explain how this works?

Hi all,

I've found an old query which I'm trying to understand. I've a question about the FROM part. I understand that the temporary table is a key-valuepair. But I don't understand what happens in the from part. Because it returns the dutch names of the week (created in the key-valuepair), but why? The query looks like this:

WITH days AS ( SELECT "map"(ARRAY['Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'], ARRAY['Zondag','Maandag','Dinsdag','Woensdag','Donderdag','Vrijdag','Zaterdag']) "dagen"

)

SELECT , "date"("tabel1"."datumtijd") "date" , "dagen"["date_format"("date"("tabel1"), '%W')] "days" FROM days , "tabel1" LEFT JOIN "tabel2 "ON (....