( mc.contentID = "1" )
( ms.status = 2 AND mc.created <= ms.lastUpdate )
Not sure if the rest of your logic is good...[/QUOTE]not sure the logic here is any good either
if ms.status = 2 AND mc.created <= ms.lastUpdate, you will get a bunch of content, regardless of which contentID it's for
my understanding is, it has to be for contentID = 1
hence, the OR is wrong
spree, you used a left outer join... is it possible to have a message_content row for a contentid that has no match in the message_status table? or will there always be a status for each contentid in message_content?
in that case, it should be an inner join
by the way, any relation to winston spree simon?