Trips » Thailand

Trip Details

Thailand

Created by

  Dave Henderson View Profile  

Woodbridge, United Kingdom

32

Message User

Start / End Date

2nd Nov 2006 - 15th Nov 2006

Trip Visibility

This trip is viewable to the public

Departing From

Woodbridge, United Kingdom

Departing on: 2nd Nov 2006

Destinations

Bangkok, Thailand

2nd Nov 2006 - 7th Nov 2006

Ko Chang, Thailand

7th Nov 2006 - 16th Nov 2006

Bangkok, Thailand

11th Nov 2006 - 15th Nov 2006
Who's on this trip?

Dave Henderson

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) 
0.9869
(default) 38 queries took 14 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`770
8DESCRIBE `friend_tags`770
9DESCRIBE `photo_albums`550
10DESCRIBE `photos`770
11DESCRIBE `videos`990
12DESCRIBE `user_locations`990
13DESCRIBE `friends`770
14DESCRIBE `friend_invites`991
15DESCRIBE `wish_lists`10101
16DESCRIBE `trip_members`661
17DESCRIBE `friend_groups`440
18DESCRIBE `friend_group_links`441
19DESCRIBE `featured_trips`551
20DESCRIBE `trip_followers`440
21DESCRIBE `trip_invites`990
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` = 37 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` = (37) ORDER BY `TripDestination`.`lft` ASC 440
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 (190, 191, 209, 210) 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` = (37) 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` = (37) 110
30SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`photo_filename` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6 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` = (37) 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` = 6 GROUP BY `Account`.`id` LIMIT 1111
33SELECT `FeaturedTrip`.`id` FROM `featured_trips` AS `FeaturedTrip` WHERE `FeaturedTrip`.`trip_id` = 37 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` = 37 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` = 37 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:1328652353;s:4:\"rand\";i:1455743912;s:7:\"timeout\";i:10;}Message|a:0:{}', `expires` = 1328652354 WHERE `id` = '9b2218f0ec7f44d6b9bede1de10b94d0'10