SELECT
    customers.account_code,
    customers.name,
    customer_contacts.first_name,
    customer_contacts.last_name,
    customer_contacts.phone
FROM
    customers
        LEFT JOIN
    customer_contacts ON customers.id = customer_contacts.customer_id
        AND customer_contacts.is_primary = 1
        AND customer_contacts.deleted_at IS NULL
WHERE
    customers.deleted_at IS NULL
        AND account_code IN (
        '1048',
        '05AMGLA',
        '05CCSWI',
        '05MGINS',
        '05SAFEG',
        '05SMART',
        '05SOUTH',
        '101BRIAC',
        '101DCGRA',
        '101GEORG',
        '101GSPJO',
        '101SRDUN',
        '108LMACI',
        '115JAMIE',
        '126CAMPQ',
        '126DSWIN',
        '126MCKEN',
        '126SPITT',
        '126STEVE',
        '206MMCLA',
        '209CRAIM',
        '213BRIAV',
        '213GJEJO',
        '213INDIG',
        '317GREEN',
        '318PROJE',
        '319ANDYW',
        '319DANNY',
        '319JONAT',
        '319VENTU',
        '320ELITE',
        '330ALVEC',
        '330DUTTO',
        '330FOXWI',
        '330HAMPT',
        '330MIDLA',
        '330SECUR',
        '330STRON',
        '330WINDM',
        '330WINTE',
        '331PRAVI',
        '332AMBIE',
        '332CRWIN',
        '332JOHNH',
        '332SCOTL',
        '333AMCGL',
        '333JOHNO',
        '333JOHNT',
        '333REECE',
        '333ROBER',
        '333RYANJ',
        '333SANDS',
        '333SHERB',
        '333WSWIN',
        '335A1DOU',
        '335CHRIS',
        '335GEORG',
        '335MEADO',
        '40BROOS',
        '40CBBUU',
        '40GARDN',
        '40MORLA',
        '40PRECI',
        '40RMWIN',
        '40SAHOM',
        '40SOVER',
        '40STEAM',
        '40WESTW',
        '422BARR1',
        '422KEITH',
        '422KENDA',
        '422PETER',
        '423CALGL',
        '423MART5',
        '423MRWIN',
        '505ADVAN',
        '505CEDAT',
        '650KDMGL',
        '650STEPH',
        '660DAWIN',
        'A2397T',
        'A2423T',
        'A243S',
        'A2473T',
        'A2783T',
        'A3227T',
        'A3484T',
        'A4023S',
        'ALLIANCE',
        'APEXWIND',
        'ARCHIEMC',
        'ASIJOINE',
        'BILLYGRA',
        'CAMBUILD',
        'CLIFFJON',
        'DANDKWIN',
        'DEDRITE',
        'DELOCKSY',
        'DFHJOINE',
        'DGJOINER',
        'DHALL',
        'DHJOINER',
        'DIAMONDW',
        'DIAMONHE',
        'DMILLOYJ',
        'DMWINDOW',
        'DWJOINER',
        'EWANHART',
        'FBARRETT',
        'GARRIOCK',
        'GARRYCAI',
        'GARYBAIG',
        'GARYTAYL',
        'GEORGE&G',
        'GEORGEDI',
        'GORDONMC',
        'GRANTWIL',
        'GWT001',
        'HGG001',
        'JDCOOK',
        'JIMJACK',
        'JOHNST&K',
        'JOSEPHMC',
        'KEVINWHY',
        'MEARNSGL',
        'MH001',
        'MONTGOME',
        'NOBLE',
        'PATERHOM',
        'PLATINUM',
        'PROGLAZE',
        'RD001',
        'SO001',
        'SRJSCOTL',
        'SSWANSON',
        'STEVEAST',
        'STEVIENI',
        'TCJOINER',
        'TEL001',
        'TOTALBUI',
        'TRU001',
        'WINDOWS',
        'WTAGGART',
        'YATESDER')