la tua clausoka WHERE ti puo restituire solamente 1 record
SELECT MAX( order_history_id ) FROM `order_history` GROUP BY `order_id`

Pertanto al posto di " IN " mettici " = "


.