Hi.
I ask to help to understand not normal delivery of a field from table LEFT JOIN
What I did
1. compiled LIST SEARCH on the basis of FREE
2. displayed the fields of interest, they are all from GROUP_CHILDREN
3. Attached through the plug-in SEARCH JOIN table CCK_CORE
Now I want to output the field CCK_CORE in LIST VIEW
I receive here such here result:
where the CCK field took the values article, workbook, article (ID in title colum this my mistake, trash of my more experiments)(right title CCK :)
4. looked up joomla requests and found this
5. Now the result is compared
The last query returns the correct values of the attached fields
I have no idea why this is so?
and how to display the attached fields correctly. studied the response of KLAS from the post above:
"I think it should work if you add a field with the standard-free-databsecolumn storage for each column you wish to display."
but the result is such, incomprehensible
1. Help to understand the result.
2. And how to get it right.
Thank you.