Pagination with Join queries

Check the SQL statement that was executed from Debug Toolbar.

I checked it, that key is not in the result

in database and vars tab,

this is screenshoot of executed queries


Not all of the queries worked

AAAAAAAAAAAAAAKHH...!!!

I finally discovered the problem by accident ....!!

it turns out that each execution will delete the builder function in the variable.

in the code seen I do countAll() before doing findAll().
it turns out countAll() reset all the contents of $query except the model.

It seems that we can no longer use the same variable for a second execution without refilling the builder function

....
after 4 days, My stress immediately disappeared. hahahaha

thank you all...