Помогите оптимизировать SQL запрос, пожалуйста.
SELECT
tx5_wdata.id AS map_id,
tx5_wdata.fieldtype AS map_fieldtype,
tx5_wdata.oasistype AS map_oasis,
tx5_wdata.x AS map_x,
tx5_wdata.y AS map_y,
tx5_wdata.occupied AS map_occupied,
tx5_wdata.image AS map_image,
tx5_odata.conqured AS oasis_conqured,
info_user_oasis.username AS oasis_user,
info_user_oasis.tribe AS oasis_tribe,
info_alliance_oasis.tag AS oasis_alli_name,
tx5_vdata.wref AS ville_id,
tx5_vdata.owner AS ville_user,
tx5_vdata.name AS ville_name,
tx5_vdata.capital AS ville_capital,
tx5_vdata.pop AS ville_pop,
tx5_users.id AS user_id,
tx5_users.username AS user_username,
tx5_users.tribe AS user_tribe,
tx5_users.alliance AS user_alliance,
tx5_alidata.id AS aliance_id,
tx5_alidata.tag AS aliance_name
FROM ((((((tx5_wdata
LEFT JOIN tx5_vdata ON tx5_vdata.wref = tx5_wdata.id )
LEFT JOIN tx5_odata ON tx5_odata.wref = tx5_wdata.id )
LEFT JOIN tx5_users AS info_user_oasis ON info_user_oasis.id = tx5_odata.owner )
LEFT JOIN tx5_alidata AS info_alliance_oasis ON info_alliance_oasis.id = info_user_oasis.alliance )
LEFT JOIN tx5_users ON tx5_users.id = tx5_vdata.owner )
LEFT JOIN tx5_alidata ON tx5_alidata.id = tx5_users.alliance )
where tx5_wdata.id IN ($maparray)
ORDER BY FIND_IN_SET(tx5_wdata.id,'$maparray2')
Простой
