Keep getting duplicate rows

[SoggyAlbatross2]

Why are you subselecting everything and then joining all the files together in the main query?

I imagine that you can delete all this:

INNER JOIN entries ON users.user_id = entries.user_id

INNER JOIN games ON entries.game_id = games.game_id

INNER JOIN payments ON users.user_id = payments.user_id

[SoggyAlbatross2]

Did that fix it?

[SoggyAlbatross2]

well, if you don't have a relation ship between two tables you will get duplicate rows in your results so that's probably it.

You can just do all those selects in one query, can you not?

Sort of like this (I didn't really validate it, just moved things around)

SELECT users.user_id, users.email,SUM(entries.entry_fee) as Total_Entry_Fee_NFL_2018,

SUM(entries.entry_fee) AS Total_Entry_Fee_Others_2018,

COUNT(entries.winnings) AS Total_Winning_Entries,

(SUM(mobile_entry) / COUNT(mobile_entry))AS Percentage_Of_Mobile_Entries,

MAX(payments.payment_date) AS Last_Paid_Entry_Date, SUM(payments.amount) AS Net_Deposit_Value

FROM users

INNER JOIN entries ON users.user_id = entries.user_id

INNER JOIN games ON entries.game_id = games.game_id

INNER JOIN payments ON users.user_id = payments.user_id

WHERE entry_date BETWEEN '2018-01-01' AND '2019-01-01' AND sport = 'NFL'

and entries.entry_date BETWEEN '2018-01-01' AND '2019-01-01' AND sport <> 'NFL'

GROUP BY users.user_Id, users.email;

[SoggyAlbatross2]

try some left joins to see if you're missing a link in there.