select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=93400
) as subquery
Win SONY DVD Camcorder or minidisk walkman
Great news for everyone sending in entries for the OneWorld/MTV Staying Alive 2004 AUDIO and VIDEO Competition...there are now even more prizes to be won.
In addition to having your PSA (Public Service Announcement) streamed on both OneWorld and MTV's websites and receiving a glass plaque commemorating your achievement, thanks to donation by SONY (www.sony.com), winners will also receive equipment to help create future productions.
AUDIO - The winner and second place runner-up will each receive a brand new SONY minidisk walkman.
VIDEO - The winner and second place runner-up will each receive a brand new SONY DVD Camcorder.
The deadline for submission of entries is fast approaching – 16th November 2004 – so there’s no time to spare in the race to complete those short audio clips.
Remember each PSA you enter must be between 30-60 seconds, should inform viewers about HIV/AIDS and have a specific focus on women and girls. The competition is only open to young people aged between 15 and 34 years of age.
For more information about the competition see the competition pages...
|
|
for VIDEO entries
|
|
|
for AUDIO entries
|
|