TravelScoops: Profile » Tom Picking

Tom Picking

in Zürich, Switzerland


	Sex male Age 32 Friends 1

Add Tom Picking as a Friend

Send Tom Picking a Message

Morocco

15th Dec 2008 - 22nd Dec 2008

Dave Henderson

Scoops from this Trip

Final day - Marrakech, Morocco

11:20 26th February 2009

Tom added the Blog "Final day" to his trip "Morocco".

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 ...

Essaouira - Essaouira, Morocco

11:17 26th February 2009

Tom added the Blog "Essaouira" to his trip "Morocco".

This morning's trip to Essaouira began with a 3 hour wait for my bus. I wasn't too put out as I'm reading Richard Dawkins' 'God Delusion' which is doing a good job of distracting me from this wretched city. More slating later in this entry.

Two and a half hours later I arrived at the seaside town of Essaouira on the West coast of Morocco. As I so often do in new towns, I put my map into my back pocket and went for a random wander; on this occasion I got m...

Back to Marrakech - Marrakech, Morocco

11:12 26th February 2009

Tom added the Blog "Back to Marrakech" to his trip "Morocco".

I had big things planned today: immersing myself into the Moroccan way by wandering around the Medina and exploring the back alleys of Marrakech. Huh huh, more back alley references...

Following a mammoth 12 hour sleep I visited the Marjorelle Gardens which is a very distinctive private garden, turned monument to Yves Saint Laurent. Much of the buildings are painted in a vibrant cobalt blue (I believe it is called Marjorelle Blue). There are numerous clay flower pots all...

Desert Trip 3 - Merzouga, Morocco

11:11 26th February 2009

Tom added the Blog "Desert Trip 3" to his trip "Morocco".

Whoever said it is hot in the desert is talking shit; it is freezing. And because we are basically outside and mostly not moving it feels almost dangerously cold. Imagine falling asleep and waking up shivering - and that is whilst wearing thermals, coat and gloves.

I'm the only person here without a partner so I had to make do with the 2 blankets. No one else to, errr, rub up against.

Today will involve driving back to Marrakech. It will take approx 10 hours.

Desert Trip 2 - Merzouga, Morocco

11:09 26th February 2009

Tom added the Blog "Desert Trip 2" to his trip "Morocco".

Early start at 7:30am. Breakfast consisted of cake (with bread, natch). We drove through desert, serene and peaceful it may be whilst being done, it doesn't make for good blogging.

Lunch was Omelette a la Berbere (vegetable omelette in a tagine). Bits of the dish were uncooked, so doubtlessly a bout of Salmonella is on its way - what was I thinking? Although I should give credit where it is due: the food has been great, and I am still on solids. If you kn...

Notice (8): Undefined index:  Photo [APP/views/elements/map/info_window_tab.ctp, line 13]

Code | Context

$___viewFn	=	"/var/www/vhosts/travelscoops.com/httpdocs/app/views/elements/map/info_window_tab.ctp"
$___dataForView	=	array(
	"g_api_key" => "ABQIAAAA-zHWPwZiFCMhvhEzuQpayhT_WsUIlvM4Tj7Sr4wB6wj7whLAwBQlhqi4LP5Yc5Kxb0W9Lqdrt437yw",
	"is_admin" => false,
	"account" => array(
	"Account" => array(),
	"TripLocation" => array(),
	"UserLocation" => array()
),
	"is_my_friend" => false,
	"has_pending_request" => false,
	"friends" => array(
	array()
),
	"wish_list" => array(),
	"latest_trip" => array(
	"Trip" => array(),
	"TripDestination" => array(),
	"Scoop" => array()
),
	"trip_picker_list" => array(
	"Morocco"
),
	"account_trips" => array(
	array()
),
	"blog_scoops" => array(
	array(),
	array(),
	array(),
	array()
),
	"photo_scoops" => array(
	array()
),
	"video_scoops" => array(),
	"is_trip_creator" => false,
	"is_my_profile" => false,
	"use_gmap" => true,
	"genders" => array(
	"",
	"female" => "female",
	"male" => "male"
),
	"privacyLevels" => array(
	"public" => "public",
	"friends only" => "friends only"
),
	"accessLevels" => array(
	"public" => "public",
	"request" => "request",
	"private" => "private"
),
	"unread_message_count" => 0,
	"intCurrentFBUID" => null,
	"photoAlbums" => array(
	array()
),
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/accounts/view/43"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/accounts/view/43"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"button" => ButtonHelper
ButtonHelper::$helpers = array
ButtonHelper::$base = ""
ButtonHelper::$webroot = "/"
ButtonHelper::$themeWeb = NULL
ButtonHelper::$here = "/accounts/view/43"
ButtonHelper::$params = array
ButtonHelper::$action = "view"
ButtonHelper::$plugin = NULL
ButtonHelper::$data = NULL
ButtonHelper::$namedArgs = NULL
ButtonHelper::$argSeparator = NULL
ButtonHelper::$validationErrors = NULL
ButtonHelper::$tags = array
ButtonHelper::$__tainted = NULL
ButtonHelper::$__cleaned = NULL
ButtonHelper::$_log = NULL
ButtonHelper::$Html = HtmlHelper object
ButtonHelper::$Javascript = JavascriptHelper object,
	"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/accounts/view/43"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"feed" => FeedHelper
FeedHelper::$helpers = array
FeedHelper::$base = ""
FeedHelper::$webroot = "/"
FeedHelper::$themeWeb = NULL
FeedHelper::$here = "/accounts/view/43"
FeedHelper::$params = array
FeedHelper::$action = "view"
FeedHelper::$plugin = NULL
FeedHelper::$data = NULL
FeedHelper::$namedArgs = NULL
FeedHelper::$argSeparator = NULL
FeedHelper::$validationErrors = NULL
FeedHelper::$tags = array
FeedHelper::$__tainted = NULL
FeedHelper::$__cleaned = NULL
FeedHelper::$_log = NULL
FeedHelper::$Html = HtmlHelper object
FeedHelper::$Text = TextHelper object,
	"text" => TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/accounts/view/43"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = NULL
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL,
	"box" => BoxHelper
BoxHelper::$helpers = array
BoxHelper::$base = ""
BoxHelper::$webroot = "/"
BoxHelper::$themeWeb = NULL
BoxHelper::$here = "/accounts/view/43"
BoxHelper::$params = array
BoxHelper::$action = "view"
BoxHelper::$plugin = NULL
BoxHelper::$data = NULL
BoxHelper::$namedArgs = NULL
BoxHelper::$argSeparator = NULL
BoxHelper::$validationErrors = NULL
BoxHelper::$tags = array
BoxHelper::$__tainted = NULL
BoxHelper::$__cleaned = NULL
BoxHelper::$_log = NULL
BoxHelper::$Html = HtmlHelper object,
	"column" => ColumnHelper
ColumnHelper::$helpers = NULL
ColumnHelper::$base = ""
ColumnHelper::$webroot = "/"
ColumnHelper::$themeWeb = NULL
ColumnHelper::$here = "/accounts/view/43"
ColumnHelper::$params = array
ColumnHelper::$action = "view"
ColumnHelper::$plugin = NULL
ColumnHelper::$data = NULL
ColumnHelper::$namedArgs = NULL
ColumnHelper::$argSeparator = NULL
ColumnHelper::$validationErrors = NULL
ColumnHelper::$tags = array
ColumnHelper::$__tainted = NULL
ColumnHelper::$__cleaned = NULL
ColumnHelper::$_log = NULL,
	"lightbox" => LightboxHelper
LightboxHelper::$helpers = array
LightboxHelper::$base = ""
LightboxHelper::$webroot = "/"
LightboxHelper::$themeWeb = NULL
LightboxHelper::$here = "/accounts/view/43"
LightboxHelper::$params = array
LightboxHelper::$action = "view"
LightboxHelper::$plugin = NULL
LightboxHelper::$data = NULL
LightboxHelper::$namedArgs = NULL
LightboxHelper::$argSeparator = NULL
LightboxHelper::$validationErrors = NULL
LightboxHelper::$tags = array
LightboxHelper::$__tainted = NULL
LightboxHelper::$__cleaned = NULL
LightboxHelper::$_log = NULL
LightboxHelper::$Html = HtmlHelper object
LightboxHelper::$Javascript = JavascriptHelper object,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = ""
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1328722590
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/accounts/view/43"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$g_api_key	=	"ABQIAAAA-zHWPwZiFCMhvhEzuQpayhT_WsUIlvM4Tj7Sr4wB6wj7whLAwBQlhqi4LP5Yc5Kxb0W9Lqdrt437yw"
$is_admin	=	false
$account	=	array(
	"Account" => array(
	"id" => "43",
	"forename" => "Tom",
	"surname" => "Picking",
	"nickname" => "",
	"email" => "tompicking@yahoo.co.uk",
	"password" => "5516527fdc76cd75f6cede3d36e4b0b731b38c4e",
	"dob" => "1980-01-01",
	"gender" => "male",
	"privacy_level" => "public",
	"nationality" => "",
	"photo_filename" => "default.jpg",
	"fb_uid" => null,
	"use_fb" => "0",
	"email_hash" => "145c9f68cf191bd99c857c5a48d63b3e2944634466",
	"permission_group_id" => "2",
	"status" => "1",
	"disabled" => "0",
	"created" => "2009-02-24 13:18:56",
	"modified" => "2009-04-03 11:10:08",
	"fullname" => "Tom Picking"
),
	"TripLocation" => array(
	"id" => null,
	"trip_id" => null,
	"start_date" => null,
	"end_date" => null,
	"name" => null,
	"country" => null,
	"country_code" => "",
	"geoname_id" => null,
	"longitude" => null,
	"latitude" => null
),
	"UserLocation" => array(
	"id" => "24",
	"account_id" => "43",
	"name" => "Zürich",
	"country" => "Switzerland",
	"country_code" => "ch",
	"geoname_id" => "2657896",
	"longitude" => "8.5500000",
	"latitude" => "47.3666667",
	"created" => "2009-02-24 13:18:56"
)
)
$is_my_friend	=	false
$has_pending_request	=	false
$friends	=	array(
	array(
	"Account" => array(),
	"TripLocation" => array(),
	"UserLocation" => array(),
	"FriendInvite" => array(),
	"Scoop" => array(),
	"WishList" => array(),
	"Trip" => array(),
	"TripMember" => array(),
	"FriendGroup" => array(),
	"FriendGroupLink" => array(),
	"Friend" => array()
)
)
$wish_list	=	array()
$latest_trip	=	array(
	"Trip" => array(
	"id" => "40",
	"title" => "Morocco",
	"description" => "My trip to Morocco in Dec 2008",
	"start_date" => "2008-12-15",
	"end_date" => "2008-12-22",
	"access_level" => "private",
	"privacy_level" => "public",
	"photo_filename" => "1235782420.jpg",
	"account_id" => "43",
	"email" => null,
	"created" => "2009-02-26 10:35:14",
	"modified" => "2009-02-26 10:37:43"
),
	"TripDestination" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"Scoop" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
)
)
$trip_picker_list	=	array(
	"Morocco"
)
$account_trips	=	array(
	array(
	"Trip" => array(),
	"Account" => array(),
	"FeaturedTrip" => array(),
	"TripDestination" => array(),
	"Scoop" => array(),
	"TripMember" => array(),
	"TripFollower" => array(),
	"TripInvite" => array(),
	"TripJoinRequest" => array(),
	"TripMembers" => array(),
	"TripFollowers" => array()
)
)
$blog_scoops	=	array(
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
)
)
$photo_scoops	=	array(
	array(
	"Photo" => array(),
	"Scoop" => array()
)
)
$video_scoops	=	array()
$is_trip_creator	=	false
$is_my_profile	=	false
$use_gmap	=	true
$genders	=	array(
	"",
	"female" => "female",
	"male" => "male"
)
$privacyLevels	=	array(
	"public" => "public",
	"friends only" => "friends only"
)
$accessLevels	=	array(
	"public" => "public",
	"request" => "request",
	"private" => "private"
)
$unread_message_count	=	0
$intCurrentFBUID	=	null
$photoAlbums	=	array(
	array(
	"id" => "54",
	"account_id" => "43",
	"trip_id" => "40",
	"trip_destination_id" => "202",
	"foreign_id" => "14",
	"class" => "PhotoAlbum",
	"pub_date" => null,
	"created" => "2009-02-26 10:56:58",
	"modified" => "2009-02-26 10:56:58",
	"Account" => array(),
	"Trip" => array(),
	"TripDestination" => array(),
	"Blog" => array(),
	"PhotoAlbum" => array(),
	"Video" => array()
)
)
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/accounts/view/43"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/accounts/view/43"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$button	=	ButtonHelper
ButtonHelper::$helpers = array
ButtonHelper::$base = ""
ButtonHelper::$webroot = "/"
ButtonHelper::$themeWeb = NULL
ButtonHelper::$here = "/accounts/view/43"
ButtonHelper::$params = array
ButtonHelper::$action = "view"
ButtonHelper::$plugin = NULL
ButtonHelper::$data = NULL
ButtonHelper::$namedArgs = NULL
ButtonHelper::$argSeparator = NULL
ButtonHelper::$validationErrors = NULL
ButtonHelper::$tags = array
ButtonHelper::$__tainted = NULL
ButtonHelper::$__cleaned = NULL
ButtonHelper::$_log = NULL
ButtonHelper::$Html = HtmlHelper object
ButtonHelper::$Javascript = JavascriptHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/accounts/view/43"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$feed	=	FeedHelper
FeedHelper::$helpers = array
FeedHelper::$base = ""
FeedHelper::$webroot = "/"
FeedHelper::$themeWeb = NULL
FeedHelper::$here = "/accounts/view/43"
FeedHelper::$params = array
FeedHelper::$action = "view"
FeedHelper::$plugin = NULL
FeedHelper::$data = NULL
FeedHelper::$namedArgs = NULL
FeedHelper::$argSeparator = NULL
FeedHelper::$validationErrors = NULL
FeedHelper::$tags = array
FeedHelper::$__tainted = NULL
FeedHelper::$__cleaned = NULL
FeedHelper::$_log = NULL
FeedHelper::$Html = HtmlHelper object
FeedHelper::$Text = TextHelper object
$text	=	TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/accounts/view/43"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = NULL
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL
$box	=	BoxHelper
BoxHelper::$helpers = array
BoxHelper::$base = ""
BoxHelper::$webroot = "/"
BoxHelper::$themeWeb = NULL
BoxHelper::$here = "/accounts/view/43"
BoxHelper::$params = array
BoxHelper::$action = "view"
BoxHelper::$plugin = NULL
BoxHelper::$data = NULL
BoxHelper::$namedArgs = NULL
BoxHelper::$argSeparator = NULL
BoxHelper::$validationErrors = NULL
BoxHelper::$tags = array
BoxHelper::$__tainted = NULL
BoxHelper::$__cleaned = NULL
BoxHelper::$_log = NULL
BoxHelper::$Html = HtmlHelper object
$column	=	ColumnHelper
ColumnHelper::$helpers = NULL
ColumnHelper::$base = ""
ColumnHelper::$webroot = "/"
ColumnHelper::$themeWeb = NULL
ColumnHelper::$here = "/accounts/view/43"
ColumnHelper::$params = array
ColumnHelper::$action = "view"
ColumnHelper::$plugin = NULL
ColumnHelper::$data = NULL
ColumnHelper::$namedArgs = NULL
ColumnHelper::$argSeparator = NULL
ColumnHelper::$validationErrors = NULL
ColumnHelper::$tags = array
ColumnHelper::$__tainted = NULL
ColumnHelper::$__cleaned = NULL
ColumnHelper::$_log = NULL
$lightbox	=	LightboxHelper
LightboxHelper::$helpers = array
LightboxHelper::$base = ""
LightboxHelper::$webroot = "/"
LightboxHelper::$themeWeb = NULL
LightboxHelper::$here = "/accounts/view/43"
LightboxHelper::$params = array
LightboxHelper::$action = "view"
LightboxHelper::$plugin = NULL
LightboxHelper::$data = NULL
LightboxHelper::$namedArgs = NULL
LightboxHelper::$argSeparator = NULL
LightboxHelper::$validationErrors = NULL
LightboxHelper::$tags = array
LightboxHelper::$__tainted = NULL
LightboxHelper::$__cleaned = NULL
LightboxHelper::$_log = NULL
LightboxHelper::$Html = HtmlHelper object
LightboxHelper::$Javascript = JavascriptHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = ""
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1328722590
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/accounts/view/43"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$style_outer	=	"width: 350px"
$style_other_header	=	"font-family: 'Myriad Pro', Arial; font-size: 14px; color: #494949; margin-top: 5px; margin-bottom: 2px;"
$style_main_photo	=	"text-align: center;"
$style_photo	=	"float: left; padding: 3px;"

        <div class="scoop_bubble photo_scoop">

            <div class="main_photo" style="<?=$style_main_photo;?>">

                <?= $html->image('scoop_photos/150x150_r/'.$photoAlbums[0]['PhotoAlbum']['Photo'][0]['filename'], array(

include - APP/views/elements/map/info_window_tab.ctp, line 13
View::_render() - CORE/cake/libs/view/view.php, line 654
View::element() - CORE/cake/libs/view/view.php, line 339
include - APP/views/elements/map/content.ctp, line 49
View::_render() - CORE/cake/libs/view/view.php, line 654
View::element() - CORE/cake/libs/view/view.php, line 339
include - APP/views/accounts/view.ctp, line 226
View::_render() - CORE/cake/libs/view/view.php, line 654
View::render() - CORE/cake/libs/view/view.php, line 372
Controller::render() - CORE/cake/libs/controller/controller.php, line 744
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 262
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90

Notice (8): Undefined index:  Photo [APP/views/elements/map/info_window_tab.ctp, line 17]

Code | Context

$___viewFn	=	"/var/www/vhosts/travelscoops.com/httpdocs/app/views/elements/map/info_window_tab.ctp"
$___dataForView	=	array(
	"g_api_key" => "ABQIAAAA-zHWPwZiFCMhvhEzuQpayhT_WsUIlvM4Tj7Sr4wB6wj7whLAwBQlhqi4LP5Yc5Kxb0W9Lqdrt437yw",
	"is_admin" => false,
	"account" => array(
	"Account" => array(),
	"TripLocation" => array(),
	"UserLocation" => array()
),
	"is_my_friend" => false,
	"has_pending_request" => false,
	"friends" => array(
	array()
),
	"wish_list" => array(),
	"latest_trip" => array(
	"Trip" => array(),
	"TripDestination" => array(),
	"Scoop" => array()
),
	"trip_picker_list" => array(
	"Morocco"
),
	"account_trips" => array(
	array()
),
	"blog_scoops" => array(
	array(),
	array(),
	array(),
	array()
),
	"photo_scoops" => array(
	array()
),
	"video_scoops" => array(),
	"is_trip_creator" => false,
	"is_my_profile" => false,
	"use_gmap" => true,
	"genders" => array(
	"",
	"female" => "female",
	"male" => "male"
),
	"privacyLevels" => array(
	"public" => "public",
	"friends only" => "friends only"
),
	"accessLevels" => array(
	"public" => "public",
	"request" => "request",
	"private" => "private"
),
	"unread_message_count" => 0,
	"intCurrentFBUID" => null,
	"photoAlbums" => array(
	array()
),
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/accounts/view/43"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/accounts/view/43"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"button" => ButtonHelper
ButtonHelper::$helpers = array
ButtonHelper::$base = ""
ButtonHelper::$webroot = "/"
ButtonHelper::$themeWeb = NULL
ButtonHelper::$here = "/accounts/view/43"
ButtonHelper::$params = array
ButtonHelper::$action = "view"
ButtonHelper::$plugin = NULL
ButtonHelper::$data = NULL
ButtonHelper::$namedArgs = NULL
ButtonHelper::$argSeparator = NULL
ButtonHelper::$validationErrors = NULL
ButtonHelper::$tags = array
ButtonHelper::$__tainted = NULL
ButtonHelper::$__cleaned = NULL
ButtonHelper::$_log = NULL
ButtonHelper::$Html = HtmlHelper object
ButtonHelper::$Javascript = JavascriptHelper object,
	"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/accounts/view/43"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"feed" => FeedHelper
FeedHelper::$helpers = array
FeedHelper::$base = ""
FeedHelper::$webroot = "/"
FeedHelper::$themeWeb = NULL
FeedHelper::$here = "/accounts/view/43"
FeedHelper::$params = array
FeedHelper::$action = "view"
FeedHelper::$plugin = NULL
FeedHelper::$data = NULL
FeedHelper::$namedArgs = NULL
FeedHelper::$argSeparator = NULL
FeedHelper::$validationErrors = NULL
FeedHelper::$tags = array
FeedHelper::$__tainted = NULL
FeedHelper::$__cleaned = NULL
FeedHelper::$_log = NULL
FeedHelper::$Html = HtmlHelper object
FeedHelper::$Text = TextHelper object,
	"text" => TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/accounts/view/43"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = NULL
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL,
	"box" => BoxHelper
BoxHelper::$helpers = array
BoxHelper::$base = ""
BoxHelper::$webroot = "/"
BoxHelper::$themeWeb = NULL
BoxHelper::$here = "/accounts/view/43"
BoxHelper::$params = array
BoxHelper::$action = "view"
BoxHelper::$plugin = NULL
BoxHelper::$data = NULL
BoxHelper::$namedArgs = NULL
BoxHelper::$argSeparator = NULL
BoxHelper::$validationErrors = NULL
BoxHelper::$tags = array
BoxHelper::$__tainted = NULL
BoxHelper::$__cleaned = NULL
BoxHelper::$_log = NULL
BoxHelper::$Html = HtmlHelper object,
	"column" => ColumnHelper
ColumnHelper::$helpers = NULL
ColumnHelper::$base = ""
ColumnHelper::$webroot = "/"
ColumnHelper::$themeWeb = NULL
ColumnHelper::$here = "/accounts/view/43"
ColumnHelper::$params = array
ColumnHelper::$action = "view"
ColumnHelper::$plugin = NULL
ColumnHelper::$data = NULL
ColumnHelper::$namedArgs = NULL
ColumnHelper::$argSeparator = NULL
ColumnHelper::$validationErrors = NULL
ColumnHelper::$tags = array
ColumnHelper::$__tainted = NULL
ColumnHelper::$__cleaned = NULL
ColumnHelper::$_log = NULL,
	"lightbox" => LightboxHelper
LightboxHelper::$helpers = array
LightboxHelper::$base = ""
LightboxHelper::$webroot = "/"
LightboxHelper::$themeWeb = NULL
LightboxHelper::$here = "/accounts/view/43"
LightboxHelper::$params = array
LightboxHelper::$action = "view"
LightboxHelper::$plugin = NULL
LightboxHelper::$data = NULL
LightboxHelper::$namedArgs = NULL
LightboxHelper::$argSeparator = NULL
LightboxHelper::$validationErrors = NULL
LightboxHelper::$tags = array
LightboxHelper::$__tainted = NULL
LightboxHelper::$__cleaned = NULL
LightboxHelper::$_log = NULL
LightboxHelper::$Html = HtmlHelper object
LightboxHelper::$Javascript = JavascriptHelper object,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = ""
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1328722590
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/accounts/view/43"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$g_api_key	=	"ABQIAAAA-zHWPwZiFCMhvhEzuQpayhT_WsUIlvM4Tj7Sr4wB6wj7whLAwBQlhqi4LP5Yc5Kxb0W9Lqdrt437yw"
$is_admin	=	false
$account	=	array(
	"Account" => array(
	"id" => "43",
	"forename" => "Tom",
	"surname" => "Picking",
	"nickname" => "",
	"email" => "tompicking@yahoo.co.uk",
	"password" => "5516527fdc76cd75f6cede3d36e4b0b731b38c4e",
	"dob" => "1980-01-01",
	"gender" => "male",
	"privacy_level" => "public",
	"nationality" => "",
	"photo_filename" => "default.jpg",
	"fb_uid" => null,
	"use_fb" => "0",
	"email_hash" => "145c9f68cf191bd99c857c5a48d63b3e2944634466",
	"permission_group_id" => "2",
	"status" => "1",
	"disabled" => "0",
	"created" => "2009-02-24 13:18:56",
	"modified" => "2009-04-03 11:10:08",
	"fullname" => "Tom Picking"
),
	"TripLocation" => array(
	"id" => null,
	"trip_id" => null,
	"start_date" => null,
	"end_date" => null,
	"name" => null,
	"country" => null,
	"country_code" => "",
	"geoname_id" => null,
	"longitude" => null,
	"latitude" => null
),
	"UserLocation" => array(
	"id" => "24",
	"account_id" => "43",
	"name" => "Zürich",
	"country" => "Switzerland",
	"country_code" => "ch",
	"geoname_id" => "2657896",
	"longitude" => "8.5500000",
	"latitude" => "47.3666667",
	"created" => "2009-02-24 13:18:56"
)
)
$is_my_friend	=	false
$has_pending_request	=	false
$friends	=	array(
	array(
	"Account" => array(),
	"TripLocation" => array(),
	"UserLocation" => array(),
	"FriendInvite" => array(),
	"Scoop" => array(),
	"WishList" => array(),
	"Trip" => array(),
	"TripMember" => array(),
	"FriendGroup" => array(),
	"FriendGroupLink" => array(),
	"Friend" => array()
)
)
$wish_list	=	array()
$latest_trip	=	array(
	"Trip" => array(
	"id" => "40",
	"title" => "Morocco",
	"description" => "My trip to Morocco in Dec 2008",
	"start_date" => "2008-12-15",
	"end_date" => "2008-12-22",
	"access_level" => "private",
	"privacy_level" => "public",
	"photo_filename" => "1235782420.jpg",
	"account_id" => "43",
	"email" => null,
	"created" => "2009-02-26 10:35:14",
	"modified" => "2009-02-26 10:37:43"
),
	"TripDestination" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"Scoop" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
)
)
$trip_picker_list	=	array(
	"Morocco"
)
$account_trips	=	array(
	array(
	"Trip" => array(),
	"Account" => array(),
	"FeaturedTrip" => array(),
	"TripDestination" => array(),
	"Scoop" => array(),
	"TripMember" => array(),
	"TripFollower" => array(),
	"TripInvite" => array(),
	"TripJoinRequest" => array(),
	"TripMembers" => array(),
	"TripFollowers" => array()
)
)
$blog_scoops	=	array(
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
)
)
$photo_scoops	=	array(
	array(
	"Photo" => array(),
	"Scoop" => array()
)
)
$video_scoops	=	array()
$is_trip_creator	=	false
$is_my_profile	=	false
$use_gmap	=	true
$genders	=	array(
	"",
	"female" => "female",
	"male" => "male"
)
$privacyLevels	=	array(
	"public" => "public",
	"friends only" => "friends only"
)
$accessLevels	=	array(
	"public" => "public",
	"request" => "request",
	"private" => "private"
)
$unread_message_count	=	0
$intCurrentFBUID	=	null
$photoAlbums	=	array(
	array(
	"id" => "54",
	"account_id" => "43",
	"trip_id" => "40",
	"trip_destination_id" => "202",
	"foreign_id" => "14",
	"class" => "PhotoAlbum",
	"pub_date" => null,
	"created" => "2009-02-26 10:56:58",
	"modified" => "2009-02-26 10:56:58",
	"Account" => array(),
	"Trip" => array(),
	"TripDestination" => array(),
	"Blog" => array(),
	"PhotoAlbum" => array(),
	"Video" => array()
)
)
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/accounts/view/43"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/accounts/view/43"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$button	=	ButtonHelper
ButtonHelper::$helpers = array
ButtonHelper::$base = ""
ButtonHelper::$webroot = "/"
ButtonHelper::$themeWeb = NULL
ButtonHelper::$here = "/accounts/view/43"
ButtonHelper::$params = array
ButtonHelper::$action = "view"
ButtonHelper::$plugin = NULL
ButtonHelper::$data = NULL
ButtonHelper::$namedArgs = NULL
ButtonHelper::$argSeparator = NULL
ButtonHelper::$validationErrors = NULL
ButtonHelper::$tags = array
ButtonHelper::$__tainted = NULL
ButtonHelper::$__cleaned = NULL
ButtonHelper::$_log = NULL
ButtonHelper::$Html = HtmlHelper object
ButtonHelper::$Javascript = JavascriptHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/accounts/view/43"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$feed	=	FeedHelper
FeedHelper::$helpers = array
FeedHelper::$base = ""
FeedHelper::$webroot = "/"
FeedHelper::$themeWeb = NULL
FeedHelper::$here = "/accounts/view/43"
FeedHelper::$params = array
FeedHelper::$action = "view"
FeedHelper::$plugin = NULL
FeedHelper::$data = NULL
FeedHelper::$namedArgs = NULL
FeedHelper::$argSeparator = NULL
FeedHelper::$validationErrors = NULL
FeedHelper::$tags = array
FeedHelper::$__tainted = NULL
FeedHelper::$__cleaned = NULL
FeedHelper::$_log = NULL
FeedHelper::$Html = HtmlHelper object
FeedHelper::$Text = TextHelper object
$text	=	TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/accounts/view/43"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = NULL
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL
$box	=	BoxHelper
BoxHelper::$helpers = array
BoxHelper::$base = ""
BoxHelper::$webroot = "/"
BoxHelper::$themeWeb = NULL
BoxHelper::$here = "/accounts/view/43"
BoxHelper::$params = array
BoxHelper::$action = "view"
BoxHelper::$plugin = NULL
BoxHelper::$data = NULL
BoxHelper::$namedArgs = NULL
BoxHelper::$argSeparator = NULL
BoxHelper::$validationErrors = NULL
BoxHelper::$tags = array
BoxHelper::$__tainted = NULL
BoxHelper::$__cleaned = NULL
BoxHelper::$_log = NULL
BoxHelper::$Html = HtmlHelper object
$column	=	ColumnHelper
ColumnHelper::$helpers = NULL
ColumnHelper::$base = ""
ColumnHelper::$webroot = "/"
ColumnHelper::$themeWeb = NULL
ColumnHelper::$here = "/accounts/view/43"
ColumnHelper::$params = array
ColumnHelper::$action = "view"
ColumnHelper::$plugin = NULL
ColumnHelper::$data = NULL
ColumnHelper::$namedArgs = NULL
ColumnHelper::$argSeparator = NULL
ColumnHelper::$validationErrors = NULL
ColumnHelper::$tags = array
ColumnHelper::$__tainted = NULL
ColumnHelper::$__cleaned = NULL
ColumnHelper::$_log = NULL
$lightbox	=	LightboxHelper
LightboxHelper::$helpers = array
LightboxHelper::$base = ""
LightboxHelper::$webroot = "/"
LightboxHelper::$themeWeb = NULL
LightboxHelper::$here = "/accounts/view/43"
LightboxHelper::$params = array
LightboxHelper::$action = "view"
LightboxHelper::$plugin = NULL
LightboxHelper::$data = NULL
LightboxHelper::$namedArgs = NULL
LightboxHelper::$argSeparator = NULL
LightboxHelper::$validationErrors = NULL
LightboxHelper::$tags = array
LightboxHelper::$__tainted = NULL
LightboxHelper::$__cleaned = NULL
LightboxHelper::$_log = NULL
LightboxHelper::$Html = HtmlHelper object
LightboxHelper::$Javascript = JavascriptHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = ""
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1328722590
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/accounts/view/43"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$style_outer	=	"width: 350px"
$style_other_header	=	"font-family: 'Myriad Pro', Arial; font-size: 14px; color: #494949; margin-top: 5px; margin-bottom: 2px;"
$style_main_photo	=	"text-align: center;"
$style_photo	=	"float: left; padding: 3px;"

                        'controller' => 'photos',

                        'action' => 'view',

                        $photoAlbums[0]['PhotoAlbum']['Photo'][0]['id']

include - APP/views/elements/map/info_window_tab.ctp, line 17
View::_render() - CORE/cake/libs/view/view.php, line 654
View::element() - CORE/cake/libs/view/view.php, line 339
include - APP/views/elements/map/content.ctp, line 49
View::_render() - CORE/cake/libs/view/view.php, line 654
View::element() - CORE/cake/libs/view/view.php, line 339
include - APP/views/accounts/view.ctp, line 226
View::_render() - CORE/cake/libs/view/view.php, line 654
View::render() - CORE/cake/libs/view/view.php, line 372
Controller::render() - CORE/cake/libs/controller/controller.php, line 744
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 262
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90

Notice (8): Undefined index:  Photo [APP/views/elements/map/info_window_tab.ctp, line 38]

Code | Context

$___viewFn	=	"/var/www/vhosts/travelscoops.com/httpdocs/app/views/elements/map/info_window_tab.ctp"
$___dataForView	=	array(
	"g_api_key" => "ABQIAAAA-zHWPwZiFCMhvhEzuQpayhT_WsUIlvM4Tj7Sr4wB6wj7whLAwBQlhqi4LP5Yc5Kxb0W9Lqdrt437yw",
	"is_admin" => false,
	"account" => array(
	"Account" => array(),
	"TripLocation" => array(),
	"UserLocation" => array()
),
	"is_my_friend" => false,
	"has_pending_request" => false,
	"friends" => array(
	array()
),
	"wish_list" => array(),
	"latest_trip" => array(
	"Trip" => array(),
	"TripDestination" => array(),
	"Scoop" => array()
),
	"trip_picker_list" => array(
	"Morocco"
),
	"account_trips" => array(
	array()
),
	"blog_scoops" => array(
	array(),
	array(),
	array(),
	array()
),
	"photo_scoops" => array(
	array()
),
	"video_scoops" => array(),
	"is_trip_creator" => false,
	"is_my_profile" => false,
	"use_gmap" => true,
	"genders" => array(
	"",
	"female" => "female",
	"male" => "male"
),
	"privacyLevels" => array(
	"public" => "public",
	"friends only" => "friends only"
),
	"accessLevels" => array(
	"public" => "public",
	"request" => "request",
	"private" => "private"
),
	"unread_message_count" => 0,
	"intCurrentFBUID" => null,
	"photoAlbums" => array(
	array()
),
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/accounts/view/43"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/accounts/view/43"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"button" => ButtonHelper
ButtonHelper::$helpers = array
ButtonHelper::$base = ""
ButtonHelper::$webroot = "/"
ButtonHelper::$themeWeb = NULL
ButtonHelper::$here = "/accounts/view/43"
ButtonHelper::$params = array
ButtonHelper::$action = "view"
ButtonHelper::$plugin = NULL
ButtonHelper::$data = NULL
ButtonHelper::$namedArgs = NULL
ButtonHelper::$argSeparator = NULL
ButtonHelper::$validationErrors = NULL
ButtonHelper::$tags = array
ButtonHelper::$__tainted = NULL
ButtonHelper::$__cleaned = NULL
ButtonHelper::$_log = NULL
ButtonHelper::$Html = HtmlHelper object
ButtonHelper::$Javascript = JavascriptHelper object,
	"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/accounts/view/43"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"feed" => FeedHelper
FeedHelper::$helpers = array
FeedHelper::$base = ""
FeedHelper::$webroot = "/"
FeedHelper::$themeWeb = NULL
FeedHelper::$here = "/accounts/view/43"
FeedHelper::$params = array
FeedHelper::$action = "view"
FeedHelper::$plugin = NULL
FeedHelper::$data = NULL
FeedHelper::$namedArgs = NULL
FeedHelper::$argSeparator = NULL
FeedHelper::$validationErrors = NULL
FeedHelper::$tags = array
FeedHelper::$__tainted = NULL
FeedHelper::$__cleaned = NULL
FeedHelper::$_log = NULL
FeedHelper::$Html = HtmlHelper object
FeedHelper::$Text = TextHelper object,
	"text" => TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/accounts/view/43"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = NULL
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL,
	"box" => BoxHelper
BoxHelper::$helpers = array
BoxHelper::$base = ""
BoxHelper::$webroot = "/"
BoxHelper::$themeWeb = NULL
BoxHelper::$here = "/accounts/view/43"
BoxHelper::$params = array
BoxHelper::$action = "view"
BoxHelper::$plugin = NULL
BoxHelper::$data = NULL
BoxHelper::$namedArgs = NULL
BoxHelper::$argSeparator = NULL
BoxHelper::$validationErrors = NULL
BoxHelper::$tags = array
BoxHelper::$__tainted = NULL
BoxHelper::$__cleaned = NULL
BoxHelper::$_log = NULL
BoxHelper::$Html = HtmlHelper object,
	"column" => ColumnHelper
ColumnHelper::$helpers = NULL
ColumnHelper::$base = ""
ColumnHelper::$webroot = "/"
ColumnHelper::$themeWeb = NULL
ColumnHelper::$here = "/accounts/view/43"
ColumnHelper::$params = array
ColumnHelper::$action = "view"
ColumnHelper::$plugin = NULL
ColumnHelper::$data = NULL
ColumnHelper::$namedArgs = NULL
ColumnHelper::$argSeparator = NULL
ColumnHelper::$validationErrors = NULL
ColumnHelper::$tags = array
ColumnHelper::$__tainted = NULL
ColumnHelper::$__cleaned = NULL
ColumnHelper::$_log = NULL,
	"lightbox" => LightboxHelper
LightboxHelper::$helpers = array
LightboxHelper::$base = ""
LightboxHelper::$webroot = "/"
LightboxHelper::$themeWeb = NULL
LightboxHelper::$here = "/accounts/view/43"
LightboxHelper::$params = array
LightboxHelper::$action = "view"
LightboxHelper::$plugin = NULL
LightboxHelper::$data = NULL
LightboxHelper::$namedArgs = NULL
LightboxHelper::$argSeparator = NULL
LightboxHelper::$validationErrors = NULL
LightboxHelper::$tags = array
LightboxHelper::$__tainted = NULL
LightboxHelper::$__cleaned = NULL
LightboxHelper::$_log = NULL
LightboxHelper::$Html = HtmlHelper object
LightboxHelper::$Javascript = JavascriptHelper object,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = ""
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1328722590
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/accounts/view/43"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$g_api_key	=	"ABQIAAAA-zHWPwZiFCMhvhEzuQpayhT_WsUIlvM4Tj7Sr4wB6wj7whLAwBQlhqi4LP5Yc5Kxb0W9Lqdrt437yw"
$is_admin	=	false
$account	=	array(
	"Account" => array(
	"id" => "43",
	"forename" => "Tom",
	"surname" => "Picking",
	"nickname" => "",
	"email" => "tompicking@yahoo.co.uk",
	"password" => "5516527fdc76cd75f6cede3d36e4b0b731b38c4e",
	"dob" => "1980-01-01",
	"gender" => "male",
	"privacy_level" => "public",
	"nationality" => "",
	"photo_filename" => "default.jpg",
	"fb_uid" => null,
	"use_fb" => "0",
	"email_hash" => "145c9f68cf191bd99c857c5a48d63b3e2944634466",
	"permission_group_id" => "2",
	"status" => "1",
	"disabled" => "0",
	"created" => "2009-02-24 13:18:56",
	"modified" => "2009-04-03 11:10:08",
	"fullname" => "Tom Picking"
),
	"TripLocation" => array(
	"id" => null,
	"trip_id" => null,
	"start_date" => null,
	"end_date" => null,
	"name" => null,
	"country" => null,
	"country_code" => "",
	"geoname_id" => null,
	"longitude" => null,
	"latitude" => null
),
	"UserLocation" => array(
	"id" => "24",
	"account_id" => "43",
	"name" => "Zürich",
	"country" => "Switzerland",
	"country_code" => "ch",
	"geoname_id" => "2657896",
	"longitude" => "8.5500000",
	"latitude" => "47.3666667",
	"created" => "2009-02-24 13:18:56"
)
)
$is_my_friend	=	false
$has_pending_request	=	false
$friends	=	array(
	array(
	"Account" => array(),
	"TripLocation" => array(),
	"UserLocation" => array(),
	"FriendInvite" => array(),
	"Scoop" => array(),
	"WishList" => array(),
	"Trip" => array(),
	"TripMember" => array(),
	"FriendGroup" => array(),
	"FriendGroupLink" => array(),
	"Friend" => array()
)
)
$wish_list	=	array()
$latest_trip	=	array(
	"Trip" => array(
	"id" => "40",
	"title" => "Morocco",
	"description" => "My trip to Morocco in Dec 2008",
	"start_date" => "2008-12-15",
	"end_date" => "2008-12-22",
	"access_level" => "private",
	"privacy_level" => "public",
	"photo_filename" => "1235782420.jpg",
	"account_id" => "43",
	"email" => null,
	"created" => "2009-02-26 10:35:14",
	"modified" => "2009-02-26 10:37:43"
),
	"TripDestination" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"Scoop" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
)
)
$trip_picker_list	=	array(
	"Morocco"
)
$account_trips	=	array(
	array(
	"Trip" => array(),
	"Account" => array(),
	"FeaturedTrip" => array(),
	"TripDestination" => array(),
	"Scoop" => array(),
	"TripMember" => array(),
	"TripFollower" => array(),
	"TripInvite" => array(),
	"TripJoinRequest" => array(),
	"TripMembers" => array(),
	"TripFollowers" => array()
)
)
$blog_scoops	=	array(
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
),
	array(
	"Blog" => array(),
	"Scoop" => array()
)
)
$photo_scoops	=	array(
	array(
	"Photo" => array(),
	"Scoop" => array()
)
)
$video_scoops	=	array()
$is_trip_creator	=	false
$is_my_profile	=	false
$use_gmap	=	true
$genders	=	array(
	"",
	"female" => "female",
	"male" => "male"
)
$privacyLevels	=	array(
	"public" => "public",
	"friends only" => "friends only"
)
$accessLevels	=	array(
	"public" => "public",
	"request" => "request",
	"private" => "private"
)
$unread_message_count	=	0
$intCurrentFBUID	=	null
$photoAlbums	=	array(
	array(
	"id" => "54",
	"account_id" => "43",
	"trip_id" => "40",
	"trip_destination_id" => "202",
	"foreign_id" => "14",
	"class" => "PhotoAlbum",
	"pub_date" => null,
	"created" => "2009-02-26 10:56:58",
	"modified" => "2009-02-26 10:56:58",
	"Account" => array(),
	"Trip" => array(),
	"TripDestination" => array(),
	"Blog" => array(),
	"PhotoAlbum" => array(),
	"Video" => array()
)
)
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/accounts/view/43"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/accounts/view/43"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$button	=	ButtonHelper
ButtonHelper::$helpers = array
ButtonHelper::$base = ""
ButtonHelper::$webroot = "/"
ButtonHelper::$themeWeb = NULL
ButtonHelper::$here = "/accounts/view/43"
ButtonHelper::$params = array
ButtonHelper::$action = "view"
ButtonHelper::$plugin = NULL
ButtonHelper::$data = NULL
ButtonHelper::$namedArgs = NULL
ButtonHelper::$argSeparator = NULL
ButtonHelper::$validationErrors = NULL
ButtonHelper::$tags = array
ButtonHelper::$__tainted = NULL
ButtonHelper::$__cleaned = NULL
ButtonHelper::$_log = NULL
ButtonHelper::$Html = HtmlHelper object
ButtonHelper::$Javascript = JavascriptHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/accounts/view/43"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$feed	=	FeedHelper
FeedHelper::$helpers = array
FeedHelper::$base = ""
FeedHelper::$webroot = "/"
FeedHelper::$themeWeb = NULL
FeedHelper::$here = "/accounts/view/43"
FeedHelper::$params = array
FeedHelper::$action = "view"
FeedHelper::$plugin = NULL
FeedHelper::$data = NULL
FeedHelper::$namedArgs = NULL
FeedHelper::$argSeparator = NULL
FeedHelper::$validationErrors = NULL
FeedHelper::$tags = array
FeedHelper::$__tainted = NULL
FeedHelper::$__cleaned = NULL
FeedHelper::$_log = NULL
FeedHelper::$Html = HtmlHelper object
FeedHelper::$Text = TextHelper object
$text	=	TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/accounts/view/43"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = NULL
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL
$box	=	BoxHelper
BoxHelper::$helpers = array
BoxHelper::$base = ""
BoxHelper::$webroot = "/"
BoxHelper::$themeWeb = NULL
BoxHelper::$here = "/accounts/view/43"
BoxHelper::$params = array
BoxHelper::$action = "view"
BoxHelper::$plugin = NULL
BoxHelper::$data = NULL
BoxHelper::$namedArgs = NULL
BoxHelper::$argSeparator = NULL
BoxHelper::$validationErrors = NULL
BoxHelper::$tags = array
BoxHelper::$__tainted = NULL
BoxHelper::$__cleaned = NULL
BoxHelper::$_log = NULL
BoxHelper::$Html = HtmlHelper object
$column	=	ColumnHelper
ColumnHelper::$helpers = NULL
ColumnHelper::$base = ""
ColumnHelper::$webroot = "/"
ColumnHelper::$themeWeb = NULL
ColumnHelper::$here = "/accounts/view/43"
ColumnHelper::$params = array
ColumnHelper::$action = "view"
ColumnHelper::$plugin = NULL
ColumnHelper::$data = NULL
ColumnHelper::$namedArgs = NULL
ColumnHelper::$argSeparator = NULL
ColumnHelper::$validationErrors = NULL
ColumnHelper::$tags = array
ColumnHelper::$__tainted = NULL
ColumnHelper::$__cleaned = NULL
ColumnHelper::$_log = NULL
$lightbox	=	LightboxHelper
LightboxHelper::$helpers = array
LightboxHelper::$base = ""
LightboxHelper::$webroot = "/"
LightboxHelper::$themeWeb = NULL
LightboxHelper::$here = "/accounts/view/43"
LightboxHelper::$params = array
LightboxHelper::$action = "view"
LightboxHelper::$plugin = NULL
LightboxHelper::$data = NULL
LightboxHelper::$namedArgs = NULL
LightboxHelper::$argSeparator = NULL
LightboxHelper::$validationErrors = NULL
LightboxHelper::$tags = array
LightboxHelper::$__tainted = NULL
LightboxHelper::$__cleaned = NULL
LightboxHelper::$_log = NULL
LightboxHelper::$Html = HtmlHelper object
LightboxHelper::$Javascript = JavascriptHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = ""
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1328722590
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/accounts/view/43"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$style_outer	=	"width: 350px"
$style_other_header	=	"font-family: 'Myriad Pro', Arial; font-size: 14px; color: #494949; margin-top: 5px; margin-bottom: 2px;"
$style_main_photo	=	"text-align: center;"
$style_photo	=	"float: left; padding: 3px;"

                        }

                    echo "</div>";

                } elseif(count($photoAlbums[0]['PhotoAlbum']['Photo']) > 1) {

include - APP/views/elements/map/info_window_tab.ctp, line 38
View::_render() - CORE/cake/libs/view/view.php, line 654
View::element() - CORE/cake/libs/view/view.php, line 339
include - APP/views/elements/map/content.ctp, line 49
View::_render() - CORE/cake/libs/view/view.php, line 654
View::element() - CORE/cake/libs/view/view.php, line 339
include - APP/views/accounts/view.ctp, line 226
View::_render() - CORE/cake/libs/view/view.php, line 654
View::render() - CORE/cake/libs/view/view.php, line 372
Controller::render() - CORE/cake/libs/controller/controller.php, line 744
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 262
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90

Back to MarrakechMarrakech, Morocco

Desert Trip 2Merzouga, Morocco

Final dayMarrakech, Morocco

EssaouiraEssaouira, Morocco


	Tom hasn't uploaded any videos yet.

(default) 198 queries took 6 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	0
4	DESCRIBE `featured_trips`	5	5	0
5	DESCRIBE `scoops`	9	9	0
6	DESCRIBE `blogs`	7	7	0
7	DESCRIBE `comments`	7	7	0
8	DESCRIBE `ratings`	7	7	0
9	DESCRIBE `friend_tags`	7	7	0
10	DESCRIBE `photo_albums`	5	5	0
11	DESCRIBE `photos`	7	7	0
12	DESCRIBE `videos`	9	9	0
13	DESCRIBE `trip_members`	6	6	0
14	DESCRIBE `trip_followers`	4	4	0
15	DESCRIBE `trip_invites`	9	9	0
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	0
20	DESCRIBE `wish_lists`	10	10	0
21	DESCRIBE `friend_groups`	4	4	0
22	DESCRIBE `friend_group_links`	4	4	0
23	DESCRIBE `messages`	8	8	0
24	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '80d95d32d9de55050ccc1655fbcca0de'	1	1	0
25	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` = 43 GROUP BY `Account`.`id` LIMIT 1	1	1	1
26	SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 43))) OR (((`Friend`.`account_id` = 43) AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 1 LIMIT 1	0	0	0
27	SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 43))) OR (((`Friend`.`account_id` = 43) AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 0 LIMIT 1	0	0	0
28	SELECT `Account`.`id` FROM `accounts` AS `Account` LEFT JOIN `friends` AS `Friend` ON (`Account`.`id` = `Friend`.`account_id` OR `Account`.`id` = `Friend`.`friend_id`) WHERE ((`Friend`.`account_id` = 43 OR `Friend`.`friend_id` = 43) AND (`Account`.`id` <> 43) AND (`Friend`.`approved` = 1));	1	1	0
29	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` = (6) GROUP BY `Account`.`id` ORDER BY rand() ASC	1	1	1
30	SELECT `FriendA`.`id`, `FriendA`.`account_id`, `FriendA`.`friend_id`, `FriendA`.`approved`, `FriendA`.`id_hash`, `FriendA`.`created`, `FriendA`.`modified` FROM `friends` AS `FriendA` WHERE `FriendA`.`approved` = 1 AND `FriendA`.`account_id` = (6)	8	8	0
31	SELECT `FriendB`.`id`, `FriendB`.`account_id`, `FriendB`.`friend_id`, `FriendB`.`approved`, `FriendB`.`id_hash`, `FriendB`.`created`, `FriendB`.`modified` FROM `friends` AS `FriendB` WHERE `FriendB`.`approved` = 1 AND `FriendB`.`friend_id` = (6)	8	8	0
32	SELECT `FriendInvite`.`id`, `FriendInvite`.`account_id`, `FriendInvite`.`friend_id`, `FriendInvite`.`email`, `FriendInvite`.`approved`, `FriendInvite`.`id_hash`, `FriendInvite`.`fb_user_id_hash`, `FriendInvite`.`created`, `FriendInvite`.`modified` FROM `friend_invites` AS `FriendInvite` WHERE `FriendInvite`.`account_id` = (6)	7	7	0
33	SELECT `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `scoops` AS `Scoop` WHERE `Scoop`.`account_id` = (6)	62	62	0
34	SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` = (6)	5	5	0
35	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`.`account_id` = (6)	10	10	0
36	SELECT `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = (6)	10	10	0
37	SELECT `FriendGroup`.`id`, `FriendGroup`.`name`, `FriendGroup`.`account_id`, `FriendGroup`.`created` FROM `friend_groups` AS `FriendGroup` WHERE `FriendGroup`.`account_id` = (6)	2	2	0
38	SELECT `FriendGroupLink`.`id`, `FriendGroupLink`.`account_id`, `FriendGroupLink`.`friend_group_id`, `FriendGroupLink`.`created` FROM `friend_group_links` AS `FriendGroupLink` WHERE `FriendGroupLink`.`account_id` = (6)	0	0	0
39	SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` = 43	0	0	0
40	SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 43 AND `TripMember`.`status` = 0	1	1	0
41	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = (40) AND ((`Trip`.`start_date` <= NOW()) AND (`Trip`.`end_date` >= NOW())) ORDER BY `Trip`.`created` DESC LIMIT 1	0	0	0
42	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = (40) ORDER BY `Trip`.`start_date` DESC LIMIT 1	1	1	0
43	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	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`.`trip_destination_id` IN (201, 202, 203, 204, 205, 206, 207)	8	8	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` = 43 AND `Account`.`status` <> 0	1	1	0
46	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	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` = 43 AND `Account`.`status` <> 0	1	1	0
48	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	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` = 43 AND `Account`.`status` <> 0	1	1	0
50	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	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` = 43 AND `Account`.`status` <> 0	1	1	0
52	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
53	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
54	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
55	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	1
56	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
57	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
58	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
59	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
60	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
61	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` = 201 AND `TripDestination`.`id` IS NOT NULL	1	1	0
62	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` = 202 AND `TripDestination`.`id` IS NOT NULL	1	1	0
63	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` = 202 AND `TripDestination`.`id` IS NOT NULL	1	1	0
64	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` = 202 AND `TripDestination`.`id` IS NOT NULL	1	1	0
65	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` = 203 AND `TripDestination`.`id` IS NOT NULL	1	1	0
66	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`id` = 203 AND `TripDestination`.`id` IS NOT NULL	1	1	0
67	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` = 203 AND `TripDestination`.`id` IS NOT NULL	1	1	0
68	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` = 204 AND `TripDestination`.`id` IS NOT NULL	1	1	0
69	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 53	1	1	0
70	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 54	0	0	0
71	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 58	1	1	0
72	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 60	1	1	0
73	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 55	1	1	0
74	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 56	1	1	0
75	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 57	1	1	0
76	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating` FROM `blogs` AS `Blog` WHERE `Blog`.`scoop_id` = 59	1	1	0
77	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 53	0	0	0
78	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 54	1	1	0
79	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 58	0	0	0
80	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 60	0	0	0
81	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 55	0	0	0
82	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 56	0	0	0
83	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 57	0	0	0
84	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 59	0	0	0
85	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` = 53	0	0	0
86	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` = 54	0	0	0
87	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` = 58	0	0	0
88	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` = 60	0	0	0
89	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` = 55	0	0	0
90	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` = 56	0	0	0
91	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` = 57	0	0	0
92	SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating` FROM `videos` AS `Video` WHERE `Video`.`scoop_id` = 59	0	0	0
93	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
94	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
95	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
96	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
97	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
98	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
99	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
100	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
101	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
102	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
103	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
104	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
105	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
106	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
107	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
108	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
109	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
110	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
111	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
112	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
113	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
114	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
115	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
116	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
117	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
118	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
119	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
120	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
121	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
122	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
123	SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 40	1	1	0
124	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
125	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
126	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` = 202 AND `TripDestination`.`id` IS NOT NULL	1	1	0
127	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`.`trip_destination_id` = (202)	3	3	0
128	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` = 204 AND `TripDestination`.`id` IS NOT NULL	1	1	0
129	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`.`trip_destination_id` = (204)	1	1	0
130	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` = 202 AND `TripDestination`.`id` IS NOT NULL	1	1	0
131	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`.`trip_destination_id` = (202)	3	3	0
132	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` = 203 AND `TripDestination`.`id` IS NOT NULL	1	1	0
133	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`.`trip_destination_id` = (203)	3	3	0
134	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` = 203 AND `TripDestination`.`id` IS NOT NULL	1	1	0
135	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`.`trip_destination_id` = (203)	3	3	0
136	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` = 203 AND `TripDestination`.`id` IS NOT NULL	1	1	0
137	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`.`trip_destination_id` = (203)	3	3	0
138	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` = 202 AND `TripDestination`.`id` IS NOT NULL	1	1	0
139	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`.`trip_destination_id` = (202)	3	3	0
140	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` = 201 AND `TripDestination`.`id` IS NOT NULL	1	1	0
141	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`.`trip_destination_id` = (201)	1	1	0
142	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` = 60	1	1	0
143	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` = 59	1	1	0
144	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` = 58	1	1	0
145	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` = 57	1	1	0
146	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` = 56	1	1	0
147	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` = 55	1	1	0
148	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` = 54	0	0	0
149	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` = 53	1	1	0
150	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 60	0	0	0
151	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 59	0	0	0
152	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 58	0	0	0
153	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 57	0	0	0
154	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 56	0	0	0
155	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 55	0	0	0
156	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 54	1	1	0
157	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` = (14)	1	1	0
158	SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id` FROM `photo_albums` AS `PhotoAlbum` WHERE `PhotoAlbum`.`scoop_id` = 53	0	0	0
159	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` = 60	0	0	0
160	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` = 59	0	0	0
161	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` = 58	0	0	0
162	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` = 57	0	0	0
163	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` = 56	0	0	0
164	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` = 55	0	0	0
165	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` = 54	0	0	0
166	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` = 53	0	0	0
167	SELECT `Trip`.`id`, `Trip`.`title` FROM `trips` AS `Trip` WHERE `Trip`.`id` = (40) ORDER BY `Trip`.`start_date` DESC	1	1	0
168	SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 43 AND `TripMember`.`status` = 0	1	1	0
169	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`, `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` = (40) ORDER BY `Trip`.`start_date` DESC	1	1	0
170	SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC	7	7	0
171	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`.`trip_id` = (40) ORDER BY `Scoop`.`created` DESC	8	8	0
172	SELECT `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`status` = 0 AND `TripMember`.`trip_id` = (40)	1	1	0
173	SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` = (40)	1	1	0
174	SELECT `TripInvite`.`id`, `TripInvite`.`account_id`, `TripInvite`.`trip_id`, `TripInvite`.`recipient_id`, `TripInvite`.`email`, `TripInvite`.`approved`, `TripInvite`.`id_hash`, `TripInvite`.`fb_user_id_hash`, `TripInvite`.`created` FROM `trip_invites` AS `TripInvite` WHERE `TripInvite`.`trip_id` = (40)	0	0	0
175	SELECT `TripJoinRequest`.`id`, `TripJoinRequest`.`account_id`, `TripJoinRequest`.`trip_id`, `TripJoinRequest`.`approved`, `TripJoinRequest`.`created` FROM `trip_join_requests` AS `TripJoinRequest` WHERE `TripJoinRequest`.`trip_id` = (40)	0	0	0
176	SELECT `TripMembers`.`id`, `TripMembers`.`forename`, `TripMembers`.`surname`, `TripMembers`.`nickname`, `TripMembers`.`email`, `TripMembers`.`password`, `TripMembers`.`dob`, `TripMembers`.`gender`, `TripMembers`.`privacy_level`, `TripMembers`.`nationality`, `TripMembers`.`photo_filename`, `TripMembers`.`fb_uid`, `TripMembers`.`use_fb`, `TripMembers`.`email_hash`, `TripMembers`.`permission_group_id`, `TripMembers`.`status`, `TripMembers`.`disabled`, `TripMembers`.`created`, `TripMembers`.`modified`, `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `accounts` AS `TripMembers` JOIN `trip_members` AS `TripMember` ON (`TripMember`.`trip_id` = 40 AND `TripMember`.`account_id` = `TripMembers`.`id`) WHERE 1 = 1	1	1	0
177	SELECT `TripFollowers`.`id`, `TripFollowers`.`forename`, `TripFollowers`.`surname`, `TripFollowers`.`nickname`, `TripFollowers`.`email`, `TripFollowers`.`password`, `TripFollowers`.`dob`, `TripFollowers`.`gender`, `TripFollowers`.`privacy_level`, `TripFollowers`.`nationality`, `TripFollowers`.`photo_filename`, `TripFollowers`.`fb_uid`, `TripFollowers`.`use_fb`, `TripFollowers`.`email_hash`, `TripFollowers`.`permission_group_id`, `TripFollowers`.`status`, `TripFollowers`.`disabled`, `TripFollowers`.`created`, `TripFollowers`.`modified`, `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `accounts` AS `TripFollowers` JOIN `trip_followers` AS `TripFollower` ON (`TripFollower`.`trip_id` = 40 AND `TripFollower`.`account_id` = `TripFollowers`.`id`) WHERE 1 = 1	1	1	0
178	SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating`, `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `blogs` AS `Blog` LEFT JOIN `scoops` AS `Scoop` ON (`Blog`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'Blog' AND `Scoop`.`account_id` = 43 ORDER BY rand() ASC LIMIT 4	4	4	1
179	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` = 58	1	1	0
180	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
181	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` = 202	1	1	0
182	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` = 56	1	1	0
183	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
184	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` = 203	1	1	0
185	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` = 60	1	1	0
186	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
187	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` = 202	1	1	0
188	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` = 59	1	1	0
189	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
190	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` = 204	1	1	0
191	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` FROM `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'PhotoAlbum' AND `Scoop`.`account_id` = 43 ORDER BY rand() ASC LIMIT 4	1	1	0
192	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` = 54	1	1	0
193	SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 43 AND `Account`.`status` <> 0	1	1	0
194	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` = 202	1	1	0
195	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 `Scoop`.`class` = 'Video' AND `Scoop`.`account_id` = 43 ORDER BY rand() ASC LIMIT 4	0	0	0
196	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
197	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'	1	1	0
198	UPDATE `cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328758590;s:4:\"rand\";i:1272878031;s:7:\"timeout\";i:10;}Message\|a:0:{}', `expires` = 1328758591 WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'	1		0

(default) 198 queries took 6 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 `messages`

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

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`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` = 43 GROUP BY `Account`.`id` LIMIT 1

SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 43))) OR (((`Friend`.`account_id` = 43) AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 1 LIMIT 1

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));

SELECT `FriendA`.`id`, `FriendA`.`account_id`, `FriendA`.`friend_id`, `FriendA`.`approved`, `FriendA`.`id_hash`, `FriendA`.`created`, `FriendA`.`modified` FROM `friends` AS `FriendA` WHERE `FriendA`.`approved` = 1 AND `FriendA`.`account_id` = (6)

SELECT `FriendB`.`id`, `FriendB`.`account_id`, `FriendB`.`friend_id`, `FriendB`.`approved`, `FriendB`.`id_hash`, `FriendB`.`created`, `FriendB`.`modified` FROM `friends` AS `FriendB` WHERE `FriendB`.`approved` = 1 AND `FriendB`.`friend_id` = (6)

SELECT `FriendInvite`.`id`, `FriendInvite`.`account_id`, `FriendInvite`.`friend_id`, `FriendInvite`.`email`, `FriendInvite`.`approved`, `FriendInvite`.`id_hash`, `FriendInvite`.`fb_user_id_hash`, `FriendInvite`.`created`, `FriendInvite`.`modified` FROM `friend_invites` AS `FriendInvite` WHERE `FriendInvite`.`account_id` = (6)

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

SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` = (6)

SELECT `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = (6)

SELECT `FriendGroup`.`id`, `FriendGroup`.`name`, `FriendGroup`.`account_id`, `FriendGroup`.`created` FROM `friend_groups` AS `FriendGroup` WHERE `FriendGroup`.`account_id` = (6)

SELECT `FriendGroupLink`.`id`, `FriendGroupLink`.`account_id`, `FriendGroupLink`.`friend_group_id`, `FriendGroupLink`.`created` FROM `friend_group_links` AS `FriendGroupLink` WHERE `FriendGroupLink`.`account_id` = (6)

SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 43 AND `TripMember`.`status` = 0

SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`trip_id` = (40) ORDER BY `TripDestination`.`lft` ASC

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

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

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

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

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

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

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

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

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

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

129

130

131

132

133

134

135

136

137

138

139

140

141

142

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

143

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

144

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

145

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

146

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

147

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

148

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

149

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

150

151

152

153

154

155

156

157

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

158

159

160

161

162

163

164

165

166

167

SELECT `Trip`.`id`, `Trip`.`title` FROM `trips` AS `Trip` WHERE `Trip`.`id` = (40) ORDER BY `Trip`.`start_date` DESC

168

SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 43 AND `TripMember`.`status` = 0

169

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`, `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` = (40) ORDER BY `Trip`.`start_date` DESC

170

171

172

173

SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` = (40)

174

SELECT `TripInvite`.`id`, `TripInvite`.`account_id`, `TripInvite`.`trip_id`, `TripInvite`.`recipient_id`, `TripInvite`.`email`, `TripInvite`.`approved`, `TripInvite`.`id_hash`, `TripInvite`.`fb_user_id_hash`, `TripInvite`.`created` FROM `trip_invites` AS `TripInvite` WHERE `TripInvite`.`trip_id` = (40)

175

SELECT `TripJoinRequest`.`id`, `TripJoinRequest`.`account_id`, `TripJoinRequest`.`trip_id`, `TripJoinRequest`.`approved`, `TripJoinRequest`.`created` FROM `trip_join_requests` AS `TripJoinRequest` WHERE `TripJoinRequest`.`trip_id` = (40)

176

SELECT `TripMembers`.`id`, `TripMembers`.`forename`, `TripMembers`.`surname`, `TripMembers`.`nickname`, `TripMembers`.`email`, `TripMembers`.`password`, `TripMembers`.`dob`, `TripMembers`.`gender`, `TripMembers`.`privacy_level`, `TripMembers`.`nationality`, `TripMembers`.`photo_filename`, `TripMembers`.`fb_uid`, `TripMembers`.`use_fb`, `TripMembers`.`email_hash`, `TripMembers`.`permission_group_id`, `TripMembers`.`status`, `TripMembers`.`disabled`, `TripMembers`.`created`, `TripMembers`.`modified`, `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `accounts` AS `TripMembers` JOIN `trip_members` AS `TripMember` ON (`TripMember`.`trip_id` = 40 AND `TripMember`.`account_id` = `TripMembers`.`id`) WHERE 1 = 1

177

SELECT `TripFollowers`.`id`, `TripFollowers`.`forename`, `TripFollowers`.`surname`, `TripFollowers`.`nickname`, `TripFollowers`.`email`, `TripFollowers`.`password`, `TripFollowers`.`dob`, `TripFollowers`.`gender`, `TripFollowers`.`privacy_level`, `TripFollowers`.`nationality`, `TripFollowers`.`photo_filename`, `TripFollowers`.`fb_uid`, `TripFollowers`.`use_fb`, `TripFollowers`.`email_hash`, `TripFollowers`.`permission_group_id`, `TripFollowers`.`status`, `TripFollowers`.`disabled`, `TripFollowers`.`created`, `TripFollowers`.`modified`, `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `accounts` AS `TripFollowers` JOIN `trip_followers` AS `TripFollower` ON (`TripFollower`.`trip_id` = 40 AND `TripFollower`.`account_id` = `TripFollowers`.`id`) WHERE 1 = 1

178

SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating`, `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `blogs` AS `Blog` LEFT JOIN `scoops` AS `Scoop` ON (`Blog`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'Blog' AND `Scoop`.`account_id` = 43 ORDER BY rand() ASC LIMIT 4

179

180

181

182

183

184

185

186

187

188

189

190

191

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` FROM `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'PhotoAlbum' AND `Scoop`.`account_id` = 43 ORDER BY rand() ASC LIMIT 4

192

193

194

195

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 `Scoop`.`class` = 'Video' AND `Scoop`.`account_id` = 43 ORDER BY rand() ASC LIMIT 4

196

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

197

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

198

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


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