Someone
public sql v1 · immutable SELECT `l2jdb_drop`.`id_npc` , `l2jdb_drop`.`category` , SUM( LEAST( `l2jdb_drop`.`chance` *6, 1000000 ) ) AS `chance_sum` FROM `l2jdb_drop` WHERE id_item =1868 GROUP BY `id_npc` , `category` SELECT `l2jdb_drop`.`id_npc` , `l2jdb_drop`.`category` , SUM( LEAST( `l2jdb_drop`.`chance` *6, 1000000 ) ) AS `chance_sum` FROM `l2jdb_drop` WHERE id_item =1868 GROUP BY `id_npc` , `category`