Unnamed
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` GROUP BY `id_npc` , `category` HAVING id_item =1868 SELECT `l2jdb_drop`.`id_npc` , `l2jdb_drop`.`category` , SUM( LEAST( `l2jdb_drop`.`chance` *6, 1000000 ) ) AS `chance_sum` FROM `l2jdb_drop` GROUP BY `id_npc` , `category` HAVING id_item =1868