Hi Shawn,

I wondered if you might be able to help me with an SQL query. I want to list all the internet sites I've surfed in my database. Here's a query that matches the url with a urlid:

SELECT concat(usc.scheme,"://",us.server,up.path) FROM url_visit uv INNER JOIN url_servers us ON us.id=uv.url_server_ID INNER JOIN url_paths up ON up.id=uv.url_path_ID INNER JOIN url_queries uq ON uq.id=uv.url_query_ID INNER JOIN url_schemes usc ON usc.id=uv.url_scheme_ID AND uv.urlid=10023;

And that works really quickly. However I want to run this for each urlid matching my uid in table internet_usage.

mysql> desc internet_usage; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | uid | varchar(10) | YES | MUL | NULL | | | time | datetime | YES | | NULL | | | ip | bigint(20) | YES | | 0 | | | urlid | mediumint(9) | | | 0 | | | size | int(11) | YES | | 0 | | +-------+--------------+------+-----+---------+-------+

So maybe it's something like:

SELECT iu.time, INET_NTOA(iu.ip), concat(usc.scheme,"://",us.server,up.path) FROM internet_usage us, url_visit uv WHERE iu.uid="u752352" INNER JOIN url_servers us ON us.id=uv.url_server_ID INNER JOIN url_paths up ON up.id=uv.url_path_ID INNER JOIN url_queries uq ON uq.id=uv.url_query_ID INNER JOIN url_schemes usc ON usc.id=uv.url_scheme_ID

But I haven't tried this because my tables are very big and I didn't want to do the wrong join!

Thanks for any help you can offer.

js.