• 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

Rate these ads! There are lots of ways to create a good counter marketing message.  We've put together some examples for you to watch and listen to, analyze and discuss.  Check 'em out and get inspired! You can even rate the ads you love or hate, and tell us why! Bad Habit (English) User Rating: / 10   Bad Habit (Spanish) User Rating: / 2   Barbershop User Rating: / 7   Casket User Rating: / 10   Crazy Notions User Rating: / 3   Dentist User Rating: / 4   Francisca User Rating: / 1   Gee Whiz User Rating: / 2   Homemade User Rating: / 1   Name Tags User Rating: / 8   Rap User Rating: / 4   Smoking Costs User Rating: / 4   Stop Reading User Rating: / 4   Thank You User Rating: / 5

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 '%counter marketing%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'counter-marketing/5.html' LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&task=blogcategory&id=30&Itemid=77'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 77 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1210686597' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1210686597' )
 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 = 77
18
SELECT COUNT(a.id)
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-13 07:04' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-13 07:04' )
 AND ( a.catid=30 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
19
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, s.published AS sec_pub,  cc.published AS sec_pub, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-13 07:04' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-13 07:04' )
 AND ( a.catid=30 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY cc.title,  a.title
LIMIT 24
20
SELECT *
 FROM jos_categories
 WHERE id = '30'
21
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 = 58
22
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=58&Itemid=77'
23
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
24
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
25
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
26
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=58'
27
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=58&Itemid=120'
28
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='58' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
29
SELECT hits from jos_content WHERE id=58
30
select media from jos_media where id = 58
31
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 = 59
32
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=59&Itemid=121'
35
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='59' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
36
SELECT hits from jos_content WHERE id=59
37
select media from jos_media where id = 59
38
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 = 43
39
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=43&Itemid=77'
40
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=43'
41
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=43&Itemid=111'
42
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='43' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
43
SELECT hits from jos_content WHERE id=43
44
select media from jos_media where id = 43
45
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 = 41
46
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=41&Itemid=77'
47
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=41'
48
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=41&Itemid=112'
49
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='41' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
50
SELECT hits from jos_content WHERE id=41
51
select media from jos_media where id = 41
52
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 = 57
53
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=57&Itemid=114'
56
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='57' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
57
SELECT hits from jos_content WHERE id=57
58
select media from jos_media where id = 57
59
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 = 44
60
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=44&Itemid=77'
61
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=44'
62
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=44&Itemid=115'
63
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='44' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
64
SELECT hits from jos_content WHERE id=44
65
select media from jos_media where id = 44
66
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 = 42
67
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=42&Itemid=116'
70
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='42' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
71
SELECT hits from jos_content WHERE id=42
72
select media from jos_media where id = 42
73
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 = 60
74
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=60&Itemid=77'
75
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=60'
76
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=60&Itemid=117'
77
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='60' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
78
SELECT hits from jos_content WHERE id=60
79
select media from jos_media where id = 60
80
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 = 62
81
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=62&Itemid=77'
82
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=62'
83
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=62&Itemid=118'
84
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='62' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
85
SELECT hits from jos_content WHERE id=62
86
select media from jos_media where id = 62
87
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 = 39
88
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=39&Itemid=77'
89
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=39'
90
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=39&Itemid=119'
91
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='39' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
92
SELECT hits from jos_content WHERE id=39
93
select media from jos_media where id = 39
94
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 = 61
95
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=61&Itemid=77'
96
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=61'
97
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=61&Itemid=122'
98
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='61' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
99
SELECT hits from jos_content WHERE id=61
100
select media from jos_media where id = 61
101
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 = 45
102
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=45&Itemid=77'
103
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=45'
104
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=45&Itemid=123'
105
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='45' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
106
SELECT hits from jos_content WHERE id=45
107
select media from jos_media where id = 45
108
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 = 49
109
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=49&Itemid=124'
112
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='49' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
113
SELECT hits from jos_content WHERE id=49
114
select media from jos_media where id = 49
115
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 = 55
116
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=55&Itemid=77'
117
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=55'
118
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=55&Itemid=125'
119
SELECT COUNT(*) FROM jos_jomcomment WHERE contentid='55' AND (`option`='com_content' OR `option`='com_myblog') AND published='1'
120
SELECT hits from jos_content WHERE id=55
121
select media from jos_media where id = 55
122
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'
123
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 = 77 )
 ORDER BY ordering
124
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
125
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
126
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_frontpage&Itemid=1'
130
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
131
SELECT oldurl

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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

	FROM jos_redirection

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