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

Reply via email to