SELECT *
FROM  `mod_products`
WHERE  `mod_products`.`productNumber`
NOT IN (
    SELECT  `productNumber`
    FROM  `mod_bookings_products`
    WHERE  `bID` =  '20'
)
AND  `mod_products`.`userID` =  '1'
AND  `mod_products`.`subProductToID` !=  '0'