Count problem

So you want results for different warenkorb_havesUSER_id users, instead of just warenkorb_havesUSER_id = 3?

Code:

SELECT warenkorb_havesUSER_id, COUNT(warenkorb_havesUSER_id) AS anzahl02 FROM warenkorb WHERE warenkorb_status = 2 GROUP BY warenkorb_havesUSER_id

This will return different warenkorb_havesUSER_id's with related row counts.