Need some help with query

[Smolf3d]

This is work fine

SELECT contests_statistic.START
     , contests_statistic.END
     , contests_statistic.FIRST
     , contests_statistic.SECOND
     , contests_statistic.third
     , contests_statistic.prise_first
     , contests_statistic.prise_second
     , contests_statistic.prise_third
     , contests_statistic.firstsmscontests
     , contests_statistic.secondsmscontests
     , contests_statistic.thirdsmscontests
     , users.id AS firstid
     , users.country AS firstcountry
     , ( SELECT id
     FROM users
     WHERE username = contests_statistic.SECOND) AS secondid
     , ( SELECT country
     FROM users
     WHERE username = contests_statistic.SECOND) AS secondcountry
     , ( SELECT id
     FROM users
     WHERE username = contests_statistic.third) AS thirdid
     , ( SELECT country
     FROM users
     WHERE username = contests_statistic.third) AS thirdcountry
     FROM contests_statistic 
     LEFT JOIN users 
     ON contests_statistic.FIRST = users.username
     ORDER BY contests_statistic.id DESC LIMIT 2

But how can i optimization this query?

[mkoenig]

Thats over my head.

You are in Israel? Im Jewish god bless.

[r937]

SELECT contests_statistic.start
     , contests_statistic.end
     , contests_statistic.first
     , contests_statistic.second
     , contests_statistic.third
     , contests_statistic.prise_first
     , contests_statistic.prise_second
     , contests_statistic.prise_third
     , contests_statistic.firstsmscontests
     , contests_statistic.secondsmscontests
     , contests_statistic.thirdsmscontests
     , user1.id      AS firstid
     , user1.country AS firstcountry
     , user2.id      AS secondid
     , user2.country AS secondcountry
     , user3.id      AS thirdid
     , user3.country AS thirdcountry
  FROM contests_statistic 
LEFT OUTER
  JOIN users AS user1
    ON user1.username = contests_statistic.first
LEFT OUTER
  JOIN users AS user2
    ON user2.username = contests_statistic.second
LEFT OUTER
  JOIN users AS user3
    ON user3.username = contests_statistic.third
ORDER 
    BY contests_statistic.id DESC LIMIT 2

[Smolf3d]

thanks r937