Heool

header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept");

CREATE 

    ALGORITHM = UNDEFINED 

    DEFINER = `Teamunited123`@`%` 

    SQL SECURITY DEFINER

VIEW `submitted_lastmonth` AS

    SELECT 

        COUNT(`crm`.`lead_id`) AS `leadid`,

        `crm`.`app_date` AS `appdate`

    FROM

        (`call_response_master` `crm`

        LEFT JOIN `lead_master` `lm` ON (((`lm`.`lead_id` = `crm`.`lead_id`)

            AND (`lm`.`lead_status` = 1))))

    WHERE

        ((`crm`.`client_id` = 1)

            AND (`crm`.`status_id` = 11)

            AND (`crm`.`app_date` >= (CAST(NOW() AS DATE) - INTERVAL 60 DAY)))

    GROUP BY `crm`.`app_date`