I am not shure about recalculating constants in mysql. Try
.........
where activity.event_time_unix <= const
..........
where const is the result of 981990589 - (2* ( 24 * (60 * 60) ) )
----- Original Message -----
From: Bryan Hunt <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 7:09 PM
Subject: Can anyone suggest a more efficient method
> I have two tables, one contains units one contains activity
> I run this query ......
>
> select unit.dialup_user, unit.address1, activity.dialup_user
> from unit
> LEFT JOIN activity ON
> (unit.dialup_user = activity.dialup_user)
> where !(activity.event_time_unix > (981990589 - (2* ( 24 * (60 *
> 60) ) ) ) ) && unit.status ="Active"
> GROUP BY unit.id
>
> What I am trying to do is select every unit that does not have an entry in
> the activity table after a certain unix time.
> Any help would be much appreciated
>
>
> Here is the output from the explain command
> table type possible_keys key key_len ref rows
> Extra
> ----- ---- ------------- --- ------- --- ----
> -----
> unit ALL NULL NULL NULL NULL 840 where used; Using
> temporary
> activity ALL NULL NULL NULL NULL 29109 where used
>
> (2 row(s) affected)
>
>
> Bryan Hunt
> Developer
> Netnote Inc
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
