ERROR

We are sorry - although we did our best: an error occurred
Typedatabase
MessageYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categorie..." at line 5
QuerySELECT (SELECT categories_id FROM categories_description WHERE language_id = 2 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 2 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 2 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 2 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 2 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 2 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 2 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 2 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url, (SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt, (SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt

Nick Birch 
Television commercial synopsis [PDF ebook] 
Campaign designed to encourage organ donation

Supporto

Project Report from the year 2010 in the subject Communications – Public Relations, Advertising, Marketing, Social Media, grade: 1.5, Central Queensland University, course: Media Relations in Arts Administration, language: English, abstract: TELEVISION COMMERCIAL SYNOPSIS
As part of the Australian Government’s new national reform package, The Organ and Tissue Authority was established on the 1st of January 2009 as a nationally coordinated approach to organ and tissue donation for transplantation (Donate Life, 2009). The Australian Organ and Tissue Authority’s chief executive Karen Murphy has said that ‘families need to know each other’s wishes about organ and tissue donation, because even if you are registered as a donor, your next of kin is still asked to give consent for donation to take place’ (The Border Watch, 2009).
‘Donate Life is the new brand and name for the national network of organ donor agencies that will deliver the message that every Australian has the potential to save lives’ (The Border Watch, 2009). Funded by The Organ and Tissue Authority, Donate Life offers educational services, donor family support, donor/recipient correspondence and also run Australian Organ Donor Awareness Week, the largest public awareness campaign in Australia associated with organ and tissue donation for transplantation (Donate Life, 2009). The Australian Organ Donor Awareness Week’s aims are to ‘raise donation rates in Australia by focusing on the pressing need for organ and tissue donation, encourage families to discuss their wishes, [highlight] the success of organ transplantation in Australia; and, finally, promote the registration of consent on the Australian Organ Donor Register’ (Parry, 2007, p.137).
You can watch the television commercial project here: http://youtu.be/ua H6s IIb6j Q

€5.99
Modalità di pagamento

Circa l’autore

Nick Birch is a Media Production Professional with a Masters of Creative Enterprise.
He has been working in the creative industries since 2000: mainly as an editor for local and international television series, commercials, documentaries, short films, corporate projects and music videos. He also produces, directs, shoots, sound-designs and writes.
His extensive experience and natural affinity with clients and their vision makes him a favourite to work with, seeing the return of many satisfied customers. He has worked with TV networks, Hollywood producers, radio stations, mining magnates, airlines, actors, singers, dancers, lawyers, charities, designers, construction, children, animals, sports, tourism and even a volcanologist.
He believes in balance, loyalty, freedom, humour and truth—values which permeate his livelihood.
His enterprise is to make your story rise and shine in the most admirable, genuine, spectacular and engaging style possible.
You can see some of his work at nickbirchstudio.com

Acquista questo ebook e ricevine 1 in più GRATIS!
Lingua Inglese ● Formato PDF ● ISBN 9783656609490 ● Dimensione 0.8 MB ● Casa editrice GRIN Verlag ● Città München ● Paese DE ● Pubblicato 2014 ● Edizione 1 ● Scaricabile 24 mesi ● Moneta EUR ● ID 3988683 ● Protezione dalla copia senza

Altri ebook dello stesso autore / Editore

5.107 Ebook in questa categoria