| MuOnline |
SELECT c.owner_guild, c.siege_start_date, c.siege_end_date, c.money, c.tax_rate_chaos, c.tax_rate_store, c.tax_hunt_zone, g.G_Master, g.G_Mark FROM MuCastle_DATA AS c LEFT JOIN Guild AS g ON (c.owner_guild Collate Database_Default = g.G_Name Collate Database_Default)
SELECT r.SEQ_NUM, r.REG_SIEGE_GUILD, r.REG_MARKS, r.IS_GIVEUP, g.G_Master FROM MuCastle_REG_SIEGE AS r INNER JOIN Guild AS g ON(r.REG_SIEGE_GUILD Collate Database_Default = g.G_Name Collate Database_Default) ORDER BY r.SEQ_NUM DESC
|