AKA table is used as an alias for linking tables.
Maybe it's clear to everyone :) but the translation made me a cruel joke :)
When I understood with search join I found out that I did not understand the field next to JOIN.
Some suggestion is to make 'AKA table' since seblod itself arranges t0, t1, t2 ... and does not ask me, I reconciled to this not fairness. Because for me to correctly get AS 'field' it was necessary to use the DEBUG mode and search for the resultant query ... the 21st century of programming was not true?
So I used this field as a comment :) so it became more convenient to build 3-4 JOIN but here I did not carefully neglected to use it and forgot :) after which I experienced 3 hours of nightmare :)
however, there is a suggestion that the creators had logic
t0 for CCK_CORE
then in the sequence as indicated in the plugin
t1 - JOIN 1
t2 - JOIN 2
....
t3 .... that is the last number to link to free based table witch cck_core
Is it so?
I will be grateful for offering best practices
I hope it will be useful
I also don't understand why this aliases are not used in the end query, they only have meaning inside join field wkich makes it very hard to create right query when one needs to add something to select part as basically you need to guess right alias.