Blogs » Tom Picking » Final day

Final day by Tom Picking

Final day

I am pleased to report that I succeeded in buying things in Marrakech without having to go through the tedious process of haggling. The tedious processs that inevitably works in favour of the blaggers as they are content to spend all day holding out to agree an inflated price.

There is a government-baked artisan centre that sells everything at a fixed price. I am sure I paid a slight premium over the minimum a desperate blagger might sell at, especially as I bought numerous items, but I certainly avoided the risk of paying the ridiculous prices that every traveller I've spoken to has had the misfortune of paying.

Now for a quick summary of my Moroccan trip. All in all I'm pleased I came here, and in particular I am pleased to have used Marrakech as a hub for visiting other towns/villages such as Essaouira and Merzouga (in the Sahara). I'm not a fan of Marrakech, but I'm pleased I came here to formulate my own opinions. There is plenty of contrast in the city, from the hectic (Jamaa Al Fna square and the bustling main roads) to the tranquil (Jardin Princess Lalla Masna and Jardin Marjorelle), the cultural spectacles (the Koutoubia) to the brazen awfulness of the Souks. There is something to intrigue and interest everyone. But equally, there is plenty to piss off everyone.

Highlights: trip to Sahara / first 30 mins exploring Jamaa Al Fna at night / Jardins of Marrakech
Low points: blaggers / beggars/ prices / cold temperature

app/webroot/index.php (line 93)
0.8857
(default) 156 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `accounts`19191
2DESCRIBE `trip_destinations`15151
3DESCRIBE `trips`12121
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`991
13DESCRIBE `trip_members`660
14DESCRIBE `trip_followers`440
15DESCRIBE `trip_invites`990
16DESCRIBE `trip_join_requests`550
17DESCRIBE `user_locations`991
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` = '9b2218f0ec7f44d6b9bede1de10b94d0'110
25SELECT `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 `Blog`.`id` = 26 LIMIT 1110
26SELECT `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` = 60 110
27SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
28SELECT `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` = 43 110
29SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
30SELECT `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` = 202 110
31SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Blog' AND `Comment`.`foreign_id` = (26) 000
32SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Blog' AND `FriendTag`.`foreign_id` = (26) 000
33SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 GROUP BY `Account`.`id` LIMIT 1110
34SELECT `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` = (43) ORDER BY `Scoop`.`created` DESC 880
35SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
36SELECT `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` = (43) ORDER BY `Scoop`.`created` DESC 880
37SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
38SELECT `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` = (43) ORDER BY `Scoop`.`created` DESC 880
39SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
40SELECT `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` = (43) ORDER BY `Scoop`.`created` DESC 880
41SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
42SELECT `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` = (43) ORDER BY `Scoop`.`created` DESC 880
43SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
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`.`account_id` = (43) ORDER BY `Scoop`.`created` DESC 880
45SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
46SELECT `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` = (43) ORDER BY `Scoop`.`created` DESC 880
47SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
48SELECT `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` = (43) ORDER BY `Scoop`.`created` DESC 880
49SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
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`.`account_id` = (43) ORDER BY `Scoop`.`created` DESC 880
51SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
52SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
53SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
54SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
55SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
56SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
57SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
58SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
59SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 60 110
60SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 59 110
61SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 58 110
62SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 57 110
63SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 56 110
64SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 55 110
65SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 54 000
66SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 53 110
67SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 60 000
68SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 59 000
69SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 58 000
70SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 57 000
71SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 56 000
72SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 55 000
73SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 54 110
74SELECT `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` = (14) 110
75SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 53 000
76SELECT `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` = 60 000
77SELECT `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` = 59 000
78SELECT `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` = 58 000
79SELECT `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` = 57 000
80SELECT `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` = 56 000
81SELECT `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` = 55 000
82SELECT `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` = 54 000
83SELECT `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` = 53 000
84 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` = 43 OR `Friend`.`friend_id` = 43) AND (`Account`.`id` <> 43) AND (`Friend`.`approved` = 1));110
85SELECT `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 `Blog`.`id` = 26 LIMIT 1110
86SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Blog' AND `Comment`.`foreign_id` = (26) 000
87SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Blog' AND `Rating`.`foreign_id` = (26) 000
88SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Blog' AND `FriendTag`.`foreign_id` = (26) 000
89SELECT COUNT(*) AS `count` FROM `blogs` AS `Blog` WHERE `Blog`.`id` = 26 110
90UPDATE `blogs` SET `views` = 1113 WHERE `blogs`.`id` = 2613
91SELECT `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` = 26 000
92SELECT `TripDestination`.`id` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`geoname_id` = 2542997 440
93SELECT `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`, `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 `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 `Scoop`.`trip_destination_id` IN (194, 202, 205, 413) 771
94SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
95SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
96SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0 110
97SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6 AND `Account`.`status` <> 0 110
98SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6 AND `Account`.`status` <> 0 110
99SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6 AND `Account`.`status` <> 0 110
100SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 6 AND `Account`.`status` <> 0 110
101SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
102SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
103SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40 110
104SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 71 110
105SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 71 110
106SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 71 110
107SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 71 110
108SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 54 000
109SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 58 110
110SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 60 110
111SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 145 000
112SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 146 110
113SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 147 000
114SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 149 110
115SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 54 110
116SELECT `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` = (14) 110
117SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 58 000
118SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 60 000
119SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 145 110
120SELECT `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` = (44) 770
121SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 146 000
122SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 147 110
123SELECT `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` = (45) 15150
124SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 149 000
125SELECT `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` = 54 000
126SELECT `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` = 58 000
127SELECT `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` = 60 000
128SELECT `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` = 145 000
129SELECT `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` = 146 000
130SELECT `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` = 147 000
131SELECT `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` = 149 000
132SELECT `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` = 14 LIMIT 1110
133SELECT `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` = (14) 110
134SELECT `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 `Blog`.`id` = 24 LIMIT 1110
135SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Blog' AND `Comment`.`foreign_id` = (24) 000
136SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Blog' AND `Rating`.`foreign_id` = (24) 000
137SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Blog' AND `FriendTag`.`foreign_id` = (24) 000
138SELECT `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 `Blog`.`id` = 26 LIMIT 1110
139SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Blog' AND `Comment`.`foreign_id` = (26) 000
140SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Blog' AND `Rating`.`foreign_id` = (26) 000
141SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Blog' AND `FriendTag`.`foreign_id` = (26) 000
142SELECT `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` = 44 LIMIT 1110
143SELECT `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` = (44) 770
144SELECT `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 `Blog`.`id` = 46 LIMIT 1110
145SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Blog' AND `Comment`.`foreign_id` = (46) 000
146SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Blog' AND `Rating`.`foreign_id` = (46) 000
147SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Blog' AND `FriendTag`.`foreign_id` = (46) 000
148SELECT `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` = 45 LIMIT 1110
149SELECT `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` = (45) 15150
150SELECT `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 `Blog`.`id` = 47 LIMIT 1110
151SELECT `Comment`.`id`, `Comment`.`class`, `Comment`.`foreign_id`, `Comment`.`account_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`class` = 'Blog' AND `Comment`.`foreign_id` = (47) 000
152SELECT `Rating`.`id`, `Rating`.`class`, `Rating`.`foreign_id`, `Rating`.`account_id`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `Rating`.`class` = 'Blog' AND `Rating`.`foreign_id` = (47) 000
153SELECT `FriendTag`.`id`, `FriendTag`.`account_id`, `FriendTag`.`email`, `FriendTag`.`name`, `FriendTag`.`foreign_id`, `FriendTag`.`class`, `FriendTag`.`created` FROM `friend_tags` AS `FriendTag` WHERE `FriendTag`.`class` = 'Blog' AND `FriendTag`.`foreign_id` = (47) 000
154SELECT 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
155SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '9b2218f0ec7f44d6b9bede1de10b94d0'110
156UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328652031;s:4:\"rand\";i:1455743912;s:7:\"timeout\";i:10;}Message|a:0:{}', `expires` = 1328652032 WHERE `id` = '9b2218f0ec7f44d6b9bede1de10b94d0'10