OK, I get
SELECT products.*, productcategories.* FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID WHERE ProductID = '-1' OR CatPermalink = 'brush'
have run it on 2 tables (products and productcategories) and nothing shows in the results in either of them.