At the first of the month (no changes made to the database; this script is
just running SELECT statements at present) the number of rows returned by
this query dropped noticeably. Is this a bug, is my query just fubar'd,
or...?
SELECT account.username AS account_username, customers.username AS
customers_username, account.accout_no, account.email, customers.last_mod
FROM account LEFT JOIN customers ON account.username = customers.username
WHERE (customers.username IS NULL OR customers.username LIKE
\"%_expired\") OR (customers.last_mod <= current_date() - 14 AND
customers.access_status = 'D') ORDER BY last_mod";
The number of rows returned:
4/10 253
4/9 247
4/8 243
4/7 241
4/6 234
4/5 226
4/4 221
4/3 216
4/2 207
4/1 197
3/31 333
3/30 312
Thanks!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
