empty result when using a subquery select

Use a left join instead. It is faster with many values anyway:

SELECT t1.article 
FROM table1 t1
LEFT JOIN table2 t2 ON t1.article = t2.article
WHERE t2.article IS NULL