SELECT
                    d.domain_id,
                    d.domain_url,
                    d.db,
                    (CASE ISNULL(pd.m_token) WHEN TRUE THEN LCASE(d.m_token) ELSE LCASE(pd.m_token) END) m_token,
                    (CASE ISNULL(pd.m_token) WHEN TRUE THEN 0 ELSE 1 END) from_partner,
                    ext.m_ext as marketing_ext,
                    ext.m_partner_id as marketing_partner
                FROM modx_shared.wt_domain d
                LEFT JOIN modx_shared.wt_partner_domains pd
                    ON d.domain_id = pd.domain_id
                    AND "" LIKE CONCAT("%", pd.domain, "%")
                LEFT JOIN modx_shared.wt_token_ext_lookup ext
                    ON ext.m_token = (CASE ISNULL(pd.m_token) WHEN TRUE THEN d.m_token ELSE pd.m_token END)
                WHERE
                    d.domain = "FitLivingSolutions.com"
                    AND d.client_partner = "GB"
                    AND d.m_token <> ""