PDO Woes, multiple inner joins

$search = array(
	className	=> 'MyClass',
	packageName	=> 'myClass',
	by		=> $_GET['by'], //examples are name, County.name, Country.name, and Offer.name
	term 		=> $_GET['term'], //$_GET search var
);

//Build search criteria
$criteria = array(
	$search['by'].':LIKE' => '%'. $search['term'] .'%'
);

//Build query
$q = $modx->newQuery($search['className']);
//$q->innerJoin('Offer', 'Offer', $search['className'].'.offerId=Offer.id');
//$q->innerJoin('County', 'County', $search['className'].'.countyId=County.id');
//$q->innerJoin('Country', 'Country', $search['className'].'.countryId=Country.id');
$q->where($criteria);
$q->sortby('name','ASC');

$o = $modx->getCollection($search['className'], $q);

$results = array();

foreach($o as $result) {
	$i = array (
		label			=> $result->get($search['by']),
		value			=> $result->get($search['by'])
	);
	array_push($results, $i);
}

echo json_encode($results);

$q->sortby('name','ASC');
$q->prepare();echo $q->toSql();

SELECT `OfferOne`.`id` AS `OfferOne_id`, `OfferOne`.`name` AS `OfferOne_name`, `OfferOne`.`addressLineOne` AS `OfferOne_addressLineOne`, `OfferOne`.`addressLineTwo` AS `OfferOne_addressLineTwo`, `OfferOne`.`addressLineThree` AS `OfferOne_addressLineThree`, `OfferOne`.`countyId` AS `OfferOne_countyId`, `OfferOne`.`postCode` AS `OfferOne_postCode`, `OfferOne`.`countryId` AS `OfferOne_countryId`, `OfferOne`.`url` AS `OfferOne_url`, `OfferOne`.`telephoneNumber` AS `OfferOne_telephoneNumber`, `OfferOne`.`offerId` AS `OfferOne_offerId`, `OfferOne`.`monday` AS `OfferOne_monday`, `OfferOne`.`tuesday` AS `OfferOne_tuesday`, `OfferOne`.`wednesday` AS `OfferOne_wednesday`, `OfferOne`.`thursday` AS `OfferOne_thursday`, `OfferOne`.`friday` AS `OfferOne_friday`, `OfferOne`.`saturday` AS `OfferOne_saturday`, `OfferOne`.`sunday` AS `OfferOne_sunday`, `OfferOne`.`availability` AS `OfferOne_availability`, `OfferOne`.`exclusions` AS `OfferOne_exclusions`, `OfferOne`.`photo` AS `OfferOne_photo`, `OfferOne`.`published` AS `OfferOne_published`, `OfferOne`.`deleted` AS `OfferOne_deleted` FROM `modx_offerOne` AS `OfferOne` WHERE `OfferOne`.`name` LIKE '%test%' ORDER BY name ASC

SELECT `OfferOne`.`id` AS `OfferOne_id`, `OfferOne`.`name` AS `OfferOne_name`, `OfferOne`.`addressLineOne` AS `OfferOne_addressLineOne`, `OfferOne`.`addressLineTwo` AS `OfferOne_addressLineTwo`, `OfferOne`.`addressLineThree` AS `OfferOne_addressLineThree`, `OfferOne`.`countyId` AS `OfferOne_countyId`, `OfferOne`.`postCode` AS `OfferOne_postCode`, `OfferOne`.`countryId` AS `OfferOne_countryId`, `OfferOne`.`url` AS `OfferOne_url`, `OfferOne`.`telephoneNumber` AS `OfferOne_telephoneNumber`, `OfferOne`.`offerId` AS `OfferOne_offerId`, `OfferOne`.`monday` AS `OfferOne_monday`, `OfferOne`.`tuesday` AS `OfferOne_tuesday`, `OfferOne`.`wednesday` AS `OfferOne_wednesday`, `OfferOne`.`thursday` AS `OfferOne_thursday`, `OfferOne`.`friday` AS `OfferOne_friday`, `OfferOne`.`saturday` AS `OfferOne_saturday`, `OfferOne`.`sunday` AS `OfferOne_sunday`, `OfferOne`.`availability` AS `OfferOne_availability`, `OfferOne`.`exclusions` AS `OfferOne_exclusions`, `OfferOne`.`photo` AS `OfferOne_photo`, `OfferOne`.`published` AS `OfferOne_published`, `OfferOne`.`deleted` AS `OfferOne_deleted` FROM `modx_offerOne` AS `OfferOne` JOIN `modx_offers` `Offer` ON OfferOne.offerId=Offer.id JOIN `modx_counties` `County` ON OfferOne.countyId=County.id JOIN `modx_countries` `Country` ON OfferOne.countryId=Country.id WHERE `OfferOne`.`name` LIKE '%test%' ORDER BY name ASC

$q->select($modx->getSelectColumns($search['className'], $search['className']));

$result->get('County.name')

$q->select($modx->getSelectColumns('County', 'County', 'County.'));
$q->select($modx->getSelectColumns('Country', 'Country', 'Country.'));