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 ('97', '96', '95', '94', '2') AND `g_item_drops`.`Level` >= '41' AND `g_item_drops`.`Level` <= 41 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