Mine

mysql> explain SELECT lo.identity as online, y.`ID_MEMBER`, y.`memberName`, y.`suspendido`, y.`realName`, y.`birthdate`, y.`dateRegistered`, y.`avatar`, y.`foto_genteya`, y.`foto_camiseta`, y.`versionfoto`, y.`veces_retiradas`, v.`votos`, v.`votos_totales`, v.`esvip`, y.`nombre`, y.`pais`, y.`cod_ciudad`, y.`ciudad`, y.`gender` FROM `votos_totales` v JOIN `yabbse_members` y ON (y.`ID_MEMBER`=v.`id` ) LEFT JOIN `yabbse_log_online` lo ON (lo.identity=y.`ID_MEMBER`) WHERE 1 AND y.`ID_MEMBER`=v.`id` AND y.`suspendido`='0' AND `ganador_semana`='0' AND y.`tiene_foto`='1' ORDER BY v.`votos` DESC LIMIT 0,15;
+----+-------------+-------+--------+------------------------+----------------+---------+---------------------+--------+-------------+
| id | select_type | table | type   | possible_keys          | key            | key_len | ref                 | rows   | Extra       |
+----+-------------+-------+--------+------------------------+----------------+---------+---------------------+--------+-------------+
|  1 | SIMPLE      | v     | index  | PRIMARY                | votos          | 4       | NULL                | 512218 |             | 
|  1 | SIMPLE      | y     | ref    | PRIMARY,ganador_semana | ganador_semana | 6       | const,genteya.v.id  |      1 | Using where | 
|  1 | SIMPLE      | lo    | eq_ref | PRIMARY                | PRIMARY        | 4       | genteya.y.ID_MEMBER |      1 | Using index | 
+----+-------------+-------+--------+------------------------+----------------+---------+---------------------+--------+-------------+