[RESOLVED] Query Compare if the value of a field is doubled

problem solved
i did forgot the distinct function

You need not have edited your post so that other members could have seen what the problem is and apply whatever your solution is.

BTW, using GROUP BY is more optimized than using DISTINCT since distinct will still load all the records and just remove the duplicates while GROUP BY is not.