Trips » Kris in Europe 2007

Trip Details

Kris in Europe 2007

Created by

  Kris View Profile  

Geraldine, New Zealand

24

Message User

Start / End Date

7th Mar 2007 - 22nd Dec 2007

Trip Visibility

This trip is viewable to the public

Departing From

Geraldine, New Zealand

Departing on: 7th Mar 2007

Destinations

Dublin, Ireland

7th Mar 2007 - 22nd Dec 2007
Who's on this trip?

Kris Johnstone

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.0686
(default) 38 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `trips`12121
2DESCRIBE `accounts`19191
3DESCRIBE `trip_destinations`15152
4DESCRIBE `scoops`990
5DESCRIBE `blogs`771
6DESCRIBE `comments`771
7DESCRIBE `ratings`771
8DESCRIBE `friend_tags`771
9DESCRIBE `photo_albums`550
10DESCRIBE `photos`771
11DESCRIBE `videos`991
12DESCRIBE `user_locations`991
13DESCRIBE `friends`771
14DESCRIBE `friend_invites`991
15DESCRIBE `wish_lists`10101
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` = 97 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` = (97) ORDER BY `TripDestination`.`lft` ASC 220
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 (521, 522) 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` = (97) ORDER BY `Scoop`.`created` DESC 000
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` = (97) 110
30SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`photo_filename` FROM `accounts` AS `Account` WHERE `Account`.`id` = 120 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` = (97) 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` = 120 GROUP BY `Account`.`id` LIMIT 1111
33SELECT `FeaturedTrip`.`id` FROM `featured_trips` AS `FeaturedTrip` WHERE `FeaturedTrip`.`trip_id` = 97 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` = 97 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` = 97 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'111
38UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328652458;s:4:\"rand\";i:1455743912;s:7:\"timeout\";i:10;}Message|a:0:{}', `expires` = 1328652459 WHERE `id` = '9b2218f0ec7f44d6b9bede1de10b94d0'10