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

Aventyr profile - BandWagon

Aventyr

Photo of Aventyr
Book This Artist

Members

Roger Olsen vocal
Jan Tore Befring lead guitar
Steinar Aven guitar
Didrik Amundsen bass
Trond Vilnes drums

Biography

AVENTYR

Unmasked, raw Rock 'N' Roll is the key word, brought to you in an authentic, energetic, rich and captivating way, and of course the mandatory crank-up-the-reverb guitar-solos – This is AVENTYR!

AVENTYR started out in a gloomy dark attic in 2001, at the head of the Sognefjord, Norway. They held on for several turbulent years, with a good flow of musicians from bands like Funeral, Taake and Grotesque Hysterectomy amongst their ranks.

In ‘04 AVENTYR went to sleep and in '08 arose yet again, with guitarist, composer and founder Steinar Aven, and vocalist, composer and co-founder Roger Olsen as the only remaining members of the "old" AVENTYR. Together with a fresh generation of rockers AVENTYR re-emerged from the dark ground and back onto the music-scene; ready and able.

In 2011 the band released the EP ''Trouble'', mixed by Beau Hill (Alice Cooper, Europe, Winger etc.) at the UK label Casket Music. The EP received good reviews both at home and abroad. In one of the reviews the band were defined as a mixture of Hellacopters and Backyard Babies in great shape - a description well-earned. This led, among other things, to a 5-year publishing agreement with American Michael Davenport / Expressive Artists, where names like AC/DC, Guns 'n' Roses and David Bowie are signed.

Already in late 2011 the band was ready with new material to follow-up the EP. The debut album “Driven” was recorded by the band themselves in a local studio in their home town of Førde in Norway.

The recordings stood by from January to August 2012 and finally the tunes were sent over the "pond" for mix and master by their good partner Beau Hill. The result is a bunch of efficient in-your-face rock'n'roll tunes. As musical inspiration one can find everything from Mötorhead to Billy Idol, no comparison btw.

This artist doesn't have any gigs yet

Contact:
Roger Olsen
roggol@online.no
004792430496

When Norway careens into the USA the results are unsurprisingly eclectic and not as messy as you might think! However, the amount of Britishness about ‘Driven’ by Norway’s Aventyr, which was mixed and mastered by legendary American producer Beau Hill, maybe isn’t quite what was expected. This debut effort is pleasantly varied in approach with elements of good old fashioned metal in the style of Judas Priest jostling keenly with the howl and stomp of The Cult, a touch of Sunset Strip, some straight down the middle NWOBHM’ness and a good blast of energetic rock and roll. Yeah I know, that sounds like a stramash of ideas and in a way it is. However if you are able and willing to put aside the fact that one song on this album can sounds decidedly unlike the next, while still fitting together beautifully, then there’s much to entice the bouncy big kid out of you here. A twin guitar sound courtesy of lead licker Jan Tore Befring and rhythm raconteur Steinar Aven infuses ‘Driven’ with a keen sense of purpose, while the sometimes snarling, sometimes scything vocals from Roger Olsen sit perfectly in songs strongly influenced by a whole host of 70s and 80s ideals. ‘Outside’ combines the school-cap riffery of AC/DC to an early Def chant of Leppard via the snarl of ‘Kill ‘Em All’ Metallica. ‘Delirious’ adds a human pyramid of Scorpions staccato harmony riffs to a blurting NWOBHM chorus. ‘Torpedo’ mashes up wolf worrying era Cult and the lip-curling gurn of Billy Idol, while ‘Crazy Roads’ pounds and pummels like Priest rattling their ‘British Steel’. Add to that a Skid Row grind and layered Crüe like gang chorus in the title track and then a hip shimmying of G&R, a throaty cough of Motorhead and a straight between the eyesness of Krokus or Golden Earring and you pretty much have Aventyr covered. What’s not to like? Steven Reid

Notice (8): Undefined variable: bio_full [APP/views/acts/view.ctp, line 454]
(default) 43 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Profile`.`id` FROM `profiles` AS `Profile` WHERE `slug` = 'Roggol' AND `active` = 1 LIMIT 1111
2SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 2982 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:16:43' ORDER BY `created` desc LIMIT 1005
3SELECT `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` = 2982 LIMIT 1112
4SELECT `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` = (2982) ORDER BY `order` ASC 000
5SELECT `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` = (2982) ORDER BY `order` ASC 666
6SELECT `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` = (2982) ORDER BY `order` ASC 222
7SELECT `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` = (2982) ORDER BY `order` ASC 666
8SELECT `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` = (2982) 330
9SELECT `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` = 2982 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 110
10SELECT `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` = 2982 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
11SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
12SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
13SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 2982 AND `type` = 'twitter_followers' AND `created` > '2018-02-17 16:16:43' ORDER BY `created` desc LIMIT 1000
14SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 2982 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:16:43' ORDER BY `created` desc LIMIT 1000
15SELECT `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` = 2982 LIMIT 1110
16SELECT `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` = (2982) ORDER BY `order` ASC 000
17SELECT `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` = (2982) ORDER BY `order` ASC 660
18SELECT `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` = (2982) ORDER BY `order` ASC 220
19SELECT `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` = (2982) ORDER BY `order` ASC 660
20SELECT `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` = (2982) 330
21SELECT `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` = 2982 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 110
22SELECT `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` = 2982 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
23SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
24SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
25INSERT INTO `acts_stats` (`act_id`, `type`, `value`, `modified`, `created`) VALUES (2982, 'facebook_likes', NULL, '2018-02-24 16:16:43', '2018-02-24 16:16:43')1048: Column 'value' cannot be null0
26SELECT `ActsStat`.`id`, `ActsStat`.`act_id`, `ActsStat`.`type`, `ActsStat`.`value`, `ActsStat`.`created`, `ActsStat`.`modified` FROM `acts_stats` AS `ActsStat` WHERE `act_id` = 2982 AND `type` = 'facebook_likes' AND `created` > '2018-02-17 16:16:43' ORDER BY `created` desc LIMIT 1000
27SELECT `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` = 2982 LIMIT 1110
28SELECT `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` = (2982) ORDER BY `order` ASC 000
29SELECT `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` = (2982) ORDER BY `order` ASC 660
30SELECT `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` = (2982) ORDER BY `order` ASC 220
31SELECT `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` = (2982) ORDER BY `order` ASC 660
32SELECT `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` = (2982) 330
33SELECT `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` = 2982 AND `ActsGenre`.`genre_id` = `Genre`.`id`) 110
34SELECT `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` = 2982 AND `AccountsProfile`.`account_id` = `Account`.`id`) ORDER BY `Account`.`name` ASC 110
35SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
36SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
37SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
38SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
39SELECT `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` = 2982 LIMIT 1110
40SELECT `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` = 2982 110
41SELECT `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` = (2982) ORDER BY `order` ASC 000
42SELECT `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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000
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:43' AND `Act`.`id` = 2982 AND `Event`.`cancelled` = 0 000