TravelScoops: Search

Featured Trips

Showing 5 of 5 results

Morocco

15/12/08 - 22/12/08

Tom Picking

My trip to Morocco in Dec 2008

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.

Magical Incas

14/04/09 - 02/05/09

Dave Henderson

South America: Santiago to Sao Paulo

20/05/09 - 03/07/09

Dave Henderson

Intrepid Altiplano

02/05/09 - 20/05/09

Dave Henderson

(default) 45 queries took 32 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `scoops`	9	9	1
2	DESCRIBE `accounts`	19	19	2
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` = 'c1a4a519a655ed0d958a780715c52d03'	1	1	1
25	SELECT `Trip`.`id` FROM `trips` AS `Trip` WHERE `Trip`.`privacy_level` = 'public'	53	53	0
26	SELECT COUNT(*) AS `count` FROM `featured_trips` AS `FeaturedTrip` LEFT JOIN `trips` AS `Trip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE 1 = 1	1	1	1
27	SELECT `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified`, `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 `featured_trips` AS `FeaturedTrip` LEFT JOIN `trips` AS `Trip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE 1 = 1 LIMIT 8	5	5	1
28	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` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
29	SELECT `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` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43	1	1	0
30	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` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	1
31	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` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 71	1	1	0
32	SELECT `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` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6	1	1	0
33	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` = (71) ORDER BY `TripDestination`.`lft` ASC	16	16	1
34	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` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 27	1	1	0
35	SELECT `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` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6	1	1	0
36	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` = (27) ORDER BY `TripDestination`.`lft` ASC	10	10	1
37	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` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 59	1	1	0
38	SELECT `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` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6	1	1	0
39	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` = (59) ORDER BY `TripDestination`.`lft` ASC	12	12	1
40	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` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 55	1	1	0
41	SELECT `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` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6	1	1	0
42	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` = (55) ORDER BY `TripDestination`.`lft` ASC	8	8	0
43	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	1
44	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'c1a4a519a655ed0d958a780715c52d03'	1	1	0
45	UPDATE `cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1283567247;s:4:\"rand\";i:1394770547;s:7:\"timeout\";i:10;}', `expires` = 1283567247 WHERE `id` = 'c1a4a519a655ed0d958a780715c52d03'	1		0

(default) 45 queries took 32 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` = 'c1a4a519a655ed0d958a780715c52d03'

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

SELECT COUNT(*) AS `count` FROM `featured_trips` AS `FeaturedTrip` LEFT JOIN `trips` AS `Trip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE 1 = 1

SELECT `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified`, `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 `featured_trips` AS `FeaturedTrip` LEFT JOIN `trips` AS `Trip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE 1 = 1 LIMIT 8

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` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40

SELECT `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` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43

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` = (40) ORDER BY `TripDestination`.`lft` ASC

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` = 'c1a4a519a655ed0d958a780715c52d03'

UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1283567247;s:4:\"rand\";i:1394770547;s:7:\"timeout\";i:10;}', `expires` = 1283567247 WHERE `id` = 'c1a4a519a655ed0d958a780715c52d03'


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