just in case anyone will need it:
Code:
SELECT * FROM ( SELECT *, (CAST( wins AS float )/CAST( cups AS float)) AS winns FROM cup_info ) ORDER BY winns*players DESC, cups DESC, wins DESC LIMIT 15;
withotu making int to float, too many 0 results were in table...so floating is the fix
__________________