Need help converting a multitable MySQL query to MODx DBAPI

$wua = $modx->getFullTableName("web_user_attributes");
$wg = $modx->getFullTableName("web_groups");
$wgn = $modx->getFullTableName("webgroup_names");

// query includes custom rows added to extend the web_user_attributes table
$sql = 'SELECT `u`.`company`, `u`.`website`, `u`.`comment`, `u`.`address`, `u`.`city`, `u`.`state`, `u`.`zip`, `u`.`fullname`,' `u`.`phone`, `u`.`fax`, `u`.`mobilephone`, `u`.`email`';
$sql .= 'FROM $wua AS `u` ';
$sql .= 'LEFT JOIN `$wg` AS w ON `u`.`id` =  `w`.`webuser` ';
$sql .= 'LEFT JOIN `$wgn` AS n  ON n.id =  `w`.`webgroup` ';
$sql .= 'WHERE `u`.`type` = 1';
$sql .= 'AND `u`.`company` LIKE  '%whatever%' ';
$sql .= 'OR `u`.`type` = 1';
$sql .= 'AND `n`.`name` LIKE '%whatever%' ';
$sql .= 'ORDER BY `u`.`company` ASC ';

$result = $modx->db->query($sql);

$sql =<<<YOYOYO
SELECT u.company, u.website, u.comment, u.address, u.city, u.state, u.zip, u.fullname, u.phone, u.fax, u.mobilephone, u.email
FROM $wua AS u 
LEFT JOIN $wg AS w ON u.id =  w.webuser 
LEFT JOIN $wgn AS n  ON n.id =  w.webgroup 
WHERE u.type = 1
AND u.company LIKE '%whatever%' 
OR u.type = 1
AND n.name LIKE '%whatever%' 
ORDER BY u.company ASC;
YOYOYO