• 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

Login

Please login to access all features on this site and receive contest updates.

Username Password Remember me

Lost Password?

Privacy policy

About Tobacco Did you know... - The major cigarette companies spend over $41 million per day (that's more than $15 billion per year) to promote their products, and their spending goes up every year. - A lot of that tobacco promotion reaches kids and teens. - Nearly every adult who smokes (almost 90%) started smoking before they were 18 years old. - Over 5 million kids and teens alive today will die early from smoking-related illnesses. Tobacco is a deadly, addictive product.*       > Learn the facts here. The tobacco industry has targeted children and teens with slick advertising messages.      > Learn more here. Tobacco impacts some groups of people more than others.       > Learn about disparities here. Before you write your script or storyboard, do some research, so you can counter the lies and misinformation, and spread the truth! *We're talking here about commercial tobacco (cigarettes, cigars, pipes, spit tobacco, etc.) not about the traditional use of small amounts of tobacco by some Native Americans for religious and ceremonial use.

About Tobacco Info on tobacco Tobacco marketing What are disparities? Info on disparities Rate these ads! Watch, listen to &    discuss real ads 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 '%about tobacco 2%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'about-tobacco-2/index.php' LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&task=section&id=11&Itemid=64'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 64 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1210687096' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1210687096' )
 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 = 64
18
SELECT *
 FROM jos_sections
 WHERE id = '11'
19
SELECT a.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS a
 LEFT JOIN jos_content AS b ON b.catid = a.id
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2008-05-13 07:13' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2008-05-13 07:13' )
 WHERE a.section = '11'
 AND a.published = 1
 AND a.access <= 0
 AND b.access <= 0
 GROUP BY a.id
 HAVING numitems > 0
 ORDER BY a.ordering
20
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'
21
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 = 64 )
 ORDER BY ordering
22
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
23
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
24
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_contact&Itemid=3'
44
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_registration&task=lostPassword'
45
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=11&Itemid=64'
46
SELECT *
 FROM jos_banner
 WHERE showBanner=1
47
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 3
48
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_weblinks&catid=26&Itemid=48'
51
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_weblinks&catid=28&Itemid=49'
52
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=35&Itemid=63'
53
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_weblinks&catid=27&Itemid=50'
54
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Rate these ads!'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
55
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=blogcategory&id=30&Itemid=77'
56
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Site tools'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
57
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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