xthreads error

[leefish]

Yea RateU, I knew he had posted this before. 1master1, the problem here is that you are shrouding this whole query in mystery. We do not really know what you are trying to achieve, where you want to use it etc.

In this case, trying to help you is hard. If you put that query in a function (either in a plugin file or whatever file you are trying to load it from) it will do something. Whether it will do what you want - I have no idea.

What I DO know is, if you want to call a field from the threadfields table when your select is on the threads table you have to JOIN to the threadfields table in your query. Thats for sure.

Also, in phpmyadmin, you will see a table called threadfields. Scroll to the bottom of the table and click check all. Then the browse icon. Then you will see the table layout and you will see that there is indeed a column in threadfields called desc. There is in mine anyway.