SQL Queries combineren

$res = $db->query("SELECT t.ticketid AS TicketID, uo.organizationname AS Organization, t.fullname AS Contact, ticketmaskid AS Ticket, t.departmenttitle AS Department, ticketstatustitle AS TicketStatus,
SUM((COALESCE(tt.timebillable,0)/60/60)*COALESCE(optionvalue,0)) as Total_Price
FROM swtickets t
LEFT JOIN swtickettimetracks tt ON tt.ticketid = t.ticketid
LEFT JOIN swusers u ON t.userid = u.userid
LEFT JOIN swuserorganizations uo ON u.userorganizationid = uo.userorganizationid
LEFT JOIN swcustomfieldvalues cfv ON tt.tickettimetrackid = cfv.typeid
LEFT JOIN swcustomfieldoptions cfo ON cfo.customfieldoptionid = cfv.fieldvalue
WHERE t.isresolved =1
AND ((date(FROM_UNIXTIME(t.dateline)) BETWEEN '" . $jaardag . "' AND '" . $jaareind . "')) 
GROUP BY  uo.userorganizationid");

2e Query
						
$debnr = $db->query("SELECT t.ticketid AS TicketID, uo.organizationname AS Organization, fieldvalue AS debnr
FROM swtickets t
LEFT JOIN swusers u ON t.userid = u.userid
LEFT JOIN swuserorganizations uo ON u.userorganizationid = uo.userorganizationid
LEFT JOIN swcustomfieldvalues cfv ON uo.userorganizationid = cfv.typeid
WHERE cfv.customfieldid = 3
AND ((date(FROM_UNIXTIME(t.dateline)) BETWEEN '" . $jaardag . "' AND '" . $jaareind . "')) 
GROUP BY  uo.userorganizationid");