[phpOpenTracker-User] Check my logic?

Does the following 'make sense' - it is trying to extract the 

page views, visits, and visitors to a document with 'success.php' in it 

cheers
simon 

SELECT 

COUNT( pot_documents.data_id) Pages, 

COUNT( DISTINCT pot_accesslog.accesslog_id) Visits, 

COUNT( DISTINCT pot_visitors.visitor_id) Visitors 

FROM 

pot_accesslog, pot_documents, pot_visitors 

WHERE 

pot_accesslog.document_id = pot_documents.data_id 

AND 

pot_visitors.client_id = 1 

AND 

pot_accesslog.accesslog_id = pot_visitors.accesslog_id 

AND 

pot_documents.document_url LIKE '%success.php%' 



-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01