Tests of getItemData

No date, will be yesterday - query
  CLICKTHROUGHS DATE DOWNLOADS ITEMVIEWS TITLE URL
query
RESULTSET
query [Filtered - Top 100 of 453 rows]
  CTSUM DOWNLOADS ITSUM TITLE URL
1 119 0 602 Running Model-Glue 3 on a box with Model-Glue 2 http://www.coldfusionjedi.com/index.cfm/2008/5/7/Running-ModelGlue-3-on-a-box-with-ModelGlue-2
2 147 0 600 Quick CFBL update and a minor LighthousePro update http://www.coldfusionjedi.com/index.cfm/2008/5/7/Quick-CFBL-update-and-a-minor-LighthousePro-update
3 94 0 599 Ask a Jedi: Multiple templates and Model-Glue http://www.coldfusionjedi.com/index.cfm/2008/5/7/Ask-a-Jedi-Multiple-templates-and-ModelGlue
4 192 0 509 Ask a Jedi: Getting the current directory http://www.coldfusionjedi.com/index.cfm/2008/5/8/Ask-a-Jedi-Getting-the-current-directory
5 56 0 490 Adobe Developer Week recordings http://www.coldfusionjedi.com/index.cfm/2008/5/6/Adobe-Developer-Week-recordings
6 133 0 455 CFLOG and Permissions http://www.coldfusionjedi.com/index.cfm/2008/5/8/CFLOG-and-Permissions
7 284 0 400 Proposals for ColdFusion 9 - From the Enemy's Camp http://www.coldfusionjedi.com/index.cfm/2008/5/9/Proposals-for-ColdFusion-9--From-the-Enemys-Camp
8 55 0 400 I'm not a programmer http://www.coldfusionjedi.com/index.cfm/2008/5/5/Im-not-a-programmer
9 19 0 385 cfObjective Slides/Code http://www.coldfusionjedi.com/index.cfm/2008/5/4/cfObjective-SlidesCode
10 18 0 374 2 quick links (one tech, one music) http://www.coldfusionjedi.com/index.cfm/2008/5/3/2-quick-links-one-tech-one-music
11 12 0 369 (Short) Review: Iron Man http://www.coldfusionjedi.com/index.cfm/2008/5/3/Short-Review-Iron-Man
12 14 0 337 Model-Glue 3 - The New Frakin' Awesomeness http://www.coldfusionjedi.com/index.cfm/2008/5/2/ModelGlue-3--The-New-Frakin-Awesomeness
13 168 0 326 There is only one Spry... http://www.coldfusionjedi.com/index.cfm/2008/5/9/There-is-only-one-Spry
14 28 0 313 Another hint on ColdFusion 9? http://www.coldfusionjedi.com/index.cfm/2008/5/2/Another-hint-on-ColdFusion-9
15 12 0 276 Adobe announces public bug/enhancement database for ColdFusion http://www.coldfusionjedi.com/index.cfm/2008/5/2/Adobe-announces-public-bugenhancement-database-for-ColdFusion
16 91 0 261 Model-Glue 3 - Example of Custom Event Types http://www.coldfusionjedi.com/index.cfm/2008/5/9/ModelGlue-3--Example-of-Custom-Event-Types
17 15 0 261 cfObjective Keynote: News on Centaur (CF9) http://www.coldfusionjedi.com/index.cfm/2008/5/2/cfObjective-Keynote-News-on-Centaur-CF9
18 12 0 243 Ask a Jedi: Why would I use cfhtmlhead? http://www.coldfusionjedi.com/index.cfm/2008/5/2/Ask-a-Jedi-Why-would-I-use-cfhtmlhead
19 12 0 207 New month, new job. I've joined Broadchoice http://www.coldfusionjedi.com/index.cfm/2008/5/1/New-month-new-job-Ive-joined-Broadchoice
20 11 0 192 Ask a Jedi - Why isn't my session expired when I logout? http://www.coldfusionjedi.com/index.cfm/2008/5/1/Ask-a-Jedi--Why-isnt-my-session-expired-when-I-logout
21 138 0 175 The last book you will ever read http://www.coldfusionjedi.com/index.cfm/2008/5/11/The-last-book-you-will-ever-read
22 5 0 165 Project updates http://www.coldfusionjedi.com/index.cfm/2008/4/30/Project-updates
23 4 0 151 Recording URL and Slides from CF/OS Presentation http://www.coldfusionjedi.com/index.cfm/2008/4/30/Recording-URL-and-Slides-from-CFOS-Presentation
24 9 0 137 Ask a Jedi: Does ColdFusion have a htmlfoot tag? http://www.coldfusionjedi.com/index.cfm/2008/4/30/Ask-a-Jedi-Does-ColdFusion-have-a-htmlfoot-tag
25 4 0 121 Ask a Jedi: Copy session values from one application to another http://www.coldfusionjedi.com/index.cfm/2008/4/29/Ask-a-Jedi-Copy-session-values-from-one-application-to-another
26 2 0 119 Presentation tonight on ColdFusion and Open Source http://www.coldfusionjedi.com/index.cfm/2008/4/29/Presentation-tonight-on-ColdFusion-and-Open-Source
27 2 0 105 LighthousePro Updated http://www.coldfusionjedi.com/index.cfm/2008/4/28/LighthousePro-Updated
28 2 0 103 Reader looking for UK-based (or related) Reseller http://www.coldfusionjedi.com/index.cfm/2008/4/28/Reader-looking-for-UKbased-or-related-Reseller
29 5 0 102 Ask a Jedi: Caching Stored Procedures http://www.coldfusionjedi.com/index.cfm/2008/4/25/Ask-a-Jedi-Caching-Stored-Procedures
30 3 0 98 Transfer 1.0 RC is Out http://www.coldfusionjedi.com/index.cfm/2008/4/28/Transfer-10-RC-is-Out
31 1 0 94 Small Canvas update http://www.coldfusionjedi.com/index.cfm/2008/4/25/Small-Canvas-update
32 2 0 93 ColdFusion/SlideShare integration tip http://www.coldfusionjedi.com/index.cfm/2008/4/25/ColdFusionSlideShare-integration-tip
33 3 0 88 Galleon 2.013 Released http://www.coldfusionjedi.com/index.cfm/2008/4/24/Galleon-2013-Released
34 2 0 83 Ask a Jedi: Using JSON in older versions of ColdFusion http://www.coldfusionjedi.com/index.cfm/2008/4/24/Ask-a-Jedi-Using-JSON-in-older-versions-of-ColdFusion
35 4 0 82 Real men write their own forms (or do they?) http://www.coldfusionjedi.com/index.cfm/2008/4/24/Real-men-write-their-own-forms-or-do-they
36 2 0 79 Check out varScoper http://www.coldfusionjedi.com/index.cfm/2008/4/21/Check-out-varScoper
37 2 0 70 Ask a Jedi: Handling RSS feeds with custom data http://www.coldfusionjedi.com/index.cfm/2008/4/23/Ask-a-Jedi-Handling-RSS-feeds-with-custom-data
38 1 0 70 cfObjective Blog Posts (City Related) http://www.coldfusionjedi.com/index.cfm/2008/4/23/cfObjective-Blog-Posts-City-Related
39 4 0 66 What makes a code diva? http://www.coldfusionjedi.com/index.cfm/2008/4/22/What-makes-a-code-diva
40 4 0 61 YouTube CFC Updated http://www.coldfusionjedi.com/index.cfm/2008/4/19/YouTube-CFC-Updated
41 1 0 60 Ask a Jedi: Query naming inside a CFC - best practice? http://www.coldfusionjedi.com/index.cfm/2008/4/22/Ask-a-Jedi-Query-naming-inside-a-CFC--best-practice
42 4 0 58 Ask a Jedi: Extending ColdFusion's auto-complete feature http://www.coldfusionjedi.com/index.cfm/2008/4/21/Ask-a-Jedi-Extending-ColdFusions-autocomplete-feature
43 2 0 55 Ask a Jedi: Two CFGRID Questions http://www.coldfusionjedi.com/index.cfm/2008/4/17/Ask-a-Jedi-Two-CFGRID-Questions
44 2 0 54 CFCACHE and the Fall of Rome http://www.coldfusionjedi.com/index.cfm/2008/4/17/CFCACHE-and-the-Fall-of-Rome
45 0 0 54 The Complete Guide to Adding Error Handling to Your ColdFusion Application http://www.coldfusionjedi.com/index.cfm/2007/12/5/The-Complete-Guide-to-Adding-Error-Handling-to-Your-ColdFusion-Application
46 0 0 53 Ask a Jedi: Question about learning frameworks (and other things) http://www.coldfusionjedi.com/index.cfm/2008/4/18/Ask-a-Jedi-Question-about-learning-frameworks-and-other-things
47 0 0 52 ColdFusion 8.0.1 is out the door! http://www.coldfusionjedi.com/index.cfm/2008/4/3/ColdFusion-801-is-out-the-door
48 2 0 51 imageUtils gets some Tiff love http://www.coldfusionjedi.com/index.cfm/2008/4/15/imageUtils-gets-some-Tiff-love
49 1 0 51 ColdFusion 8.0.1 change to CFEXECUTE http://www.coldfusionjedi.com/index.cfm/2008/4/9/ColdFusion-801-change-to-CFEXECUTE
50 0 0 51 ColdFusion 8.0.1 adds pizazz to implicit array/struct creation http://www.coldfusionjedi.com/index.cfm/2008/4/3/ColdFusion-801-adds-pizazz-to-implicit-arraystruct-creation
51 2 0 50 Ask a Jedi: What is the proper way to handle session/cgi variables in CFCs? http://www.coldfusionjedi.com/index.cfm/2008/4/15/Ask-a-Jedi-What-is-the-proper-way-to-handle-sessioncgi-variables-in-CFCs
52 1 0 50 Ask a Jedi: ColdFusion 8 Ajax Features and JavaScript Detection http://www.coldfusionjedi.com/index.cfm/2008/3/13/Ask-a-Jedi-ColdFusion-8-Ajax-Features-and-JavaScript-Detection
53 0 0 50 WebCharts and ColdFusion http://www.coldfusionjedi.com/index.cfm/2008/4/14/WebCharts-and-ColdFusion
54 1 0 49 Free Exchange Testing http://www.coldfusionjedi.com/index.cfm/2008/4/7/Free-Exchange-Testing
55 4 0 48 Review: Rock Band http://www.coldfusionjedi.com/index.cfm/2008/4/19/Review-Rock-Band
56 2 0 48 First draft of new YouTube API http://www.coldfusionjedi.com/index.cfm/2008/4/15/First-draft-of-new-YouTube-API
57 0 0 48 CFFEED Fixes in 8.0.1 http://www.coldfusionjedi.com/index.cfm/2008/4/4/CFFEED-Fixes-in-801
58 0 0 48 ColdFusion 8.0.1 - Easier to add PDF Watermarks http://www.coldfusionjedi.com/index.cfm/2008/4/4/ColdFusion-801--Easier-to-add-PDF-Watermarks
59 4 0 47 My current least favorite Mac 'feature' http://www.coldfusionjedi.com/index.cfm/2008/4/16/My-current-least-favorite-Mac-feature
60 1 0 47 Ask a Jedi: Creating lowercased cookies in ColdFusion http://www.coldfusionjedi.com/index.cfm/2008/4/16/Ask-a-Jedi-Creating-lowercased-cookies-in-ColdFusion
61 0 0 47 Ask a Jedi: Flash, ColdFusion and FIle Uploads http://www.coldfusionjedi.com/index.cfm/2008/4/10/Ask-a-Jedi-Flash-ColdFusion-and-FIle-Uploads
62 1 0 46 How can I move my Flex app into multiple layers? http://www.coldfusionjedi.com/index.cfm/2008/4/15/How-can-I-move-my-Flex-app-into-multiple-layers
63 0 0 46 Ask a Jedi: Is my site slow because of Ajax or something else? http://www.coldfusionjedi.com/index.cfm/2008/4/7/Ask-a-Jedi-Is-my-site-slow-because-of-Ajax-or-something-else
64 1 0 45 Ask a Jedi: Question on Application based CFCs http://www.coldfusionjedi.com/index.cfm/2008/3/24/Ask-a-Jedi-Question-on-Application-based-CFCs
65 1 0 45 Quick and Dirty ColdFusion 8 CAPTCHA Guide http://www.coldfusionjedi.com/index.cfm/2008/3/29/Quick-and-Dirty-ColdFusion-8-CAPTCHA-Guide
66 1 0 45 Designers for CFLib wanted http://www.coldfusionjedi.com/index.cfm/2008/4/10/Designers-for-CFLib-wanted
67 0 0 45 One AIR annoyance http://www.coldfusionjedi.com/index.cfm/2008/3/27/One-AIR-annoyance
68 0 0 45 Inteviewed by Greg Cerveny http://www.coldfusionjedi.com/index.cfm/2008/4/14/Inteviewed-by-Greg-Cerveny
69 0 0 45 Udate to pdfUtils Component http://www.coldfusionjedi.com/index.cfm/2008/4/4/Udate-to-pdfUtils-Component
70 0 0 45 RIA Dev Shed Review (and Files) http://www.coldfusionjedi.com/index.cfm/2008/4/7/RIADevShed-Review-and-Files
71 0 0 45 I hit level 35 today (IRL) http://www.coldfusionjedi.com/index.cfm/2008/4/8/I-hit-level-35-today-IRL
72 0 0 45 Open BlueDragon Steering Committee http://www.coldfusionjedi.com/index.cfm/2008/4/8/Open-BlueDragon-Steering-Committee
73 0 0 44 Time Tracker AIR Application Updated http://www.coldfusionjedi.com/index.cfm/2008/3/25/Time-Tracker-AIR-Application-Updated
74 0 0 44 Searching CFDocs http://www.coldfusionjedi.com/index.cfm/2008/3/28/Searching-CFDocs
75 0 0 44 Model-Glue 3 Preview http://www.coldfusionjedi.com/index.cfm/2008/4/10/ModelGlue-3-Preview
76 0 0 44 XML forms and CFIMAGE http://www.coldfusionjedi.com/index.cfm/2008/4/7/XML-forms-and-CFIMAGE
77 1 0 43 Ask a Jedi: CFC Scope Question http://www.coldfusionjedi.com/index.cfm/2008/3/18/Ask-a-Jedi-CFC-Scope-Question
78 1 0 43 is your framework up to date? http://www.coldfusionjedi.com/index.cfm/2008/3/20/is-your-framework-up-to-date
79 0 0 43 Facebook API Book http://www.coldfusionjedi.com/index.cfm/2008/3/18/Facebook-API-Book
80 0 0 43 BACFUG Spry Preso Files http://www.coldfusionjedi.com/index.cfm/2008/3/23/BACFUG-Spry-Preso-Files
81 0 0 43 I'm an idiot for not using... http://www.coldfusionjedi.com/index.cfm/2008/3/27/Im-an-idiot-for-not-using
82 0 0 43 ColdFire Update http://www.coldfusionjedi.com/index.cfm/2008/4/8/ColdFire-Update
83 1 0 42 Ask a Jedi: ColdFusion 8 Licensing Question http://www.coldfusionjedi.com/index.cfm/2008/3/14/Ask-a-Jedi-ColdFusion-8-Licensing-Question
84 0 0 42 Ask a Jedi: Sending emails out over time. http://www.coldfusionjedi.com/index.cfm/2008/3/31/Ask-a-Jedi-Sending-emails-out-over-time
85 0 0 42 Spry, Dates, and how we will make you conform.... http://www.coldfusionjedi.com/index.cfm/2008/3/5/Spry-Dates-and-how-we-will-make-you-conform
86 0 0 42 The Jedi Punts - Need IE testers http://www.coldfusionjedi.com/index.cfm/2008/4/2/The-Jedi-Punts--Need-IE-testers
87 0 0 42 RIAForge update http://www.coldfusionjedi.com/index.cfm/2008/4/3/RIAForge-update
88 1 0 41 Interesting ColdFusion 8, Auto-Suggest issue to watch for http://www.coldfusionjedi.com/index.cfm/2008/3/17/Interesting-ColdFusion-8-AutoSuggest-issue-to-watch-for
89 0 0 41 Ask a Jedi: No cookie for you! http://www.coldfusionjedi.com/index.cfm/2008/2/29/Ask-a-Jedi-No-cookie-for-you
90 0 0 41 Changes to attributeCollection in 8.0.1 http://www.coldfusionjedi.com/index.cfm/2008/4/3/Changes-to-attributeCollection-in-801
91 1 0 39 Ask a Jedi: Development question - built in JRun web server versus IIS http://www.coldfusionjedi.com/index.cfm/2008/3/10/Ask-a-Jedi-Development-question--built-in-JRun-web-server-versus-IIS
92 0 0 39 Ask a Jedi: Requiring an API key for web services http://www.coldfusionjedi.com/index.cfm/2008/2/14/Ask-a-Jedi-Requiring-an-API-key-for-web-services
93 0 0 39 Photoshop Express Launches http://www.coldfusionjedi.com/index.cfm/2008/3/27/Photoshop-Express-Launches
94 0 0 39 Adding an ADD button for cfgrid http://www.coldfusionjedi.com/index.cfm/2008/3/3/Adding-an-ADD-button-for-cfgrid
95 0 0 39 ColdFusion Bloggers Update http://www.coldfusionjedi.com/index.cfm/2008/3/30/ColdFusion-Bloggers-Update
96 0 0 39 These are not the search results you are lookin for... http://www.coldfusionjedi.com/index.cfm/2008/3/30/These-are-not-the-search-results-you-are-lookin-for
97 0 0 39 Misleading docs for isUserInAnyRole http://www.coldfusionjedi.com/index.cfm/2008/3/31/Misleading-docs-for-isUserInAnyRole
98 0 0 39 Galleon ColdFusion Forums update http://www.coldfusionjedi.com/index.cfm/2008/4/1/Galleon-ColdFusion-Forums-update
99 0 0 39 Old School Ray http://www.coldfusionjedi.com/index.cfm/2008/4/1/Old-School-Ray
100 0 0 39 Work for the NFL! (ColdFusion Job, and no, not an April Fool's joke) http://www.coldfusionjedi.com/index.cfm/2008/4/1/Work-for-the-NFL-ColdFusion-Job-and-no-not-an-April-Fools-joke
CACHED false
EXECUTIONTIME 47
SQL select sum(clickthroughs) as ctsum, sum(itemviews) as itsum, downloads, title, url from last7 group by url, title, downloads order by itsum desc, ctsum desc