MyBusinessColleges.com

State: Florida Change state

Search Online Colleges Instead

Florida Campuses : Massage, Healing & Health

American Institute of Massage Therapy - FL

American Institute of Massage Therapy - FL

Accreditation:

Accrediting Commission of Career Schools and Colleges of Technology (ACCSCT

Programs

Massage Therapy

Cortiva Institute

Cortiva Institute

Accreditation:

Commission on Massage Therapy Accreditation (COMTA)

Daytona College

Daytona College

Accreditation:

Accrediting Commission of Career Schools

Programs

Aesthetics Skincare - Diploma

Medical Therapeutic Massage- Associate of Science

Therapeutic Massage and Skin Care - Associate of Science

Therapeutic Massage- Diploma

Everest Institute

Everest Institute

Accreditation:

Accrediting Commission of Career Schools and Colleges of Technology.

Programs

Massage Therapy

Florida Career College

Florida Career College

Accreditation:

Accrediting Council for Independent Colleges and Schools (ACICS) to award diplomas and Associate of Science degrees.

Campuses

Florida Career College - Brandon Campus, FL

Programs

Associate's Degree - Professional Therapeutic Massage

Diploma - Clinical Skin Care

Diploma - Professional Therapeutic Massage

Florida Career College - Clearwater Campus, FL

Programs

Diploma - Clinical Skin Care

Diploma - Professional Therapeutic Massage

Florida Career College - Hialeah, FL

Programs

Diploma - Clinical Skin Care

Diploma - Massage Therapy Technician

Florida Career College - Lauderdale Lakes Campus, FL

Programs

Diploma - Clinical Skin Care

Diploma - Massage Therapy Technician

Florida Career College - Miami Campus, FL

Programs

Diploma - Clinical Skin Care

Diploma - Massage Therapy Technician

Florida Career College - Pembroke Pines, FL

Programs

Diploma - Clinical Skin Care

Diploma - Massage Therapy Technician

Florida Career College - West Palm Beach Campus, FL

Programs

Diploma - Clinical Skin Care

Diploma - Massage Therapy Technician

Florida College of Natural Health

Florida College of Natural Health

Accreditation:

The Accrediting Commission of Career Schools and Colleges of Technology (ACCSCT)

Campuses

Florida College of Natural Health - Ft. Lauderdale, FL

Programs

Advanced Massage

Massage and Skin Care

Paramedical Skin Care

Skin Care and Electrology Training Program

Skin Care Training

Therapeutic Massage Training Program

Florida College of Natural Health - Miami, FL

Programs

Advanced Massage

Massage and Skin Care

Paramedical Skin Care

Skin Care and Electrology Training Program

Skin Care Training

Therapeutic Massage Training Program

Florida College of Natural Health - Orlando, FL

Programs

Advanced Massage

Massage and Skin Care

Paramedical Skin Care

Skin Care Training

Therapeutic Massage Training Program

Florida College of Natural Health - Sarasota, FL

Programs

Advanced Massage

Massage and Skin Care

Paramedical Skin Care

Skin Care Training

Therapeutic Massage Training Program

Heritage Institute

Heritage Institute

Accreditation:

Accrediting Commission of Career Schools and Colleges of Technology (ACCSCT).

Campuses

Heritage Institute - Ft. Myers, FL

Programs

Esthetics

Therapeutic Massage

Heritage Institute - Jacksonville, FL

Programs

Esthetics

Therapeutic Massage

High-Tech Institute

High-Tech Institute

Accreditation:

Accrediting Commission of Career Schools and Colleges of Technology (ACCSCT),

Programs

Massage Therapy

Keiser Career College

Keiser Career College

Accreditation:

Commission of Career Schools and Colleges of Technology

Campuses

Keiser Career College - Greenacres, FL

Programs

A.S. Massage Therapy

A.S. Spa Management

Massage Therapy

Keiser Career College - Miami Lakes, FL

Programs

A.S. Massage Therapy

A.S. Spa Management

Massage Therapy

Southwest Florida College

Southwest Florida College

Accreditation:

Accrediting Council for Independent Colleges and Schools (ACICS)

Campuses

Southwest Florida College - Fort Myers

Programs

Massage Therapy

Southwest Florida College, Tampa, FL

Programs

Massage Therapy

© Copyright 2005 - 2007 MyBusinessColleges.com

Online Business Colleges | Online Business schools | Business Colleges

Log and debug messages

#	type	message
1	PhpConfigHandler	php.ini "register_globals" key is better set to "false" (current value is "'1'" - php.ini location: "/usr/local/lib/php.ini")
2	Context	initialization
3	Controller	initialization
4	Routing	match route [search-results-state-program-slug] "/campus-schools/state/:state/program/:slug"
5	Request	request parameters array ( 'state' => 'florida-colleges', 'slug' => 'massage-healing-and-health', 'module' => 'search', 'action' => 'perma_state_program',)
6	Controller	dispatch request
7	Filter	executing filter "sfRenderingFilter"
8	Filter	executing filter "sfWebDebugFilter"
9	Filter	executing filter "sfCommonFilter"
10	Filter	executing filter "sfFlashFilter"
11	Filter	flag old flash messages ("program_id", "zipCode", "degree_id", "state_id")
12	Filter	executing filter "sfExecutionFilter"
13	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'username' => '**', ), FLAGS: 0
14	Creole	prepareStatement(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=?
15	Creole	applyLimit(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6, offset: 0, limit: 1
16	Creole	executeQuery(): [26.11 ms] SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 LIMIT 1
17	Action	call "searchActions->executePerma_state_program()"
18	Creole	prepareStatement(): SELECT state.ID, state.NAME FROM state WHERE state.NAME=?
19	Creole	applyLimit(): SELECT state.ID, state.NAME FROM state WHERE state.NAME='Florida', offset: 0, limit: 1
20	Creole	executeQuery(): [0.46 ms] SELECT state.ID, state.NAME FROM state WHERE state.NAME='Florida' LIMIT 1
21	Creole	prepareStatement(): SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL=?
22	Creole	applyLimit(): SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health', offset: 0, limit: 1
23	Creole	executeQuery(): [5.75 ms] SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health' LIMIT 1
24	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
25	Creole	executeQuery(): [0.55 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
26	Creole	prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY UPPER(college.NAME) ASC
27	Creole	executeQuery(): [0.50 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (2014,808,437,481,2089,2089,2089,2089,2089,2089,2089,309,309,309,309,2103,2103,2118,2143,2143,2219,323,323) ORDER BY UPPER(college.NAME) ASC
28	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
29	Creole	executeQuery(): [0.85 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2014 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
30	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
31	Creole	executeQuery(): [1.06 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2014 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
32	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
33	Creole	executeQuery(): [0.43 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=808 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
34	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
35	Creole	executeQuery(): [0.31 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=811 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
36	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
37	Creole	executeQuery(): [0.33 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=437 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
38	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
39	Creole	executeQuery(): [1.99 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=437 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
40	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
41	Creole	executeQuery(): [0.41 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=481 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
42	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
43	Creole	executeQuery(): [0.58 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=495 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
44	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
45	Creole	executeQuery(): [0.40 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2089 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
46	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
47	Creole	executeQuery(): [1.28 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2090 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
48	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
49	Creole	executeQuery(): [1.17 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2091 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
50	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
51	Creole	executeQuery(): [0.68 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2092 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
52	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
53	Creole	executeQuery(): [0.68 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2093 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
54	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
55	Creole	executeQuery(): [0.74 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2094 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
56	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
57	Creole	executeQuery(): [0.62 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2095 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
58	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
59	Creole	executeQuery(): [1.24 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2096 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
60	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
61	Creole	executeQuery(): [0.43 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=309 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
62	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
63	Creole	executeQuery(): [5.15 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=310 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
64	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
65	Creole	executeQuery(): [0.80 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=311 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
66	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
67	Creole	executeQuery(): [2.40 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=312 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
68	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
69	Creole	executeQuery(): [6.18 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=313 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
70	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
71	Creole	executeQuery(): [0.55 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2103 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
72	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
73	Creole	executeQuery(): [1.00 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2104 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
74	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
75	Creole	executeQuery(): [1.66 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2105 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
76	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
77	Creole	executeQuery(): [0.39 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2118 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
78	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
79	Creole	executeQuery(): [0.64 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2120 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
80	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
81	Creole	executeQuery(): [0.87 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2143 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
82	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
83	Creole	executeQuery(): [0.98 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2144 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
84	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
85	Creole	executeQuery(): [1.59 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2145 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
86	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
87	Creole	executeQuery(): [0.48 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=323 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
88	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
89	Creole	executeQuery(): [0.68 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=325 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
90	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
91	Creole	executeQuery(): [1.36 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=324 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
92	Action	change template to "myCampusSearchResults"
93	View	initialize view for "search/perma_state_program"
94	View	render "sf_app_dir/modules/search/templates/myCampusSearchResultsSuccess.php"
95	PartialHelper	set slot "side"
96	PartialHelper	call "search->executeCampusSearchRightNav()"
97	Creole	prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
98	Creole	executeQuery(): [0.50 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
99	View	initialize view for "search/_campusSearchRightNav"
100	View	render "sf_app_dir/modules/search/templates/_campusSearchRightNav.php"
101	PartialHelper	call "featured->executeFeaturedSites()"
102	Creole	prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID
103	Creole	executeQuery(): [0.51 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='site' AND content_module.NAME='layout' AND content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 AND content_page.ID=content_module.CONTENT_PAGE_ID
104	Creole	prepareStatement(): SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=? AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC
105	Creole	executeQuery(): [0.39 ms] SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=6 AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC
106	View	initialize view for "featured/_featuredSites"
107	View	render "sf_app_dir/modules/featured/templates/_featuredSites.php"
108	PartialHelper	call "search->executeSearchBoxSmall()"
109	Creole	prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
110	Creole	executeQuery(): [0.46 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=103 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
111	Creole	prepareStatement(): SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college_state.STATE_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC
112	Creole	executeQuery(): [0.32 ms] SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=58 AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC
113	View	initialize view for "search/_searchBoxSmall"
114	View	render "sf_app_dir/modules/search/templates/_searchBoxSmall.php"
115	View	decorate content with "sf_app_dir/templates/mySearchResultsLayout.php"
116	View	render "sf_app_dir/templates/mySearchResultsLayout.php"
117	View	initialize view for "global/_vista"
118	View	render "sf_app_dir/templates/_vista.php"
119	View	initialize view for "global/_header"
120	View	render "sf_app_dir/templates/_header.php"
121	View	initialize view for "global/_footer"
122	View	render "sf_app_dir/templates/_footer.php"

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    action: perma_state_program
    module: search
    slug: massage-healing-and-health
    state: florida-colleges
attributeHolder: 
  symfony/default:

Response

---
cookies: 
httpHeaders: 
parameterHolder: 
  helper/asset/auto/javascript: 
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    description: >
      Online Business College degrees and
      accredited college recommendations
      through MyBusinessColleges.com. Online
      college programs for continuing buniness
      education.
    keywords: >
      business schools, business degrees,
      online business degrees
    robots: no index, no follow
    title: >
      Online Business Schools and Business
      Programs : myBusinessCollege.com
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
  helper/asset/auto/stylesheet/first: 
    global: 
  helper/asset/auto/stylesheet/last: 
    layoutMySearchResults: 
    modules: 
    mySearchResults: 
  symfony/action/view: 
    search_perma_state_program_template: myCampusSearchResults
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included: 
  symfony/view/sfView/slot: 
    slot_names: 
    slots: 
      side: |
        <div id="contnets_right">
        <div class="featured_programs">
        <h3>Featured Programs</h3>
        <p><img src="/images/../images/global/right_menuimg2.gif" alt="Right_menuimg2" /></p>
        <p class="title_pink">Degrees for this state and program</p>
        <ul>
        <li>
        <a href="/index.php/campus-schools/state/florida-colleges/degrees/associates-program/massage-healing-and-health.html">Associates Degree</a>           </li>
        <li>
        <a href="/index.php/campus-schools/state/florida-colleges/degrees/graduate-certificates-dip-program/massage-healing-and-health.html">Graduate Certificates & Diplomas</a>           </li>
        </ul>
        </div>
        </div>

Settings

---
app_cid: 1248
app_college_logo: >
  http://mycollegesolution.com/images/college_logos/
app_description: >
  Online Business College degrees and
  accredited college recommendations
  through MyBusinessColleges.com. Online
  college programs for continuing buniness
  education.
app_keywords: >
  business schools, business degrees,
  online business degrees
app_program_id: 103
app_site_fullname: myBusinessColleges.com
app_site_id: 6
app_site_type: program
app_title: >
  Online Business Schools and Business
  Programs : myBusinessCollege.com
mod_featured_enabled: 1
mod_featured_is_internal: 
mod_featured_view_class: sfPHP
mod_search_enabled: 1
mod_search_is_internal: 
mod_search_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend
sf_app_i18n_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend
sf_bin_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: 
sf_check_symfony_version: 
sf_compressed: 
sf_config_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/config
sf_config_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/config
sf_config_dir_name: config
sf_data_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: content
sf_doc_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/data/doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
sf_environment: dev
sf_error_404_action: error
sf_error_404_module: site
sf_error_reporting: 2047
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 
sf_i18n_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/i18n
sf_lib_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/lib
sf_lib_dir_name: lib
sf_log_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate: 
sf_login_action: login
sf_login_module: default
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/lib/model
sf_module_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_orm: propel
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache
sf_root_dir: /home/mybiznes/mybusinesscolleges/trunk
sf_routing_defaults: 
  sf_culture: en
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: /home/mybiznes/mysymfony/data
sf_symfony_lib_dir: /home/mybiznes/mysymfony/lib
sf_template_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/template
sf_test: 
sf_test_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/test
sf_test_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1328497179.91
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:  &darr;&nbsp;
sf_validation_error_suffix:  &nbsp;&darr;
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/web
sf_web_dir_name: web

Globals

---
cookie: 
  symfony: 5781fadfe4dcdb26d0b4a069dbf6b005
env: 
  DOCUMENT_ROOT: /home/mybiznes/public_html
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: >
    text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
  HTTP_CACHE_CONTROL: no-cache
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=5781fadfe4dcdb26d0b4a069dbf6b005
  HTTP_HOST: www.mybusinesscolleges.com
  HTTP_IF_MODIFIED_SINCE: Sat, 25 Sep 2010 09:43:59 GMT
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: >
    CCBot/1.0
    (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc02-02
  PATH: /bin:/usr/bin
  PATH_INFO: >
    /campus-schools/state/florida-colleges/program/massage-healing-and-health.html
  PATH_TRANSLATED: /home/mybiznes/public_html/index.php
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 38.107.179.223
  REMOTE_PORT: 51711
  REQUEST_METHOD: GET
  REQUEST_URI: >
    /index.php/campus-schools/state/florida-colleges/program/massage-healing-and-health.html
  SCRIPT_FILENAME: /home/mybiznes/public_html/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 67.18.127.7
  SERVER_ADMIN: webmaster@mybusinesscolleges.com
  SERVER_NAME: www.mybusinesscolleges.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache Server at www.mybusinesscolleges.com Port 80</address>
    
  SERVER_SOFTWARE: Apache
  UNIQUE_ID: Ty9CG0Up5gcAABrk278AAAE2
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: /home/mybiznes/public_html
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: >
    text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
  HTTP_CACHE_CONTROL: no-cache
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=5781fadfe4dcdb26d0b4a069dbf6b005
  HTTP_HOST: www.mybusinesscolleges.com
  HTTP_IF_MODIFIED_SINCE: Sat, 25 Sep 2010 09:43:59 GMT
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: >
    CCBot/1.0
    (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc02-02
  PATH: /bin:/usr/bin
  PATH_INFO: >
    /campus-schools/state/florida-colleges/program/massage-healing-and-health.html
  PATH_TRANSLATED: /home/mybiznes/public_html/index.php
  PHP_SELF: >
    /index.php/campus-schools/state/florida-colleges/program/massage-healing-and-health.html
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 38.107.179.223
  REMOTE_PORT: 51711
  REQUEST_METHOD: GET
  REQUEST_TIME: 1328497179
  REQUEST_URI: >
    /index.php/campus-schools/state/florida-colleges/program/massage-healing-and-health.html
  SCRIPT_FILENAME: /home/mybiznes/public_html/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 67.18.127.7
  SERVER_ADMIN: webmaster@mybusinesscolleges.com
  SERVER_NAME: www.mybusinesscolleges.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache Server at www.mybusinesscolleges.com Port 80</address>
    
  SERVER_SOFTWARE: Apache
  UNIQUE_ID: Ty9CG0Up5gcAABrk278AAAE2
  argc: 0
  argv: 
session: 
  symfony/user/sfUser/attributes: 
    symfony/flash: 
      program_id: 113
      zipCode: 
      degree_id: 
      state_id: 49
    symfony/flash/remove: 
  symfony/user/sfUser/authenticated: 
  symfony/user/sfUser/credentials: 
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1328497161

Php

---
php: 5.2.17
os: >
  Linux newyork.websitewelcome.com
  2.6.38.7 #46 SMP Tue Jan 31 22:55:42 CST
  2012 i686
extensions: 
  - date
  - libxml
  - openssl
  - pcre
  - zlib
  - bcmath
  - bz2
  - calendar
  - ctype
  - curl
  - dbase
  - dom
  - hash
  - filter
  - ftp
  - gd
  - gettext
  - session
  - iconv
  - standard
  - json
  - mbstring
  - mcrypt
  - mhash
  - mime_magic
  - mssql
  - mysql
  - SimpleXML
  - odbc
  - posix
  - pspell
  - Reflection
  - imap
  - SPL
  - mysqli
  - soap
  - sockets
  - exif
  - tidy
  - tokenizer
  - wddx
  - xml
  - xmlreader
  - xmlrpc
  - xmlwriter
  - xsl
  - zip
  - cgi-fcgi
  - magickwand
  - imagick
  - PDO
  - pdo_sqlite
  - SQLite
  - pdo_mysql
  - mailparse
  - Phar
  - timezonedb
  - SourceGuardian
  - ionCube Loader
  - Zend Optimizer

SQL queries

[26.11 ms] SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 LIMIT 1
[0.46 ms] SELECT state.ID, state.NAME FROM state WHERE state.NAME='Florida' LIMIT 1
[5.75 ms] SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health' LIMIT 1
[0.55 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[0.50 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (2014,808,437,481,2089,2089,2089,2089,2089,2089,2089,309,309,309,309,2103,2103,2118,2143,2143,2219,323,323) ORDER BY UPPER(college.NAME) ASC
[0.85 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2014 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[1.06 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2014 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.43 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=808 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[0.31 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=811 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.33 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=437 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[1.99 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=437 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.41 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=481 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[0.58 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=495 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.40 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2089 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[1.28 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2090 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[1.17 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2091 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.68 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2092 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.68 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2093 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.74 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2094 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.62 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2095 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[1.24 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2096 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.43 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=309 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[5.15 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=310 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.80 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=311 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[2.40 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=312 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[6.18 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=313 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.55 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2103 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[1.00 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2104 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[1.66 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2105 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.39 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2118 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[0.64 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2120 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.87 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2143 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[0.98 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2144 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[1.59 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2145 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.48 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=323 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[0.68 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=325 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[1.36 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=324 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.50 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=113 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
[0.51 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='site' AND content_module.NAME='layout' AND content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 AND content_page.ID=content_module.CONTENT_PAGE_ID
[0.39 ms] SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=6 AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC
[0.46 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=58 AND college_program.PROGRAM_ID=103 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
[0.32 ms] SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=58 AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC