[phpOpenTracker-User] Unique vistiors to a single doc

If i wanted to get the unique users to a page would this query do that? It
appears to work, but is there a better way.

I'm trying to set up a waterfall graph. Showing attrition of users as they
move from one page to the next in a sales process.

SELECT COUNT(DISTINCT(vis.visitor_id)) FROM `pot_visitors` AS vis,
pot_accesslog as Acc WHERE Acc.document_id = **INSERT DOC ID HERE*** AND
Acc.accesslog_id = vis.accesslog_id

Cheers.
S

(thanks very much for POT sebastian)



-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click