Houston Metro None technical
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');
Select a data source above to see its default query.