SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, i.itime, i.imore as more, m.mnumber as authorid, m.memail as authormail, m.murl as authorurl, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_item as i, nucleus_member as m, nucleus_category as c WHERE i.iblog=1 and i.iauthor=m.mnumber and i.icat=c.catid and i.idraft=0 and i.itime<="2008-12-05 04:01:29" AND i.iblog = 1 AND i.inumber IN (2,9,11,179,178,192,191) ORDER BY i.itime DESC LIMIT 1,5

stdClass Object
(
    [itemid] => 9
    [title] => MT-Blacklist saves the day
    [body] => 	
So rememer my post about the good and bad of blog comments ?

	
Well, Jay Allen has kindly provided MT-Blacklist and I’ve installed it. Rather than an IP-based blacklist (which everyone knows is difficult to maintain and just plain ineffective), this one lets me filter comments for certain spam-like words.

	
YEEEE-HAW. Gotta love MT. Plugins rock.

Thanks Jay!!


 
    [author] => erin
    [authorname] => Erin Schnabel
    [itime] => 2003-10-27 20:27:00
    [more] => 


 
    [authorid] => 1
    [authormail] => erinschnabel@gmail.com
    [authorurl] => http://ebullientworks.com/
    [category] => General
    [catid] => 1
    [closed] => 0
)

stdClass Object
(
    [itemid] => 2
    [title] => Handy Things to know for running a blog..
    [body] => 	
Or a website for that matter…

	

	
Block unwanted robots, spambots…
		
30 days to a more accessible weblog
	


 
    [author] => erin
    [authorname] => Erin Schnabel
    [itime] => 2003-03-13 23:16:00
    [more] => 

 
    [authorid] => 1
    [authormail] => erinschnabel@gmail.com
    [authorurl] => http://ebullientworks.com/
    [category] => General
    [catid] => 1
    [closed] => 0
)