TravelScoops: Search

Trips

Showing 8 of 53 results

Ansterdam with me mates

16/04/09 - 20/04/09

Simon Evans

Boxy But Good: Woodbridge to Timbuctu

08/01/09 - 30/01/09

Dave Henderson

In January of this year myself and a few friends decided to embark on a journey through the Sahara desert to Bamako in Mali, in a car worth £400.\nWe managed to raise around £3800 in total for charities.

Philippines

24/04/09 - 02/05/09

business

EuroTrip

09/06/09 - 23/06/09

Backpacking around europe with my uni friend Aimee

07/12/06 - 23/12/06

04/09/07 - 29/09/07

3 weeks to escape London and see a new place.

South America 2009

24/03/09 - 05/07/09

Mike Stuart

Quito to La Paz, to Santiago, to Buenos Aires, to Rio; and everywhere inbetween.

Ian's trip around the world!

14/06/09 - 13/12/09

Ian Anderson

6 month trip around the world. On this site I will keep a log of all my activities

Page Previous 1234567 Next

(default) 38 queries took 43 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `scoops`	9	9	1
2	DESCRIBE `accounts`	19	19	1
3	DESCRIBE `trip_destinations`	15	15	1
4	DESCRIBE `trips`	12	12	1
5	DESCRIBE `featured_trips`	5	5	1
6	DESCRIBE `trip_members`	6	6	1
7	DESCRIBE `trip_followers`	4	4	1
8	DESCRIBE `trip_invites`	9	9	1
9	DESCRIBE `trip_join_requests`	5	5	1
10	DESCRIBE `user_locations`	9	9	1
11	DESCRIBE `friends`	7	7	1
12	DESCRIBE `friend_invites`	9	9	1
13	DESCRIBE `wish_lists`	10	10	1
14	DESCRIBE `friend_groups`	4	4	1
15	DESCRIBE `friend_group_links`	4	4	1
16	DESCRIBE `blogs`	7	7	1
17	DESCRIBE `comments`	7	7	1
18	DESCRIBE `ratings`	7	7	1
19	DESCRIBE `friend_tags`	7	7	1
20	DESCRIBE `photo_albums`	5	5	1
21	DESCRIBE `photos`	7	7	1
22	DESCRIBE `videos`	9	9	1
23	DESCRIBE `messages`	8	8	1
24	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '32fc0886cf33ff6051583b37cadf71ea'	1	1	0
25	SELECT `Trip`.`id` FROM `trips` AS `Trip` WHERE `Trip`.`privacy_level` = 'public'	53	53	0
26	SELECT COUNT(*) AS `count` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` IN (2, 3, 5, 15, 19, 26, 27, 28, 29, 32, 33, 37, 38, 40, 43, 44, 45, 46, 47, 48, 49, 50, 51, 55, 57, 58, 59, 60, 62, 63, 66, 67, 69, 71, 72, 74, 77, 83, 85, 89, 90, 93, 94, 95, 96, 97, 98, 101, 102, 103, 104, 105, 106)	1	1	1
27	SELECT `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`, `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`, `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` IN (2, 3, 5, 15, 19, 26, 27, 28, 29, 32, 33, 37, 38, 40, 43, 44, 45, 46, 47, 48, 49, 50, 51, 55, 57, 58, 59, 60, 62, 63, 66, 67, 69, 71, 72, 74, 77, 83, 85, 89, 90, 93, 94, 95, 96, 97, 98, 101, 102, 103, 104, 105, 106) LIMIT 32, 8	8	8	1
28	SELECT `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` IN (69, 71, 72, 74, 77, 83, 85, 89) ORDER BY `TripDestination`.`lft` ASC	75	75	2
29	SELECT `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` IN (69, 71, 72, 74, 77, 83, 85, 89) ORDER BY `Scoop`.`created` DESC	31	31	1
30	SELECT `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` IN (69, 71, 72, 74, 77, 83, 85, 89)	7	7	0
31	SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89)	2	2	15
32	SELECT `TripInvite`.`id`, `TripInvite`.`account_id`, `TripInvite`.`trip_id`, `TripInvite`.`recipient_id`, `TripInvite`.`email`, `TripInvite`.`approved`, `TripInvite`.`id_hash`, `TripInvite`.`fb_user_id_hash`, `TripInvite`.`created` FROM `trip_invites` AS `TripInvite` WHERE `TripInvite`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89)	2	2	0
33	SELECT `TripJoinRequest`.`id`, `TripJoinRequest`.`account_id`, `TripJoinRequest`.`trip_id`, `TripJoinRequest`.`approved`, `TripJoinRequest`.`created` FROM `trip_join_requests` AS `TripJoinRequest` WHERE `TripJoinRequest`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89)	1	1	0
34	SELECT `TripMembers`.`id`, `TripMembers`.`forename`, `TripMembers`.`surname`, `TripMembers`.`nickname`, `TripMembers`.`email`, `TripMembers`.`password`, `TripMembers`.`dob`, `TripMembers`.`gender`, `TripMembers`.`privacy_level`, `TripMembers`.`nationality`, `TripMembers`.`photo_filename`, `TripMembers`.`fb_uid`, `TripMembers`.`use_fb`, `TripMembers`.`email_hash`, `TripMembers`.`permission_group_id`, `TripMembers`.`status`, `TripMembers`.`disabled`, `TripMembers`.`created`, `TripMembers`.`modified`, `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `accounts` AS `TripMembers` JOIN `trip_members` AS `TripMember` ON (`TripMember`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89) AND `TripMember`.`account_id` = `TripMembers`.`id`) WHERE 1 = 1	7	7	0
35	SELECT `TripFollowers`.`id`, `TripFollowers`.`forename`, `TripFollowers`.`surname`, `TripFollowers`.`nickname`, `TripFollowers`.`email`, `TripFollowers`.`password`, `TripFollowers`.`dob`, `TripFollowers`.`gender`, `TripFollowers`.`privacy_level`, `TripFollowers`.`nationality`, `TripFollowers`.`photo_filename`, `TripFollowers`.`fb_uid`, `TripFollowers`.`use_fb`, `TripFollowers`.`email_hash`, `TripFollowers`.`permission_group_id`, `TripFollowers`.`status`, `TripFollowers`.`disabled`, `TripFollowers`.`created`, `TripFollowers`.`modified`, `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `accounts` AS `TripFollowers` JOIN `trip_followers` AS `TripFollower` ON (`TripFollower`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89) AND `TripFollower`.`account_id` = `TripFollowers`.`id`) WHERE 1 = 1	2	2	0
36	SELECT 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	1	1	0
37	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '32fc0886cf33ff6051583b37cadf71ea'	1	1	0
38	UPDATE `cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1284182519;s:4:\"rand\";i:567459301;s:7:\"timeout\";i:10;}', `expires` = 1284182520 WHERE `id` = '32fc0886cf33ff6051583b37cadf71ea'	1		0

(default) 38 queries took 43 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `scoops`

DESCRIBE `accounts`

DESCRIBE `trip_destinations`

DESCRIBE `trips`

DESCRIBE `featured_trips`

DESCRIBE `trip_members`

DESCRIBE `trip_followers`

DESCRIBE `trip_invites`

DESCRIBE `trip_join_requests`

DESCRIBE `user_locations`

DESCRIBE `friends`

DESCRIBE `friend_invites`

DESCRIBE `wish_lists`

DESCRIBE `friend_groups`

DESCRIBE `friend_group_links`

DESCRIBE `blogs`

DESCRIBE `comments`

DESCRIBE `ratings`

DESCRIBE `friend_tags`

DESCRIBE `photo_albums`

DESCRIBE `photos`

DESCRIBE `videos`

DESCRIBE `messages`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '32fc0886cf33ff6051583b37cadf71ea'

SELECT `Trip`.`id` FROM `trips` AS `Trip` WHERE `Trip`.`privacy_level` = 'public'

SELECT COUNT(*) AS `count` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` IN (2, 3, 5, 15, 19, 26, 27, 28, 29, 32, 33, 37, 38, 40, 43, 44, 45, 46, 47, 48, 49, 50, 51, 55, 57, 58, 59, 60, 62, 63, 66, 67, 69, 71, 72, 74, 77, 83, 85, 89, 90, 93, 94, 95, 96, 97, 98, 101, 102, 103, 104, 105, 106)

SELECT `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`, `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`, `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` IN (2, 3, 5, 15, 19, 26, 27, 28, 29, 32, 33, 37, 38, 40, 43, 44, 45, 46, 47, 48, 49, 50, 51, 55, 57, 58, 59, 60, 62, 63, 66, 67, 69, 71, 72, 74, 77, 83, 85, 89, 90, 93, 94, 95, 96, 97, 98, 101, 102, 103, 104, 105, 106) LIMIT 32, 8

SELECT `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` IN (69, 71, 72, 74, 77, 83, 85, 89) ORDER BY `TripDestination`.`lft` ASC

SELECT `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` IN (69, 71, 72, 74, 77, 83, 85, 89) ORDER BY `Scoop`.`created` DESC

SELECT `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` IN (69, 71, 72, 74, 77, 83, 85, 89)

SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89)

SELECT `TripInvite`.`id`, `TripInvite`.`account_id`, `TripInvite`.`trip_id`, `TripInvite`.`recipient_id`, `TripInvite`.`email`, `TripInvite`.`approved`, `TripInvite`.`id_hash`, `TripInvite`.`fb_user_id_hash`, `TripInvite`.`created` FROM `trip_invites` AS `TripInvite` WHERE `TripInvite`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89)

SELECT `TripJoinRequest`.`id`, `TripJoinRequest`.`account_id`, `TripJoinRequest`.`trip_id`, `TripJoinRequest`.`approved`, `TripJoinRequest`.`created` FROM `trip_join_requests` AS `TripJoinRequest` WHERE `TripJoinRequest`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89)

SELECT `TripMembers`.`id`, `TripMembers`.`forename`, `TripMembers`.`surname`, `TripMembers`.`nickname`, `TripMembers`.`email`, `TripMembers`.`password`, `TripMembers`.`dob`, `TripMembers`.`gender`, `TripMembers`.`privacy_level`, `TripMembers`.`nationality`, `TripMembers`.`photo_filename`, `TripMembers`.`fb_uid`, `TripMembers`.`use_fb`, `TripMembers`.`email_hash`, `TripMembers`.`permission_group_id`, `TripMembers`.`status`, `TripMembers`.`disabled`, `TripMembers`.`created`, `TripMembers`.`modified`, `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `accounts` AS `TripMembers` JOIN `trip_members` AS `TripMember` ON (`TripMember`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89) AND `TripMember`.`account_id` = `TripMembers`.`id`) WHERE 1 = 1

SELECT `TripFollowers`.`id`, `TripFollowers`.`forename`, `TripFollowers`.`surname`, `TripFollowers`.`nickname`, `TripFollowers`.`email`, `TripFollowers`.`password`, `TripFollowers`.`dob`, `TripFollowers`.`gender`, `TripFollowers`.`privacy_level`, `TripFollowers`.`nationality`, `TripFollowers`.`photo_filename`, `TripFollowers`.`fb_uid`, `TripFollowers`.`use_fb`, `TripFollowers`.`email_hash`, `TripFollowers`.`permission_group_id`, `TripFollowers`.`status`, `TripFollowers`.`disabled`, `TripFollowers`.`created`, `TripFollowers`.`modified`, `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `accounts` AS `TripFollowers` JOIN `trip_followers` AS `TripFollower` ON (`TripFollower`.`trip_id` IN (69, 71, 72, 74, 77, 83, 85, 89) AND `TripFollower`.`account_id` = `TripFollowers`.`id`) WHERE 1 = 1

SELECT 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

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '32fc0886cf33ff6051583b37cadf71ea'

UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1284182519;s:4:\"rand\";i:567459301;s:7:\"timeout\";i:10;}', `expires` = 1284182520 WHERE `id` = '32fc0886cf33ff6051583b37cadf71ea'


	Email Password Forgot your password? Or if you registered using your facebook profile, login securely here: