Profile » Mike

Working in Victoria!See All Trips
  This trip currently has no scoops.  
Blogs by Mike

OtavaloOtavalo, Ecuador - 26th Mar 2009

Today, we took a three hour bus ride to Otovalo, the largest indigenous market in South America, although we kind of misjudged how long it would take to get there, and it turned out we had just an hour there before we had to head back, for the 6pm group meeting.

The market itself was OK, alot of the stalls were selling the same stuff though – alpaca wool, bracelets and jewelery, ponchos, and wood or stone carvings. There was also a food market there though, where we saw one guy selling live baby chickens in paper bags, and several stalls with kilos and kilos of so many d... [read more]

Into Peru!Mancora, Peru - 5th Apr 2009

We left Cuenca early, taking a long bus trip South into Peru. The passport controls were surprisingly easy, no more than a twenty minute wait at each, while the border was a trickle of a river, over which passed a wide bridge, packed with traders flogging everything from livestock to clothing and electronics.

Once over the border, we met our new tour leader, Sylvana (26, Lima) and said goodbye to Belen who had taken us through Ecuador.

We arrived at our hotel in Mancora at about 5.30pm and we were all delighted by our first sights of Peru. The town was a sma... [read more]

Amazon Jungle! Cuenca, Ecuador

This morning, our bus from Quito took 7 hours, to Tena, where we had lunch (Caldo de Pollo - chicken soup, and Spicy Pork Belly), before we got another bus for about 40 minutes to the Cotococha Jungle Lodges.

In the jungle, it was insanely hot, and humid, but the place was amazing. It´s so quiet compared to Quito as well, just in the middle of nowhere, miles from the nearest village.

The lodges had no electricity, so any light is by kerosene lamps, with cold showers using river water.

In the afternoon, we went to visit the Quichuan local... [read more]

Arrival.Quito, Ecuador - 25th Mar 2009

Just after arriving in Quito, having travelled for more or less 18 hours, the taxi driver responds to my directions with "Oh, the Gringo Quarter." Which is nice.

First impressions of Quito are more or less as I expected. It´s similar to the sightly dodgier parts of most European towns. Only it´s all like that. There´s a KFC just round the corner from the hotel (no, I haven´t been yet), and the security guard there is armed.

The hotel is much better than I expected, I´ve got a double bed with ensuite, free internet in t... [read more]

Photographs by Mike

More photos by this user

Videos by Mike
  Mike hasn't uploaded any videos yet.  
app/webroot/index.php (line 93)
1.0897
(default) 86 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `accounts`19191
2DESCRIBE `trip_destinations`15151
3DESCRIBE `trips`12120
4DESCRIBE `featured_trips`550
5DESCRIBE `scoops`990
6DESCRIBE `blogs`770
7DESCRIBE `comments`770
8DESCRIBE `ratings`770
9DESCRIBE `friend_tags`770
10DESCRIBE `photo_albums`550
11DESCRIBE `photos`770
12DESCRIBE `videos`990
13DESCRIBE `trip_members`660
14DESCRIBE `trip_followers`440
15DESCRIBE `trip_invites`990
16DESCRIBE `trip_join_requests`550
17DESCRIBE `user_locations`990
18DESCRIBE `friends`770
19DESCRIBE `friend_invites`990
20DESCRIBE `wish_lists`10100
21DESCRIBE `friend_groups`440
22DESCRIBE `friend_group_links`440
23DESCRIBE `messages`881
24SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '2348d31390b98a970075dffc7d156d7e'110
25SELECT `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` = 101 GROUP BY `Account`.`id` LIMIT 1111
26SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 101))) OR (((`Friend`.`account_id` = 101) AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 1 LIMIT 1000
27SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 101))) OR (((`Friend`.`account_id` = 101) AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 0 LIMIT 1001
28 SELECT `Account`.`id` FROM `accounts` AS `Account` LEFT JOIN `friends` AS `Friend` ON (`Account`.`id` = `Friend`.`account_id` OR `Account`.`id` = `Friend`.`friend_id`) WHERE ((`Friend`.`account_id` = 101 OR `Friend`.`friend_id` = 101) AND (`Account`.`id` <> 101) AND (`Friend`.`approved` = 1));220
29SELECT `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` IN (6, 103) GROUP BY `Account`.`id` ORDER BY rand() ASC 221
30SELECT `FriendA`.`id`, `FriendA`.`account_id`, `FriendA`.`friend_id`, `FriendA`.`approved`, `FriendA`.`id_hash`, `FriendA`.`created`, `FriendA`.`modified` FROM `friends` AS `FriendA` WHERE `FriendA`.`approved` = 1 AND `FriendA`.`account_id` IN (103, 6) 990
31SELECT `FriendB`.`id`, `FriendB`.`account_id`, `FriendB`.`friend_id`, `FriendB`.`approved`, `FriendB`.`id_hash`, `FriendB`.`created`, `FriendB`.`modified` FROM `friends` AS `FriendB` WHERE `FriendB`.`approved` = 1 AND `FriendB`.`friend_id` IN (103, 6) 880
32SELECT `FriendInvite`.`id`, `FriendInvite`.`account_id`, `FriendInvite`.`friend_id`, `FriendInvite`.`email`, `FriendInvite`.`approved`, `FriendInvite`.`id_hash`, `FriendInvite`.`fb_user_id_hash`, `FriendInvite`.`created`, `FriendInvite`.`modified` FROM `friend_invites` AS `FriendInvite` WHERE `FriendInvite`.`account_id` IN (103, 6) 770
33SELECT `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`.`account_id` IN (103, 6) 63630
34SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` IN (103, 6) 550
35SELECT `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`.`account_id` IN (103, 6) 11110
36SELECT `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` IN (103, 6) 11110
37SELECT `FriendGroup`.`id`, `FriendGroup`.`name`, `FriendGroup`.`account_id`, `FriendGroup`.`created` FROM `friend_groups` AS `FriendGroup` WHERE `FriendGroup`.`account_id` IN (103, 6) 220
38SELECT `FriendGroupLink`.`id`, `FriendGroupLink`.`account_id`, `FriendGroupLink`.`friend_group_id`, `FriendGroupLink`.`created` FROM `friend_group_links` AS `FriendGroupLink` WHERE `FriendGroupLink`.`account_id` IN (103, 6) 000
39SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` = 101 000
40SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 101 AND `TripMember`.`status` = 0 440
41SELECT `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` IN (85, 55, 101, 103) AND ((`Trip`.`start_date` <= NOW()) AND (`Trip`.`end_date` >= NOW())) ORDER BY `Trip`.`created` DESC LIMIT 1000
42SELECT `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` IN (85, 55, 101, 103) ORDER BY `Trip`.`start_date` DESC LIMIT 1110
43SELECT `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` = (103) ORDER BY `TripDestination`.`lft` ASC 440
44SELECT `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 (571, 572, 573, 574) 000
45SELECT `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` = (103) ORDER BY `Scoop`.`created` DESC 000
46SELECT `Trip`.`id`, `Trip`.`title` FROM `trips` AS `Trip` WHERE `Trip`.`id` IN (85, 55, 101, 103) ORDER BY `Trip`.`start_date` DESC 440
47SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 101 AND `TripMember`.`status` = 0 440
48SELECT `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 (85, 55, 101, 103) ORDER BY `Trip`.`start_date` DESC 440
49SELECT `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 (103, 101, 55, 85) ORDER BY `TripDestination`.`lft` ASC 58581
50SELECT `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 (103, 101, 55, 85) ORDER BY `Scoop`.`created` DESC 18180
51SELECT `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 (103, 101, 55, 85) 550
52SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` IN (103, 101, 55, 85) 110
53SELECT `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 (103, 101, 55, 85) 000
54SELECT `TripJoinRequest`.`id`, `TripJoinRequest`.`account_id`, `TripJoinRequest`.`trip_id`, `TripJoinRequest`.`approved`, `TripJoinRequest`.`created` FROM `trip_join_requests` AS `TripJoinRequest` WHERE `TripJoinRequest`.`trip_id` IN (103, 101, 55, 85) 110
55SELECT `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 (103, 101, 55, 85) AND `TripMember`.`account_id` = `TripMembers`.`id`) WHERE 1 = 1 550
56SELECT `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 (103, 101, 55, 85) AND `TripFollower`.`account_id` = `TripFollowers`.`id`) WHERE 1 = 1 110
57SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating`, `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 `blogs` AS `Blog` LEFT JOIN `scoops` AS `Scoop` ON (`Blog`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'Blog' AND `Scoop`.`account_id` = 101 ORDER BY rand() ASC LIMIT 4441
58SELECT `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`.`id` = 183 110
59SELECT `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` = 101 AND `Account`.`status` <> 0 110
60SELECT `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`.`id` = 452 110
61SELECT `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`.`id` = 202 110
62SELECT `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` = 101 AND `Account`.`status` <> 0 110
63SELECT `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`.`id` = 454 110
64SELECT `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`.`id` = 184 110
65SELECT `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` = 101 AND `Account`.`status` <> 0 110
66SELECT `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`.`id` = 453 110
67SELECT `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`.`id` = 178 110
68SELECT `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` = 101 AND `Account`.`status` <> 0 110
69SELECT `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`.`id` = 451 110
70SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating`, `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 `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'PhotoAlbum' AND `Scoop`.`account_id` = 101 ORDER BY rand() ASC LIMIT 4440
71SELECT `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`.`id` = 235 110
72SELECT `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` = 101 AND `Account`.`status` <> 0 110
73SELECT `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`.`id` = 451 110
74SELECT `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`.`id` = 235 110
75SELECT `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` = 101 AND `Account`.`status` <> 0 110
76SELECT `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`.`id` = 451 110
77SELECT `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`.`id` = 235 110
78SELECT `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` = 101 AND `Account`.`status` <> 0 110
79SELECT `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`.`id` = 451 110
80SELECT `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`.`id` = 235 110
81SELECT `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` = 101 AND `Account`.`status` <> 0 110
82SELECT `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`.`id` = 451 110
83SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating`, `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 `videos` AS `Video` LEFT JOIN `scoops` AS `Scoop` ON (`Scoop`.`foreign_id` = `Video`.`id` AND `Scoop`.`class` = 'Video') WHERE `Scoop`.`class` = 'Video' AND `Scoop`.`account_id` = 101 ORDER BY rand() ASC LIMIT 4000
84SELECT 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
85SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '2348d31390b98a970075dffc7d156d7e'110
86UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328578523;s:4:\"rand\";i:626325828;s:7:\"timeout\";i:10;}Auth|a:1:{s:7:\"Account\";N;}', `expires` = 1328578524 WHERE `id` = '2348d31390b98a970075dffc7d156d7e'10