Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Anders Norrbring (listsnorrbring.se)
Date: Sun Oct 14 2007 - 06:13:21 CDT
I'm trying to set up a query, but I don't really get the result I
expected, so can someone please help me out here?
The query I've built is this:
SELECT a1.username FROM accountuser AS a1
LEFT JOIN (freeaccounts AS f1, payments AS p1)
ON (a1.username = p1.username
AND p1.username = f1.username)
WHERE a1.username LIKE 'cit%'
AND a1.imp + a1.pp + a1.se + a1.auth != 0
AND (f1.free IS NULL OR f1.free = false)
AND (p1.validdate < UNIX_TIMESTAMP(NOW()) OR p1.validdate IS NULL)
The accountuser table is always fully populated.
The freeaccounts and payments tables are only occupied with the
'username' field if it's been used previously, so they may not contain
What I expect to get from the query is 'username' from the accountuser
The a1.username starts with 'cit',
Any of a1.imp, a1.pp, a1.se or a1.auth is not 0,
f1.free is either not populated or false.
p1.validdate is either not populated, or the timestamp is before NOW.
Everything seems to work except for the passed time check. If I set
p1.validdate to a timestamp for something next week, the username is
still returned in the result.
Grateful for any hints...
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql