Oh, that is true, i'll try to fix that issue.
So, the following syntax for try to recover data from normal, mvp and boss cards should be work right?.
query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE type = 6 group by name_japanese", .@id);
query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE mexp > 0 and type = 6 by name_japanese", .@MVP);
query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE mode & 32 and type = 6 by name_japanese", .@BOSS);
Note: i'm using the following script : Link
Greetings.-