Warning (2): file_get_contents(https://graph.facebook.com/callumraffertymusic) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
 [APP/models/acts_stat.php, line 57]
Notice (8): Trying to get property of non-object [APP/models/acts_stat.php, line 62]
Warning (512): SQL Error: 1048: Column 'value' cannot be null [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

Query: INSERT INTO `acts_stats` (`act_id`, `type`, `value`, `modified`, `created`) VALUES (3851, 'facebook_likes', NULL, '2018-02-24 16:17:08', '2018-02-24 16:17:08')

CALLUM RAFFERTY profile - BandWagon

CALLUM RAFFERTY

Photo of CALLUM RAFFERTY
  • Pop, Folk, Acoustic, Singer/Songwriter
  • West Malling
Book This Artist

Members

Callum Rafferty - guitar/Loop pdeal/Vox

Biography

Callum Rafferty is a 14 year old Singer Songwriter from Kent , Uk.
Callum has written numerous songs and performs covers depending on what he is required to do at certain events - music genre, pop, folk . He has perfomed at many various venues in London and Kent including, Dingwalls in Camden, Beck Theatre in London, Hazlitt Theatre in Maidstone, Kent. Those are just a few of them.
Callum's biggest performance to date was at Rochester castle infront of 5,000 people.
Regardless of his age Callum is an extremely confident performer - as a one man band , he performs with the use of an acoustic guitar, (which he has played for 7 years), and a loop pedal.

Past Events

Event Name Venue Date
Fiddlers Elbow Camden The Fiddlers Elbow 8 Aug 2012
Student Showcase Towngate Theatre 13 Sep 2013
100% Alternative Valentines Harrow Arts Centre 16 Feb 2013

All that is needed is a Microphone and a jack lead into the PA.

I Have been mentioned in the Medway Messenger, The Kent Messenger and the Maidstone messenger, Kent radio interview, and The Roundhouse Camden have interviewed and advertised me performing at their Rising Festival 2013 this year , after I won the band slam competition in December 2012.

Callum Rafferty is a 14 year old Singer Songwriter from Kent , Uk.
Callum has written numerous songs and performs covers depending on what he is required to do at certain events - music genre, pop, folk . He has perfomed at many various venues in London and Kent including, Dingwalls in Camden, Beck Theatre in London, Hazlitt Theatre in Maidstone, Kent. Those are just a few of them.
Callum's biggest performance to date was at Rochester castle infront of 5,000 people.
Regardless of his age Callum is an extremely confident performer - as a one man band , he performs with the use of an acoustic guitar, (which he has played for 7 years), and a loop pedal.
(default) 99 queries took 29 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `notifications`12120
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `acts_events`10100
4SHOW FULL COLUMNS FROM `acts`16160
5SHOW FULL COLUMNS FROM `locations`14140
6SHOW FULL COLUMNS FROM `event_watches`660
7SHOW FULL COLUMNS FROM `profiles`23230
8SHOW FULL COLUMNS FROM `accounts`330
9SHOW FULL COLUMNS FROM `users`20200
10SHOW FULL COLUMNS FROM `accounts_users`330
11SHOW FULL COLUMNS FROM `accounts_profiles`330
12SHOW FULL COLUMNS FROM `venues`770
13SHOW FULL COLUMNS FROM `stages`440
14SHOW FULL COLUMNS FROM `event_stages`660
15SHOW FULL COLUMNS FROM `events`12120
16SHOW FULL COLUMNS FROM `event_days`550
17SHOW FULL COLUMNS FROM `event_slots`10100
18SHOW FULL COLUMNS FROM `event_slot_types`220
19SHOW FULL COLUMNS FROM `acts_event_slots`440
20SHOW FULL COLUMNS FROM `genres`330
21SHOW FULL COLUMNS FROM `events_profiles`330
22SHOW FULL COLUMNS FROM `events_genres`330
23SHOW FULL COLUMNS FROM `event_slot_types_events`330
24SHOW FULL COLUMNS FROM `overall_act_ratings`990
25SHOW FULL COLUMNS FROM `acts_events_recommendations`660
26SHOW FULL COLUMNS FROM `act_images`13130
27SHOW FULL COLUMNS FROM `act_media`770
28SHOW FULL COLUMNS FROM `acts_genres`330
29SHOW FULL COLUMNS FROM `activity`990
30SHOW FULL COLUMNS FROM `acts_events_notifications`330
31SHOW FULL COLUMNS FROM `activity_notifications`330
32SHOW FULL COLUMNS FROM `promoters`550
33SHOW FULL COLUMNS FROM `overall_promoter_ratings`990
34SHOW FULL COLUMNS FROM `promoters_events_recommendations`770
35SHOW FULL COLUMNS FROM `tickets`660
36SELECT `Profile`.`id` FROM `profiles` AS `Profile` WHERE `slug` = 'callumrafferty' AND `active` = 1 LIMIT 1111
37SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3851 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:17:08' ORDER BY `created` desc LIMIT 1006
38SELECT `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` = 3851 LIMIT 1112
39SELECT `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` = (3851) ORDER BY `order` ASC 000
40SELECT `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` = (3851) ORDER BY `order` ASC 116
41SELECT `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` = (3851) ORDER BY `order` ASC 221
42SELECT `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` = (3851) ORDER BY `order` ASC 116
43SELECT `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` = (3851) 1021021
44SELECT `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` = 3851 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 440
45SELECT `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` = 3851 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 330
47SELECT `EventsGenre`.`id`, `EventsGenre`.`event_id`, `EventsGenre`.`genre_id` FROM `events_genres` AS `EventsGenre` WHERE `EventsGenre`.`event_id` = 1396 000
48SELECT `EventStage`.`id`, `EventStage`.`event_id`, `EventStage`.`stage_id`, `EventStage`.`name`, `EventStage`.`desciption`, `EventStage`.`order`, `Stage`.`id`, `Stage`.`venue_id`, `Stage`.`capacity`, `Stage`.`name` FROM `event_stages` AS `EventStage` LEFT JOIN `stages` AS `Stage` ON (`EventStage`.`stage_id` = `Stage`.`id`) WHERE `EventStage`.`event_id` = 1396 ORDER BY `EventStage`.`order` ASC LIMIT 1110
49SELECT `Stage`.`id`, `Stage`.`venue_id`, `Stage`.`capacity`, `Stage`.`name` FROM `stages` AS `Stage` WHERE `Stage`.`id` = 564 110
50SELECT `Venue`.`id`, `Venue`.`location_id`, `Venue`.`promoter_id`, `Venue`.`name`, `Venue`.`email`, `Venue`.`phone`, `Venue`.`website` FROM `venues` AS `Venue` WHERE `Venue`.`id` = 564 110
51SELECT `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` FROM `locations` AS `Location` WHERE `Location`.`id` = 3321 111
52SELECT `EventsProfile`.`id`, `EventsProfile`.`event_id`, `EventsProfile`.`profile_id` FROM `events_profiles` AS `EventsProfile` WHERE `EventsProfile`.`event_id` = 1396 LIMIT 1110
53SELECT `EventsGenre`.`id`, `EventsGenre`.`event_id`, `EventsGenre`.`genre_id` FROM `events_genres` AS `EventsGenre` WHERE `EventsGenre`.`event_id` = 2075 000
54SELECT `EventStage`.`id`, `EventStage`.`event_id`, `EventStage`.`stage_id`, `EventStage`.`name`, `EventStage`.`desciption`, `EventStage`.`order`, `Stage`.`id`, `Stage`.`venue_id`, `Stage`.`capacity`, `Stage`.`name` FROM `event_stages` AS `EventStage` LEFT JOIN `stages` AS `Stage` ON (`EventStage`.`stage_id` = `Stage`.`id`) WHERE `EventStage`.`event_id` = 2075 ORDER BY `EventStage`.`order` ASC LIMIT 1110
55SELECT `Stage`.`id`, `Stage`.`venue_id`, `Stage`.`capacity`, `Stage`.`name` FROM `stages` AS `Stage` WHERE `Stage`.`id` = 715 110
56SELECT `Venue`.`id`, `Venue`.`location_id`, `Venue`.`promoter_id`, `Venue`.`name`, `Venue`.`email`, `Venue`.`phone`, `Venue`.`website` FROM `venues` AS `Venue` WHERE `Venue`.`id` = 715 110
57SELECT `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` FROM `locations` AS `Location` WHERE `Location`.`id` = 4296 111
58SELECT `EventsProfile`.`id`, `EventsProfile`.`event_id`, `EventsProfile`.`profile_id` FROM `events_profiles` AS `EventsProfile` WHERE `EventsProfile`.`event_id` = 2075 LIMIT 1110
59SELECT `EventsGenre`.`id`, `EventsGenre`.`event_id`, `EventsGenre`.`genre_id` FROM `events_genres` AS `EventsGenre` WHERE `EventsGenre`.`event_id` = 2061 220
60SELECT `Genre`.`id`, `Genre`.`name`, `Genre`.`slug` FROM `genres` AS `Genre` WHERE `Genre`.`id` IN (2, 37) ORDER BY `name` ASC 220
61SELECT `EventStage`.`id`, `EventStage`.`event_id`, `EventStage`.`stage_id`, `EventStage`.`name`, `EventStage`.`desciption`, `EventStage`.`order`, `Stage`.`id`, `Stage`.`venue_id`, `Stage`.`capacity`, `Stage`.`name` FROM `event_stages` AS `EventStage` LEFT JOIN `stages` AS `Stage` ON (`EventStage`.`stage_id` = `Stage`.`id`) WHERE `EventStage`.`event_id` = 2061 ORDER BY `EventStage`.`order` ASC LIMIT 1110
62SELECT `Stage`.`id`, `Stage`.`venue_id`, `Stage`.`capacity`, `Stage`.`name` FROM `stages` AS `Stage` WHERE `Stage`.`id` = 708 110
63SELECT `Venue`.`id`, `Venue`.`location_id`, `Venue`.`promoter_id`, `Venue`.`name`, `Venue`.`email`, `Venue`.`phone`, `Venue`.`website` FROM `venues` AS `Venue` WHERE `Venue`.`id` = 708 110
64SELECT `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` FROM `locations` AS `Location` WHERE `Location`.`id` = 4250 112
65SELECT `EventsProfile`.`id`, `EventsProfile`.`event_id`, `EventsProfile`.`profile_id` FROM `events_profiles` AS `EventsProfile` WHERE `EventsProfile`.`event_id` = 2061 LIMIT 1110
66SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 000
67SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3851 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:17:08' ORDER BY `created` desc LIMIT 1000
68SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3851 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:17:08' ORDER BY `created` desc LIMIT 1001
69SELECT `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` = 3851 LIMIT 1110
70SELECT `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` = (3851) ORDER BY `order` ASC 000
71SELECT `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` = (3851) ORDER BY `order` ASC 110
72SELECT `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` = (3851) ORDER BY `order` ASC 220
73SELECT `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` = (3851) ORDER BY `order` ASC 110
74SELECT `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` = (3851) 1021020
75SELECT `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` = 3851 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 440
76SELECT `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` = 3851 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
77SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 330
78SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 000
79INSERT INTO `acts_stats` (`act_id`, `type`, `value`, `modified`, `created`) VALUES (3851, 'facebook_likes', NULL, '2018-02-24 16:17:08', '2018-02-24 16:17:08')1048: Column 'value' cannot be null0
80SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3851 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:17:08' ORDER BY `created` desc LIMIT 1000
81SELECT `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` = 3851 LIMIT 1110
82SELECT `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` = (3851) ORDER BY `order` ASC 000
83SELECT `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` = (3851) ORDER BY `order` ASC 110
84SELECT `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` = (3851) ORDER BY `order` ASC 220
85SELECT `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` = (3851) ORDER BY `order` ASC 110
86SELECT `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` = (3851) 1021020
87SELECT `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` = 3851 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 440
88SELECT `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` = 3851 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
89SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 330
90SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 000
91SELECT `EpkSetting`.`id`, `EpkSetting`.`profile_id`, `EpkSetting`.`foreground_colour`, `EpkSetting`.`background_colour` FROM `epk_settings` AS `EpkSetting` WHERE `EpkSetting`.`profile_id` = 3851 LIMIT 1110
92SELECT `EpkImage`.`id`, `EpkImage`.`model`, `EpkImage`.`foreign_key`, `EpkImage`.`dirname`, `EpkImage`.`basename`, `EpkImage`.`filename`, `EpkImage`.`description`, `EpkImage`.`checksum`, `EpkImage`.`alternative`, `EpkImage`.`group`, `EpkImage`.`created`, `EpkImage`.`modified`, `EpkImage`.`order` FROM `epk_images` AS `EpkImage` WHERE `foreign_key` = 3851 ORDER BY `id` DESC LIMIT 1001
93SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 330
94SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 000
95SELECT `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` = 3851 LIMIT 1110
96SELECT `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` = 3851 110
97SELECT `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` = (3851) ORDER BY `order` ASC 000
98SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 330
99SELECT `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:17:08' AND `Act`.`id` = 3851 AND `Event`.`cancelled` = 0 000