Get user points

Hi,

I have tables:

users: id, name, ...

campaigns: id, name, active, ...

stickers: id, code, points, campaign_id, user_id

prizes: id, name, points,

orders: id, campaign_id, user_id, prize_id

When user register sticker campaign_id and user_id is inserted.

For each campaign i need to get all users with they points for current campaign, minus ordered prize for current campaign.

Anyone can help me to optimize this how to get it, because my current code use more than 100 queries, and its only 3 campaigns and 3 users.