A Database Error Occurred

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column 'jx3.g_item_drops.DropRate' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT `ItemType`, `ItemIndex`, `Min` FROM (`g_item_drops`) WHERE `ClassID` IN ('171', '170', '169', '168', '167', '229', '228', '10', '213', '265', '321', '322', '264', '263', '262', '260', '9', '8', '7', '6', '5', '4') AND `g_item_drops`.`Level` >= '8' AND `g_item_drops`.`Level` <= 9 AND (ItemType =5 AND ItemIndex IN (5486,3526,3001,2860,3528,2861,2858,3529,2862,2859)) ORDER BY `g_item_drops`.`DropRate` Desc LIMIT 200