Complex query in Views API - advice

Hi

I want to use the views module to list the nodes returned by a query like this:

<?php 
 $querynobody = "SELECT uid FROM users WHERE name = 'nobody'";
  $nobodyobject = db_fetch_object(db_query($querynobody));
 $query = "SELECT m.evalid,n.title,n.nid,n.created FROM (node n INNER JOIN fhsstadmin_mediation m ON n.nid=m.nid) WHERE n.type='fhsstadmin-mediation' AND m.mediationstatus='0' AND m.evaluid != '$user->uid' AND m.pageuid != '$user->uid' AND n.uid='$nobodyobject->uid' GROUP BY n.title ORDER BY n.created ";
 if ($limitnum >= 0 ) $query .= " LIMIT " . $limitnum;
?>

How do I put in all the ANDs in the end properly?

I know how to expose the various columns using:

<?php
 $tables['fhsstadmin_mediation'] = array(
    "name" => "fhsstadmin_mediation",
    "join" => array(
      "left" => array(
        "table" => "node",
        "field" => "nid"
      ),
      "right" => array(
        "field" => "nid"
      ),
    ),
    "fields" => array(
      "mediatoruid" => array(
        'name' => "Mediator ID",
        'sortable' => true,
        'mediatoruid' => "mediatoruid",
        'addlfields' => array("mediatoruid")
      ),
      "evaluid" => array(
        'name' => "Mediator Eval ID",
        'sortable' => true,
        'evaluid' => "evaluid",
        'addlfields' => array("evaluid")
      ),
// etc.
    ),
    "filters" => array(
      "currentuidevaluated" => array(
        'list' => "views_handler_filter_usercurrent",
  //      'handler' => "views_handler_filter_uid_mediated",
        'field' => 'evaluid',
        'name' => "FHSST: Current User Authored Evaluation that was Mediated",
        'operator' => array('=' => "touched by"),
        'list-type' => 'select',
        'help' => "This allows you to filter by whether or not the logged in user authored or commented on the node.",
      ),
?>

But the filter is way too complicated for me right now - any advice would be greatly appreciated.

Mark