Обсуждение: Re: [SQL] using LIMIT only on primary table

Try this:

SELECT *
from order_items
where order_id in (select ID from orders order by ID desc limit 100);

DAQ