CREATE TEMPORARY TABLE IF NOT EXISTS x_t AS
    SELECT
        t.*
    FROM
        `dfi_leads_log_cache` t
    WHERE t.WebsiteId IN ('962', '966', '1008', '1070')
    ORDER BY t.SentDate DESC
    LIMIT 10000;
SELECT
    IFNULL(tt.`CustFullName`, "(Unknown)") AS `Name`,
    IF(tt.`LeadType` = 1, tt.Campaign, "") AS Campaign
FROM
    x_t tt ;


SELECT
    IFNULL(tt.`CustFullName`, "(Unknown)") AS `Name`,
    IF(tt.`LeadType` = 1, tt.Campaign, "") AS Campaign
FROM
    x_t tt
    LEFT JOIN dfi_leads_log ll
        ON ll.`Id` = tt.`LeadLogId`
        AND tt.`LeadType` = 1
    LEFT JOIN dfi_lead_sms_log sl
        ON sl.`Id` = tt.`LeadLogId`
        AND tt.`LeadType` = 2
    LEFT JOIN dfi_lead_phone_log pl
        ON pl.`Id` = tt.`LeadLogId`
        AND tt.`LeadType` = 3
    LEFT JOIN dfi_customer_data cd
        ON cd.`Id` = tt.`CustomerId`
    LEFT JOIN dealers d
        ON d.id = ll.DealerId
        OR d.id = sl.DealerId
        OR d.id = pl.DealerId