State: California Change state
California Campuses : Massage, Healing & Health
Clarita College
Accreditation:
Accrediting Commission for Career Schools and Colleges of Technology (ACCSCT),
Campuses
- Clarita College - Canyon Country, CA
- Clarita College - Lancaster, CA
Programs
Massage Therapy
Programs
Massage Therapy
Concorde Career Institute
Accreditation:
Accrediting Commission of Career Schools & Colleges of Technology (ACCSCT).
Programs
Massage Therapy
Everest College
Accreditation:
Higher Learning Commission and a member of the North Central Association.
Campuses
- Everest College - Alhambra, CA
- Everest College - Anaheim, CA
- Everest College - City of Industry, CA
- Everest College - Gardena, CA
- Everest College - Hayward, CA
- Everest College - Ontario, CA
- Everest College - Reseda, CA
- Everest College - San Bernardino, CA
- Everest College - San Francisco, CA
- Everest College - San Jose, CA
- Everest College - Torrance, CA
- Everest College - West Los Angeles, Ca.
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Fremont College
Accreditation:
Accrediting Commission of Career Schools and Colleges of Technology (ACCSCT)
Programs
Massage Therapy
Sports and Rehab Therapy
High-Tech Institute
Accreditation:
Accrediting Commission of Career Schools and Colleges of Technology (ACCSCT),
Programs
Massage Therapy
Maric College
Accreditation:
Accrediting Council for Independent Colleges and Schools (ACICS)
Campuses
- Maric College - Palm Springs, CA
- Maric College - Riverside, CA
- Maric College - San Diego North Valley, CA
- Maric College - San Diego, CA
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
National Holistic Institute
Accreditation:
Accrediting Council for Continuing Education and Training (ACCET)
Campuses
- National Holistic Institute - Emeryville
- National Holistic Institute - Los Angeles (Encino)
- National Holistic Institute - Petaluma (Sonoma County)
- National Holistic Institute - San Francisco
- National Holistic Institute - San Jose
Programs
Massage Therapist and Health Educator
Programs
Massage Therapist and Health Educator
Programs
Massage Therapist and Health Educator
Programs
Massage Therapist and Health Educator
Programs
Massage Therapist and Health Educator
National Polytechnic College - CA
Accreditation:
ACCST
Programs
Massage Therapist II
Massage Therapist III
Remington College
Accreditation:
Accrediting Council for Independent Colleges and Schools (ACICS)
Programs
Massage Therapy
Western Career College
Accreditation:
Accrediting Commission for Community and Junior Colleges of the Western Association of Schools and Colleges
Campuses
- Western Career College - Antioch, CA
- Western Career College - Citrus Heights, CA
- Western Career College - Pleasant Hill, CA
- Western Career College - Sacramento, CA
- Western Career College - San Jose, CA
- Western Career College - San Leandro, CA
- Western Career College - Stockton, CA
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
Programs
Massage Therapy
WyoTEch
Accreditation:
Accrediting Commission of Career Schools
Programs
Massage Therapy
© Copyright 2005 - 2007 MyBusinessColleges.com
vars & config
logs & msgs
57
8365.5 KB
1143 ms
Log and debug messages
- [all]
- [none]
- PartialHelper
- sfAction
- sfContext
- sfController
- sfCreole
- sfFilter
- sfPhpConfigHandler
- sfRequest
- sfRouting
- sfView
| # | 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' => 'california-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 ("zipCode", "degree_id", "program_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(): [0.37 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='California', offset: 0, limit: 1 |
| 20 | Creole | executeQuery(): [0.38 ms] SELECT state.ID, state.NAME FROM state WHERE state.NAME='California' 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(): [0.36 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(): [6.93 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=8 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.89 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 (2039,2039,1095,438,438,438,438,438,438,438,438,438,438,438,438,750,2118,2189,2189,2189,2189,203,203,203,203,203,2206,2235,338,338,338,338,338,338,338,863) 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(): [5.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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2039 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.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) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2040 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 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 |
| 33 | Creole | executeQuery(): [1.05 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=2041 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 |
| 34 | 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 |
| 35 | Creole | executeQuery(): [5.62 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=1095 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 36 | 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 |
| 37 | Creole | executeQuery(): [1.86 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=434 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 38 | 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 |
| 39 | Creole | executeQuery(): [5.75 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=438 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 40 | 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 |
| 41 | Creole | executeQuery(): [10.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=440 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_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), 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 |
| 43 | Creole | executeQuery(): [13.71 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=439 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 |
| 44 | 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 |
| 45 | Creole | executeQuery(): [2.95 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=447 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 |
| 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), 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 |
| 47 | Creole | executeQuery(): [2.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), 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=453 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 |
| 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), 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 |
| 49 | Creole | executeQuery(): [2.08 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=454 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 |
| 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), 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 |
| 51 | Creole | executeQuery(): [2.81 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=461 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 |
| 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), 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 |
| 53 | Creole | executeQuery(): [4.91 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=465 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 |
| 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), 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 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,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 55 | Creole | executeQuery(): [3.05 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), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=467 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 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,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), 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 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,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 57 | Creole | executeQuery(): [7.02 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), 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=468 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 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,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), 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 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,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 59 | Creole | executeQuery(): [2.54 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), 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=469 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 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,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 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), 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 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,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 |
| 61 | Creole | executeQuery(): [1.90 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), 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=476 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 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,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 |
| 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), 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), 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 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,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 |
| 63 | Creole | executeQuery(): [3.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), 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), 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=479 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 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,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 |
| 64 | 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 |
| 65 | Creole | executeQuery(): [5.44 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=750 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.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) 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 |
| 67 | Creole | executeQuery(): [12.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=750 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 68 | 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 |
| 69 | Creole | executeQuery(): [6.00 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=8 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 |
| 70 | 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 |
| 71 | Creole | executeQuery(): [10.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) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2121 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 72 | 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 |
| 73 | Creole | executeQuery(): [5.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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2189 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.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) 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 |
| 75 | Creole | executeQuery(): [1.07 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=2194 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 76 | 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 |
| 77 | Creole | executeQuery(): [1.81 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=2196 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 |
| 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), 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 |
| 79 | Creole | executeQuery(): [1.22 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=2198 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 |
| 80 | 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 |
| 81 | 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), 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=2199 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 |
| 82 | 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 |
| 83 | Creole | executeQuery(): [5.26 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=203 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.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) 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 |
| 85 | Creole | executeQuery(): [16.35 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=204 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 86 | 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 |
| 87 | Creole | executeQuery(): [5.04 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=207 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 |
| 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), 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 |
| 89 | Creole | executeQuery(): [3.73 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=206 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 |
| 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), 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 |
| 91 | Creole | executeQuery(): [1.84 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=208 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 |
| 92 | 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 |
| 93 | Creole | executeQuery(): [4.78 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=205 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 |
| 94 | 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 |
| 95 | Creole | executeQuery(): [7.12 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2206 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 96 | 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 |
| 97 | Creole | executeQuery(): [2.77 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=2206 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 98 | 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 |
| 99 | Creole | executeQuery(): [6.07 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2235 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 100 | 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 |
| 101 | Creole | executeQuery(): [2.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=2242 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 102 | 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 |
| 103 | Creole | executeQuery(): [6.17 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=338 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 104 | 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 |
| 105 | Creole | executeQuery(): [11.32 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=346 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 106 | 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 |
| 107 | Creole | executeQuery(): [4.73 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=339 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 |
| 108 | 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 |
| 109 | Creole | executeQuery(): [6.25 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=340 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 |
| 110 | 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 |
| 111 | Creole | executeQuery(): [5.46 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=341 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 |
| 112 | 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 |
| 113 | Creole | executeQuery(): [5.84 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=345 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 |
| 114 | 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 |
| 115 | Creole | executeQuery(): [10.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), 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=342 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 |
| 116 | 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 |
| 117 | Creole | executeQuery(): [3.14 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=343 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 |
| 118 | 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 |
| 119 | Creole | executeQuery(): [6.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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=863 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 120 | 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 |
| 121 | Creole | executeQuery(): [5.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) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=871 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 122 | Action | change template to "myCampusSearchResults" |
| 123 | View | initialize view for "search/perma_state_program" |
| 124 | View | render "sf_app_dir/modules/search/templates/myCampusSearchResultsSuccess.php" |
| 125 | PartialHelper | set slot "side" |
| 126 | PartialHelper | call "search->executeCampusSearchRightNav()" |
| 127 | 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 |
| 128 | Creole | executeQuery(): [5.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.STATUS=1 AND college_state.STATE_ID=8 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 |
| 129 | View | initialize view for "search/_campusSearchRightNav" |
| 130 | View | render "sf_app_dir/modules/search/templates/_campusSearchRightNav.php" |
| 131 | PartialHelper | call "featured->executeFeaturedSites()" |
| 132 | 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 |
| 133 | Creole | executeQuery(): [7.40 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 |
| 134 | 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 |
| 135 | Creole | executeQuery(): [4.58 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 |
| 136 | View | initialize view for "featured/_featuredSites" |
| 137 | View | render "sf_app_dir/modules/featured/templates/_featuredSites.php" |
| 138 | PartialHelper | call "search->executeSearchBoxSmall()" |
| 139 | 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 |
| 140 | Creole | executeQuery(): [31.30 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=8 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 |
| 141 | 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 |
| 142 | Creole | executeQuery(): [20.10 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=8 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 |
| 143 | View | initialize view for "search/_searchBoxSmall" |
| 144 | View | render "sf_app_dir/modules/search/templates/_searchBoxSmall.php" |
| 145 | View | decorate content with "sf_app_dir/templates/mySearchResultsLayout.php" |
| 146 | View | render "sf_app_dir/templates/mySearchResultsLayout.php" |
| 147 | View | initialize view for "global/_vista" |
| 148 | View | render "sf_app_dir/templates/_vista.php" |
| 149 | View | initialize view for "global/_header" |
| 150 | View | render "sf_app_dir/templates/_header.php" |
| 151 | View | initialize view for "global/_footer" |
| 152 | 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: california-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/california-colleges/degrees/associates-program/massage-healing-and-health.html">Associates Degree</a> </li>
<li>
<a href="/index.php/campus-schools/state/california-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: 1284135588.83 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: ↓ sf_validation_error_suffix: ↓ 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: c8c94c8052654bbcbeb35ce540d9db2d
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=c8c94c8052654bbcbeb35ce540d9db2d
HTTP_HOST: www.mybusinesscolleges.com
HTTP_PRAGMA: no-cache
HTTP_USER_AGENT: >
CCBot/1.0
(+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID: ccc03-02
PATH: /bin:/usr/bin
PATH_INFO: >
/campus-schools/state/california-colleges/program/massage-healing-and-health.html
PATH_TRANSLATED: /home/mybiznes/public_html/index.php
QUERY_STRING:
REDIRECT_STATUS: 200
REMOTE_ADDR: 38.107.191.105
REMOTE_PORT: 58271
REQUEST_METHOD: GET
REQUEST_URI: >
/index.php/campus-schools/state/california-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 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.mybusinesscolleges.com Port 80</address>
SERVER_SOFTWARE: >
Apache mod_auth_passthrough/2.1
mod_bwlimited/1.4 FrontPage/5.0.2.2635
UNIQUE_ID: TIpapEUp5gcAAH4KOL0AAACC
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=c8c94c8052654bbcbeb35ce540d9db2d
HTTP_HOST: www.mybusinesscolleges.com
HTTP_PRAGMA: no-cache
HTTP_USER_AGENT: >
CCBot/1.0
(+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID: ccc03-02
PATH: /bin:/usr/bin
PATH_INFO: >
/campus-schools/state/california-colleges/program/massage-healing-and-health.html
PATH_TRANSLATED: /home/mybiznes/public_html/index.php
PHP_SELF: >
/index.php/campus-schools/state/california-colleges/program/massage-healing-and-health.html
QUERY_STRING:
REDIRECT_STATUS: 200
REMOTE_ADDR: 38.107.191.105
REMOTE_PORT: 58271
REQUEST_METHOD: GET
REQUEST_TIME: 1284135588
REQUEST_URI: >
/index.php/campus-schools/state/california-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 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.mybusinesscolleges.com Port 80</address>
SERVER_SOFTWARE: >
Apache mod_auth_passthrough/2.1
mod_bwlimited/1.4 FrontPage/5.0.2.2635
UNIQUE_ID: TIpapEUp5gcAAH4KOL0AAACC
argc: 0
argv:
session:
symfony/user/sfUser/attributes:
symfony/flash:
zipCode:
degree_id:
program_id: 113
state_id: 58
symfony/flash/remove:
symfony/user/sfUser/authenticated:
symfony/user/sfUser/credentials:
symfony/user/sfUser/culture: en
symfony/user/sfUser/lastRequest: 1284135553
Php
--- php: 5.2.9 os: > Linux newyork.websitewelcome.com 2.6.34.6 #1 SMP Fri Aug 27 18:43:47 CDT 2010 i686 extensions: - zip - libxml - xsl - xmlwriter - xmlrpc - dom - xmlreader - xml - wddx - tokenizer - tidy - session - pcre - SimpleXML - sockets - soap - SPL - standard - Reflection - pspell - posix - mysqli - mysql - mime_magic - mhash - mcrypt - mbstring - json - imap - iconv - hash - gettext - gd - ftp - filter - exif - date - curl - ctype - calendar - bcmath - zlib - openssl - cgi-fcgi - PDO - pdo_sqlite - SQLite - pdo_mysql - uploadprogress - ionCube Loader - Zend Optimizer
SQL queries
- [0.37 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.38 ms] SELECT state.ID, state.NAME FROM state WHERE state.NAME='California' LIMIT 1
- [0.36 ms] SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health' LIMIT 1
- [6.93 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=8 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.89 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 (2039,2039,1095,438,438,438,438,438,438,438,438,438,438,438,438,750,2118,2189,2189,2189,2189,203,203,203,203,203,2206,2235,338,338,338,338,338,338,338,863) ORDER BY UPPER(college.NAME) ASC
- [5.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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2039 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.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) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2040 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [1.05 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=2041 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
- [5.62 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=1095 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.86 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=434 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [5.75 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=438 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
- [10.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=440 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [13.71 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=439 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.95 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=447 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
- [2.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), 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=453 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
- [2.08 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=454 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
- [2.81 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=461 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
- [4.91 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=465 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
- [3.05 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), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=467 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 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,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [7.02 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), 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=468 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 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,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [2.54 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), 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=469 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 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,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [1.90 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), 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=476 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 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,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
- [3.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), 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), 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=479 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 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,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
- [5.44 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=750 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
- [12.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=750 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [6.00 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=8 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
- [10.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) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=2121 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [5.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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2189 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.07 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=2194 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [1.81 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=2196 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
- [1.22 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=2198 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
- [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), 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=2199 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
- [5.26 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=203 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
- [16.35 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=204 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [5.04 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=207 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
- [3.73 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=206 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
- [1.84 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=208 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
- [4.78 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=205 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
- [7.12 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2206 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
- [2.77 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=2206 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [6.07 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=2235 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
- [2.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=2242 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [6.17 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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=338 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
- [11.32 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=346 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [4.73 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=339 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
- [6.25 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=340 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
- [5.46 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=341 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
- [5.84 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=345 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
- [10.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), 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=342 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
- [3.14 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=343 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
- [6.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=8 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=863 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.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) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=871 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
- [5.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.STATUS=1 AND college_state.STATE_ID=8 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
- [7.40 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
- [4.58 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
- [31.30 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=8 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
- [20.10 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=8 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
Timers
| type | calls | time (ms) |
|---|---|---|
| Configuration | 14 | 4.22 |
| Action "search/perma_state_program" | 1 | 899.14 |
| Database | 57 | 320.49 |
| View "Success" for "search/perma_state_program" | 1 | 142.83 |
| Component "search/campusSearchRightNav" | 1 | 10.36 |
| Partial "search/_campusSearchRightNav" | 1 | 39.05 |
| Component "featured/featuredSites" | 1 | 35.50 |
| Partial "featured/_featuredSites" | 1 | 0.55 |
| Component "search/searchBoxSmall" | 1 | 54.65 |
| Partial "search/_searchBoxSmall" | 1 | 2.43 |
| Partial "global/_vista" | 1 | 0.27 |
| Partial "global/_header" | 1 | 0.55 |
| Partial "global/_footer" | 1 | 0.27 |