return most recent that i have not already seen

[dtra]

hi all

basically i want to merge these two queries

 //get the user's id
 SELECT user_ID, user_Nick FROM urban_userlog ORDER BY user_LoggedInDate DESC, user_LoggedInTime DESC
 
 //get the id of a user that i have not voted for in the past hour
 SELECT uservotelog_VoteeUserID FROM urban_uservotelog WHERE
 uservotelog_VoterUserID <> '1' AND UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(uservotelog_DateTime) < 3600

the query below, eg. returns 100 records
with the timestamp part taken out, it returns eg. 1000 records
even though i may have voted for only 20 users
so the query below, should return eg. 980 records

all the relavant fields are there, table name is what is before the underscore
votelog contains all vote details, userlog contains user details

    SELECT DISTINCT user_ID, user_Nick FROM urban_userlog 
 		 	LEFT OUTER JOIN urban_uservotelog ON user_ID = uservotelog_VoteeUserID
 		 	WHERE uservotelog_VoterUserID <> '1' AND UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(uservotelog_DateTime) < 3600 
 		 	ORDER BY user_LoggedInDate DESC, user_LoggedInTime DESC

just checked, in fact the query above returns records that i have already seen as well

when i run a query to select who i have voted for in the past hour or half hour using that timestamp method
it returns the correct result

thanks
dave

[r937]

select user_ID
     , user_Nick 
  from urban_userlog 
left outer 
  join urban_uservotelog
    on user_ID 
     = uservotelog_VoteeUserID
   and uservotelog_VoterUserID <> '1' 
   and uservotelog_DateTime
     > date_add(now(), interval 1 hour)
 where uservotelog_VoteeUserID is null     
order
    by user_LoggedInDate desc
     , user_LoggedInTime desc

[dtra]

thanks as always mate
if i move this part into the where statement does this affect the query much

from left outer join to where

AND uservotelog_VoterUserID <> '1'

[r937]

sorry, i don't know

do an EXPLAIN on it, it might shed some light

[dtra]

cool, yeah it was other bad queries that were slowing it down