Select results from common “” and join another table, MySQL

Language: Layout:

drop table if exists Service;
drop table if exists Client_;
drop table if exists ClientService;
drop table if exists HostingAccount;

CREATE TABLE Service
    (`ServiceID` int, `ServiceType` int)
;
    
INSERT INTO Service
    (`ServiceID`, `ServiceType`)
VALUES
    (1, 1),
    (2, 1),
    (3, 1),
    (4, 2)
;

CREATE TABLE Client_
    (`ClientID` int, `UserID` int, `CustomerID` int)
;
    
INSERT INTO Client_
    (`ClientID`, `UserID`, `CustomerID`)
VALUES
    (10, 1, 1),
    (134, 2, 2),
    (135, 3, 3),
    (137, 4, 4),
    (273, 5, 5)
;

CREATE TABLE ClientService
    (`ClientServiceID` int, `ClientID` int, `ServiceID` int, `Description` varchar(33))
;
    
INSERT INTO ClientService
    (`ClientServiceID`, `ClientID`, `ServiceID`, `Description`)
VALUES
    (28, 10, 2, 'Premium master "multaps1.com"'),
    (48, 134, 2, 'Premium master "multaps3.com"'),
    (58, 135, 2, 'Premium master "multaps4.com"'),
    (68, 137, 2, 'Premium master "multaps5.com"'),
    (366, 273, 1, 'Webhosting master "multaps10.com"')
;

CREATE TABLE HostingAccount
    (`HostingAccountID` int, `Domain` varchar(12), `DomainIP` int, `Username` varchar(7), `Email` varchar(21))
;
    
INSERT INTO HostingAccount
    (`HostingAccountID`, `Domain`, `DomainIP`, `Username`, `Email`)
VALUES
    (2, 'multaps1.com', 7, 'Bert', 'Bert@in.com'),
    (3, 'multaps2.com', 9, 'Bernard', 'nard.@Sedn.ca'),
    (4, 'multaps3.com', 3, 'Bree', 'Aenean@Cum.org'),
    (5, 'explts.com', 1, 'exploi', 'ante@cursusluctus.edu'),
    (6, 'multaps5.com', 10, 'Rama', 'quis@tempusrisusuk')
;

SELECT DISTINCT C.CustomerID,
				CS.Description,
                HA.Email,
                HA.Domain,
                HA.UserName
FROM ClientService AS CS
INNER JOIN Client_ AS C ON C.ClientID=CS.ClientID
LEFT JOIN Service As S ON CS.ServiceID = S.ServiceID
LEFT JOIN HostingAccount AS HA ON  CS.Description LIKE CONCAT('%', HA.Domain, '%')
WHERE S.ServiceType IN (1, 2, 3)
ORDER BY HA.HostingAccountID DESC;

drop table if exists Client_;
drop table if exists ClientService;
drop table if exists HostingAccount;
drop table if exists Service;


absolute service time: 0,38 sec