Trips » hyderabad

Trip Details

hyderabad

Created by

  View Profile  
Message User

Start / End Date

29th May 2009 - 31st May 2009

Trip Visibility

This trip is viewable to the public

Departing From

Delhi, India

Departing on: 29th May 2009

Destinations

Chennai, India

29th May 2009 - 31st May 2009

Hyderabad, India

29th May 2009 - 31st May 2009
Edit TripDelete Trip
Who's on this trip?Manage Members
Who's following this trip?
  It looks like nobody is following this trip yet.  
Trip Route

Javascript is required to view the map.

  This trip currently has no scoops. Why not let people know more about the trip by uploading photos, videos and blogs?  
app/webroot/index.php (line 93) 
1.4128
(default) 37 queries took 27 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `trips`12121
2DESCRIBE `accounts`19192
3DESCRIBE `trip_destinations`15152
4DESCRIBE `scoops`991
5DESCRIBE `blogs`771
6DESCRIBE `comments`771
7DESCRIBE `ratings`771
8DESCRIBE `friend_tags`771
9DESCRIBE `photo_albums`551
10DESCRIBE `photos`772
11DESCRIBE `videos`991
12DESCRIBE `user_locations`991
13DESCRIBE `friends`771
14DESCRIBE `friend_invites`991
15DESCRIBE `wish_lists`10101
16DESCRIBE `trip_members`661
17DESCRIBE `friend_groups`441
18DESCRIBE `friend_group_links`441
19DESCRIBE `featured_trips`551
20DESCRIBE `trip_followers`441
21DESCRIBE `trip_invites`991
22DESCRIBE `trip_join_requests`551
23DESCRIBE `messages`881
24SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '32fc0886cf33ff6051583b37cadf71ea'110
25SELECT `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` = 93 LIMIT 1110
26SELECT `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` = (93) ORDER BY `TripDestination`.`lft` ASC 331
27SELECT `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 (500, 501, 502) 000
28SELECT `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` = (93) ORDER BY `Scoop`.`created` DESC 000
29SELECT `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` = (93) 000
30SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` = (93) 000
31SELECT `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` IS NULL GROUP BY `Account`.`id` LIMIT 1000
32SELECT `FeaturedTrip`.`id` FROM `featured_trips` AS `FeaturedTrip` WHERE `FeaturedTrip`.`trip_id` = 93 000
33SELECT COUNT(*) AS `count` FROM `trip_members` AS `TripMember` LEFT JOIN `accounts` AS `Account` ON (`TripMember`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) WHERE `TripMember`.`account_id` IS NULL AND `TripMember`.`trip_id` = 93 AND `TripMember`.`status` = 0 110
34SELECT COUNT(*) AS `count` FROM `trip_followers` AS `TripFollower` LEFT JOIN `accounts` AS `Account` ON (`TripFollower`.`account_id` = `Account`.`id` AND `Account`.`status` <> 0) WHERE `TripFollower`.`account_id` IS NULL AND `TripFollower`.`trip_id` = 93 110
35SELECT COUNT(*) AS `count` FROM `messages` AS `Message` LEFT JOIN `accounts` AS `Author` ON (`Message`.`author_id` = `Author`.`id` AND `Author`.`status` <> 0) LEFT JOIN `accounts` AS `Recipient` ON (`Message`.`recipient_id` = `Recipient`.`id`) WHERE `Message`.`recipient_id` IS NULL AND `Message`.`viewed` = 0 110
36SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '32fc0886cf33ff6051583b37cadf71ea'110
37UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1284182871;s:4:\"rand\";i:567459301;s:7:\"timeout\";i:10;}', `expires` = 1284182872 WHERE `id` = '32fc0886cf33ff6051583b37cadf71ea'10