Warning (2): file_get_contents(https://graph.facebook.com/344466207397) [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]
The ZARRS profile - BandWagon

The ZARRS

Photo of The ZARRS
Book This Artist

Members

Eddie Lee (vocals) John Lazos (guitar) Chris Miller (Bass) Nicole Rowe (Sax) Francis Ovie (keyboards) Rody Braga (drums)

Biography

The ZARRS are a London based band building a great reputation as the "band to rock with" around England. Playing their high energy music to enthusiastic audiences at such famous venues as London's 100 Club, Dublin Castle, The Water Rats and The Half Moon, supporting international touring acts and 70's comeback stars (inc. Curved Air & Rose Royce) The ZARRS are a band on the move and the direction is up. Sales of their first album "May Contain Nuts" broke all expectations and garnered a worldwide fan base who eagerly await the second album, a more rock orientated offering, due for release in late June 2013. With original music that gets audiences onto their feet (and moving them), The ZARRS are not only about quality musicianship but more importantly about live audience enjoyment. Check them out on their website at http://www.thezarrs.com - and http://www.thezarrs.com/video
The ZARRS will rock your house.

This artist doesn't have any gigs yet

Two Guitars
Bass
Keyboards (2 inputs)
Sax
Drums
4-5 mics

The ZARRS are a unique breed, blending great song craft with subtle musicianship, great chorus lines, interesting subject material and a live performance, which doesn’t fail to get you shakin’ your thang! The Music Press - Feb 3, 2012. For those of you looking for a current band with that classic rock/pop rock sound this one is for you! This six member band from London, UK sounds great and their music really backs up their claim of being “ultra-accessible”. Similar artists include Bruce Springsteen, Tom Petty, The Doors, and Kasabian. From PaperBlog - Nov 28, 2012

Notice (8): Undefined variable: bio_full [APP/views/acts/view.ctp, line 454]
(default) 51 queries took 37 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` = 'thezarrs' 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` = 3521 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:17:40' ORDER BY `created` desc LIMIT 10014
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` = 3521 LIMIT 1111
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` = (3521) 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` = (3521) ORDER BY `order` ASC 996
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` = (3521) ORDER BY `order` ASC 111
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` = (3521) ORDER BY `order` ASC 996
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` = (3521) 17170
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` = 3521 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 440
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` = 3521 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:17:40' AND `Act`.`id` = 3521 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:17:40' AND `Act`.`id` = 3521 AND `Event`.`cancelled` = 0 000
17INSERT INTO `acts_stats` (`act_id`, `type`, `value`, `modified`, `created`) VALUES (3521, 'twitter_followers', 470, '2018-02-24 16:17:40', '2018-02-24 16:17:40')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` = 3521 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:17:40' 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` = 3521 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:17:40' 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` = 3521 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` = (3521) 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` = (3521) ORDER BY `order` ASC 990
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` = (3521) ORDER BY `order` ASC 110
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` = (3521) ORDER BY `order` ASC 990
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` = (3521) 17170
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` = 3521 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 440
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` = 3521 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:17:40' AND `Act`.`id` = 3521 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:17:40' AND `Act`.`id` = 3521 AND `Event`.`cancelled` = 0 000
31SELECT COUNT(*) AS `count` FROM `acts_stats` AS `ActsStat` WHERE `ActsStat`.`id` = 777423 110
32SELECT COUNT(*) AS `count` FROM `acts_stats` AS `ActsStat` WHERE `ActsStat`.`id` = 777423 110
33UPDATE `acts_stats` SET `act_id` = 3521, `type` = 'facebook_likes', `value` = NULL, `modified` = '2018-02-24 16:17:40' WHERE `acts_stats`.`id` = 77742312
34SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 3521 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:17:40' 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` = 3521 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` = (3521) 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` = (3521) ORDER BY `order` ASC 990
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` = (3521) ORDER BY `order` ASC 110
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` = (3521) ORDER BY `order` ASC 990
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` = (3521) 17170
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` = 3521 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 440
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` = 3521 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:17:40' AND `Act`.`id` = 3521 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:17:40' AND `Act`.`id` = 3521 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:17:40' AND `Act`.`id` = 3521 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:17:40' AND `Act`.`id` = 3521 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` = 3521 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` = 3521 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` = (3521) 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:17:40' AND `Act`.`id` = 3521 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:17:40' AND `Act`.`id` = 3521 AND `Event`.`cancelled` = 0 000