kenjis

> but we get an error at the output: ASC is applied twice What do you mean? What is the exact error message?

> The first parameter contains the name of the column you would like to order by. https://codeigniter4.github.io/CodeIgniter4/database/query_builder.html#orderby Do you think the following is the name of the column? `"TO_CHAR(lottery_coupons.updated_at, 'YYYY-MM-DD...

Could you paste text instead of screenshots? Screenshots are difficult to read.

In my understanding, when using Query Builder, if you do not specify simple column names, try to set `$escape` to `false` (and surely escape by yourself). If an alias cannot...

As you say, it is a bit strange. To be honest, I don't know why the following query causes the error `column "hourInterval" does not exist`. ```sql SELECT COUNT(lottery_coupons.id) AS...