SELECT `l2jdb_drop`.`id_npc` , `l2jdb_drop`.`category` , SUM( LEAST( `l2jdb_drop`.`chance` *6, 1000000 ) ) AS `chance_sum` FROM `l2jdb_drop` WHERE ( `id_npc` , `category` ) IN ( SELECT `id_npc` , `category` FROM `l2jdb_drop` WHERE id_item =1868 ) GROUP BY `id_npc` , `category`