Problème avec la requête:
SELECT b.bid, b.date, p.*, s.id AS sid, s.level, s.x, s.y, s.name AS system, g9pl.name AS player, g9pl.id AS pid,
b7a.tag AS b7_tag, b8a.tag AS b8_tag, b9a.tag AS b9_tag, b10a.tag AS b10_tag,
g1a.tag AS g1_tag, g2a.tag AS g2_tag, g3a.tag AS g3_tag, g4a.tag AS g4_tag, g5a.tag AS g5_tag, g6a.tag AS g6_tag, g7a.tag AS g7_tag, g8a.tag AS g8_tag, g9a.tag AS g9_tag
FROM (g9_planets p, g9_starmap s)
LEFT JOIN b7_player b7pl ON (b7pl.id=p.ownerid)
LEFT JOIN b7_alliances b7a ON (b7pl.alliance=b7a.id)
LEFT JOIN b8_player b8pl ON (b8pl.id=p.ownerid)
LEFT JOIN b8_alliances b8a ON (b8pl.alliance=b8a.id)
LEFT JOIN b9_player b9pl ON (b9pl.id=p.ownerid)
LEFT JOIN b9_alliances b9a ON (b9pl.alliance=b9a.id)
LEFT JOIN b10_player b10pl ON (b10pl.id=p.ownerid)
LEFT JOIN b10_alliances b10a ON (b10pl.alliance=b10a.id)
LEFT JOIN g1_player g1pl ON (p.ownerid=g1pl.id)
LEFT JOIN g1_alliances g1a ON (g1pl.alliance=g1a.id)
LEFT JOIN g2_player g2pl ON (p.ownerid=g2pl.id)
LEFT JOIN g2_alliances g2a ON (g2pl.alliance=g2a.id)
LEFT JOIN g3_player g3pl ON (p.ownerid=g3pl.id)
LEFT JOIN g3_alliances g3a ON (g3pl.alliance=g3a.id)
LEFT JOIN g4_player g4pl ON (p.ownerid=g4pl.id)
LEFT JOIN g4_alliances g4a ON (g4pl.alliance=g4a.id)
LEFT JOIN g5_player g5pl ON (p.ownerid=g5pl.id)
LEFT JOIN g5_alliances g5a ON (g5pl.alliance=g5a.id)
LEFT JOIN g6_player g6pl ON (p.ownerid=g6pl.id)
LEFT JOIN g6_alliances g6a ON (g6pl.alliance=g6a.id)
LEFT JOIN g7_player g7pl ON (p.ownerid=g7pl.id)
LEFT JOIN g7_alliances g7a ON (g7pl.alliance=g7a.id)
LEFT JOIN g8_player g8pl ON (p.ownerid=g8pl.id)
LEFT JOIN g8_alliances g8a ON (g8pl.alliance=g8a.id)
LEFT JOIN g9_player g9pl ON (p.ownerid=g9pl.id)
LEFT JOIN g9_alliances g9a ON (g9pl.alliance=g9a.id)
LEFT JOIN best_planets b ON (b.x=s.x AND b.y=s.y AND b.system=CONCAT(SUBSTRING_INDEX(s.name, '
', 1),' ', p.planetid) AND b.id=p.ownerid)
WHERE s.id='121' AND p.systemid=s.id
ORDER BY p.planetid
.
Code d'erreur: 1146
Erreur MySQL: Table 'azgharde.b8_alliances' doesn't exist