[MrNase]

One last thing: I try to get the first post of each thread marked with "onfrontpage" out of the database. Iam using the following query but i doesn't work

$getnews = $DB_site->query("
	## GET LATEST THREADS ##
	SELECT thread.*,thread.iconid AS threadiconid $previewfield
	FROM ".TABLE_PREFIX."thread AS thread
	LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
	LEFT JOIN ".TABLE_PREFIX."post AS post ON(thread.threadid = post.threadid)
	$previewjoin
	WHERE open = '1'
	AND forumid NOT IN (0$limitfids)
	AND onfrontpage = '1'
	AND thread.visible = '1'
	AND deletionlog.primaryid IS NULL
	ORDER BY lastpost
	DESC LIMIT 10");

while($news = $DB_site->fetch_array($getnews)) {

The errormessage is

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: 
	## GET LATEST THREADS ##
	SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
	FROM thread AS thread
	LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
	LEFT JOIN post AS post ON(thread.threadid = post.threadid)
	LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
	WHERE open = '1'
	AND forumid NOT IN (0)
	AND onfrontpage = '1'
	AND thread.visible = '1'
	AND deletionlog.primaryid IS NULL
	ORDER BY lastpost
	DESC LIMIT 10
mysql error: Not unique table/alias: 'post'

mysql error number: 1066

Date: Friday 27th of February 2004 04:20:26 PM
Script: http://xxx/232/new.php
Referer: 
Username: MrNase
IP Address: xx.xxx.0.xx