Stumped on really UGLY query...

[Antivirus]

Ugh... I am working on a query which pulls a lot of data from many different tables. It is as follows:

$sql = $db->query_read("
   SELECT scst_task.*, scst_tasktype.tasktype, scst_team.teamtitle, scst_feedback.feedbackid
   FROM scst_task
   LEFT JOIN scst_tasktype ON scst_tasktype.tasktypeid = scst_task.tasktypeid
   LEFT JOIN scst_team ON scst_team.teamid = scst_task.teamid
   LEFT JOIN usergroup ON usergroup.scstugteamid = scst_task.teamid
   LEFT JOIN scst_feedback ON scst_feedback.taskid = scst_task.taskid
   WHERE (scst_task.recurring >= (COUNT scst_feedback.feedbackid))
   ORDER BY scst_task.enddate ASC, scst_team.teamtitle ASC
");

The problem is with the WHERE clause. It's not doing what I need. I need it to only pull the tasks associated with feedback quantity which is less than or equal to the value in that task's 'recurring' column.

In other words, the data in the task table could have 2 rows as follows:

taskid1 || recurring 2
taskid2 || recurring 1
taskid3 || recurring 1


... while the data in the feedback table could have 3 rows as follows:

feedbackid1 || taskid 1 || miscdata
feedbackid2 || taskid 2 || miscdata
feedbackid4 || taskid 1 || miscdata
feedbackid5 || taskid 3 || miscdata


...therefore the results would pull only taskid1 since taskid2 & taskid3 have <= occurrences in feedback table with records linked to them.

If i haven't explained this well, please let me know, i'd be happy to go into more detail. Thanks