Warning (2): file_get_contents(https://graph.facebook.com/crimsonsaints) [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]
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 (3080, 'facebook_likes', NULL, '2018-02-24 16:16:25', '2018-02-24 16:16:25')

The Crimson Saints profile - BandWagon

The Crimson Saints

This artist hasn\'t added any media yet

Members

Jamie k, mr Manson, CG, kieran Hughes, Groucho

Biography

The Crimson Saints are an independent, exciting modern band, Their sound calls on a range of influences from rhythm & blues, soul, classic rock and british pop and indie. Their songs are stories of innocence and experience, escape and regret. They will stick in your head and etch themselves in your heart.

This artist doesn't have any gigs yet

This artist has not entered any technical information.

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 39 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `acts_events_ratings`663
2SHOW FULL COLUMNS FROM `promoters_events_ratings`660
3SHOW FULL COLUMNS FROM `search_index`19191
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
5SHOW FULL COLUMNS FROM `epk_images`13130
6SHOW FULL COLUMNS FROM `epk_settings`440
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
8SHOW FULL COLUMNS FROM `acts_stats`660
9SELECT `Profile`.`id` FROM `profiles` AS `Profile` WHERE `slug` = 'CrimsonSaints' AND `active` = 1 LIMIT 1111
10SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3080 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:16:25' ORDER BY `created` desc LIMIT 1001
11SELECT `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` = 3080 LIMIT 1113
12SELECT `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` = (3080) ORDER BY `order` ASC 000
13SELECT `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` = (3080) ORDER BY `order` ASC 0010
14SELECT `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` = (3080) ORDER BY `order` ASC 001
15SELECT `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` = (3080) ORDER BY `order` ASC 009
16SELECT `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` = (3080) 115
17SELECT `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` = 3080 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 220
18SELECT `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` = 3080 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
19SELECT `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:16:25' AND `Act`.`id` = 3080 AND `Event`.`cancelled` = 0 000
20SELECT `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:16:25' AND `Act`.`id` = 3080 AND `Event`.`cancelled` = 0 000
21SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3080 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:16:25' ORDER BY `created` desc LIMIT 1000
22SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3080 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:16:25' ORDER BY `created` desc LIMIT 1000
23SELECT `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` = 3080 LIMIT 1112
24SELECT `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` = (3080) ORDER BY `order` ASC 000
25SELECT `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` = (3080) ORDER BY `order` ASC 003
26SELECT `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` = (3080) ORDER BY `order` ASC 000
27SELECT `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` = (3080) ORDER BY `order` ASC 000
28SELECT `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` = (3080) 110
29SELECT `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` = 3080 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 220
30SELECT `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` = 3080 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
31SELECT `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:16:25' AND `Act`.`id` = 3080 AND `Event`.`cancelled` = 0 000
32SELECT `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:16:25' AND `Act`.`id` = 3080 AND `Event`.`cancelled` = 0 000
33INSERT INTO `acts_stats` (`act_id`, `type`, `value`, `modified`, `created`) VALUES (3080, 'facebook_likes', NULL, '2018-02-24 16:16:25', '2018-02-24 16:16:25')1048: Column 'value' cannot be null0
34SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3080 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:16:25' ORDER BY `created` desc LIMIT 1000
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` = 3080 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` = (3080) 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` = (3080) ORDER BY `order` ASC 000
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` = (3080) ORDER BY `order` ASC 000
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` = (3080) ORDER BY `order` ASC 000
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` = (3080) 110
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` = 3080 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` = 3080 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:16:25' AND `Act`.`id` = 3080 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:16:25' AND `Act`.`id` = 3080 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:16:25' AND `Act`.`id` = 3080 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:16:25' AND `Act`.`id` = 3080 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` = 3080 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` = 3080 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` = (3080) 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:16:25' AND `Act`.`id` = 3080 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:16:25' AND `Act`.`id` = 3080 AND `Event`.`cancelled` = 0 000