Accessibility Tools
Hide
John C. Redfern, MD

Dr. Redfern was born and raised in Marietta, Georgia. After working several years as an engineer, he decided to change careers and attended the Medical College of Georgia in Augusta. He completed an orthopedic residency at the University of Southern California in Los Angeles, followed by an orthopedic sports medicine fellowship at the University of Utah in Salt Lake City.

Dr. Redfern and his wife, Roma, have a daughter and a son and enjoy many outdoor activities such as snow skiing, hiking, and running.

Area of Interest

In addition to general orthopedic care, Dr. Redfern has a particular interest in arthroscopic and open techniques for shoulder and knee disorders.

Learn more about John C. Redfern, MD: www.johnredfernmd.com

Philosophy Of Care

My mission is to provide a full range of orthopedic care to patients and remain at the forefront of orthopedic knowledge and techniques. My intention is to provide each patient with cost effective and respectful care with the goal of making a difference in the patients’ quality of life. I recognize that each patient is an individual with variable expectations and needs. Therefore, I strive to discuss all treatment options with the patient without bias so that we can decide on appropriate treatment for their individualized care

About John C. Redfern, MD
Education & Training

Fellowship

  • Orthopedic Sports Medicine Fellowship, University of Utah, Salt Lake City, UT

Residency

  • Orthopedic Surgery, University of Southern California, Los Angeles, CA

Undergraduate

  • BS in Chemical Engineering, Georgia Institute of Technology, Atlanta, GA
  • BS in Biochemistry, Georgia Institute of Technology, Atlanta, GA

Medical School

  • Medical College of Georgia, Augusta, GA
Distinctions
  • Board Certified: Candidate Member, American Board of Orthopaedic Surgery
  • Membership: Candidate Member, American Orthopaedic Society for Sports Medicine
  • Membership: Candidate Member, Arthroscopy Association of North America
  • Awards: Top Doc, Colorado Springs Style Magazine: 2023

Practice Locations

Videos

My Team

Phillip Falender, PA-C
Phillip Falender, PA-C
Physician Assistant to John C. Redfern, MD

Patient Reviews

  • Susanne M
    5.0/5

    Dr Redfern was the best. He actually cared to give me a full examination of my troubled shoulder area and LISTENED! He actually helped me feel better ... View More

  • Danita M
    5.0/5

    Great surgeon, not only did a fine job fixing my broken leg, but was very caring and answered all my questions with every follow up. View More

  • Phillip V
    5.0/5

    Very thorough explanation and very informative. Got me scheduled right away and listened about my injury View More

  • Tatiana V
    5.0/5

    I had a wonderful experience with Dr. Redfern. He delivers care with knowledge, professionalism, empathy and kindness. Dr. Redfern provided me with ac... View More

  • Mark A
    5.0/5

    Dr.Redfern did my Rght Shoulder almost 20 years and still swinging.He will do my Left Shoulder and I'm looking forward to it. Thank you Dr. Redfern an... View More

  • Vicki H
    5.0/5

    Dr. Redfern really listens. CSOG is a very busy practice but he takes his time to discuss issues and options. View More

Colorado Springs Locations
Orthopaedic Care Across Colorado Springs

Visit CSOG at convenient locations for specialty care, Express Care, imaging, therapy, and recovery support.

North Campus

4110 Briargate Parkway
Suite 300
Colorado Springs, CO 80920

Mon - Thu : 7:00 am to 5:00 pm
Fri : 7:00 am to 4:00 pm

Schedule an Appointment
South Campus

1655 Quail Lake Loop
Colorado Springs, CO 80906

Mon - Thu : 7:00 am to 5:00 pm
Fri : 7:00 am to 4:00 pm

Schedule an Appointment
East Campus

6140 Tutt Blvd
Suite 110
Colorado Springs, CO 80923

Mon - Fri : 7:00 am to 6:00 pm

Schedule an Appointment
Ready to Take the Next Step Toward Better Movement?

Whether you are dealing with a new injury, chronic pain, arthritis, or recovery after surgery, CSOG can help you find the right orthopaedic care path.

001 
SET 
    NAMES "utf8mb4" COLLATE "utf8mb4_unicode_ci"
FileFunctionLine
/home/csogy/public_html/database/Zebra_Database.phpquery()3907
/home/csogy/public_html/helpers/functions.phpset_charset()42
/home/csogy/public_html/models/YpoDatabase.phpgetConnection()22
/home/csogy/public_html/models/Provider.php__construct()27
/home/csogy/public_html/configs/common.php__construct()182
/home/csogy/public_html/common/common.phprequire_once()5
/home/csogy/public_html/profile.phprequire_once()3
002 
SELECT 
    DISTINCT T.* 
FROM 
    cs_page_alerts T 
    LEFT JOIN cs_page_alerts_page_urls PU ON (
        PU.page_alert_id = T.id 
        AND T.is_global = 0
    ) 
WHERE 
    T.status = '1' 
    AND (
        PU.page_url = 'https://csog.ypo.pw/physician/john-c-redfern-md/' 
        OR T.is_global = 1
    ) 
ORDER BY 
    T.is_global ASC, 
    T.id DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLETALL333.33Using where; Using temporary; Using filesort
1SIMPLEPUALL3100.00Using where; Distinct; Using join buffer (hash join)
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/PageAlert.phprawQuery()67
/home/csogy/public_html/models/PageAlert.phpgetCurrentPageAlerts()76
/home/csogy/public_html/configs/common.phpgetCurrentPageAlertsGrouped()185
/home/csogy/public_html/common/common.phprequire_once()5
/home/csogy/public_html/profile.phprequire_once()3
003 
SELECT 
    id 
FROM 
    cs_providers 
WHERE 
    slug = 'john-c-redfern-md' 
    AND status = 1
id
33
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_providersALL911.10Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()303
/home/csogy/public_html/profile.phpgetQsToID()15
004 
SELECT 
    T.*, 
    GROUP_CONCAT(
        DISTINCT PT.sh_name 
        ORDER BY 
            PT.sh_name SEPARATOR ', '
    ) AS sh_name, 
    GROUP_CONCAT(
        DISTINCT PT.type 
        ORDER BY 
            PT.type SEPARATOR ', '
    ) AS type_name 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_type PT ON FIND_IN_SET(PT.id, T.provider_type) > 0 
WHERE 
    T.id = '33' 
GROUP BY 
    T.id
idprovider_typefirst_namemiddle_namelast_namedegreeslugdesignationshort_titlegenderphotobioaccepting_new_patientphoneemailschedule_urlreferral_urlreview_urlsort_orderis_therapistsis_audubonstatuspublicationsphilosophy_careprofessional_affiliationsaccoladesarea_interestcommunity_outreachseo_titleseo_keywordsseo_descriptionis_abosis_aoacreated_atupdated_atsh_nametype_name
331John C.Redfern, MDjohn-c-redfern-mdFellowship Trained & Board Certified Orthopedic SurgeonJohn C. Redfern, MDMalejohn-c-redfern-md-1784566994.png<p>Dr. Redfern was born and raised in Marietta, Georgia. After working several years as an engineer, he decided to change careers and attended the Medical College of Georgia in Augusta. He completed an orthopedic residency at the University of Southern California in Los Angeles, followed by an orthopedic sports medicine fellowship at the University of Utah in Salt Lake City.</p><p>Dr. Redfern and his wife, Roma, have a daughter and a son and enjoy many outdoor activities such as snow skiing, hiking, and running.</p>https://www.johnredfernmd.comhttps://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=57220001<p>My mission is to provide a full range of orthopedic care to patients and remain at the forefront of orthopedic knowledge and techniques. My intention is to provide each patient with cost effective and respectful care with the goal of making a difference in the patients’ quality of life. I recognize that each patient is an individual with variable expectations and needs. Therefore, I strive to discuss all treatment options with the patient without bias so that we can decide on appropriate treatment for their individualized care</p><p>In addition to general orthopedic care, Dr. Redfern has a particular interest in arthroscopic and open techniques for shoulder and knee disorders.</p>102026-07-17 15:18:592026-10-06 17:09:14MDDoctor
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLETconstPRIMARYPRIMARY4const1100.00
1SIMPLEPTALL6100.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()272
/home/csogy/public_html/profile.phpgetRecord()20
005 
SELECT 
    PP.id, 
    PP.title, 
    PP.page_url, 
    PP.slug, 
    PP.type 
FROM 
    cs_specialties_condestions_procedures PP 
    INNER JOIN cs_provider_condestions_procedures PC ON PP.id = PC.condestion_id 
WHERE 
    PC.provider_id = '33' 
    AND PP.type = '1'
idtitlepage_urlslugtype
719Arthroscopic Surgery/sports-medicine/arthroscopic-surgery-orthopaedic-specialists-colorado-springs-co/arthroscopic-surgery1
509Knee Surgery/knee/knee-surgery-orthopaedic-specialists-colorado-springs-co/knee-surgery1
120Shoulder Surgery/shoulder/shoulder-surgery-orthopaedic-specialists-colorado-springs-co/shoulder-surgery1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEPCALL9010.00Using where
1SIMPLEPPeq_refPRIMARYPRIMARY4csogy_csog_db.PC.condestion_id110.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()293
/home/csogy/public_html/profile.phpgetProceduersList()26
006 
SELECT 
    PP.id, 
    PP.title, 
    PP.page_url, 
    PP.slug, 
    PP.type 
FROM 
    cs_specialties_condestions_procedures PP 
    INNER JOIN cs_provider_condestions_procedures PC ON PP.id = PC.condestion_id 
WHERE 
    PC.provider_id = '33' 
    AND PP.type = '2'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEPCALL9010.00Using where
1SIMPLEPPeq_refPRIMARYPRIMARY4csogy_csog_db.PC.condestion_id110.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()293
/home/csogy/public_html/profile.phpgetProceduersList()27
007 
SELECT 
    sp.id, 
    sp.specialty_name, 
    sp.slug, 
    sp.parent_id, 
    sp.page_url, 
    parent.specialty_name AS parent_name, 
    parent.slug AS parent_slug 
FROM 
    cs_provider_specialties ps 
    INNER JOIN cs_specialties sp ON sp.id = ps.specialty_id 
    LEFT JOIN cs_specialties parent ON parent.id = sp.parent_id 
WHERE 
    ps.provider_id = '33' 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name
idspecialty_nameslugparent_idpage_urlparent_nameparent_slug
4Shouldershoulder0/shoulder-orthopaedic-specialists-colorado-springs-co/
17Sports Medicinesports-medicine0/sports-medicine-orthopaedic-specialists-colorado-springs-co/
33Trauma & Fracture Caretrauma-fracture-care0
31General Orthopedicsgeneral-orthopedics34Orthopedic Surgeryorthopedic-surgery
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpsALL8010.00Using where; Using temporary; Using filesort
1SIMPLEspeq_refPRIMARYPRIMARY4csogy_csog_db.ps.specialty_id1100.00
1SIMPLEparenteq_refPRIMARYPRIMARY4csogy_csog_db.sp.parent_id1100.00
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()231
/home/csogy/public_html/profile.phpgetSpecalityWithAllList()29
008 
SELECT 
    * 
FROM 
    cs_provider_locations PL 
    INNER JOIN cs_locations L ON L.id = PL.location_id 
WHERE 
    PL.provider_id = '33'
idprovider_idlocation_idlocation_nameslugpage_urladdress1address2citystatezipcountryphonefaxemaillatitudelongitudeimagelocation_descriptionmap_iframeemergency_contactparking_informationstatuscreated_atupdated_at
1331North Campusnorth-campus/contact-north-campus-orthopaedic-specialists-colorado-springs-co/4110 Briargate Parkway Suite 300 Colorado Springs, CO80920(719) 632-7669(719) 632-0088satyam.ypo+1@gmail.com12026-08-10 11:34:44
2332South Campussouth-campus/contact-south-campus-orthopaedic-specialists-colorado-springs-co/1655 Quail Lake LoopColorado Springs, CO 80906(719) 632-7669(719) 632-0088satyam.ypo+1@gmail.com12026-08-10 11:34:52
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEPLALL15310.00Using where
1SIMPLELALLPRIMARY333.33Using where; Using join buffer (hash join)
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()255
/home/csogy/public_html/profile.phpgetLocationsByProivder()31
009 
SELECT 
    e.*, 
    et.title 
FROM 
    cs_provider_education e 
    INNER JOIN cs_education_types et on e.education_type = et.id 
WHERE 
    provider_id = '33'
idprovider_ideducation_typeinstitutelocationyeardescriptionsort_ordertitle
1883333Orthopedic Sports Medicine Fellowship, University of Utah, Salt Lake City, UTFellowship
1884332Orthopedic Surgery, University of Southern California, Los Angeles, CAResidency
1885338BS in Chemical Engineering, Georgia Institute of Technology, Atlanta, GAUndergraduate
1886338BS in Biochemistry, Georgia Institute of Technology, Atlanta, GAUndergraduate
1887331Medical College of Georgia, Augusta, GAMedical School
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEeALL15210.00Using where
1SIMPLEeteq_refPRIMARYPRIMARY4csogy_csog_db.e.education_type1100.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()315
/home/csogy/public_html/profile.phpgetEducation()33
010 
SELECT 
    * 
FROM 
    cs_provider_certifications 
WHERE 
    provider_id = '33'
idprovider_idcertificate_typetitledescriptionyearsort_order
103033Board CertifiedCandidate Member, American Board of Orthopaedic Surgery
103133MembershipCandidate Member, American Orthopaedic Society for Sports Medicine
103233MembershipCandidate Member, Arthroscopy Association of North America
103333AwardsTop Doc, Colorado Springs Style Magazine: 2023
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_provider_certificationsALL7810.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()330
/home/csogy/public_html/profile.phpgetCerification()35
011 
SELECT 
    t.* 
FROM 
    cs_provider_video t 
    INNER JOIN cs_providers p ON t.provider_id = p.id 
WHERE 
    p.id = 33
idprovider_idphotoembed_code
2833<iframe width="560" height="315" src="https://www.youtube.com/embed/NbEjwns5kFc?si=533JnD6f3IeO2Y41" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
2733<iframe width="560" height="315" src="https://www.youtube.com/embed/WirDHYLGEa4?si=gjTH1XhYiwSw85YS" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
2933<iframe width="560" height="315" src="https://www.youtube.com/embed/fzHiQXRA7H0?si=ricTEJJxmPfdkndg" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
3033<iframe width="560" height="315" src="https://www.youtube.com/embed/IwDK3cbyu7s?si=vTbbGg9t9aCexo70" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
3133<iframe width="560" height="315" src="https://www.youtube.com/embed/m8YUql1goyU?si=1fEw9BFq5jmpwdoi" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
3233<iframe width="560" height="315" src="https://www.youtube.com/embed/bTmLlEp8eL8?si=8DT7ZtibX3X4lT7r" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
3333<iframe width="560" height="315" src="https://www.youtube.com/embed/luXg1GYGDrk?si=-38FSnprtNBKALfG" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
3433<iframe width="560" height="315" src="https://www.youtube.com/embed/8jfjlFzv-aY?si=01OQbQE4p24YH5_m" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpconstPRIMARYPRIMARY4const1100.00Using index
1SIMPLEtALL7610.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()728
/home/csogy/public_html/profile.phpgetVidoesList()37
012 
SELECT 
    COUNT(DISTINCT t.id) AS num 
FROM 
    cs_testimonials t 
    INNER JOIN cs_websites_list w ON w.id = t.website_id 
    LEFT JOIN cs_providers ph ON t.provider_id = ph.id 
WHERE 
    1 
    AND t.is_verified = '2' 
    AND t.is_published = '1' 
    AND t.status = '1' 
    AND t.provider_id = '33'
num
6
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtALL1090.92Using where
1SIMPLEweq_refPRIMARYPRIMARY4csogy_csog_db.t.website_id1100.00Using where; Using index
1SIMPLEpheq_refPRIMARYPRIMARY4csogy_csog_db.t.provider_id1100.00Using where; Using index
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Testimonial.phprawQuerySingle()411
/home/csogy/public_html/profile.phpgetListOfRecords()42
013 
SELECT 
    t.id, 
    concat(
        t.first_name, 
        ' ', 
        UPPER(
            LEFT(t.last_name, 1)
        )
    ) as name, 
    t.email, 
    t.provider_id, 
    t.rating, 
    t.message, 
    t.source, 
    t.website_id, 
    t.is_published, 
    t.created_on, 
    t.status, 
    t.is_verified, 
    w.url as website, 
    ph.short_title 
FROM 
    cs_testimonials t 
    INNER JOIN cs_websites_list w ON w.id = t.website_id 
    LEFT JOIN cs_providers ph ON t.provider_id = ph.id 
WHERE 
    1 
    AND t.is_verified = '2' 
    AND t.is_published = '1' 
    AND t.status = '1' 
    AND t.provider_id = '33' 
GROUP BY 
    t.id 
ORDER BY 
    t.created_on DESC 
LIMIT 
    0, 1000
idnameemailprovider_idratingmessagesourcewebsite_idis_publishedcreated_onstatusis_verifiedwebsiteshort_title
155Susanne Mpavithra@yourpracticeonline.in335Dr Redfern was the best. He actually cared to give me a full examination of my troubled shoulder area and LISTENED! He actually helped me feel better where I was hurting and he gave me the best guidance on what to do next!1812026-09-30 09:30:2112johnredfernmd.ypo.pwJohn C. Redfern, MD
154Danita Mpavithra@yourpracticeonline.in335Great surgeon, not only did a fine job fixing my broken leg, but was very caring and answered all my questions with every follow up.1812026-09-30 09:29:3712johnredfernmd.ypo.pwJohn C. Redfern, MD
153Phillip Vpavithra@yourpracticeonline.in335Very thorough explanation and very informative. Got me scheduled right away and listened about my injury1812026-09-30 09:29:0512johnredfernmd.ypo.pwJohn C. Redfern, MD
152Tatiana Vpavithra@yourpracticeonline.in335I had a wonderful experience with Dr. Redfern. He delivers care with knowledge, professionalism, empathy and kindness. Dr. Redfern provided me with active listening and education regarding my diagnosis making me feel safe and confident about my health care decisions. I would doubtlessly recommend his practice!1812026-09-30 09:28:2012johnredfernmd.ypo.pwJohn C. Redfern, MD
151Mark Apavithra@yourpracticeonline.in335Dr.Redfern did my Rght Shoulder almost 20 years and still swinging.He will do my Left Shoulder and I'm looking forward to it. Thank you Dr. Redfern and Nursing team ❤️1812026-09-30 09:27:3012johnredfernmd.ypo.pwJohn C. Redfern, MD
150Vicki Hpavithra@yourpracticeonline.in335Dr. Redfern really listens. CSOG is a very busy practice but he takes his time to discuss issues and options.1812026-09-30 09:25:5012johnredfernmd.ypo.pwJohn C. Redfern, MD
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtindexPRIMARYPRIMARY41090.92Using where; Using temporary; Using filesort
1SIMPLEweq_refPRIMARYPRIMARY4csogy_csog_db.t.website_id1100.00Using index condition
1SIMPLEpheq_refPRIMARYPRIMARY4csogy_csog_db.t.provider_id1100.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Testimonial.phprawQuery()430
/home/csogy/public_html/profile.phpgetListOfRecords()42
014 
SELECT 
    T.*, 
    GROUP_CONCAT(
        DISTINCT PT.sh_name 
        ORDER BY 
            PT.sh_name SEPARATOR ', '
    ) AS sh_name, 
    GROUP_CONCAT(
        DISTINCT PT.type 
        ORDER BY 
            PT.type SEPARATOR ', '
    ) AS p_type 
FROM 
    cs_provider_assistant PA 
    INNER JOIN cs_providers T ON T.id = PA.assistant_id 
    INNER JOIN cs_provider_type PT ON FIND_IN_SET(PT.id, T.provider_type) > 0 
WHERE 
    PA.doctor_id = '33' 
    AND T.status = '1' 
GROUP BY 
    T.id
idprovider_typefirst_namemiddle_namelast_namedegreeslugdesignationshort_titlegenderphotobioaccepting_new_patientphoneemailschedule_urlreferral_urlreview_urlsort_orderis_therapistsis_audubonstatuspublicationsphilosophy_careprofessional_affiliationsaccoladesarea_interestcommunity_outreachseo_titleseo_keywordsseo_descriptionis_abosis_aoacreated_atupdated_atsh_namep_type
542PhillipFalender, PA-Cphillip-falender-pa-cPhillip Falender, PA-CMalephillip-falender-1791190973.jpg<p>In Colorado Springs, Phill has been directly involved with the care and treatment of professional and collegiate athletes, as well as Olympic Training Center athletes. He also completed a certification course to become a golf fitness instructor through the Titleist Performance Institute.</p><p>Phill’s wife, Lotta, is a marketing consultant, and they have three wonderful children. When the weather is warm Phill enjoys playing golf, but when the snow starts to fall, his true passion is skiing. Phill and Lotta enjoy Colorado Springs, and look forward to raising their children at the foot of the mountains.</p>0001<p>Phill is a physician assistant specializing in all aspects of Orthopaedics with primary focus in sports medicine. His extensive experience in orthopedic care, enables him to help his physicians treat even the most complex sports medicine cases.</p>002026-07-17 18:17:302026-10-05 14:32:53PAPhysician Assistant
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEPAALL3510.00Using where; Using temporary; Using filesort
1SIMPLETeq_refPRIMARYPRIMARY4csogy_csog_db.PA.assistant_id110.00Using where
1SIMPLEPTALL6100.00Using where; Using join buffer (hash join)
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()357
/home/csogy/public_html/profile.phpgetAssistentList()68
015 
SELECT 
    schema_text 
FROM 
    cs_provider_schema 
WHERE 
    provider_id = '33' 
    AND website_id = '1' 
ORDER BY 
    id DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_provider_schemaALL616.67Using where; Using filesort
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Schema.phprawQuerySingle()31
/home/csogy/public_html/includes/schema-file.phpgetSchemaDetails()3
/home/csogy/public_html/profile.phprequire_once()100
001
$_REQUEST 
array (
  'qs' => 'john-c-redfern-md',
)
001
$_POST 
array (
)
001
$_GET 
array (
  'qs' => 'john-c-redfern-md',
)
001
$_SESSION 
array (
)
001
$_COOKIE 
array (
  'PHPSESSID' => '3bda1cb3c7e7825da44ff85b74dc0e09',
)
001
$_FILES 
array (
)
001
$_SERVER 
array (
  'USER' => 'csogy',
  'HOME' => '/home/csogy',
  'SCRIPT_NAME' => '/profile.php',
  'REQUEST_URI' => '/physician/john-c-redfern-md/',
  'QUERY_STRING' => 'qs=john-c-redfern-md',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_QUERY_STRING' => 'qs=john-c-redfern-md',
  'REDIRECT_URL' => '/physician/john-c-redfern-md/',
  'REMOTE_PORT' => '7420',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/profile.php',
  'SERVER_ADMIN' => 'webmaster@csog.ypo.pw',
  'CONTEXT_DOCUMENT_ROOT' => '/home/csogy/public_html',
  'CONTEXT_PREFIX' => '',
  'REQUEST_SCHEME' => 'https',
  'DOCUMENT_ROOT' => '/home/csogy/public_html',
  'REMOTE_ADDR' => '216.73.216.171',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '172.31.81.87',
  'SERVER_NAME' => 'csog.ypo.pw',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin',
  'HTTP_X_HTTPS' => '1',
  'HTTP_HOST' => 'csog.ypo.pw',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_COOKIE' => 'PHPSESSID=3bda1cb3c7e7825da44ff85b74dc0e09',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_ACCEPT' => '*/*',
  'proxy-nokeepalive' => '1',
  'H2_STREAM_TAG' => '1877161-606-59',
  'H2_STREAM_ID' => '59',
  'H2_PUSHED_ON' => '',
  'H2_PUSHED' => '',
  'H2_PUSH' => 'off',
  'H2PUSH' => 'off',
  'HTTP2' => 'on',
  'SSL_TLS_SNI' => 'csog.ypo.pw',
  'HTTPS' => 'on',
  'GOOGLE_APPLICATION_CREDENTIALS' => '/home/csogy/public_html/mobileapp/notifications/config/firebase-service-account.json',
  'HTTP_AUTHORIZATION' => '',
  'SCRIPT_URI' => 'https://csog.ypo.pw/physician/john-c-redfern-md/',
  'SCRIPT_URL' => '/physician/john-c-redfern-md/',
  'UNIQUE_ID' => 'avj8GNnzTe5gLFgPBCW-ygAA0Qo',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1877161-606-59',
  'REDIRECT_H2_STREAM_ID' => '59',
  'REDIRECT_H2_PUSHED_ON' => '',
  'REDIRECT_H2_PUSHED' => '',
  'REDIRECT_H2_PUSH' => 'off',
  'REDIRECT_H2PUSH' => 'off',
  'REDIRECT_HTTP2' => 'on',
  'REDIRECT_SSL_TLS_SNI' => 'csog.ypo.pw',
  'REDIRECT_HTTPS' => 'on',
  'REDIRECT_GOOGLE_APPLICATION_CREDENTIALS' => '/home/csogy/public_html/mobileapp/notifications/config/firebase-service-account.json',
  'REDIRECT_HTTP_AUTHORIZATION' => '',
  'REDIRECT_SCRIPT_URI' => 'https://csog.ypo.pw/physician/john-c-redfern-md/',
  'REDIRECT_SCRIPT_URL' => '/physician/john-c-redfern-md/',
  'REDIRECT_UNIQUE_ID' => 'avj8GNnzTe5gLFgPBCW-ygAA0Qo',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/profile.php',
  'REQUEST_TIME_FLOAT' => 1794702360.32804107666015625,
  'REQUEST_TIME' => 1794702360,
  'argv' => 
  array (
    0 => 'qs=john-c-redfern-md',
  ),
  'argc' => 1,
)
15 / 0