如何限制ScheduledExecutorService(How to restrict ScheduledExecutorService)

 你真的应该规范你的数据，将标签存储在一个单独的表中，这样你就不必像这样做超复杂的逻辑。 
 
 同时，你的问题是布尔组。 并优先于OR，所以你的查询应该是 
 
SELECT
    company.domain,
    company.company_name,
    CONCAT_WS(
        ',',
        company.business_sector,
        company.tags
    ) AS 'tags',
        GROUP_CONCAT(
            employee.employee_id SEPARATOR ','
        ) AS 'employee_ids',
        COUNT(employee.employee_id) AS 'employees'
FROM
    company
INNER JOIN employee ON company.domain = employee.domain
WHERE
    (company.tags REGEXP '^Retail| Retail |Retail$'
    OR company.business_sector LIKE '%Retail%')
AND company.tags NOT REGEXP '^Apparel| Apparel |Apparel$'
AND company.business_sector NOT LIKE '%Apparel%'
AND company.domain NOT IN (
    '@hotmail.com',
    '@gmail.com',
    '@aol.com'
)
GROUP BY
    company.domain
 
 密切关注圆括号的位置。 

I found something that works perfect for now, I'm using a MATCH AGAINST full-text search method:
 
SELECT
    company.domain,
    company.company_name,
    CONCAT_WS(
        ',',
        company.business_sector,
        company.tags
    ) AS 'tags',
    GROUP_CONCAT(
        employee.employee_id SEPARATOR ','
    ) AS 'employee_ids',
    COUNT(employee.employee_id) AS 'employees',
    COUNT(ct_connections.id) AS 'already_connected'
FROM
    company
INNER JOIN employee ON company.domain = employee.domain
LEFT JOIN ct_connections ON employee.email = ct_connections.email
AND ct_connections.client_id = 1
WHERE
    (
        MATCH (company.tags) AGAINST ('Retail')
        OR company.business_sector LIKE '%Retail%'
    )
AND (
    NOT MATCH (company.tags) AGAINST ('Apparel')
    AND company.business_sector NOT LIKE '%Apparel%'
    AND NOT MATCH (company.tags) AGAINST ('Footwear')
    AND company.business_sector NOT LIKE '%Footwear%'
)
AND company.domain NOT IN (
    '@hotmail.com',
    '@gmail.com',
    '@aol.com'
)
GROUP BY
    company.domain