Nikola pregled2

SELECT
  `view_money_flow`.`our_party_id`     AS `our_party_id`,
  `view_money_flow`.`our_party_name`   AS `our_party_name`,
  `view_money_flow`.`their_party_id`   AS `their_party_id`,
  `view_money_flow`.`their_party_name` AS `their_party_name`,
  `view_money_flow`.`currency_name`    AS `currency_name`,
  -- `view_money_flow`.`description`      AS `description`,
  -- `view_money_flow`.`type`             AS `type`,

  FORMAT(SUM((CASE WHEN ((`view_money_flow`.`type` = 'OUR') AND (`view_money_flow`.`description` = 'invoice'))
  THEN `view_money_flow`.`amount` WHEN ((`view_money_flow`.`type` = 'THEIR') AND (`view_money_flow`.`description` = 'invoice'))
  THEN -(`view_money_flow`.`amount`) WHEN ((`view_money_flow`.`type` = 'OUR') AND (`view_money_flow`.`description` = 'payment'))
  THEN `view_money_flow`.`amount` WHEN ((`view_money_flow`.`type` = 'THEIR') AND (`view_money_flow`.`description` = 'payment'))
  THEN -(`view_money_flow`.`amount`) END)),2) AS `amount`

FROM `view_money_flow`
WHERE (`view_money_flow`.`due_date` <= CURDATE()) AND our_party_id =1
GROUP BY `view_money_flow`.`our_party_id`,`view_money_flow`.`their_party_id`,`view_money_flow`.`currency_name`
ORDER BY amount DESC