TravelScoops: Photo Albums » Simon Evans

Showing 5 of 5 results

Location:Hampi

From the Trip:Simon and Ev's World Tour

Date: 20/05/2009

By:Simon Evans


	Simon Evans View Profile

Age

Friends

Message User

Other scoops from this user

see all

"Day 48 – 23rd June 2009 – Sikkim and our trek to Chanchenzonga, the third highest mountain in the world" from the trip "Simon and Ev's World Tour".

10:57 26th June 2009

"Day 36 – 11th June 2009 – Kalimpong and Darjeeling : Finally some cold weather in the mountains!" from the trip "Simon and Ev's World Tour".

10:54 26th June 2009

"Day 30 – 5th June 2009 – Calcutta : Planes, trains, and automobiles" from the trip "Simon and Ev's World Tour".

10:27 5th June 2009

"Temples and stuff" from the trip "Simon and Ev's World Tour".

16:10 30th May 2009

"Day 24 – 30th May 2009 – Broken boats, Rain and Ruins" from the trip "Simon and Ev's World Tour".

11:56 30th May 2009

(default) 110 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `photo_albums`	5	5	0
2	DESCRIBE `scoops`	9	9	0
3	DESCRIBE `accounts`	19	19	1
4	DESCRIBE `trip_destinations`	15	15	1
5	DESCRIBE `trips`	12	12	0
6	DESCRIBE `featured_trips`	5	5	0
7	DESCRIBE `trip_members`	6	6	0
8	DESCRIBE `trip_followers`	4	4	0
9	DESCRIBE `trip_invites`	9	9	0
10	DESCRIBE `trip_join_requests`	5	5	0
11	DESCRIBE `user_locations`	9	9	0
12	DESCRIBE `friends`	7	7	0
13	DESCRIBE `friend_invites`	9	9	0
14	DESCRIBE `wish_lists`	10	10	0
15	DESCRIBE `friend_groups`	4	4	0
16	DESCRIBE `friend_group_links`	4	4	0
17	DESCRIBE `blogs`	7	7	1
18	DESCRIBE `comments`	7	7	0
19	DESCRIBE `ratings`	7	7	0
20	DESCRIBE `friend_tags`	7	7	0
21	DESCRIBE `videos`	9	9	0
22	DESCRIBE `photos`	7	7	0
23	DESCRIBE `messages`	8	8	0
24	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '80d95d32d9de55050ccc1655fbcca0de'	1	1	0
25	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id`, `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 `photo_albums` AS `PhotoAlbum` LEFT JOIN `scoops` AS `Scoop` ON (`PhotoAlbum`.`scoop_id` = `Scoop`.`id`) WHERE `PhotoAlbum`.`id` = 78 LIMIT 1	1	1	0
26	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`.`id` = 206	1	1	0
27	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` = 71 AND `Account`.`status` <> 0	1	1	0
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` = 66	1	1	0
29	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`.`id` = 471	1	1	0
30	SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` = (78)	5	5	0
31	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` = 71 OR `Friend`.`friend_id` = 71) AND (`Account`.`id` <> 71) AND (`Friend`.`approved` = 1));	3	3	1
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` = 71 GROUP BY `Account`.`id` LIMIT 1	1	1	0
33	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
34	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` = 71 AND `Account`.`status` <> 0	1	1	0
35	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
36	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` = 71 AND `Account`.`status` <> 0	1	1	0
37	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	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` = 71 AND `Account`.`status` <> 0	1	1	0
39	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
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` = 71 AND `Account`.`status` <> 0	1	1	0
41	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
42	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` = 71 AND `Account`.`status` <> 0	1	1	0
43	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
44	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` = 71 AND `Account`.`status` <> 0	1	1	0
45	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
46	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` = 71 AND `Account`.`status` <> 0	1	1	0
47	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
48	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` = 71 AND `Account`.`status` <> 0	1	1	0
49	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
50	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` = 71 AND `Account`.`status` <> 0	1	1	0
51	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
52	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` = 71 AND `Account`.`status` <> 0	1	1	0
53	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	1
54	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` = 71 AND `Account`.`status` <> 0	1	1	0
55	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`.`account_id` = (71) ORDER BY `Scoop`.`created` DESC	11	11	0
56	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` = 66	1	1	0
57	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` = 66	1	1	0
58	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` = 66	1	1	0
59	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` = 66	1	1	0
60	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` = 66	1	1	0
61	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` = 66	1	1	0
62	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` = 66	1	1	0
63	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` = 66	1	1	0
64	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` = 66	1	1	0
65	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` = 66	1	1	0
66	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` = 67	1	1	0
67	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 228	1	1	0
68	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 227	1	1	0
69	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 223	1	1	1
70	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 206	0	0	0
71	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 205	1	1	0
72	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 194	0	0	0
73	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 191	1	1	0
74	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 190	1	1	0
75	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 180	1	1	0
76	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 169	1	1	0
77	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 157	0	0	0
78	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 228	0	0	0
79	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 227	0	0	0
80	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 223	0	0	0
81	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 206	1	1	0
82	SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` = (78)	5	5	0
83	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 205	0	0	0
84	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 194	1	1	0
85	SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` = (70)	5	5	2
86	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 191	0	0	0
87	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 190	0	0	0
88	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 180	0	0	0
89	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 169	0	0	0
90	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 157	1	1	0
91	SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` = (52)	5	5	0
92	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 228	0	0	0
93	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 227	0	0	0
94	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 223	0	0	0
95	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 206	0	0	0
96	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 205	0	0	0
97	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 194	0	0	0
98	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 191	0	0	0
99	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 190	0	0	0
100	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 180	0	0	0
101	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 169	0	0	0
102	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 157	0	0	0
103	SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `photo_albums` AS `PhotoAlbum` ON (`Photo`.`photo_album_id` = `PhotoAlbum`.`id`) WHERE `Photo`.`photo_album_id` = 78	1	1	0
104	SELECT `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`, `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `photo_albums` AS `PhotoAlbum` ON (`Photo`.`photo_album_id` = `PhotoAlbum`.`id`) WHERE `Photo`.`photo_album_id` = 78 LIMIT 15	5	5	0
105	SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Photo' AND `Comment`.`foreign_id` IN (609, 610, 611, 612, 613)	0	0	0
106	SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Photo' AND `Rating`.`foreign_id` IN (609, 610, 611, 612, 613)	0	0	0
107	SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Photo' AND `FriendTag`.`foreign_id` IN (609, 610, 611, 612, 613)	0	0	0
108	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
109	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'	1	1	0
110	UPDATE `cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328759461;s:4:\"rand\";i:1272878031;s:7:\"timeout\";i:10;}Message\|a:0:{}', `expires` = 1328759461 WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'	1		1

(default) 110 queries took 9 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `photo_albums`

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 `videos`

DESCRIBE `photos`

DESCRIBE `messages`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '80d95d32d9de55050ccc1655fbcca0de'

SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id`, `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 `photo_albums` AS `PhotoAlbum` LEFT JOIN `scoops` AS `Scoop` ON (`PhotoAlbum`.`scoop_id` = `Scoop`.`id`) WHERE `PhotoAlbum`.`id` = 78 LIMIT 1

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`.`id` = 206

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` = 71 AND `Account`.`status` <> 0

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` = 66

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`.`id` = 471

SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` = (78)

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` = 71 OR `Friend`.`friend_id` = 71) AND (`Account`.`id` <> 71) AND (`Friend`.`approved` = 1));

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 228

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 227

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 223

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 206

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 205

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 194

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 191

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 190

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 180

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 169

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 157

SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 228

SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 228

100

101

102

103

SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `photo_albums` AS `PhotoAlbum` ON (`Photo`.`photo_album_id` = `PhotoAlbum`.`id`) WHERE `Photo`.`photo_album_id` = 78

104

SELECT `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`, `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `photo_albums` AS `PhotoAlbum` ON (`Photo`.`photo_album_id` = `PhotoAlbum`.`id`) WHERE `Photo`.`photo_album_id` = 78 LIMIT 15

105

SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Photo' AND `Comment`.`foreign_id` IN (609, 610, 611, 612, 613)

106

SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Photo' AND `Rating`.`foreign_id` IN (609, 610, 611, 612, 613)

107

SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Photo' AND `FriendTag`.`foreign_id` IN (609, 610, 611, 612, 613)

108

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

109

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'

110

UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328759461;s:4:\"rand\";i:1272878031;s:7:\"timeout\";i:10;}Message|a:0:{}', `expires` = 1328759461 WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'


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