SELECT
    proposal.id,
    project.`start_on_development`,
    IFNULL(project.`project_origin`, 'unknown'),
    IFNULL(project.`market`, 'unknown'),
    IFNULL(project.`source_analytic`, 'unknown'),
    CONCAT(project.id, ' - ', project.title) AS Project,
    CONCAT(customer.id, ' - ', IFNULL(customer.name,''), ' ', IFNULL(customer.surname,'')) AS Customer,
    CONCAT(customer.id, ' - ', IFNULL(developer.name,''), ' ', IFNULL(developer.surname,'')) AS Developer,
    CONCAT(adminUser.id, ' - ', IFNULL(adminUser.name,''), ' ', IFNULL(adminUser.surname,'')) AS AdminUser,
    ROUND(SUM(task.`currency_price`), 2) AS Price,
    ROUND(SUM(task.`developer_price`), 2) AS Cost,
    ROUND(SUM(task.`currency_price`) - SUM(task.`developer_price`), 2) AS Margin
FROM (((((`yp_proposal` proposal
INNER JOIN `yp_task` task ON task.`proposal_id` = proposal.`id`)
INNER JOIN `yp_project` project ON proposal.`project_id` = project.`id`)
INNER JOIN `yp_yeeply_user` customer ON customer.id = project.`projects_as_client_id`)
INNER JOIN `yp_yeeply_user` developer ON developer.id = project.`projects_as_dev_id`)
INNER JOIN `yp_admin_user` adminUser ON adminUser.id = project.`adminUser_id`)
WHERE project.`admin_status` = 'won' AND proposal.`status` = 'status_accepted' AND DATE(project.`start_on_development`) = DATE(CURRENT_DATE-1)
GROUP BY proposal.id