Trips » Ashes 2006/07

Trip Details

Ashes 2006/07

Created by

  Nick Davis View Profile  

Brisbane, Australia

32

Message User

Start / End Date

8th Dec 2006 - 7th Jan 2007

Trip Visibility

This trip is viewable to the public

Departing From

London, United Kingdom

Departing on: 8th Dec 2006

Destinations

Kuta, Indonesia

8th Dec 2006 - 15th Dec 2006
Stopping at...

Perth, Melbourne, Sydney

[click to expand]

Perth, Australia

15th Dec 2006 - 24th Dec 2006

Melbourne, Australia

24th Dec 2006 - 28th Dec 2006

Sydney, Australia

28th Dec 2006 - 3rd Jan 2007

Tokyo, Japan

3rd Jan 2007 - 6th Jan 2007
Who's on this trip?

Nick Davis

Who's following this trip?
  It looks like nobody is following this trip yet.  
Trip Route

Javascript is required to view the map.

  This trip currently has no scoops.  
app/webroot/index.php (line 93) 
1.1178
(default) 38 queries took 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `trips`12124
2DESCRIBE `accounts`19191
3DESCRIBE `trip_destinations`15151
4DESCRIBE `scoops`990
5DESCRIBE `blogs`770
6DESCRIBE `comments`770
7DESCRIBE `ratings`771
8DESCRIBE `friend_tags`770
9DESCRIBE `photo_albums`550
10DESCRIBE `photos`770
11DESCRIBE `videos`990
12DESCRIBE `user_locations`990
13DESCRIBE `friends`770
14DESCRIBE `friend_invites`990
15DESCRIBE `wish_lists`10100
16DESCRIBE `trip_members`660
17DESCRIBE `friend_groups`440
18DESCRIBE `friend_group_links`440
19DESCRIBE `featured_trips`551
20DESCRIBE `trip_followers`440
21DESCRIBE `trip_invites`991
22DESCRIBE `trip_join_requests`551
23DESCRIBE `messages`881
24SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '9b2218f0ec7f44d6b9bede1de10b94d0'110
25SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 43 LIMIT 1110
26SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (43) ORDER BY `TripDestination`.`lft` ASC 660
27SELECT `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `scoops` AS `Scoop` WHERE `Scoop`.`trip_destination_id` IN (248, 249, 250, 251, 252, 253) 000
28SELECT `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `scoops` AS `Scoop` WHERE `Scoop`.`trip_id` = (43) ORDER BY `Scoop`.`created` DESC 001
29SELECT `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`status` = 0 AND `TripMember`.`trip_id` = (43) 110
30SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`photo_filename` FROM `accounts` AS `Account` WHERE `Account`.`id` = 33 AND `Account`.`status` <> 0 110
31SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` = (43) 000
32SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` = 33 GROUP BY `Account`.`id` LIMIT 1111
33SELECT `FeaturedTrip`.`id` FROM `featured_trips` AS `FeaturedTrip` WHERE `FeaturedTrip`.`trip_id` = 43 000
34SELECT COUNT(*) AS `count` FROM `trip_members` AS `TripMember` LEFT JOIN `accounts` AS `Account` ON (`TripMember`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) WHERE `TripMember`.`account_id` IS NULL AND `TripMember`.`trip_id` = 43 AND `TripMember`.`status` = 0 110
35SELECT COUNT(*) AS `count` FROM `trip_followers` AS `TripFollower` LEFT JOIN `accounts` AS `Account` ON (`TripFollower`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) WHERE `TripFollower`.`account_id` IS NULL AND `TripFollower`.`trip_id` = 43 110
36SELECT COUNT(*) AS `count` FROM `messages` AS `Message` LEFT JOIN `accounts` AS `Author` ON (`Message`.`author_id` = `Author`.`id` AND `Author`.`status` <> 0) LEFT JOIN `accounts` AS `Recipient` ON (`Message`.`recipient_id` = `Recipient`.`id`) WHERE `Message`.`recipient_id` IS NULL AND `Message`.`viewed` = 0 110
37SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '9b2218f0ec7f44d6b9bede1de10b94d0'110
38UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328653133;s:4:\"rand\";i:1455743912;s:7:\"timeout\";i:10;}Message|a:0:{}', `expires` = 1328653133 WHERE `id` = '9b2218f0ec7f44d6b9bede1de10b94d0'10