user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 21
query: SELECT node.nid AS nid,
node_data_field_case_image.field_case_image_fid AS node_data_field_case_image_field_case_image_fid,
node_data_field_case_image.field_case_image_list AS node_data_field_case_image_field_case_image_list,
node_data_field_case_image.field_case_image_data AS node_data_field_case_image_field_case_image_data,
node.language AS node_language,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_case_image.field_video_embed AS node_data_field_case_image_field_video_embed,
node_data_field_case_image.field_video_value AS node_data_field_case_image_field_video_value,
node_data_field_case_image.field_video_provider AS node_data_field_case_image_field_video_provider,
node_data_field_case_image.field_video_data AS node_data_field_case_image_field_video_data,
node_data_field_case_image.field_video_version AS node_data_field_case_image_field_video_version,
node_data_field_case_image.field_video_duration AS node_data_field_case_image_field_video_duration,
node.title AS node_title,
node.created AS node_created
FROM node node
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN content_type_case_page node_data_field_case_image ON node.vid = node_data_field_case_image.vid
WHERE (node.type in ('case_page')) AND (node.nid != 76) AND (term_node.tid = 3)
ORDER BY node_created DESC
LIMIT 0, -1 in /var/www/html/sites/all/modules/views/includes/view.inc on line 771.
Event Production
- Icon launches the new adidas Team GB kit
- HSBC - Wimbledon
- ICON:MEI Put on a Show for adidas at County Hall!
- Caged XBOX Monster - Gears of War 3
- adidas 2012 Media Stunts
- Dover Castle
- Aviva - You Are the Big Picture
- adidas 2012 Media Launch
- Henman Water Screen
- Colt Conference
- 2012 Water-screen Cannes Film Festival
- 2010 Winter Olympics – Team GB launch
- Street Soccer
- Omnia Press Event
- Moto Sunset Lounge
Street Soccer
Over two years we launched and stage-managed Coca Cola's Street Soccer campaign featuring England and Manchester United star player Wayne Rooney.
We tracked down 'street' venues in Manchester, which we styled and branded to reflect the street-level feel of the campaign. We then laid out six full-size five-a-side pitches for the sixty competition winners to play on.
As well as liaising with the police, and Wayne Rooney's management and security, we set up all the technical facilities that the international media required.
