SQL - Get value of column for rows matching a string AND a list of strings not found in the table

join shbcf.ru