SELECT isip.subscription_id FROM institutional_subscription_ip isip, subscriptions s, subscription_types st WHERE ((isip.ip_end IS NOT NULL AND 65947472 >= isip.ip_start AND 65947472 <= isip.ip_end AND isip.subscription_id = s.subscription_id AND s.journal_id = 22 AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2021-05-05 19:30:48' >= s.date_start AND '2021-05-05 19:30:48' <= s.date_end))) AND (st.format = 1 OR st.format = 17)) OR (isip.ip_end IS NULL AND 65947472 = isip.ip_start AND isip.subscription_id = s.subscription_id AND s.journal_id = 22 Speed: 0.918 ms