Mine

SELECT DISTINCT `l2jdb_npc`.`id` , `l2jdb_npc`.`level` , `l2jdb_npc`.`name` , `l2jdb_npc`.`title` , `l2jdb_npc`.`hp` ,`l2jdb_npc`.`mp` , `l2jdb_npc`.`xp` , `l2jdb_npc`.`sp` , `l2jdb_npc`.`patk` , `l2jdb_npc`.`pdef` , `l2jdb_npc`.`matk` ,`l2jdb_npc`.`mdef` , `l2jdb_npc`.`id_type` , `l2jdb_npc_type`.`name` AS `type_name` , `l2jdb_spawn`.`id_npc` IS NOT NULL AS `spawned` , `l2jdb_drop`.`category` , (	LEAST( `chance_sum`.`chance_sum` , 1000000 ) * 		LEAST( `l2jdb_drop`.`chance` *6, 1000000 ) / `chance_sum`.`chance_sum`) /10000 AS `real_chance` , `l2jdb_drop`.`min` * FLOOR( MOST(1000000,`l2jdb_drop`.`chance` *6)/1000000 ), `l2jdb_drop`.`max`* (CEIL( `l2jdb_drop`.`chance` *6)/1000000 ))FROM `l2jdb_npc`LEFT JOIN `l2jdb_npc_type` ON `l2jdb_npc`.`id_type` = `l2jdb_npc_type`.`id`LEFT JOIN `l2jdb_spawn` ON `l2jdb_npc`.`id` = `l2jdb_spawn`.`id_npc`LEFT JOIN `l2jdb_drop` ON `l2jdb_npc`.`id` = `l2jdb_drop`.`id_npc`LEFT JOIN (	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	) AS `chance_sum` ON `l2jdb_drop`.`category` = `chance_sum`.`category`			AND `l2jdb_drop`.`id_npc` = `chance_sum`.`id_npc`WHERE NOT `l2jdb_npc`.`name` = ""	AND `l2jdb_drop`.`id_item` =1868	AND `l2jdb_drop`.`category` != -1ORDER BY `l2jdb_npc`.`name` ASCLIMIT 0 , 30