SELECT qr.ID AS ID,
c.ID AS CalendarID,
DATE_FORMAT(QuoteDate,'%m-%d-%Y') AS QuoteDate,
DATE_FORMAT(`Start`,'%m-%d-%Y') AS VerDate,
TIME_FORMAT(`Start`,'%h:%i %p') AS VerTime,
Name, MakeModel, CONCAT_WS('-',Prefix, Telephone) AS Phone,
Email,
Address,
City,
State,
Zipcode,
MilesQuoted,
AmtQuoted,
AmtCharged,
ServiceFee
FROM quoterequests qr

RIGHT JOIN calendar c
ON Quote = qr.ID

WHERE AmtCharged > 0
AND YEAR(`Start`) = 2015
GROUP BY
ID,
CalendarID,
`Name`,
MakeModel,
Phone,
MilesQuoted,
AmtCharged
ORDER BY UNIX_TIMESTAMP(`Start`) ASC