• 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 Red River Details

Popular Questions How much is tuition? Is there any government help with the tuition? Do your programs accept insurance? Are there student loans for the tuition? Are there any grants or scholarships?

New Questions!! How do I sign up for a seminar? Do I attend these seminars with my child? Are the seminars an extra cost? How many seminars are there? Where are the seminars?

Red River Red River Details Red River Testimonials Red River Website Red River Pictures Schools Teens Carolina Springs Darrington Horizon Ivy Ridge Midwest Red River Royal Gorge Spring Creek Lodge Pre-Teens Majestic Ranch Christian Residential Teatment Cross Creek Programs Young Adult Camas Ranch Canyon View Park Pillars of Hope

Red River Video Parent Testimonials "You are a vital link for news of our daughter and we rely on your insight." "Our children have dreams and choices for the future and parents have both faith and hope as a result of your efforts." "After years of struggling, parents have a new inner sense of peace. We are free to remain pro-active in the school program. Together, we will help our daughter to thrive so that she can enjoy a fulfilling life." "I don’t think I can thank you enough for what your vision has done for my son and family."  Read More Testimonials... Character Developement Side Story 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 >> 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 realize their true potential. Using various "Emotional Growth Seminars" we help students learn their true potential and gain the confidence to stand on their own. This helps drastically with peer group problems as students are not compelled to latch on to the first group of kids they find (which is usually a bad crowd). Without confidence teens become unmotivated and lose direction causing school problems, communication problems and other common issues students are faced with today. On a daily basis we offer activities that are constantly providing a sense of accomplishment and self worth. Kids learn that they are in control of where they go in life and with hard work and a positive attitude they can do great things. For a full list of the activities we provide our students call one of our representatives today.   < Prev   Next > [ Back ]

| 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 ((`name` LIKE '%Character Developement.html%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Character-Developement.html' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=401&id=297&lang=en&task=view' AND `oldurl` = 'Character-Developement.html'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 401 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1210941427' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1210941427' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
14
SELECT *
 FROM jos_menu
 WHERE id = 401
15
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 = 297 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-16 06:52' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-16 06:52' )
 AND a.access <= 0
16
SELECT a.id
 FROM jos_content AS a
 WHERE a.catid = 202
 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-16 06:52' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-16 06:52' )
 ORDER BY a.ordering
17
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '297'
18
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
19
SELECT a.title as mag_name, c.title as issue_name, a.id as mag_id, c.id as mag_issue, d.title as article_title
        FROM jos_magazine_sections a, jos_magazine_articles b, jos_magazine_categories c , jos_content d
        WHERE b.article_id='297' AND c.id=b.catid AND a.id=c.section AND b.article_id = d.id
20
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
21
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
22
SELECT *
 FROM jos_mambots
 WHERE id = '58'
23
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
24
SELECT *
 FROM jos_mambots
 WHERE id = '58'
25
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
26
SELECT *
 FROM jos_mambots
 WHERE id = '58'
27
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
28
SELECT *
 FROM jos_mambots
 WHERE id = '58'
29
SELECT *
 FROM jos_magazine_articles
 WHERE 
 article_id='297' 
 LIMIT 1
30
SELECT *
FROM jos_content
WHERE id = '296'
31
SELECT * from jos_users as A, jos_magazine_users as B 
 WHERE A.id = '62'
 AND A.id = B.userid
 GROUP by A.id 
 LIMIT 1
32
SELECT *
 FROM jos_magazine_categories
 WHERE 
 id='1' 
 LIMIT 1
33
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'
34
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 = 401 )
 ORDER BY ordering
35
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
36
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
37
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_expose&Itemid=529&lang=en'
38
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
39
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 06:52' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-16 06:52' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND ( a.sectionid=3 )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
LIMIT 5
40
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
41
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 = 98
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
42
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 = 100
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
43
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 = 99
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
44
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 = 101
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
45
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 06:52' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-16 06:52' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND ( a.sectionid=3 )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
46
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 = 110
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
47
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 = 109
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
48
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 = 108
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
49
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 = 107
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
50
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 = 106
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
51
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'rra'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
52
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
53
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=265'
54
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'schools'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
55
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
56
SELECT *
 FROM jos_mambots
 WHERE id = '58'
57
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
58
SELECT *
 FROM jos_mambots
 WHERE id = '58'
59
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
60
SELECT *
 FROM jos_mambots
 WHERE id = '58'
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_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
72
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Bottom Menu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
73
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_joomap&Itemid=181&lang=en'
74
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_linx&Itemid=505&lang=en'
75
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_contxtd&Itemid=523&catid=203&lang=en'