a tough query

[Adrian Schneider]

So um... what data do you need? Just the columns listed above? Are you showing users that ARE subscribed or those who are not? (etc)

This might get you started... need more info though:

SELECT
	u.userid,
	u.username,
	u.planid,
	p.title as planname,
	h.title as hostname,
	sl.status,
	sl.regdate,
	sl.expirydate
	
FROM user as u
LEFT JOIN hosting_pans as p on (u.planid = p.planid)
LEFT JOIN subscription as s on (h.subscriptionid = s.subscriptionid)
LEFT JOIN subscriptionlog as sl on (sl.subscriptionid = s.subscriptionid)

WHERE u.planid > 0

Then when you process through the results, you can use the dates to do whatever. Or, use the date in the query to restrict it to expired or valid subscriptions.