[DB-SIG] Mysql query

[Patricia]

Hi all,

I'm having a hard time trying to create this query.
I have two tables:
log - columns: id, name and date
info - columns: id, tag, value

i.e.:
log
id | name                  | date
-------------------------------------
1  | machine_name          | 07/31/06
2  | another_machine_name  | 08/01/06

info
id  | tag       | value
--------------------------------
1   | release   | release_name
1   | arch      | 32-bit
1   | mode      | amode
2   | release   | release_name
2   | arch      | 64-bit
2   | mode      | amode

Basically, the info table contains detailed information of 
each machine in the log table. The same machine can appear 
more than once, but with a different id number, that's why
I use group by in the following query:

 select lo.name, inf.value, lo.date from log as lo 
 join info as inf on lo.id=inf.id where (inf.tag='release' 
 and inf.tag='arch') AND lo.id in (select max(id) 
 from log group by name) order by name

Everything worked well, but now I've been asked to display
this data based on "mode" (located in the info table). 
I don't have to display mode, but I have to use it as 
a condition since there are more than two modes. 
I'm not sure how to add this condition to the query, though. 
I tried adding this to the query above but, of course, 
it didn't work:
 
 AND inf.id in (select id from info where value LIKE %s)

I'd appreciate any help
Thanks,
Patricia