• Home
• Schools
• News
  • News Feeds
  • Latest News
• Enrollment
  • 10 Step Guide
  • Loans
    • Loan Application
    • Home Owner Loans
  • Adobe Acrobat
  • Books
• Testimonials
• F.A.Q.
• Pictures

Home

Recent Articles Hope for Troubled Teens Helping ADHD/ADD Troubled Teens Options for Troubled Teen Drug Abuse Specialized Help for Troubled Teens with Bipolar Disorder Boot Camps for Troubled Teens

Popular Pages How much is tuition? Ivy Ridge - New York Student Loans 10 Step Guide to Enrollment Behavior Modification for Troubled Teens

Help for Troubled Teens Teen Help is a free referral service for parents with a Troubled Teen. We can direct parents to both short and long-term options to help their troubled teen as well as seminars for the parents. We also have options for children ages 7-13, teens ages 13-17.5 and young adult programs for 18-25 year olds. We have a program for troubled teens to fit your needs. If you have a troubled teen that you feel is high risk call now. To see if your troubled teen is high risk fill out this this Troubled Teen Risk Assessment . Specialty Boarding Schools Specialty Boarding Schools The Specialty Boarding Schools represented by Teen Help not only offer behavior modification and excellent academics, but daily character building courses as well as emotional growth seminars, enabling students to reach their full potential in a structured, positive environment. Parent Seminars as well as Parent/Child workshops aid families in the healing process. Read More >>   Residential Treatment Centers Residential Treatment Centers Residential Treatment Centers are very similar to Specialty Boarding Schools in the program they offer. They provide everything a Specialty Boarding School provides with additional one on one therapy. Residential Treatment Centers are an excellent means of helping Troubled Teens with emotional, psychological, and behavioral issues that Read More >> Program Components Academics Academics are an important part of a program for Troubled Teens. Most programs, especially the short term ones do not provide academics as part of their program, while more then often academics is the cause of the problems that the child is having. Kids get behind in school and it wears on their self worth and causes a spiral downwards that can lead to many issues. They start associating with bad peer groups, disrupting class, skipping Read More >> Character Developement Is your child lacking motivation or self worth? Everyone knows having confidence and self worth is one of the most if not the most important parts of becoming successful. Low confidence and self worth leads to depression and lack of motivation causing a terrible spiral in the wrong direction, this is why all of the programs Teen Help represents have intensive Character Development courses designed to build confidence and help students Read More >> Behavior Modification for Troubled Teens The Specialty Boarding Schools and Residential Treatment Centers represented by Teen Help are primarily designed to address various behavioral, academic, emotional and psychological issues. These come in many forms like ADD, ADHD, OCD, ODD, Bi-Polar, abandonment issues, detachment disorders, peer group problems, drug and alcohol problems etc, there are just too many to list in this short synopsis. Through the use of therapy and the various programs in place we are able to get to... Read More >>

Teen Help Features Teen Help Programs Help! I am a... About Us Articles

| Home | Site Map | Links | Employment | About Teen Help | Our Staff |

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 ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 507 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1210930882' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1210930882' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
7
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
12
SELECT *
 FROM jos_menu
 WHERE id = 507
13
select a.id from jos_menu a , jos_components b where b.id=a.componentid and b.name='.iJoomla Magazine' limit 1
14
SELECT *
 FROM jos_magazine_sections
 WHERE 
 published='1' 
 AND published_up<='2008-05-16' and published_down>='2008-05-16'
 AND id='1'
 ORDER BY ordering ASC LIMIT 1
15
SELECT *
 FROM jos_magazine_categories
 WHERE 
 published='1' AND id='1'
 AND published_up<='2008-05-16' and published_down>='2008-05-16'
 ORDER BY ordering ASC
16
SELECT *
 FROM jos_magazine_articles as m , jos_content as c
 WHERE 
 m.published='1' AND c.state='1' AND m.catid='1' AND m.type=2
 AND m.article_id = c.id AND c.access<=0 
 ORDER BY m.ordering ASC
17
SELECT *
 FROM jos_magazine_articles as m, jos_content as c
 WHERE 
 m.published='1' AND c.state='1' AND m.catid='1' AND m.type=1
 AND m.article_id = c.id AND c.access<=0 
 ORDER BY m.ordering ASC
18
SELECT s.*
 FROM jos_magazine_categories as c, jos_magazine_sections as s
 WHERE 
 c.section=s.id AND c.id='1'
 GROUP BY s.id
19
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
20
SELECT id,title,title_alias,introtext, images,  attribs
 FROM jos_content
 WHERE 
 id='292' 
 AND access <=0
 LIMIT 1
21
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
22
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
23
SELECT *
 FROM jos_mambots
 WHERE id = '58'
24
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
25
SELECT *
 FROM jos_mambots
 WHERE id = '58'
26
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
27
SELECT *
 FROM jos_mambots
 WHERE id = '58'
28
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
29
SELECT *
 FROM jos_mambots
 WHERE id = '58'
30
SELECT id,title,title_alias,introtext, images,  attribs
 FROM jos_content
 WHERE 
 id='293' 
 AND access <=0
 LIMIT 1
31
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
32
SELECT *
 FROM jos_mambots
 WHERE id = '58'
33
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
34
SELECT *
 FROM jos_mambots
 WHERE id = '58'
35
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
36
SELECT *
 FROM jos_mambots
 WHERE id = '58'
37
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
38
SELECT *
 FROM jos_mambots
 WHERE id = '58'
39
SELECT COUNT(*) AS numrows
 FROM jos_banner
 WHERE showBanner = 1
40
SELECT *
 FROM jos_banner
 WHERE showBanner = 1
LIMIT 1
41
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 3
42
SELECT id,title,title_alias,introtext,images,  attribs
 FROM jos_content
 WHERE 
 id='298' 
 AND access <=0
 LIMIT 1
43
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
44
SELECT *
 FROM jos_mambots
 WHERE id = '58'
45
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
46
SELECT *
 FROM jos_mambots
 WHERE id = '58'
47
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
48
SELECT *
 FROM jos_mambots
 WHERE id = '58'
49
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
50
SELECT *
 FROM jos_mambots
 WHERE id = '58'
51
SELECT id,title,title_alias,introtext,images,  attribs
 FROM jos_content
 WHERE 
 id='297' 
 AND access <=0
 LIMIT 1
52
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
53
SELECT *
 FROM jos_mambots
 WHERE id = '58'
54
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
55
SELECT *
 FROM jos_mambots
 WHERE id = '58'
56
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
57
SELECT *
 FROM jos_mambots
 WHERE id = '58'
58
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
59
SELECT *
 FROM jos_mambots
 WHERE id = '58'
60
SELECT id,title,title_alias,introtext,images,  attribs
 FROM jos_content
 WHERE 
 id='296' 
 AND access <=0
 LIMIT 1
61
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
62
SELECT *
 FROM jos_mambots
 WHERE id = '58'
63
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
64
SELECT *
 FROM jos_mambots
 WHERE id = '58'
65
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
66
SELECT *
 FROM jos_mambots
 WHERE id = '58'
67
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
68
SELECT *
 FROM jos_mambots
 WHERE id = '58'
69
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
70
SELECT *
 FROM jos_mambots
 WHERE id = '58'
71
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
72
SELECT *
 FROM jos_mambots
 WHERE id = '58'
73
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
74
SELECT *
 FROM jos_mambots
 WHERE id = '58'
75
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
76
SELECT *
 FROM jos_mambots
 WHERE id = '58'
77
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
78
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'
79
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 = 507 )
 ORDER BY ordering
80
SELECT id, metadesc, metakey, metatitle, metalang, metarobots FROM jos_sh404SEF_meta WHERE newurl = 'index.php?3de69ea13a27d1ead96ff5d7b47efae3'
81
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0'
GROUP BY m.id ORDER BY m.parent, m.ordering
82
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
83
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_expose&Itemid=529&lang=en'
84
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
85
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-16 03:56' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-16 03:56' )
 AND a.access <= 0
 AND ( a.sectionid=38 OR a.sectionid=35 )
 ORDER BY a.created DESC
LIMIT 5
86
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 319
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
87
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
88
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
89
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 320
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
90
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 311
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
91
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 318
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
92
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 310
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
93
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-16 03:56' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-16 03:56' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
LIMIT 5
94
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 97
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
95
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 254
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
96
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 40
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
97
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 49
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
98
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 296
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
99
SELECT
            m.*,
            a.id AS iid,
            a.name AS title
 FROM jos_menu as m
 LEFT JOIN jos_magazine_sections as a ON m.name = a.title
 WHERE a.published = 1
 AND m.published = 1
 AND m.access = a.access
 AND m.access <= 0
 AND a.access <= 0
 AND m.type='url'
 AND m.menutype = 'magazines'
 GROUP BY a.id
 ORDER BY a.ordering
 LIMIT 5
100
select sectionid as my_image_id from jos_content where id='1'
101
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Bottom Menu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
102
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=181&lang=en'
103
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_linx&Itemid=505&lang=en'
104
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_contxtd&Itemid=523&catid=203&lang=en'