2009 Movies Watched

[goodguy]

Kiss Kiss Bang Bang (2005)

27

[mr]2[/mr]

Really? That's kinda sad. 

[Tom]

Kiss Kiss Bang Bang (2005)

27

[mr]2[/mr]

Really? That's kinda sad. 

I don't know why, but this movie just didn't do it for me.

[yellow]

wow i'm impressed with you people listing your movies. i'm inspired to do my own.

[Jimmy]

Must of us are collectors that's why we do some crazy thing like that

By the way welcome

[Kathy]

Hi. Welcome to the forums. We all love our DVDs and like to see what others have so please feel free to post your movies. You can see most of our collections online too - usually by clicking on our signature.

[Dragonfire]

I'm so far behind with this..I've still been keeping lists...I just haven't updated here in months.  I may just wait and do it all at the end of the year...and it may just be numbers each month by that point.

[Jimmy]

At this hour the year is almost over here (30 minutes to do), so this is my stats for the year :

January - 39 movies watched
February - 17 movies watched
March - 22 movies watched
April - 37 movies watched
May - 22 movies watched
June - 16 movies watched
July - 51 movies watched
August - 0 movie watched
September - 25 movies watched
October - 54 movies watched
November - 28 movies watched
December - 49 movies watched

For a total of 360 movies watched on dvd this year

[addicted2dvd]

Grand Totals: 318
First Time Viewings: 136

[Tom]

I have gone back in entered all links to my reviews to my database. From now on, my lists will include links to my reviews for titles, where I have written a review.

38 movies in December for me:

Title	Watched on	Rating
Van Wilder (2002)	1	[mr]3[/mr]
Romy and Michele's High School Reunion (1997)	1	[mr]4[/mr]
Brazil (1985)	2	[mr]4[/mr]
Iron Man (2008)	3	[mr]5[/mr]
Lola rennt (1998)	4	[mr]4[/mr]
The Big White (2005)	4	[mr]3[/mr]
Matchstick Men (2003)	5	[mr]4[/mr]
Only You (1994)	5	[mr]4[/mr]
All I Wanna Do (1998)	6	[mr]3[/mr]
Catch Me If You Can (2002)	6	[mr]4[/mr]
Imagine Me and You (2005)	6	[mr]5[/mr]
Home Alone (1990)	6	[mr]3[/mr]
Cast Away (2000)	7	[mr]5[/mr]
The Wrestler (2008)	9	[mr]4[/mr]
Das Boot (1981)	10	[mr]5[/mr]
Das Leben der Anderen (2006)	11	[mr]4[/mr]
Starship Troopers 3: Marauder (2008)	12	[mr]3[/mr]
Don: The Chase Begins Again (2006)	13	[mr]3[/mr]
Loser (2000)	13	[mr]3[/mr]
The Opposite of Sex (1998)	13	[mr]3[/mr]
Alien (1979)	18	[mr]4[/mr]
Aliens (1986)	19	[mr]4[/mr]
A Christmas Carol (1984)	19	[mr]3[/mr]
Scrooged (1988)	19	[mr]5[/mr]
Miracle on 34th Street (1994)	19	[mr]4[/mr]
The Notebook (2004)	20	[mr]4[/mr]
Say It Isn't So (2001)	22	[mr]1[/mr]
Analyze This (1998)	22	[mr]2[/mr]
Bolt (2008)	22	[mr]4[/mr]
Thoda Pyaar Thoda Magic (2008)	23	[mr]3[/mr]
Garden State (2004)	23	[mr]3[/mr]
Finding Nemo (2003)	24	[mr]5[/mr]
She's the Man (2006)	26	[mr]4[/mr]
He's Just Not That Into You (2009)	26	[mr]3[/mr]
It's a Boy Girl Thing (2006)	27	[mr]3[/mr]
Dhoom (2004)	29	[mr]1[/mr]
Hancock (2008)	29	[mr]4[/mr]
X2 (2003)	30	[mr]4[/mr]

[Tom]

SQL statement for CCViewer:

Code Select Expand

SELECT (Iif(a.InfoValue <>'','[url='+a.InfoValue+']','')+Iif(p.OriginalTitle<>'', p.OriginalTitle, p.Title) + Iif(p.ProdYear<>0, " ("+trim(str(p.ProdYear))+")", "")+Iif(a.InfoValue<>'','[/url]','')) AS [Title], DAY(e.EventTimeStamp) as [Watched on], "[mr]"+ i.InfoValue + "[/mr]" AS [Rating] FROM ((Profiles p INNER JOIN Events e ON e.ProfileID=p.ProfileID) LEFT OUTER JOIN AdditionalInfo i ON (i.ProfileID =p.ProfileID and i.InfoName="MyRating")) Left OUTER JOIN AdditionalInfo a ON (a.ProfileID=p.ProfileID and a.InfoName="Review") WHERE  e.EventType='Watched' AND e.UserID='Thomas' AND YEAR(e.EventTimeStamp)=2009 AND MONTH(e.EventTimeStamp)=$Month$  ORDER BY e.EventTimeStamp ASC, p.SortTitle;
$Month$="1|2|3|4|5|6|7|8|9|10|11|12"

This is for year 2009 and for a user named "Thomas" (just adjust the values for other users/years).
This assumes, that you have entered the DCO rating as an additional info called "MyRating" (only the number) and the review link under the link name "Review".

[Tom]

My 377 watched movies for the whole year 2009:

Title	Month	Watched on	Rating
The Dark Knight (2008)	1	1	[mr]5[/mr]
WALL-E (2008)	1	1	[mr]5[/mr]
Ratatouille (2007)	1	2	[mr]5[/mr]
Spider-Man 3 (2007)	1	3	[mr]2[/mr]
Daredevil: Director's Cut (2003)	1	4	[mr]4[/mr]
Tenacious D: The Complete Masterworks II (2008)	1	5	[mr]3[/mr]
Planet of the Apes (2001)	1	5	[mr]4[/mr]
Jesus Christ Superstar (1973)	1	6	[mr]3[/mr]
Mr. Deeds Goes to Town (1936)	1	6	[mr]4[/mr]
Mr. Deeds (2002)	1	6	[mr]3[/mr]
Keinohrhasen (2007)	1	7	[mr]4[/mr]
Enchanted (2007)	1	7	[mr]5[/mr]
Kung Fu Panda (2008)	1	8	[mr]4[/mr]
Bedazzled (2000)	1	8	[mr]3[/mr]
Rocketeer (1991)	1	9	[mr]2[/mr]
The Day the Earth Stood Still (1951)	1	9	[mr]4[/mr]
Fantastic 4: Rise of the Silver Surfer (2007)	1	9	[mr]2[/mr]
50 First Dates (2004)	1	10	[mr]5[/mr]
Itty Bitty Titty Committee (2007)	1	10	[mr]2[/mr]
Just Like Heaven (2005)	1	11	[mr]4[/mr]
D.E.B.S. (2005)	1	11	[mr]5[/mr]
Imagine Me and You (2005)	1	12	[mr]5[/mr]
My Super Ex-Girlfriend (2006)	1	13	[mr]3[/mr]
The Terminator (1984)	1	15	[mr]4[/mr]
Terminator 2: Judgment Day (1991)	1	16	[mr]4[/mr]
Hancock (2008)	1	17	[mr]4[/mr]
Das kleine Arschloch und der alte Sack - Sterben ist Scheiße (2006)	1	17	[mr]2[/mr]
Terminator 3: Rise of the Machines (2003)	1	17	[mr]5[/mr]
Jingle All the Way (1996)	1	18	[mr]1[/mr]
Bee Movie (2007)	1	22	[mr]3[/mr]
Wanted (2008)	1	23	[mr]4[/mr]
Iron Man (2008)	1	24	[mr]5[/mr]
Dr. Horrible's Sing-Along Blog (2008)	1	25	[mr]5[/mr]
Bedazzled (1967)	1	25	[mr]3[/mr]
Dr. No (1962)	1	26	[mr]3[/mr]
Stranger Than Fiction (2006)	1	27	[mr]5[/mr]
Star Trek: The Motion Picture (1979)	1	29	[mr]3[/mr]
Star Trek II: The Wrath of Khan (1982)	1	31	[mr]4[/mr]
Star Trek III: The Search for Spock (1984)	1	31	[mr]2[/mr]
Star Trek IV: The Voyage Home (1986)	2	1	[mr]4[/mr]
Desu nôto (2006)	2	1	[mr]5[/mr]
Desu nôto: The last name (2006)	2	2	[mr]5[/mr]
Star Trek V: The Final Frontier (1989)	2	2	[mr]1[/mr]
Star Trek VI: The Undiscovered Country (1991)	2	3	[mr]4[/mr]
From Russia with Love (1963)	2	4	[mr]3[/mr]
Star Trek: Generations (1994)	2	5	[mr]3[/mr]
Star Trek: First Contact (1996)	2	6	[mr]5[/mr]
Superbad (2007)	2	8	[mr]2[/mr]
Dr. Horrible's Sing-Along Blog (2008)	2	8	[mr]5[/mr]
Star Trek: Insurrection (1998)	2	9	[mr]3[/mr]
Dr. Horrible's Sing-Along Blog (2008)	2	13	[mr]5[/mr]
Goldfinger (1964)	2	13	[mr]4[/mr]
Star Trek: Nemesis (2002)	2	14	[mr]1[/mr]
Thunderball (1965)	2	16	[mr]2[/mr]
Austin Powers: International Man of Mystery (1997)	2	17	[mr]3[/mr]
Austin Powers: The Spy Who Shagged Me (1999)	2	18	[mr]3[/mr]
The Fifth Element (1997)	2	19	[mr]5[/mr]
DOA: Dead or Alive (2006)	2	22	[mr]4[/mr]
Miracle on 34th Street (1947)	2	22	[mr]4[/mr]
Cloverfield (2007)	2	22	[mr]3[/mr]
You Only Live Twice (1967)	2	23	[mr]4[/mr]
Rocky (1976)	2	24	[mr]3[/mr]
Austin Powers in Goldmember (2002)	2	25	[mr]3[/mr]
Garfield (2004)	2	27	[mr]2[/mr]
In Bruges (2008)	2	28	[mr]4[/mr]
Batoru rowaiaru (2000)	2	28	[mr]4[/mr]
Robot Chicken: Star Wars (2007)	3	1	[mr]4[/mr]
Talladega Nights: The Ballad of Ricky Bobby (2006)	3	2	[mr]3[/mr]
On Her Majesty's Secret Service (1969)	3	2	[mr]3[/mr]
Happy-Go-Lucky (2008)	3	2	[mr]3[/mr]
Dracula: Dead and Loving It (1995)	3	3	[mr]2[/mr]
Dr. Horrible's Sing-Along Blog (2008)	3	4	[mr]5[/mr]
Run Fatboy Run (2007)	3	4	[mr]3[/mr]
GTO: Special (1999)	3	7	[mr]3[/mr]
Rocky II (1979)	3	7	[mr]3[/mr]
Rocky III (1982)	3	8	[mr]4[/mr]
Rocky IV (1985)	3	8	[mr]1[/mr]
Rocky V (1990)	3	9	[mr]4[/mr]
Rocky Balboa (2006)	3	10	[mr]5[/mr]
Diamonds Are Forever (1971)	3	13	[mr]2[/mr]
But I'm a Cheerleader (1999)	3	14	[mr]4[/mr]
It's in the Water (1998)	3	14	[mr]4[/mr]
Dead Like Me: Life After Death (2009)	3	14	[mr]4[/mr]
The Truth About Jane (2000)	3	15	[mr]4[/mr]
Saving Face (2004)	3	15	[mr]4[/mr]
Bound (1996)	3	16	[mr]4[/mr]
Lost and Delirious (2001)	3	19	[mr]3[/mr]
Live and Let Die (1973)	3	20	[mr]2[/mr]
Fucking Åmål (1998)	3	22	[mr]5[/mr]
Zack and Miri Make a Porno (2008)	3	25	[mr]3[/mr]
The Man with the Golden Gun (1974)	3	27	[mr]3[/mr]
Delirious (1991)	3	28	[mr]3[/mr]
GTO (1999)	3	29	[mr]3[/mr]
Chasing Amy (1997)	3	29	[mr]5[/mr]
The Spy Who Loved Me (1977)	3	30	[mr]4[/mr]
Hors de prix (2006)	4	1	[mr]4[/mr]
The 39 Steps (1935)	4	3	[mr]3[/mr]
Killing Zoe (1993)	4	4	[mr]3[/mr]
Supervoksen (2006)	4	4	[mr]3[/mr]
If These Walls Could Talk 2 (2000)	4	5	[mr]4[/mr]
Batman (1989)	4	5	[mr]4[/mr]
The Matrix (1999)	4	6	[mr]5[/mr]
Weird Science (1985)	4	7	[mr]2[/mr]
Fingersmith (2005)	4	10	[mr]4[/mr]
Michael Jackson: HIStory on Film - Volume II (1997)	4	12	[mr]3[/mr]
Kissing Jessica Stein (2001)	4	12	[mr]3[/mr]
Secret Agent (1936)	4	13	[mr]2[/mr]
Indiana Jones and the Kingdom of the Crystal Skull (2008)	4	17	[mr]3[/mr]
They Live (1988)	4	18	[mr]3[/mr]
First Blood (1982)	4	18	[mr]4[/mr]
Rambo: First Blood Part II (1985)	4	19	[mr]3[/mr]
For Your Eyes Only (1981)	4	19	[mr]3[/mr]
Nina's Heavenly Delights (2006)	4	19	[mr]4[/mr]
Heavenly Creatures (1994)	4	20	[mr]4[/mr]
Sabotage (1936)	4	21	[mr]3[/mr]
Rambo III (1988)	4	22	[mr]3[/mr]
Rambo (2008)	4	24	[mr]4[/mr]
Rocky Balboa (2006)	4	24	[mr]5[/mr]
Octopussy (1983)	4	25	[mr]2[/mr]
27 Dresses (2008)	4	26	[mr]2[/mr]
A View to a Kill (1985)	4	30	[mr]3[/mr]
The Bourne Ultimatum (2007)	4	30	[mr]4[/mr]
Sennen Joyu (2001)	5	1	[mr]4[/mr]
Ratatouille (2007)	5	1	[mr]5[/mr]
Danny the Dog (2004)	5	2	[mr]4[/mr]
You Can't Take It With You (1938)	5	2	[mr]3[/mr]
Charlie and the Chocolate Factory (2005)	5	2	[mr]4[/mr]
Toki wo kakeru shôjo (2006)	5	2	[mr]5[/mr]
Back to the Future (1985)	5	3	[mr]5[/mr]
Back to the Future Part II (1989)	5	3	[mr]5[/mr]
Back to the Future Part III (1990)	5	3	[mr]5[/mr]
Highlander (1986)	5	3	[mr]4[/mr]
The Living Daylights (1987)	5	4	[mr]5[/mr]
Alvin and The Chipmunks (2007)	5	5	[mr]3[/mr]
Son of Rambow (2007)	5	7	[mr]4[/mr]
The Lady Vanishes (1938)	5	8	[mr]3[/mr]
Superman Returns (2006)	5	8	[mr]5[/mr]
The Incredibles (2004)	5	9	[mr]5[/mr]
Mr. & Mrs. Smith (2005)	5	9	[mr]4[/mr]
The Shawshank Redemption (1994)	5	9	[mr]5[/mr]
The Dead Zone (1983)	5	9	[mr]4[/mr]
The Running Man (1987)	5	10	[mr]4[/mr]
The Green Mile (1999)	5	10	[mr]4[/mr]
While You Were Sleeping (1995)	5	13	[mr]4[/mr]
Leap of Faith (1992)	5	14	[mr]3[/mr]
Hollow Man (2000)	5	15	[mr]3[/mr]
Die Geschichte vom Brandner Kaspar (2008)	5	16	[mr]4[/mr]
Licence to Kill (1989)	5	16	[mr]3[/mr]
The Butterfly Effect 3: Revelations (2009)	5	17	[mr]3[/mr]
GoldenEye (1995)	5	18	[mr]3[/mr]
Driving Miss Daisy (1989)	5	20	[mr]4[/mr]
Juno (2007)	5	21	[mr]4[/mr]
Little Miss Sunshine (2006)	5	21	[mr]4[/mr]
The Colour of Magic (2008)	5	22	[mr]3[/mr]
Tomorrow Never Dies (1997)	5	25	[mr]4[/mr]
Never Say Never Again (1983)	5	30	[mr]3[/mr]
Saboteur (1942)	5	30	[mr]4[/mr]
Shadow of a Doubt (1942)	5	30	[mr]4[/mr]
Titanic (1943)	5	31	[mr]4[/mr]
Titanic (1953)	5	31	[mr]3[/mr]
A Night to Remember (1958)	5	31	[mr]5[/mr]
The Titanic (1996)	6	1	[mr]3[/mr]
Titanic (1997)	6	2	[mr]5[/mr]
Baby Mama (2008)	6	3	[mr]4[/mr]
Forgetting Sarah Marshall (2008)	6	4	[mr]4[/mr]
The World Is Not Enough (1999)	6	5	[mr]2[/mr]
Futurama: Bender's Game (2008)	6	5	[mr]3[/mr]
Wonder Woman (2009)	6	6	[mr]4[/mr]
Practical Magic (1998)	6	7	[mr]4[/mr]
Miss Congeniality (2000)	6	7	[mr]4[/mr]
Bewitched (2005)	6	7	[mr]4[/mr]
The Children's Hour (1961)	6	7	[mr]4[/mr]
Boys on the Side (1995)	6	8	[mr]4[/mr]
Lethal Weapon (1987)	6	8	[mr]5[/mr]
Mallrats (1995)	6	8	[mr]4[/mr]
Clerks II (2006)	6	8	[mr]4[/mr]
Lethal Weapon 2 (1989)	6	9	[mr]4[/mr]
Better than Chocolate (1999)	6	10	[mr]4[/mr]
Lethal Weapon 3 (1992)	6	10	[mr]4[/mr]
Triumph of Love (2002)	6	11	[mr]3[/mr]
Masters of the Universe (1987)	6	11	[mr]2[/mr]
Die Another Day (2002)	6	11	[mr]4[/mr]
Wonder Woman (2009)	6	11	[mr]4[/mr]
Lethal Weapon 4 (1998)	6	12	[mr]4[/mr]
A Time to Kill (1996)	6	13	[mr]3[/mr]
Red Dwarf: Back to Earth (2009)	6	16	[mr]3[/mr]
Freedom Writers (2006)	6	17	[mr]3[/mr]
Casino Royale (2006)	6	19	[mr]3[/mr]
La Femme de Chambre du Titanic (1997)	6	20	[mr]3[/mr]
Captain America (1990)	6	24	[mr]3[/mr]
The Hard Way (1991)	6	25	[mr]3[/mr]
Quantum of Solace (2008)	6	26	[mr]4[/mr]
Loaded Weapon 1 (1993)	6	26	[mr]3[/mr]
Batman: Gotham Knight (2008)	6	27	[mr]2[/mr]
Ella Enchanted (2004)	6	28	[mr]4[/mr]
The Princess Diaries (2001)	6	29	[mr]4[/mr]
The Princess Diaries 2: Royal Engagement (2004)	6	29	[mr]2[/mr]
Krrish (2006)	6	30	[mr]4[/mr]
Superman: The Last Son of Krypton (1996)	7	1	[mr]3[/mr]
Shrek 2 (2004)	7	1	[mr]4[/mr]
Stardust (2007)	7	3	[mr]5[/mr]
Rope (1948)	7	4	[mr]3[/mr]
Koi... mil gaya (2003)	7	4	[mr]4[/mr]
High Art (1998)	7	5	[mr]2[/mr]
Krrish (2006)	7	5	[mr]4[/mr]
Clueless (1995)	7	7	[mr]4[/mr]
Kabhi Khushi Kabhie Gham (2001)	7	8	[mr]4[/mr]
Kal Ho Naa Ho (2003)	7	9	[mr]4[/mr]
Stage Fright (1950)	7	11	[mr]2[/mr]
Koi... mil gaya (2003)	7	11	[mr]4[/mr]
Veer-Zaara (2004)	7	11	[mr]5[/mr]
Kuch Kuch Hota Hai (1998)	7	13	[mr]4[/mr]
In Bruges (2008)	7	14	[mr]4[/mr]
Mujhse Dosti Karoge (2002)	7	15	[mr]3[/mr]
Get Smart (2008)	7	15	[mr]2[/mr]
Main Hoon Na (2004)	7	17	[mr]4[/mr]
Kaho Naa... Pyaar Hai (2000)	7	18	[mr]2[/mr]
Strangers on a Train (1951)	7	18	[mr]2[/mr]
Nochnoi dozor (2004)	7	18	[mr]3[/mr]
Krrish (2006)	7	19	[mr]4[/mr]
NANA (2005)	7	19	[mr]4[/mr]
Paheli (2005)	7	19	[mr]3[/mr]
Lakshya (2004)	7	20	[mr]4[/mr]
Bride & Prejudice (2004)	7	21	[mr]4[/mr]
Kleinruppin forever (2004)	7	21	[mr]3[/mr]
Yes Man (2008)	7	22	[mr]4[/mr]
Dilwale Dulhania Le Jayenge (1995)	7	23	[mr]4[/mr]
Mission Kashmir (2001)	7	23	[mr]3[/mr]
Hum Tumhare Hain Sanam (2002)	7	24	[mr]3[/mr]
West Side Story (1961)	7	24	[mr]3[/mr]
Kabhi Alvida Naa Kehna (2006)	7	25	[mr]4[/mr]
Kabhi Khushi Kabhie Gham (2001)	7	25	[mr]4[/mr]
Salaam Namaste (2005)	7	26	[mr]4[/mr]
Who's Afraid of Virginia Woolf? (1966)	7	27	[mr]4[/mr]
Becoming Jane (2007)	7	27	[mr]2[/mr]
Dil Chahta Hai (2001)	7	28	[mr]3[/mr]
Fire (1996)	7	28	[mr]2[/mr]
Malá morská víla (1975)	7	28	[mr]1[/mr]
Nina's Heavenly Delights (2006)	7	29	[mr]4[/mr]
Kuch Kuch Hota Hai (1998)	7	29	[mr]4[/mr]
Chori Chori Chupke Chupke (2001)	7	30	[mr]4[/mr]
The Waterboy (1999)	7	30	[mr]3[/mr]
I Confess (1953)	7	31	[mr]3[/mr]
Hum Tum (2004)	7	31	[mr]4[/mr]
Ghajini (2007)	8	1	[mr]5[/mr]
Memento (2000)	8	1	[mr]5[/mr]
Kal Ho Naa Ho (2003)	8	2	[mr]4[/mr]
Yaadein... (2001)	8	2	[mr]2[/mr]
Anjaam (1994)	8	2	[mr]3[/mr]
Main Prem Ki Diwani Hoon (2003)	8	3	[mr]3[/mr]
Mr. India (1987)	8	5	[mr]3[/mr]
Black (2005)	8	6	[mr]5[/mr]
Dial M for Murder (1954)	8	7	[mr]4[/mr]
Rear Window (1954)	8	8	[mr]3[/mr]
Only the Lonely (1991)	8	8	[mr]3[/mr]
Mohabbatein (2000)	8	9	[mr]3[/mr]
D.E.B.S. (2005)	8	9	[mr]5[/mr]
Chalte Chalte (2003)	8	9	[mr]4[/mr]
Phir Bhi Dil Hai Hindustani (2000)	8	10	[mr]3[/mr]
Veer-Zaara (2004)	8	11	[mr]5[/mr]
Mujhse Dosti Karoge (2002)	8	13	[mr]3[/mr]
Main Hoon Na (2004)	8	13	[mr]4[/mr]
Lakshya (2004)	8	14	[mr]4[/mr]
The Trouble with Harry (1955)	8	15	[mr]3[/mr]
Garfield: A Tail of Two Kitties (2006)	8	15	[mr]2[/mr]
Garfield Gets Real (2007)	8	15	[mr]3[/mr]
The Batman/Superman Movie (1997)	8	16	[mr]4[/mr]
Love Actually (2003)	8	16	[mr]4[/mr]
Kaho Naa... Pyaar Hai (2000)	8	16	[mr]2[/mr]
Paheli (2005)	8	17	[mr]3[/mr]
Kuch Naa Kaho (2003)	8	17	[mr]2[/mr]
Ta Ra Rum Pum (2007)	8	18	[mr]3[/mr]
Saathiya (2006)	8	20	[mr]3[/mr]
Dilwale Dulhania Le Jayenge (1995)	8	22	[mr]4[/mr]
The Man Who Knew Too Much (1956)	8	22	[mr]2[/mr]
What About Bob? (1991)	8	23	[mr]4[/mr]
My Stepmother Is an Alien (1988)	8	23	[mr]3[/mr]
The Lake House (2006)	8	23	[mr]4[/mr]
My Favorite Martian (1999)	8	24	[mr]3[/mr]
My Cousin Vinny (1992)	8	25	[mr]4[/mr]
Boys Don't Cry (1999)	8	26	[mr]3[/mr]
Grease (1977)	8	27	[mr]3[/mr]
Dnevnoy dozor (2006)	8	27	[mr]3[/mr]
Fanaa (2006)	9	1	[mr]4[/mr]
Taare Zameen Par (2007)	9	7	[mr]4[/mr]
Drop Dead Fred (1991)	9	9	[mr]3[/mr]
Legally Blonde (2001)	9	11	[mr]4[/mr]
Dirty Harry (1971)	9	11	[mr]3[/mr]
The Curious Case of Benjamin Button (2008)	9	12	[mr]3[/mr]
Laaga Chunari Mein Daag (2007)	9	14	[mr]3[/mr]
Hotaru no haka (1988)	9	15	[mr]3[/mr]
Push (2009)	9	17	[mr]2[/mr]
Slumdog Millionaire (2008)	9	18	[mr]4[/mr]
The Day the Earth Stood Still (2008)	9	22	[mr]3[/mr]
Saawariya (2007)	9	24	[mr]3[/mr]
Black (2005)	9	25	[mr]5[/mr]
Ghostbusters (1984)	10	2	[mr]4[/mr]
Angel Heart (1987)	10	3	[mr]3[/mr]
Bee Movie (2007)	10	9	[mr]3[/mr]
The Wrong Man (1956)	10	10	[mr]3[/mr]
Watchmen (2009)	10	10	[mr]4[/mr]
U, Me aur Hum (2008)	10	17	[mr]3[/mr]
Bunty aur Babli (2005)	10	18	[mr]3[/mr]
The Shawshank Redemption (1994)	10	20	[mr]5[/mr]
Jhoom Barabar Jhoom (2007)	10	22	[mr]4[/mr]
The Time Machine (1960)	10	24	[mr]5[/mr]
Rent (2005)	10	26	[mr]4[/mr]
Lesbian Vampire Killers (2009)	10	27	[mr]3[/mr]
Starship Troopers (1997)	10	31	[mr]4[/mr]
Starship Troopers 2: Hero of the Federation (2003)	10	31	[mr]2[/mr]
Cats & Dogs (2001)	11	1	[mr]4[/mr]
10 Things I Hate About You (1999)	11	1	[mr]4[/mr]
Josie and the Pussycats (2001)	11	1	[mr]5[/mr]
Fight Club: Members Only (2006)	11	2	[mr]1[/mr]
Road Trip (2000)	11	2	[mr]4[/mr]
How to Lose Friends & Alienate People (2008)	11	3	[mr]3[/mr]
Apt Pupil (1998)	11	4	[mr]4[/mr]
You've Got Mail (1998)	11	5	[mr]4[/mr]
Umrao Jaan (2006)	11	7	[mr]2[/mr]
Monsters vs. Aliens (2009)	11	7	[mr]4[/mr]
X-Men Origins: Wolverine (2009)	11	7	[mr]3[/mr]
Låt Den Rätte Komma In (2008)	11	8	[mr]5[/mr]
Vertigo (1958)	11	8	[mr]4[/mr]
The Day the Earth Stood Still (1951)	11	8	[mr]4[/mr]
Queen of the Damned (2002)	11	8	[mr]2[/mr]
Waiting for Guffman (1996)	11	8	[mr]2[/mr]
Gladiator (2000)	11	10	[mr]4[/mr]
Office Space (1999)	11	11	[mr]4[/mr]
Troy: Director's Cut (2004)	11	14	[mr]2[/mr]
Battle for Terra (2007)	11	14	[mr]4[/mr]
Zack and Miri Make a Porno (2008)	11	14	[mr]3[/mr]
Banlieue 13 (2004)	11	14	[mr]4[/mr]
Psycho (1960)	11	15	[mr]5[/mr]
Star Trek (2009)	11	21	[mr]5[/mr]
Banlieue 13 Ultimatum (2009)	11	21	[mr]4[/mr]
North by Northwest (1959)	11	21	[mr]2[/mr]
Kakushi Toride no San-Akunin (1958)	11	22	[mr]2[/mr]
Kiss Kiss Bang Bang (2005)	11	27	[mr]2[/mr]
Ice Age: Dawn of the Dinosaurs (2009)	11	28	[mr]3[/mr]
Van Wilder (2002)	12	1	[mr]3[/mr]
Romy and Michele's High School Reunion (1997)	12	1	[mr]4[/mr]
Brazil (1985)	12	2	[mr]4[/mr]
Iron Man (2008)	12	3	[mr]5[/mr]
Lola rennt (1998)	12	4	[mr]4[/mr]
The Big White (2005)	12	4	[mr]3[/mr]
Matchstick Men (2003)	12	5	[mr]4[/mr]
Only You (1994)	12	5	[mr]4[/mr]
All I Wanna Do (1998)	12	6	[mr]3[/mr]
Catch Me If You Can (2002)	12	6	[mr]4[/mr]
Imagine Me and You (2005)	12	6	[mr]5[/mr]
Home Alone (1990)	12	6	[mr]3[/mr]
Cast Away (2000)	12	7	[mr]5[/mr]
The Wrestler (2008)	12	9	[mr]4[/mr]
Das Boot (1981)	12	10	[mr]5[/mr]
Das Leben der Anderen (2006)	12	11	[mr]4[/mr]
Starship Troopers 3: Marauder (2008)	12	12	[mr]3[/mr]
Don: The Chase Begins Again (2006)	12	13	[mr]3[/mr]
Loser (2000)	12	13	[mr]3[/mr]
The Opposite of Sex (1998)	12	13	[mr]3[/mr]
Alien (1979)	12	18	[mr]4[/mr]
Aliens (1986)	12	19	[mr]4[/mr]
A Christmas Carol (1984)	12	19	[mr]3[/mr]
Scrooged (1988)	12	19	[mr]5[/mr]
Miracle on 34th Street (1994)	12	19	[mr]4[/mr]
The Notebook (2004)	12	20	[mr]4[/mr]
Say It Isn't So (2001)	12	22	[mr]1[/mr]
Analyze This (1998)	12	22	[mr]2[/mr]
Bolt (2008)	12	22	[mr]4[/mr]
Thoda Pyaar Thoda Magic (2008)	12	23	[mr]3[/mr]
Garden State (2004)	12	23	[mr]3[/mr]
Finding Nemo (2003)	12	24	[mr]5[/mr]
She's the Man (2006)	12	26	[mr]4[/mr]
He's Just Not That Into You (2009)	12	26	[mr]3[/mr]
It's a Boy Girl Thing (2006)	12	27	[mr]3[/mr]
Dhoom (2004)	12	29	[mr]1[/mr]
Hancock (2008)	12	29	[mr]4[/mr]
X2 (2003)	12	30	[mr]4[/mr]

[Tom]

SQL query:

Code Select Expand

SELECT (Iif(a.InfoValue <>'','[url='+a.InfoValue+']','')+Iif(p.OriginalTitle<>'', p.OriginalTitle, p.Title) + Iif(p.ProdYear<>0, " ("+trim(str(p.ProdYear))+")", "")+Iif(a.InfoValue<>'','[/url]','')) AS [Title], Month(e.EventTimeStamp) as [Month], DAY(e.EventTimeStamp) as [Watched on], "[mr]"+ i.InfoValue + "[/mr]" AS [Rating] FROM ((Profiles p INNER JOIN Events e ON e.ProfileID=p.ProfileID) LEFT OUTER JOIN AdditionalInfo i ON (i.ProfileID =p.ProfileID and i.InfoName="MyRating")) Left OUTER JOIN AdditionalInfo a ON (a.ProfileID=p.ProfileID and a.InfoName="Review") WHERE  e.EventType='Watched' AND e.UserID='Thomas' AND YEAR(e.EventTimeStamp)=2009  ORDER BY e.EventTimeStamp ASC, p.SortTitle;

Notes see above.

Hint:
In CCViewer, if you right-click on the result table of the SQL query, you can copy the result to the clipboard. You are asked to enter how the columns should be divided. If you enter "bbcode", a table which can be used in the forum is generated.

[goodguy]

EDITh:

I decided to move my stats into my Watch Log thread here.

[Dragonfire]

I finally checked my lists.  I may be off by a few since I sort of stopped with the lists at the end of November and through December when work got a bit nuts.  Anyway, here are my totals.

January - 12
February - 12
March - 19
April - 15
May - 17
June - 17
July - 19
August - 13
September - 10
October - 38
November - 12
December - 7

Total - 191

[richierich]

Total Movies Watched:

Month	Watched	First Viewing
January	35	34
February	26	23
March	40	35
April	40	34
May	36	31
June	21	18
July	15	13
August	42	42
September	2	2
October	41	38
November	31	28
December	40	32

Grand Total for 2009: 369
First Time Viewings in 2009: 330