Warning (2): file_get_contents(https://graph.facebook.com/whiskeyandthewilsons) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 400 Bad Request
 [APP/models/acts_stat.php, line 57]
Notice (8): Trying to get property of non-object [APP/models/acts_stat.php, line 62]
WHISKEY AND THE WILSONS profile - BandWagon

WHISKEY AND THE WILSONS

Photo of WHISKEY AND THE WILSONS
Book This Artist

Members

Alfred Overy
Joe Wilson
Chris Chamberlain
Matthew Dove

Biography

WHISKEY AND THE WILSONS are an experimental rock band.

They write, arrange and produce their own music with engineer Ben Baptie.

Their artwork is by the bands pianist/organist Joe Wilson.

They made a music video with Ramy Dance.
They like to tweet a lot. @whiskeywilsons
They will be finishing their album and gigging lots this year.

This artist doesn't have any gigs yet

1 x gtr, with own amp head
1 x bass
1x keyboard
1 x drum kit
3 x vox with electro harmonx voice box on lead vox

This artist has not entered any press information.

Notice (8): Undefined variable: bio_full [APP/views/acts/view.ctp, line 454]
(default) 51 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `promoters`550
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `overall_promoter_ratings`990
4SHOW FULL COLUMNS FROM `promoters_events_recommendations`770
5SELECT `Profile`.`id` FROM `profiles` AS `Profile` WHERE `slug` = 'whiskeyandthewilsons' AND `active` = 1 LIMIT 1111
6SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3075 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:18:10' ORDER BY `created` desc LIMIT 1004
7SELECT `Act`.`id`, `Act`.`website`, `Act`.`facebook`, `Act`.`myspace`, `Act`.`soundcloud`, `Act`.`youtube`, `Act`.`lastfm`, `Act`.`biography`, `Act`.`label`, `Act`.`location`, `Act`.`management`, `Act`.`members`, `Act`.`technical_info`, `Act`.`press`, `Act`.`location_id`, `Act`.`loc_segmentation`, `Location`.`id`, `Location`.`model`, `Location`.`type`, `Location`.`address`, `Location`.`postcode`, `Location`.`googlename`, `Location`.`googledata`, `Location`.`lat`, `Location`.`lng`, `Location`.`sw_lat`, `Location`.`sw_lng`, `Location`.`ne_lat`, `Location`.`ne_lng`, `Location`.`radius`, `Profile`.`id`, `Profile`.`name`, `Profile`.`type`, `Profile`.`phone`, `Profile`.`twitter`, `Profile`.`slug`, `Profile`.`account_type`, `Profile`.`account_admin_user_id`, `Profile`.`created`, `Profile`.`active`, `Profile`.`introcode`, `Profile`.`mock_email`, `Profile`.`tw_oauth_request_token`, `Profile`.`tw_oauth_request_token_secret`, `Profile`.`tw_oauth_token`, `Profile`.`tw_oauth_token_secret`, `Profile`.`tw_user_id`, `Profile`.`sc_access_token`, `Profile`.`sc_connected_time`, `Profile`.`sc_expires`, `Profile`.`sc_refresh_token`, `Profile`.`upgrade_promo_flag`, `Profile`.`signup_event_id`, `OverallActRating`.`id`, `OverallActRating`.`act_id`, `OverallActRating`.`count`, `OverallActRating`.`punctuality_count`, `OverallActRating`.`punctuality_total`, `OverallActRating`.`professionalism_count`, `OverallActRating`.`professionalism_total`, `OverallActRating`.`epk_count`, `OverallActRating`.`epk_total` FROM `acts` AS `Act` LEFT JOIN `locations` AS `Location` ON (`Act`.`location_id` = `Location`.`id`) INNER JOIN `profiles` AS `Profile` ON (`Act`.`id` = `Profile`.`id`) LEFT JOIN `overall_act_ratings` AS `OverallActRating` ON (`OverallActRating`.`act_id` = `Act`.`id`) WHERE `Act`.`id` = 3075 LIMIT 1112
8SELECT `ActsEventsRecommendation`.`id`, `ActsEventsRecommendation`.`act_id`, `ActsEventsRecommendation`.`acts_event_id`, `ActsEventsRecommendation`.`text`, `ActsEventsRecommendation`.`active`, `ActsEventsRecommendation`.`order` FROM `acts_events_recommendations` AS `ActsEventsRecommendation` WHERE `ActsEventsRecommendation`.`act_id` = (3075) ORDER BY `order` ASC 000
9SELECT `ActImage`.`id`, `ActImage`.`model`, `ActImage`.`foreign_key`, `ActImage`.`dirname`, `ActImage`.`basename`, `ActImage`.`filename`, `ActImage`.`description`, `ActImage`.`checksum`, `ActImage`.`alternative`, `ActImage`.`group`, `ActImage`.`created`, `ActImage`.`modified`, `ActImage`.`order` FROM `act_images` AS `ActImage` WHERE `ActImage`.`foreign_key` = (3075) ORDER BY `order` ASC 116
10SELECT `ActMedia`.`id`, `ActMedia`.`act_id`, `ActMedia`.`title`, `ActMedia`.`type`, `ActMedia`.`code`, `ActMedia`.`user_entered_code`, `ActMedia`.`order` FROM `act_media` AS `ActMedia` WHERE `ActMedia`.`act_id` = (3075) ORDER BY `order` ASC 221
11SELECT `ActRemoteImage`.`id`, `ActRemoteImage`.`model`, `ActRemoteImage`.`foreign_key`, `ActRemoteImage`.`dirname`, `ActRemoteImage`.`basename`, `ActRemoteImage`.`filename`, `ActRemoteImage`.`description`, `ActRemoteImage`.`checksum`, `ActRemoteImage`.`alternative`, `ActRemoteImage`.`group`, `ActRemoteImage`.`created`, `ActRemoteImage`.`modified`, `ActRemoteImage`.`order` FROM `act_images` AS `ActRemoteImage` WHERE `ActRemoteImage`.`foreign_key` = (3075) ORDER BY `order` ASC 116
12SELECT `ActsEvent`.`id`, `ActsEvent`.`status`, `ActsEvent`.`act_id`, `ActsEvent`.`event_id`, `ActsEvent`.`promoter_id`, `ActsEvent`.`initial_status`, `ActsEvent`.`event_slot_id`, `ActsEvent`.`event_slot_type_id`, `ActsEvent`.`created`, `ActsEvent`.`modified` FROM `acts_events` AS `ActsEvent` WHERE `ActsEvent`.`act_id` = (3075) 220
13SELECT `Genre`.`id`, `Genre`.`name`, `Genre`.`slug`, `ActsGenre`.`id`, `ActsGenre`.`act_id`, `ActsGenre`.`genre_id` FROM `genres` AS `Genre` JOIN `acts_genres` AS `ActsGenre` ON (`ActsGenre`.`act_id` = 3075 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 220
14SELECT `Account`.`id`, `Account`.`name`, `Account`.`active`, `AccountsProfile`.`id`, `AccountsProfile`.`account_id`, `AccountsProfile`.`profile_id` FROM `accounts` AS `Account` JOIN `accounts_profiles` AS `AccountsProfile` ON (`AccountsProfile`.`profile_id` = 3075 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
15SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` < '2018-02-24 16:18:10' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
16SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` >= '2018-02-24 16:18:10' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
17INSERT INTO `acts_stats` (`act_id`, `type`, `value`, `modified`, `created`) VALUES (3075, 'twitter_followers', 456, '2018-02-24 16:18:11', '2018-02-24 16:18:11')13
18SELECT LAST_INSERT_ID() AS insertID110
19SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3075 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:18:11' ORDER BY `created` desc LIMIT 1111
20SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3075 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:18:11' ORDER BY `created` desc LIMIT 1001
21SELECT `Act`.`id`, `Act`.`website`, `Act`.`facebook`, `Act`.`myspace`, `Act`.`soundcloud`, `Act`.`youtube`, `Act`.`lastfm`, `Act`.`biography`, `Act`.`label`, `Act`.`location`, `Act`.`management`, `Act`.`members`, `Act`.`technical_info`, `Act`.`press`, `Act`.`location_id`, `Act`.`loc_segmentation`, `Location`.`id`, `Location`.`model`, `Location`.`type`, `Location`.`address`, `Location`.`postcode`, `Location`.`googlename`, `Location`.`googledata`, `Location`.`lat`, `Location`.`lng`, `Location`.`sw_lat`, `Location`.`sw_lng`, `Location`.`ne_lat`, `Location`.`ne_lng`, `Location`.`radius`, `Profile`.`id`, `Profile`.`name`, `Profile`.`type`, `Profile`.`phone`, `Profile`.`twitter`, `Profile`.`slug`, `Profile`.`account_type`, `Profile`.`account_admin_user_id`, `Profile`.`created`, `Profile`.`active`, `Profile`.`introcode`, `Profile`.`mock_email`, `Profile`.`tw_oauth_request_token`, `Profile`.`tw_oauth_request_token_secret`, `Profile`.`tw_oauth_token`, `Profile`.`tw_oauth_token_secret`, `Profile`.`tw_user_id`, `Profile`.`sc_access_token`, `Profile`.`sc_connected_time`, `Profile`.`sc_expires`, `Profile`.`sc_refresh_token`, `Profile`.`upgrade_promo_flag`, `Profile`.`signup_event_id`, `OverallActRating`.`id`, `OverallActRating`.`act_id`, `OverallActRating`.`count`, `OverallActRating`.`punctuality_count`, `OverallActRating`.`punctuality_total`, `OverallActRating`.`professionalism_count`, `OverallActRating`.`professionalism_total`, `OverallActRating`.`epk_count`, `OverallActRating`.`epk_total` FROM `acts` AS `Act` LEFT JOIN `locations` AS `Location` ON (`Act`.`location_id` = `Location`.`id`) INNER JOIN `profiles` AS `Profile` ON (`Act`.`id` = `Profile`.`id`) LEFT JOIN `overall_act_ratings` AS `OverallActRating` ON (`OverallActRating`.`act_id` = `Act`.`id`) WHERE `Act`.`id` = 3075 LIMIT 1110
22SELECT `ActsEventsRecommendation`.`id`, `ActsEventsRecommendation`.`act_id`, `ActsEventsRecommendation`.`acts_event_id`, `ActsEventsRecommendation`.`text`, `ActsEventsRecommendation`.`active`, `ActsEventsRecommendation`.`order` FROM `acts_events_recommendations` AS `ActsEventsRecommendation` WHERE `ActsEventsRecommendation`.`act_id` = (3075) ORDER BY `order` ASC 000
23SELECT `ActImage`.`id`, `ActImage`.`model`, `ActImage`.`foreign_key`, `ActImage`.`dirname`, `ActImage`.`basename`, `ActImage`.`filename`, `ActImage`.`description`, `ActImage`.`checksum`, `ActImage`.`alternative`, `ActImage`.`group`, `ActImage`.`created`, `ActImage`.`modified`, `ActImage`.`order` FROM `act_images` AS `ActImage` WHERE `ActImage`.`foreign_key` = (3075) ORDER BY `order` ASC 110
24SELECT `ActMedia`.`id`, `ActMedia`.`act_id`, `ActMedia`.`title`, `ActMedia`.`type`, `ActMedia`.`code`, `ActMedia`.`user_entered_code`, `ActMedia`.`order` FROM `act_media` AS `ActMedia` WHERE `ActMedia`.`act_id` = (3075) ORDER BY `order` ASC 220
25SELECT `ActRemoteImage`.`id`, `ActRemoteImage`.`model`, `ActRemoteImage`.`foreign_key`, `ActRemoteImage`.`dirname`, `ActRemoteImage`.`basename`, `ActRemoteImage`.`filename`, `ActRemoteImage`.`description`, `ActRemoteImage`.`checksum`, `ActRemoteImage`.`alternative`, `ActRemoteImage`.`group`, `ActRemoteImage`.`created`, `ActRemoteImage`.`modified`, `ActRemoteImage`.`order` FROM `act_images` AS `ActRemoteImage` WHERE `ActRemoteImage`.`foreign_key` = (3075) ORDER BY `order` ASC 110
26SELECT `ActsEvent`.`id`, `ActsEvent`.`status`, `ActsEvent`.`act_id`, `ActsEvent`.`event_id`, `ActsEvent`.`promoter_id`, `ActsEvent`.`initial_status`, `ActsEvent`.`event_slot_id`, `ActsEvent`.`event_slot_type_id`, `ActsEvent`.`created`, `ActsEvent`.`modified` FROM `acts_events` AS `ActsEvent` WHERE `ActsEvent`.`act_id` = (3075) 220
27SELECT `Genre`.`id`, `Genre`.`name`, `Genre`.`slug`, `ActsGenre`.`id`, `ActsGenre`.`act_id`, `ActsGenre`.`genre_id` FROM `genres` AS `Genre` JOIN `acts_genres` AS `ActsGenre` ON (`ActsGenre`.`act_id` = 3075 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 220
28SELECT `Account`.`id`, `Account`.`name`, `Account`.`active`, `AccountsProfile`.`id`, `AccountsProfile`.`account_id`, `AccountsProfile`.`profile_id` FROM `accounts` AS `Account` JOIN `accounts_profiles` AS `AccountsProfile` ON (`AccountsProfile`.`profile_id` = 3075 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
29SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` < '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
30SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` >= '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
31SELECT COUNT(*) AS `count` FROM `acts_stats` AS `ActsStat` WHERE `ActsStat`.`id` = 777425 110
32SELECT COUNT(*) AS `count` FROM `acts_stats` AS `ActsStat` WHERE `ActsStat`.`id` = 777425 110
33UPDATE `acts_stats` SET `act_id` = 3075, `type` = 'facebook_likes', `value` = NULL, `modified` = '2018-02-24 16:18:11' WHERE `acts_stats`.`id` = 77742512
34SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3075 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:18:11' ORDER BY `created` desc LIMIT 1111
35SELECT `Act`.`id`, `Act`.`website`, `Act`.`facebook`, `Act`.`myspace`, `Act`.`soundcloud`, `Act`.`youtube`, `Act`.`lastfm`, `Act`.`biography`, `Act`.`label`, `Act`.`location`, `Act`.`management`, `Act`.`members`, `Act`.`technical_info`, `Act`.`press`, `Act`.`location_id`, `Act`.`loc_segmentation`, `Location`.`id`, `Location`.`model`, `Location`.`type`, `Location`.`address`, `Location`.`postcode`, `Location`.`googlename`, `Location`.`googledata`, `Location`.`lat`, `Location`.`lng`, `Location`.`sw_lat`, `Location`.`sw_lng`, `Location`.`ne_lat`, `Location`.`ne_lng`, `Location`.`radius`, `Profile`.`id`, `Profile`.`name`, `Profile`.`type`, `Profile`.`phone`, `Profile`.`twitter`, `Profile`.`slug`, `Profile`.`account_type`, `Profile`.`account_admin_user_id`, `Profile`.`created`, `Profile`.`active`, `Profile`.`introcode`, `Profile`.`mock_email`, `Profile`.`tw_oauth_request_token`, `Profile`.`tw_oauth_request_token_secret`, `Profile`.`tw_oauth_token`, `Profile`.`tw_oauth_token_secret`, `Profile`.`tw_user_id`, `Profile`.`sc_access_token`, `Profile`.`sc_connected_time`, `Profile`.`sc_expires`, `Profile`.`sc_refresh_token`, `Profile`.`upgrade_promo_flag`, `Profile`.`signup_event_id`, `OverallActRating`.`id`, `OverallActRating`.`act_id`, `OverallActRating`.`count`, `OverallActRating`.`punctuality_count`, `OverallActRating`.`punctuality_total`, `OverallActRating`.`professionalism_count`, `OverallActRating`.`professionalism_total`, `OverallActRating`.`epk_count`, `OverallActRating`.`epk_total` FROM `acts` AS `Act` LEFT JOIN `locations` AS `Location` ON (`Act`.`location_id` = `Location`.`id`) INNER JOIN `profiles` AS `Profile` ON (`Act`.`id` = `Profile`.`id`) LEFT JOIN `overall_act_ratings` AS `OverallActRating` ON (`OverallActRating`.`act_id` = `Act`.`id`) WHERE `Act`.`id` = 3075 LIMIT 1110
36SELECT `ActsEventsRecommendation`.`id`, `ActsEventsRecommendation`.`act_id`, `ActsEventsRecommendation`.`acts_event_id`, `ActsEventsRecommendation`.`text`, `ActsEventsRecommendation`.`active`, `ActsEventsRecommendation`.`order` FROM `acts_events_recommendations` AS `ActsEventsRecommendation` WHERE `ActsEventsRecommendation`.`act_id` = (3075) ORDER BY `order` ASC 000
37SELECT `ActImage`.`id`, `ActImage`.`model`, `ActImage`.`foreign_key`, `ActImage`.`dirname`, `ActImage`.`basename`, `ActImage`.`filename`, `ActImage`.`description`, `ActImage`.`checksum`, `ActImage`.`alternative`, `ActImage`.`group`, `ActImage`.`created`, `ActImage`.`modified`, `ActImage`.`order` FROM `act_images` AS `ActImage` WHERE `ActImage`.`foreign_key` = (3075) ORDER BY `order` ASC 110
38SELECT `ActMedia`.`id`, `ActMedia`.`act_id`, `ActMedia`.`title`, `ActMedia`.`type`, `ActMedia`.`code`, `ActMedia`.`user_entered_code`, `ActMedia`.`order` FROM `act_media` AS `ActMedia` WHERE `ActMedia`.`act_id` = (3075) ORDER BY `order` ASC 220
39SELECT `ActRemoteImage`.`id`, `ActRemoteImage`.`model`, `ActRemoteImage`.`foreign_key`, `ActRemoteImage`.`dirname`, `ActRemoteImage`.`basename`, `ActRemoteImage`.`filename`, `ActRemoteImage`.`description`, `ActRemoteImage`.`checksum`, `ActRemoteImage`.`alternative`, `ActRemoteImage`.`group`, `ActRemoteImage`.`created`, `ActRemoteImage`.`modified`, `ActRemoteImage`.`order` FROM `act_images` AS `ActRemoteImage` WHERE `ActRemoteImage`.`foreign_key` = (3075) ORDER BY `order` ASC 110
40SELECT `ActsEvent`.`id`, `ActsEvent`.`status`, `ActsEvent`.`act_id`, `ActsEvent`.`event_id`, `ActsEvent`.`promoter_id`, `ActsEvent`.`initial_status`, `ActsEvent`.`event_slot_id`, `ActsEvent`.`event_slot_type_id`, `ActsEvent`.`created`, `ActsEvent`.`modified` FROM `acts_events` AS `ActsEvent` WHERE `ActsEvent`.`act_id` = (3075) 220
41SELECT `Genre`.`id`, `Genre`.`name`, `Genre`.`slug`, `ActsGenre`.`id`, `ActsGenre`.`act_id`, `ActsGenre`.`genre_id` FROM `genres` AS `Genre` JOIN `acts_genres` AS `ActsGenre` ON (`ActsGenre`.`act_id` = 3075 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 220
42SELECT `Account`.`id`, `Account`.`name`, `Account`.`active`, `AccountsProfile`.`id`, `AccountsProfile`.`account_id`, `AccountsProfile`.`profile_id` FROM `accounts` AS `Account` JOIN `accounts_profiles` AS `AccountsProfile` ON (`AccountsProfile`.`profile_id` = 3075 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
43SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` < '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
44SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` >= '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
45SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` < '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
46SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` >= '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
47SELECT `Act`.`id`, `Act`.`website`, `Act`.`facebook`, `Act`.`myspace`, `Act`.`soundcloud`, `Act`.`youtube`, `Act`.`lastfm`, `Act`.`biography`, `Act`.`label`, `Act`.`location`, `Act`.`management`, `Act`.`members`, `Act`.`technical_info`, `Act`.`press`, `Act`.`location_id`, `Act`.`loc_segmentation`, `Profile`.`id`, `Profile`.`name`, `Profile`.`type`, `Profile`.`phone`, `Profile`.`twitter`, `Profile`.`slug`, `Profile`.`account_type`, `Profile`.`account_admin_user_id`, `Profile`.`created`, `Profile`.`active`, `Profile`.`introcode`, `Profile`.`mock_email`, `Profile`.`tw_oauth_request_token`, `Profile`.`tw_oauth_request_token_secret`, `Profile`.`tw_oauth_token`, `Profile`.`tw_oauth_token_secret`, `Profile`.`tw_user_id`, `Profile`.`sc_access_token`, `Profile`.`sc_connected_time`, `Profile`.`sc_expires`, `Profile`.`sc_refresh_token`, `Profile`.`upgrade_promo_flag`, `Profile`.`signup_event_id` FROM `acts` AS `Act` INNER JOIN `profiles` AS `Profile` ON (`Act`.`id` = `Profile`.`id`) WHERE `Act`.`id` = 3075 LIMIT 1110
48SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`type`, `Profile`.`phone`, `Profile`.`twitter`, `Profile`.`slug`, `Profile`.`account_type`, `Profile`.`account_admin_user_id`, `Profile`.`created`, `Profile`.`active`, `Profile`.`introcode`, `Profile`.`mock_email`, `Profile`.`tw_oauth_request_token`, `Profile`.`tw_oauth_request_token_secret`, `Profile`.`tw_oauth_token`, `Profile`.`tw_oauth_token_secret`, `Profile`.`tw_user_id`, `Profile`.`sc_access_token`, `Profile`.`sc_connected_time`, `Profile`.`sc_expires`, `Profile`.`sc_refresh_token`, `Profile`.`upgrade_promo_flag`, `Profile`.`signup_event_id` FROM `profiles` AS `Profile` WHERE `Profile`.`id` = 3075 110
49SELECT `ActsEventsRecommendation`.`id`, `ActsEventsRecommendation`.`act_id`, `ActsEventsRecommendation`.`acts_event_id`, `ActsEventsRecommendation`.`text`, `ActsEventsRecommendation`.`active`, `ActsEventsRecommendation`.`order` FROM `acts_events_recommendations` AS `ActsEventsRecommendation` WHERE `ActsEventsRecommendation`.`active` = 1 AND `ActsEventsRecommendation`.`act_id` = (3075) ORDER BY `order` ASC 000
50SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` < '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000
51SELECT `Event`.`id`, `Event`.`name`, `Event`.`description`, `Event`.`paid_status`, `Event`.`payment_details`, `Event`.`closing_date`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`created`, `Event`.`modified`, `Event`.`finalised`, `Event`.`cancelled`, (CONCAT(`Event`.`name`, " (", DATE_FORMAT(`Event`.`start_date`, "%a %D %b %Y"), if(`Event`.`end_date` is not null," - ",""), if(`Event`.`end_date` is not null,DATE_FORMAT(`Event`.`end_date`, "%a %D %b %Y"),""), ")")) AS `Event__full_title` FROM `events` AS `Event` inner JOIN `acts_events` AS `ActsEvent` ON (`Event`.`id` = `ActsEvent`.`event_id`) inner JOIN `acts` AS `Act` ON (`ActsEvent`.`act_id` = `Act`.`id` AND `ActsEvent`.`status` = "booked") WHERE `Event`.`start_date` >= '2018-02-24 16:18:11' AND `Act`.`id` = 3075 AND `Event`.`cancelled` = 0 000