All pastes #423088 Raw Edit

Someone

public sql v1 · immutable
·published 2007-04-03 22:01 UTC
rendered paste body
	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`