TravelScoops: Photos » Vickrum Loi

Location:Salta

From the Trip:Intrepid Copy

From the Album:asd

By:Vickrum Loi

Rating:


	Vickrum Loi View Profile

Age

Friends

Message User

Other scoops from this user

see all

"vid test" from the trip "Intrepid Copy".

10:58 30th March 2009

"asd" from the trip "Intrepid Copy".

10:39 30th March 2009

"mpg" from the trip "Intrepid Copy".

10:38 26th March 2009

"dir" from the trip "Intrepid Copy".

10:24 26th March 2009

"mpg" from the trip "Intrepid Copy".

12:46 20th March 2009

(default) 147 queries took 187 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `accounts`	19	19	1
2	DESCRIBE `trip_destinations`	15	15	1
3	DESCRIBE `trips`	12	12	1
4	DESCRIBE `featured_trips`	5	5	0
5	DESCRIBE `scoops`	9	9	1
6	DESCRIBE `blogs`	7	7	0
7	DESCRIBE `comments`	7	7	3
8	DESCRIBE `ratings`	7	7	1
9	DESCRIBE `friend_tags`	7	7	1
10	DESCRIBE `photo_albums`	5	5	1
11	DESCRIBE `photos`	7	7	1
12	DESCRIBE `videos`	9	9	1
13	DESCRIBE `trip_members`	6	6	0
14	DESCRIBE `trip_followers`	4	4	4
15	DESCRIBE `trip_invites`	9	9	1
16	DESCRIBE `trip_join_requests`	5	5	0
17	DESCRIBE `user_locations`	9	9	0
18	DESCRIBE `friends`	7	7	0
19	DESCRIBE `friend_invites`	9	9	1
20	DESCRIBE `wish_lists`	10	10	0
21	DESCRIBE `friend_groups`	4	4	0
22	DESCRIBE `friend_group_links`	4	4	0
23	DESCRIBE `temp_table`	3	3	1
24	DESCRIBE `messages`	8	8	0
25	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'e72e664cd5eada79310a4c2acbf2c224'	1	1	0
26	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`.`id` = 79 LIMIT 1	1	1	0
27	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` = 125	1	1	0
28	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` = 2 AND `Account`.`status` <> 0	1	1	0
29	SELECT `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `user_locations` AS `UserLocation` WHERE `UserLocation`.`account_id` = 2	1	1	0
30	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` = 58	1	1	0
31	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` = 314	1	1	1
32	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`id` = 33	1	1	0
33	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` = (79)	0	0	0
34	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` = (79)	0	0	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` = 2 GROUP BY `Account`.`id` LIMIT 1	1	1	0
36	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
37	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` = 2 AND `Account`.`status` <> 0	1	1	0
38	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
39	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` = 2 AND `Account`.`status` <> 0	1	1	0
40	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	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` = 2 AND `Account`.`status` <> 0	1	1	0
42	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
43	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` = 2 AND `Account`.`status` <> 0	1	1	0
44	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
45	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` = 2 AND `Account`.`status` <> 0	1	1	0
46	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
47	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` = 2 AND `Account`.`status` <> 0	1	1	0
48	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
49	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` = 2 AND `Account`.`status` <> 0	1	1	0
50	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
51	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` = 2 AND `Account`.`status` <> 0	1	1	0
52	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
53	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` = 2 AND `Account`.`status` <> 0	1	1	0
54	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
55	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` = 2 AND `Account`.`status` <> 0	1	1	0
56	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
57	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` = 2 AND `Account`.`status` <> 0	1	1	0
58	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
59	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` = 2 AND `Account`.`status` <> 0	1	1	0
60	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
61	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` = 2 AND `Account`.`status` <> 0	1	1	0
62	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
63	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` = 2 AND `Account`.`status` <> 0	1	1	0
64	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	2
65	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` = 2 AND `Account`.`status` <> 0	1	1	0
66	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` = (2) ORDER BY `Scoop`.`created` DESC	15	15	0
67	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` = 58	1	1	0
68	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` = 58	1	1	0
69	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` = 58	1	1	0
70	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` = 58	1	1	0
71	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` = 58	1	1	0
72	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` = 58	1	1	0
73	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` = 58	1	1	0
74	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` = 58	1	1	0
75	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` = 58	1	1	0
76	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` = 58	1	1	0
77	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` = 58	1	1	0
78	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` = 58	1	1	0
79	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` = 58	1	1	0
80	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` = 58	1	1	0
81	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` = 32	1	1	0
82	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` = 126	0	0	0
83	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` = 125	0	0	0
84	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` = 116	0	0	0
85	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` = 115	0	0	0
86	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` = 97	0	0	0
87	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` = 96	0	0	0
88	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` = 95	0	0	0
89	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` = 94	0	0	0
90	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` = 93	0	0	0
91	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` = 92	0	0	0
92	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` = 91	0	0	0
93	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` = 90	0	0	0
94	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` = 80	0	0	0
95	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` = 79	0	0	0
96	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` = 51	0	0	0
97	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 126	0	0	0
98	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 125	1	1	0
99	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` = (33)	1	1	0
100	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 116	0	0	0
101	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 115	0	0	0
102	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 97	0	0	0
103	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 96	0	0	0
104	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 95	0	0	0
105	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 94	0	0	0
106	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 93	0	0	0
107	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 92	0	0	0
108	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 91	0	0	0
109	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 90	0	0	0
110	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 80	0	0	0
111	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 79	0	0	0
112	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 51	0	0	0
113	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` = 126	1	1	0
114	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` = 125	0	0	0
115	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` = 116	1	1	0
116	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` = 115	1	1	0
117	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` = 97	1	1	0
118	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` = 96	1	1	0
119	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` = 95	1	1	0
120	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` = 94	1	1	0
121	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` = 93	1	1	0
122	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` = 92	1	1	0
123	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` = 91	1	1	0
124	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` = 90	1	1	0
125	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` = 80	1	1	0
126	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` = 79	1	1	0
127	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` = 51	0	0	0
128	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` = 2 OR `Friend`.`friend_id` = 2) AND (`Account`.`id` <> 2) AND (`Friend`.`approved` = 1));	2	2	0
129	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`.`id` = 79 LIMIT 1	1	1	0
130	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` = (79)	0	0	0
131	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` = (79)	0	0	0
132	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` = (79)	0	0	0
133	SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` WHERE `Photo`.`id` = 79	1	1	0
134	UPDATE `photos` SET `views` = 111 WHERE `photos`.`id` = 79	1		158
135	SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`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` FROM `ratings` AS `Rating` LEFT JOIN `accounts` AS `Account` ON (`Rating`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) WHERE `Rating`.`foreign_id` = 79	0	0	0
136	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`, `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`, `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`, `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`, `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating`, `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id`, `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `scoops` AS `Scoop` LEFT JOIN `accounts` AS `Account` ON (`Scoop`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) LEFT JOIN `trips` AS `Trip` ON (`Scoop`.`trip_id` = `Trip`.`id`) LEFT JOIN `trip_destinations` AS `TripDestination` ON (`Scoop`.`trip_destination_id` = `TripDestination`.`id`) LEFT JOIN `blogs` AS `Blog` ON (`Blog`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `photo_albums` AS `PhotoAlbum` ON (`PhotoAlbum`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `videos` AS `Video` ON (`Video`.`scoop_id` = `Scoop`.`id`) WHERE `TripDestination`.`geoname_id` = 3838233 AND `Scoop`.`id` <> 125 ORDER BY `Scoop`.`created` DESC	2	2	5
137	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` = 80 LIMIT 1	1	1	0
138	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` = (80)	16	16	0
139	SELECT `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 `Video`.`id` = 36 LIMIT 1	1	1	1
140	SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Video' AND `Comment`.`foreign_id` = (36)	0	0	0
141	SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Video' AND `Rating`.`foreign_id` = (36)	0	0	0
142	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` = 'Video' AND `FriendTag`.`foreign_id` = (36)	0	0	0
143	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` = 33 AND `Photo`.`id` < 79 ORDER BY `Photo`.`id` DESC LIMIT 1	0	0	1
144	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` = 33 AND `Photo`.`id` > 79 ORDER BY `Photo`.`id` ASC LIMIT 1	0	0	0
145	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
146	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'e72e664cd5eada79310a4c2acbf2c224'	1	1	0
147	UPDATE `cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1337519670;s:4:\"rand\";i:293028519;s:7:\"timeout\";i:10;}Message\|a:0:{}Auth\|a:1:{s:7:\"Account\";N;}', `expires` = 1337519671 WHERE `id` = 'e72e664cd5eada79310a4c2acbf2c224'	1		0

(default) 147 queries took 187 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `accounts`

DESCRIBE `trip_destinations`

DESCRIBE `trips`

DESCRIBE `featured_trips`

DESCRIBE `scoops`

DESCRIBE `blogs`

DESCRIBE `comments`

DESCRIBE `ratings`

DESCRIBE `friend_tags`

DESCRIBE `photo_albums`

DESCRIBE `photos`

DESCRIBE `videos`

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

DESCRIBE `messages`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'e72e664cd5eada79310a4c2acbf2c224'

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`.`id` = 79 LIMIT 1

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

SELECT `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `user_locations` AS `UserLocation` WHERE `UserLocation`.`account_id` = 2

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

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

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

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` = (79)

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` = (79)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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` = (33)

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

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

129

130

131

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` = (79)

132

133

SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` WHERE `Photo`.`id` = 79

134

UPDATE `photos` SET `views` = 111 WHERE `photos`.`id` = 79

158

135

SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`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` FROM `ratings` AS `Rating` LEFT JOIN `accounts` AS `Account` ON (`Rating`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) WHERE `Rating`.`foreign_id` = 79

136

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`, `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`, `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`, `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`, `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating`, `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id`, `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `scoops` AS `Scoop` LEFT JOIN `accounts` AS `Account` ON (`Scoop`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) LEFT JOIN `trips` AS `Trip` ON (`Scoop`.`trip_id` = `Trip`.`id`) LEFT JOIN `trip_destinations` AS `TripDestination` ON (`Scoop`.`trip_destination_id` = `TripDestination`.`id`) LEFT JOIN `blogs` AS `Blog` ON (`Blog`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `photo_albums` AS `PhotoAlbum` ON (`PhotoAlbum`.`scoop_id` = `Scoop`.`id`) LEFT JOIN `videos` AS `Video` ON (`Video`.`scoop_id` = `Scoop`.`id`) WHERE `TripDestination`.`geoname_id` = 3838233 AND `Scoop`.`id` <> 125 ORDER BY `Scoop`.`created` DESC

137

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` = 80 LIMIT 1

138

139

SELECT `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 `Video`.`id` = 36 LIMIT 1

140

141

142

143

144

145

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

146

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

147

UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1337519670;s:4:\"rand\";i:293028519;s:7:\"timeout\";i:10;}Message|a:0:{}Auth|a:1:{s:7:\"Account\";N;}', `expires` = 1337519671 WHERE `id` = 'e72e664cd5eada79310a4c2acbf2c224'


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