Trips » fbtest2

Trip Details

fbtest2

Created by

  View Profile  
Message User

Start / End Date

8th Jan 2009 - 19th Jan 2009

Trip Visibility

This trip is viewable to the public

Departing From

London, United Kingdom

Departing on: 8th Jan 2009

Destinations

Bath, United Kingdom

9th Jan 2009 - 19th Jan 2009
Edit TripDelete Trip
Who's on this trip?Manage Members
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. Why not let people know more about the trip by uploading photos, videos and blogs?  
app/webroot/index.php (line 93) 
1.0548
(default) 37 queries took 21 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `trips`12121
2DESCRIBE `accounts`19191
3DESCRIBE `trip_destinations`15151
4DESCRIBE `scoops`991
5DESCRIBE `blogs`771
6DESCRIBE `comments`771
7DESCRIBE `ratings`771
8DESCRIBE `friend_tags`771
9DESCRIBE `photo_albums`551
10DESCRIBE `photos`771
11DESCRIBE `videos`991
12DESCRIBE `user_locations`991
13DESCRIBE `friends`771
14DESCRIBE `friend_invites`991
15DESCRIBE `wish_lists`10101
16DESCRIBE `trip_members`661
17DESCRIBE `friend_groups`440
18DESCRIBE `friend_group_links`441
19DESCRIBE `featured_trips`550
20DESCRIBE `trip_followers`440
21DESCRIBE `trip_invites`991
22DESCRIBE `trip_join_requests`550
23DESCRIBE `messages`881
24SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '2348d31390b98a970075dffc7d156d7e'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` = 19 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` = (19) 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 (87, 88) 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` = (19) 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` = (19) 000
30SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` = (19) 000
31SELECT `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` IS NULL GROUP BY `Account`.`id` LIMIT 1000
32SELECT `FeaturedTrip`.`id` FROM `featured_trips` AS `FeaturedTrip` WHERE `FeaturedTrip`.`trip_id` = 19 000
33SELECT 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` = 19 AND `TripMember`.`status` = 0 110
34SELECT 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` = 19 112
35SELECT 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
36SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '2348d31390b98a970075dffc7d156d7e'110
37UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328570862;s:4:\"rand\";i:626325828;s:7:\"timeout\";i:10;}', `expires` = 1328570863 WHERE `id` = '2348d31390b98a970075dffc7d156d7e'10