Discuz! info: MySQL Query Error

Time: 2024-11-21 3:19pm
Script:

SQL: SELECT p.*, a1.aid a1id, a1.japanese a1jp, a1.chinese a1cn, a1.english a1en, a1.battleeffect a1be, a1.mapeffect a1mbe,
a2.aid a2id, a2.japanese a2jp, a2.chinese a2cn, a2.english a2en, a2.battleeffect a2be, a2.mapeffect a2mbe,
a3.aid a3id, a3.japanese a3jp, a3.chinese a3cn, a3.english a3en, a3.battleeffect a3be, a3.mapeffect a3mbe
FROM bwdex_pokemon_general p
LEFT JOIN bwdex_ability a1 ON = a1.aid
LEFT JOIN bwdex_ability a2 ON = a2.aid AND != 0
LEFT JOIN bwdex_ability a3 ON = a3.aid AND != 0
WHERE p.pmid = 649
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= a1.aid \x0D\x0A\x09\x09\x09\x09\x09\x09 LEFT JOIN bwdex_ability a2 ON = a2.ai' at line 5
Errno.: 1064