Statcounter SQL Code
Statcounter, that popular web statistics and usage tracking site, threw me some of their SQL code last night:
66.98.208.5#Resource id #17 account: select pk_user_id, username, firstname, lastname, companyname, country, email, code, name, date_type, clock_type, timezone, show_results from user,user_type where fk_user_type_id=pk_user_type_id and fk_account_id=’305813′ AND user_type.code <> ‘admin’ AND user_type.code <> ’site_admin’ AND user_type.code <> ’site_support’
66.98.208.5#Resource id #17 account: SELECT timezone FROM timezone WHERE country=’United States’
Of course, the code is relatively boring, and we can’t learn much about their internals from it.
This entry was posted on Wednesday, October 25th, 2006 at 9:35 pm and is tagged with code lt, clock type, sql code, resource id, type id, web statistics, account id, internals, timezone, united states. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback.
