how should I create this query in modx?

select * from `chrys-haefen`.`tbldogs` WHERE `litter` is not NULL LIMIT 0, 30 ;

dog_id 	sex callname 	litter 
76 	Male 	Rigger 	127
85 	Female 	Laila 	129
127 	Female 	Marley 	76
129 	Male 	Ivan 	85

SELECT male.callname as male_callname,female.callname as female_callname FROM `chrys-haefen`.`tbldogs` male
left join `chrys-haefen`.`tbldogs` female on female.litter = male.dog_id
where male.sex = 'male'

SELECT d.callname, d.regname, d.sex, i.filelocation, i.description, (
SELECT callname
FROM tbldogs d2
WHERE d2.litter = d.dog_id
) AS mated
FROM tbldogs d, tblimages i
WHERE d.litter != '0'
AND d.breedID =87
AND i.dogfk = d.dog_id
AND use_pict = 'Y'
ORDER BY sex

callname 	regname 	sex 	filelocation 	description 	mated
Laila 	Chrys-haefen Floatlikeabutafly 	Female 	images/dogs/goldens/laila/layla-stackedsm.jpg 	Laila Stacked 	Ivan
Marley 	Chrys-haefen Don’t Rock T’Boat 	Female 	images/dogs/goldens/marley/marleystackedsm.jpg 	Marley Stacked 	Rigger
Rigger 	Chrys-haefen Rigger Folkins 	Male 	images/dogs/goldens/rigger/riggersm.jpg 	Rigger 	Marley
Ivan 	Guldakra's Ivan Lendl 	Male 	images/dogs/goldens/ivan/ivan-1-year-oldsm.jpg 	Ivan 	Laila

<?php
$output = '';//create variable for holding the output
$sql = $modx->db->query( 'SELECT d.callname, d.regname, i.filelocation, i.description, (
SELECT callname
FROM tbldogs d2
WHERE d2.litter = d.dog_id
) AS mated
FROM tbldogs d, tblimages i
WHERE d.litter != '0'
AND d.breedID =87
AND i.dogfk = d.dog_id
AND use_pict = 'Y'
ORDER BY sex
LIMIT 0 , 1000');//define the DB query, in this case the table is named 'tbldogs'
$resultArray = $modx->db->makeArray($sql);//put it into an array
foreach($resultArray as $item) //go through each record in the array
{//start looping through the data array
$params['sire']=$item['regname'];//set the placeholders, the $params sets the name of the placeholder, the $item is the field name from the DB table
$params['sirecallname']=$item['callname'];
$params['dam']=$item['regname'];
$params['damcallname']=$item['callname'];
$params['photo']=$item['filelocation'];
$params['alt_text']=$item['description'];
$output.=$modx->parseChunk('Golden Litters', $params, '[+', '+]');//define the chunk name and process the content
}//finish looping through the data array
return $output;//now return the output from the processed chunk
?>

id 	SireFK 	DamFK 	dom Date Of Breeding	dow Date of Whelping	rd Relse Date to new home	no_male_puppies Number of Males Born	no_female_puppies Number of Female Puppies born	breedFK BreedID of the litter
1 	129 	85 	NULL 	2009-08-06 	2009-10-01 	7 	3 	87
2 	76 	127 	NULL 	2009-08-05 	2009-09-30 	4 	2 	87