Link Comments are not showing up [5.1.1-B2]

Imported From: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/1f8419085ca8ca76#

I have submitted a Comment (old review) on the Front-end for a Link and it's perfectly fine except I do NOT see it in the Admin -> Comments grid.

Here is the SQL and looks like we get FALSE in WHERE which fails to return the list.

SELECT
	inp_ItemReview.*,
	(IF( ISNULL(pu.Login), IF (inp_ItemReview.CreatedById = -1, 'root', IF (inp_ItemReview.CreatedById = -2, 'Guest', 'n/a')), pu.Login )) AS `ReviewedBy`,
	(item_table.l1_Name) AS `CatalogItemName`, 
	(item_table.LinkId) AS `CatalogItemId`,(ci.CategoryId) AS `CatalogItemCategory`,
	(inp_ItemReview.CreatedOn) AS `CreatedOn_date`, 
	(inp_ItemReview.CreatedOn) AS `CreatedOn_time` 
FROM inp_ItemReview 
LEFT JOIN inp_PortalUser pu ON pu.PortalUserId = inp_ItemReview.CreatedById 
LEFT JOIN inp_Link item_table ON item_table.ResourceId = inp_ItemReview.ItemId 
LEFT JOIN inp_CategoryItems ci ON item_table.ResourceId = ci.ItemResourceId AND ci.PrimaryCat = 1 
WHERE ((FALSE) AND (inp_ItemReview.ItemType = 4)) 
ORDER BY `inp_ItemReview`.`Priority` desc,`inp_ItemReview`.`CreatedOn` desc,`inp_ItemReview`.`ReviewText` asc 
LIMIT 0,11

Can anyone else repeat this?

Related Tasks

INP-736 - Getting issue details... STATUS