Complex query help

[EchoFool]

Hey i have written a really complex query to meet the criteria of my script but i can't get it to work.... this is what it is meant to do:

 

Load news feed from users that have made a comment not including the users that you have blocked.

 

 

This is my query:

 

 

<?php
$safe = 1; // my userid

SELECT t1.comment,t1.userid,t1.timestamp,t2.username,t1.id
FROM user_comments t1
INNER JOIN users t2
ON t1.userid=t2.userid
WHERE t1.feedid='1'
AND 
1 NOT IN
               (SELECT count(id) AS total
      FROM users_blocked
      WHERE (user1='$safe' AND user2=t1.userid)
      OR (user1=t1.userid AND user2='$safe'))
?>

 

 

Annoyingly it doesn't load any comments since adding the block check =/

 

 

Any ideas on my mistake?

[EchoFool]

Argh never mind i fixed it i changed it to use a NOT EXISTS instead

 

Seems to have done the trick!