[split] XThreads

[RateU]

Try this:

PHP Code:

1 2 3 4 5 6 7 8 9

$query = $db->query(" SELECT t.*, f.name, a.updatetime, a.md5hash, a.uploadtime, a.aid, a.attachname, a.filename FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."xtattachments a ON (a.tid=t.tid) WHERE t.visible=1 AND t.closed NOT LIKE 'moved|%' AND a.thumbs!='' AND t.fid IN ('".implode("','", $mbhattatgal_tid_array)."') GROUP BY a.tid ORDER BY a.aid DESC LIMIT $mbhattatgal_num ");

---