• Home
• Contest News
• NMMLP
• Contact Us

Main Menu

Home

How to Enter

Contest Rules

Entry Forms

Scripts & Storyboards

Counter Marketing

About Tobacco

After the contest

2006 Winners

Sponsors

Contact Us

Dead Serious User Rating: / 6 PoorBest  Written by Ruby Bencomo, Alejandra Bueno, Paola Castillo, Pedro Chavez, James Dean, Jessica Gutierrez, Cody Herdren, Bailey Long, Abi Mendoza, Jorge Mendoza, Uriah Snowden and Brandon Von Gedda South Valley Academy, Albuquerque NM  Produced by Kyle Faris - Youth Radio, KUNM 89.9 FM Please wait for the ad to load. If you don't see it, hit the "Refresh" or "Reload" button in your browser. Discuss this ad! What do you think about this ad?  What's the main message? What techniques does it use?  Do you think it's effective?  Why or why not? Comments (5) ... written by ut , November 28, 2007 Hello Mother, Hello Father Tobacco is baaad. B ... written by goth girl , November 09, 2007 tobacco is NOT good its bad it KILLS get it so there!!!!!!!!!!!!!!!!!!! ... written by urface , October 30, 2007 TOBACCO IS GOOD ... written by Brieann, October 23,2007 , October 23, 2007 ..: It was alright. Kind of silly but a good message:.. ... written by pavan , September 22, 2007 hello how r u? whats going on Write comment Comment Name   Add Comment Jom Comment 0.104 Serialize: Jom Comment 0.105 Building Jom COmment: Jom Comment 0.116 Fetch Cache: 30 queries executed   < Prev   Next >

2006 Winners Coffin Nails Dead Serious Dreams El humo no discrimina Gamblers In Any Language Smoker's Fashion Where is Your      Money Going? Site tools Search Tell a friend Downloads Your photo here

© 2008 Talk Back to Big Tobacco! Script & Storyboard Contest

Joomla! is Free Software released under the GNU/GPL License.

Designed by Red Evolution

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT `id`,`link` FROM jos_menu  WHERE ((`name` LIKE '%dead serious.html%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'dead-serious.html' LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&task=view&id=73&Itemid=130'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 130 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1210686818' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1210686818' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT `params` FROM `jos_mambots` WHERE `element`='azrul.system'
9
SELECT value FROM jos_jomcomment_config WHERE name='all'
10
SELECT id FROM jos_sections
11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
13
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
14
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
15
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
16
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
17
SELECT *
 FROM jos_menu
 WHERE id = 130
18
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 73 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-13 07:08' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-13 07:08' )
 AND a.access <= 0
19
SELECT a.id
 FROM jos_content AS a
 WHERE a.catid = 44
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-13 07:08' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-13 07:08' )
 ORDER BY a.ordering
20
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 73
21
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '73'
22
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
23
SELECT id FROM jos_mambots WHERE element = 'mgmediabot' AND folder = 'content'
24
SELECT *
 FROM jos_mambots
 WHERE id = '28'
25
SELECT a.*, b.created_by FROM jos_jomcomment as a, jos_content as b 
						            WHERE a.`contentid`='73' 
						                AND ( a.`option`='com_content' OR a.`option`='com_myblog') 
						                AND a.`published`='1' 
						                AND b.`id`=a.`contentid`  ORDER BY date DESC, id DESC
26
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_jomcomment&jc_task=rss&contentid=73&opt=com_content'
27
SELECT * FROM jos_jomcomment_tb WHERE contentid='73' AND published=1 AND `option`='com_content'  ORDER BY id DESC
28
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_jomcomment&task=trackback&id=73&opt=com_content'
29
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_jomcomment&task=trackback&id=73&opt=com_content'
30
SELECT count(*) FROM jos_jomcomment_tb WHERE contentid='73' AND published=1 AND `option`='com_content'  ORDER BY id DESC
31
SELECT * FROM jos_jomcomment_mailq WHERE status='0' LIMIT 0 , 10
32
select media from jos_media where id = 73
33
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=79&Itemid=130'
34
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=75&Itemid=130'
35
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
36
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 130 )
 ORDER BY ordering
37
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
38
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
39
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
40
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_contact&Itemid=3'
41
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
42
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_frontpage&Itemid=1'
43
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
44
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
45
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=22&Itemid=37'
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
47
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=36'
48
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
49
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=23&Itemid=38'
50
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=10&Itemid=29'
51
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=7&Itemid=51'
52
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=11&Itemid=64'
53
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=47&Itemid=75'
54
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=72'
55
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=72&Itemid=128'
56
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=46'
57
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=46&Itemid=74'
58
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_contact&Itemid=3'
59
SELECT *
 FROM jos_banner
 WHERE showBanner=1
60
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 3
61
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_banners&task=click&bid=3'
62
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = '2006 Winners'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
63
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=79&Itemid=138'
64
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=73&Itemid=130'
65
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=75&Itemid=131'
66
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=76&Itemid=134'
67
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=81&Itemid=139'
68
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=77'
69
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=77&Itemid=136'
70
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=78&Itemid=137'
71
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=74'
72
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=74&Itemid=133'
73
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Site tools'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
74
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_search&Itemid=82'
75
SELECT name FROM jos_menu WHERE link = 'index.php?option=com_recommend'
76
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_docman&Itemid=110'
77
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=64'
78
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=64&Itemid=126'