SQL query to return all results except one catgory’s

I have this query
SELECT p.product_id,
CONCAT(m.name,' ',p.model) as product_model, […]

See original post by invalid@example.com (ftpaccess)