



'SELECT Item.ID,
Item.title,
Item.publishDate,
Item.categoryID,
Item.lastCommentDate,
Item.amountOfComments,
MATCH title AGAINST ('blender') AS score
FROM Item
LEFT JOIN Text ON Item.textID = Text.ID
WHERE Item.typeID = 1
AND Item.publishDate < NOW()
AND Item.publishUserID IS NOT NULL
AND Item.ID != 424864
AND MATCH (title) AGAINST ('BEP DVD')
ORDER BY Item.publishDate DESC
LIMIT 0, 6'
12/01/06 @802