php - Querying records based on join not returning expected resultsGet the solution ↓↓↓
I want to retrieve subscriptions that have expired in the last 6 hours.
Why not just do something like this?
SELECT DISTINCT t.subscription_id FROM app_transactions t WHERE t.expiration > now() - interval 6 hour;
If expirations can be in the future as well:
SELECT DISTINCT t.subscription_id FROM app_transactions t WHERE t.expiration > now() - interval 6 hour AND t.expiration < now();
Your comment requires a small tweak to this query, basically
GROUP BY instead of
SELECT t.subscription_id FROM app_transactions t WHERE (t.expiration > now() - interval 6 hour AND t.expiration < now() ) OR t.expiration IS NULL GROUP BY t.sucscription_id HAVING SUM( t.expiration IS NULL ) = 0; -- no NULL ones
Share solution ↓
Link To Answer People are also looking for solutions of the problem: xml parsing error: no root element found
Didn't find the answer?
Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.
Find the answer in similar questions on our website.
Write quick answer
Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.