SELECT COUNT(order_id) AS `Order`, 
       ROUND(SUM(amount), 2) AS `SumOrder`, 
       DATE(`order_date`) AS `groupDate`, 
       COUNT(CASE WHEN payment_status=1 THEN 1 END) AS `Status1`, 
       SUM(CASE WHEN payment_status=1 THEN amount ELSE 0 END) AS `SumStatus1`, 
       COUNT(CASE WHEN payment_status=2 THEN 1 END) AS `Status2`, 
       SUM(CASE WHEN payment_status=2 THEN amount ELSE 0 END) AS `SumStatus2`, 
       COUNT(CASE WHEN payment_status=3 THEN 1 END) AS `Status3`, 
       SUM(CASE WHEN payment_status=3 THEN amount ELSE 0 END) AS `SumStatus3` 
FROM `orders` 
INNER JOIN `orders_status` ON orders.payment_status=orders_status.id 
WHERE (`orders`.`id` IN (SELECT `orders`.`id` 
                         FROM `orders` 
                         LEFT JOIN `paypal_account` ON `orders`.`paypal_account` = `paypal_account`.`paypal_account` 
                         LEFT JOIN `paypal_account_group` ON `paypal_account`.`paypal_group` = `paypal_account_group`.`id`))
  AND (DATEDIFF(CURDATE(), order_date) <= 15) 
GROUP BY `groupDate` 
ORDER BY MIN(groupDate)

SELECT COUNT(*) 
FROM `orders` 
LEFT JOIN `paypal_account` ON `orders`.`paypal_account` = `paypal_account`.`paypal_account` 
LEFT JOIN `paypal_account_group` ON `paypal_account`.`paypal_group` = `paypal_account_group`.`id`