CREATE TABLE `table1` ( 
`ID` int(10) NOT NULL AUTO_INCREMENT, 
`ISBN` varchar(255) DEFAULT NULL, 
`NO` varchar(255) DEFAULT NULL, 
`NOBD` varchar(255) DEFAULT NULL, 
`GOOD` varchar(255) DEFAULT NULL, 
PRIMARY KEY (`ID`), 
KEY `good` (`GOOD`), 
KEY `NO` (`NO`) 
) ENGINE=InnoDB AUTO_INCREMENT=147382 DEFAULT CHARSET=cp1251

CREATE TABLE `table2` ( 
`ID` int(11) NOT NULL AUTO_INCREMENT, 
`IBLOCK_ELEMENT_ID` int(11) NOT NULL, 
`IBLOCK_PROPERTY_ID` int(11) NOT NULL, 
`VALUE` text NOT NULL, 
`VALUE_ENUM` int(11) DEFAULT NULL, 
`VALUE_NUM` decimal(18,4) DEFAULT NULL, 
`DESCRIPTION` varchar(255) DEFAULT NULL, 
PRIMARY KEY (`ID`), 
KEY `ix_iblock_elem_prop_m1_1` (`IBLOCK_ELEMENT_ID`,`IBLOCK_PROPERTY_ID`), 
KEY `ix_iblock_elem_prop_m1_2` (`IBLOCK_PROPERTY_ID`), 
KEY `ix_iblock_elem_prop_m1_3` (`VALUE_ENUM`,`IBLOCK_PROPERTY_ID`), 
KEY `ix_iblock_elem_prop_m1_s4` (`IBLOCK_PROPERTY_ID`,`VALUE`(17)) 
) ENGINE=InnoDB AUTO_INCREMENT=3103932 DEFAULT CHARSET=cp1251

SELECT distinct(m1.`VALUE`)
from table2 m1
  LEFT JOIN table1 a1 ON a1.`GOOD` = m1.`VALUE` or a1.`NO` = m1.`VALUE`
WHERE m1.`IBLOCK_PROPERTY_ID` = '1' and a1.`GOOD` IS NULL and a1.`NO` IS NULL
limit 50000

SELECT m1.`VALUE`
from table2 m1
  LEFT JOIN table1 a1 ON a1.`GOOD` = m1.`VALUE`
WHERE m1.`IBLOCK_PROPERTY_ID` = '1' and a1.`GOOD` IS NULL
UNION
SELECT k1.`VALUE`
from table2 k1
  LEFT JOIN table1 t1 ON t1.`NO` = k1.`VALUE`
WHERE k1.`IBLOCK_PROPERTY_ID` = '1' and t1.`NO` IS NULL