mysql query question

[eluser]keevitaja[/eluser]
hello,

i have 2 tables:

lists:
id
name

contacts:
id
list_id

where lists.id = contacts.list_id

i would like to pull all rows from lists with a count from contacts table as how many current list_id are in contacts table. would produce something like

2 doc 6

where 2 as lists.id, doc as lists.name and 6 as count(contacts.list_id)

how can i do it? can i do it also with active records?