1 means any. Basically, it tests the subquery for the existence of one or more rows.

In our case, it is WHERE NOT EXISTS, so the final result should satisfy the condition that the subquery (the 2nd SELECT) has 0 rows return.

http://www.w3resource.com/sql/special-operators/sql_exists.php