Hey guys,
Im currently developing a jumpmod with mysql support (thx to kung for porting mysql to cod2) and am in need of a certain query.
What i have: A table filled with statistics for a certain checkpoint (checkpoint_statistics)
What i want: the 10th time_played from that table for a certain cp_id
What i think might work, but doesnt:
Please help meCode:SELECT time_played FROM (SELECT * FROM checkpoint_statistics WHERE cp_id = 1081 ORDER BY time_played DESC LIMIT 10) LIMIT 1