Hi, Thanks for the feedback on my earlier problem. I have come up with a query: SELECT *, count(contact_id) AS theCount FROM eventlog LEFT JOIN contacts ON contacts._id = eventlog.contact_id WHERE TYPE = 'CLICK' AND link_id IN (1,2) GROUP BY contact_id HAVING theCount = 2 Thing is it takes forever to run, I haven't seen it complete yet i just have to keep killing the process. I have read up on optimisation and have added some index's to the eventlog table: contact_id and link_id (contact_id on the contacts table is the PK anyways so thats fine). Any ideas on how to speed this up. (In the process list it says the state is "Copying to tmp table" for ages). Thanks Carl Chambers
