SELECT `t1`.`Date`, `t1`,`AOrd`, `t2`,`COrd`
FROM (
SELECT SUM(`price`) as `AOrd`, `Date`
FROM `orders`
JOIN `track_params` ON `orders`.`trackid` = `track_params`.`trackid`
GROUP BY DATE(`Date`)
) AS `t1`
LEFT JOIN (
SELECT SUM(`price`) as `COrd`, `Date`
FROM `orders`
JOIN `track_params` ON `orders`.`trackid` = `track_params`.`trackid`
WHERE `status` = 2
GROUP BY DATE(`Date`)
) AS `t2` USING(`Date`)