i tried running this sql
but i get some errors
// mini-boss
select item_db.id, name_japanese from item_db right join mob_db on item_db.id = mob_db.dropcardid
where mode & 32 and type = 6 and mexp = 0
and item_db.id not in
(
select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid
where ~mode & 32 and type = 6
)
and item_db.id not in
(
select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid
where mode & 32 and type = 6 and mexp != 0
)
group by item_db.id order by name_japanese;
// MVP
select item_db.id, name_japanese from item_db right join mob_db on item_db.id = mob_db.dropcardid
where mode & 32 and type = 6 and mexp != 0
and item_db.id not in
(
select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid
where ~mode & 32 and type = 6
)
and item_db.id not in
(
select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid
where mode & 32 and type = 6 and mexp = 0
)
group by item_db.id order by name_japanese;
