-- old query
SELECT * FROM order_info o
INNER JOIN order_status sts ON sts.order_info_id = o.order_status_id
WHERE sts.name = 'queued' AND o.username = 'MyUser';

-- new query
SELECT *
FROM (SELECT * FROM order_info o WHERE o.order_status_id = 'queued') AS o
WHERE o.username = 'MyUser';