SELECT CONCAT('UPDATE spawn2 SET min_expansion = ', s2.min_expansion, ' WHERE spawngroupid = ', s2.spawngroupid, ' -- ', n.name, ' lvl ', n.level, ' ', se.chance, '% chance in ', s2.zone) spawn2
FROM spawn2 s2 INNER JOIN spawnentry se ON s2.spawngroupid = se.spawngroupid INNER JOIN npc_types n ON n.id = se.npcid
WHERE s2.zone = 'guktop' AND s2.min_expansion = 0 GROUP BY s2.spawngroupid ORDER BY n.level DESC;
for first pass, nothing comes to mind
SELECT CONCAT('UPDATE spawn2 SET min_expansion = ', s2.min_expansion, ' WHERE spawngroupid = ', s2.spawngroupid, ' -- ', n.name, ' lvl ', n.level, ' ', se.chance, '% chance in ', s2.zone) spawn2 FROM spawn2 s2 INNER JOIN spawnentry se ON s2.spawngroupid = se.spawngroupid INNER JOIN npc_types n ON n.id = se.npcid WHERE s2.zone = 'guktop' AND s2.min_expansion = 0 GROUP BY s2.spawngroupid ORDER BY n.level DESC;