Edit Database Connection - Houston Metro None technical

Database Connection

Default Query

Here's your updated query with comprehensive technical NAICS codes: sqlSELECT email, CONCAT(name, ' in ', COALESCE(physical_city, ''), ', ', COALESCE(physical_state, ''), COALESCE(CONCAT(' | ', certification_type), ''), COALESCE(CONCAT(' | ', industry), ''), COALESCE(CONCAT(' | ', description), '')) AS outreach_reason FROM organizations WHERE email IS NOT NULL AND email != '' AND is_active = 1 AND (commodity_codes_raw IS NULL OR commodity_codes_raw NOT REGEXP '334[0-9]{3}|423430|423690|511210|516110|516210|517[0-9]{3}|518[0-9]{3}|541310|541320|541330|541340|541350|541360|541370|541380|541511|541512|541513|541519|541611|541612|541614|541618|541690|541713|541714|541715|541720|541990|811212');

Query must return email and outreach_reason columns