xthreads error

[leefish]

You need to do a left join to the threadfields.

Try this.............

SQL Code

SELECT t.*, tfd.desc AS xthreadsdesc, t.username AS threadusername, u.username, u.avatar FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."threadfields tfd ON (tfd.tid=t.tid) LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid) WHERE t.fid IN (148,149,163) AND t.tid IN (0,'345','324','256','108') AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.dateline DESC

---

if it doesnt like the double quotes on the table_prefix try single ones, like this:

Code:

'.TABLE_PREFIX.'

---