Accessibility Tools
Hide
Jamie L. Friedman, MD

Dr. Jamie Friedman specializes in treating a full range of sports injuries and specializes in complex injuries involving the shoulder and knee. Her fellowship training included both arthroscopic and open shoulder surgery including revisions as well as cartilage restoration procedures of the knee.

Area of Interest

As a Colorado Native she understands the active population of Colorado and enjoys taking care of their orthopaedic needs. As a former athlete, she has sustained several sports injuries herself, so she also understands how important it is to get patients back to the life they love.

She is married to Justin, an Army Veteran and current aerospace engineer. They enjoy doing outdoor activities with their two daughters including skiing, mountain biking, and camping

Learn more about Jamie L. Friedman, MD: www.jamiefriedmanmd.com

Philosophy Of Care

I have a passion for treating people of all ages and activity levels, from elite athletes to people who want to reduce pain during work or leisure activities. It’s important for me to spend time with each patient to understand their injury as well as their individual treatment goals. Coming up with a plan together and helping a patient to improve their quality of life is what I love most about this job.

About Jamie L. Friedman, MD
Education & Training

Fellowship

  • Sports Medicine, University of Colorado, Denver, CO

Residency

  • Orthopaedic Surgery, University of Connecticut, Farmington, CT

Medical School

  • Virginia Commonwealth University, Richmond, VA

Undergraduate

  • BS is Biochemistry, University of California at Santa Barbara, Santa Barbara, CA
  • BA in Mathematics, University of California at Santa Barbara, Santa Barbara, CA
Distinctions
  • Memberships & Board Certification: American Board of Orthopaedic Surgery
  • American Academy of Orthopaedic Surgeons
  • American Orthopaedic Society for Sports Medicine
  • Arthroscopy Association of North America
  • Ruth Jackson Orthopaedic Society
  • Team Physician (2019-2020): Colorado Avalanche Hockey
  • Colorado Mammoth Lacrosse
  • University of Colorado (Football and Men’s Basketball)
  • Denver University Hockey
Publications

Aircast Award for Clinical Science, American Orthopaedic Society for Sports Medicine, Baltimore, MD
“Biceps Tenotomy Versus Tenodesis in Active Patients Younger Than 55 Years: Is There
Difference in Strength and Outcomes?”

1st Place Poster at the Dean’s Symposium for Continuous Quality Improvement & Patient Safety, Farmington, CT
“Incidence of Post-Operative Complications Following Implementation of a Checklist”

Friedman JL, FitzPatrick JL, Rylander LS, Bennett C, Vidal AF, McCarty EC.
Biceps Tenotomy Versus Tenodesis in Active Patients Younger Than 55 Years: Is There a Difference in Strength and Outcomes?
Orthop J Sports Med. 2015 Feb. 12;3(2):2325967115570848.
Presented American Orthopaedic Society for Sports Medicine; Baltimore, MD. 2012
Received the Aircast Award for Clinic Science

Friedman JL, Yang JS, Vogel LA, Arciero RA.
Correlation of the Exam Under Anesthesia with Glenoid Track Measurements for Shoulder Instability: A Clinical Tool to Assess Bone Loss
Arthroscopy. 2019 Dec.
Presented at Arthroscopic Association of North America; Orlando, FL. 2019

Otto A, Friedman JL, Szolomayer LK, Baldino JB, Obopilwe E, Mazzocca AD, Arciero RA.
Semitendinosus vs. Gracilis Grafts With 1- vs. 2-Tunnel Techniques for Coracoclavicular Ligament Reconstruction: A Biomechanical Study
AM J Sports Med.  2022 Jun;50(7):1983-1989.

Smith JR, Belk JW, Friedman JL, Dragoo JL, Frank RM, Bravman JT, Wolcott ML, McCarty EC. Predictors of Mid- to Long-Term Outcomes in Patients Experiencing a Knee Dislocation: A Systematic Review of Clinical Studies
J Knee Surg.  2022 Oct;35(12):1333-1341

Salem H, Park D, Friedman JL, Jones SD, Bravman JT, McCarty EC, Frank RM. Return to Driving after Anterior Cruciate Ligament Reconstruction: A Systematic Review.
Orthop J Sports Med 2021 Jan 21;9(1):2325967120968556.

“Incidence of Post-Operative Complications Following Implementation of a Checklist”
1st Place Poster at the Dean’s Symposium for Continuous Quality Improvement & Patient Safety, Farmington, CT

Wolf MR, Williams AA, Friedman JL, Shea KP. Arthroscopic Capsular Release and Debridement of Painful Shoulder Osteoarthritis in Patients with Loss of Motion: A Mid- to Long-Term Follow-up Study.
Arthroscopy. 2017 Oct

Friedman J, Ly A, Mauffrey C, Stahel PF. Temporary Transarticular K-wire Fixation of Critical Ankle Injuries at Risk: A Neglected “Damage Control” Strategy? Orthopedics. 2015 Feb. 38 (2):122-7.

Practice Locations

Videos

My Team

Nicole Derby, PA-C
Nicole Derby, PA-C
Physician Assistant to Jamie L. Friedman, MD

Patient Reviews

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/jamie-l-friedman-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 = 'jamie-l-friedman-md' 
    AND status = 1
id
31
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 = '31' 
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
311Jamie L.Friedman, MDjamie-l-friedman-mdFellowship Trained & Board Certified Orthopedic SurgeonJamie L. Friedman, MDFemalejamie-l-friedman-md-1784567065.png<p>Dr. Jamie Friedman specializes in treating a full range of sports injuries and specializes in complex injuries involving the shoulder and knee. Her fellowship training included both arthroscopic and open shoulder surgery including revisions as well as cartilage restoration procedures of the knee.</p>https://www.jamiefriedmanmd.comhttps://iframe.socialclime.com/iframe/a1f9f627-392e-4f62-a0ec-2c9ffa2ddac3/reviews?doc=1353660001<p>Aircast Award for Clinical Science, American Orthopaedic Society for Sports Medicine, Baltimore, MD<br>“Biceps Tenotomy Versus Tenodesis in Active Patients Younger Than 55 Years: Is There<br>Difference in Strength and Outcomes?”</p><p>1st Place Poster at the Dean’s Symposium for Continuous Quality Improvement &amp; Patient Safety, Farmington, CT<br>“Incidence of Post-Operative Complications Following Implementation of a Checklist”</p><p><strong>Friedman JL</strong>, FitzPatrick JL, Rylander LS, Bennett C, Vidal AF, McCarty EC.<br>Biceps Tenotomy Versus Tenodesis in Active Patients Younger Than 55 Years: Is There a Difference in Strength and Outcomes?<br>Orthop J Sports Med. 2015 Feb. 12;3(2):2325967115570848.<br><strong>Presented American Orthopaedic Society for Sports Medicine; Baltimore, MD. 2012</strong><br><strong>Received the Aircast Award for Clinic Science</strong></p><p><strong>Friedman JL, </strong>Yang JS, Vogel LA, Arciero RA.<br>Correlation of the Exam Under Anesthesia with Glenoid Track Measurements for Shoulder Instability: A Clinical Tool to Assess Bone Loss<br>Arthroscopy. 2019 Dec.<br><strong>Presented at Arthroscopic Association of North America; Orlando, FL. 2019</strong></p><p><strong>Otto A, Friedman JL</strong>, Szolomayer LK, Baldino JB, Obopilwe E, Mazzocca AD, Arciero RA.<br>Semitendinosus vs. Gracilis Grafts With 1- vs. 2-Tunnel Techniques for Coracoclavicular Ligament Reconstruction: A Biomechanical Study<br>AM J Sports Med.&nbsp; 2022 Jun;50(7):1983-1989.</p><p>Smith JR, Belk JW,&nbsp;<strong>Friedman JL</strong>, Dragoo JL, Frank RM, Bravman JT, Wolcott ML, McCarty EC. Predictors of Mid- to Long-Term Outcomes in Patients Experiencing a Knee Dislocation: A Systematic Review of Clinical Studies<br>J Knee Surg.&nbsp; 2022 Oct;35(12):1333-1341</p><p>Salem H, Park D,&nbsp;<strong>Friedman JL</strong>, Jones SD, Bravman JT, McCarty EC, Frank RM. Return to Driving after Anterior Cruciate Ligament Reconstruction: A Systematic Review.<br>Orthop J Sports Med 2021 Jan 21;9(1):2325967120968556.</p><p>“Incidence of Post-Operative Complications Following Implementation of a Checklist”<br><strong>1st Place Poster at the Dean’s Symposium for Continuous Quality Improvement &amp; Patient Safety, Farmington, CT</strong></p><p>Wolf MR, Williams AA,&nbsp;<strong>Friedman JL</strong>, Shea KP. Arthroscopic Capsular Release and Debridement of Painful Shoulder Osteoarthritis in Patients with Loss of Motion: A Mid- to Long-Term Follow-up Study.<br>Arthroscopy. 2017 Oct</p><p><strong>Friedman J</strong>, Ly A, Mauffrey C, Stahel PF. Temporary Transarticular K-wire Fixation of Critical Ankle Injuries at Risk: A Neglected “Damage Control” Strategy? Orthopedics. 2015 Feb. 38 (2):122-7.</p><p>I have a passion for treating people of all ages and activity levels, from elite athletes to people who want to reduce pain during work or leisure activities. It’s important for me to spend time with each patient to understand their injury as well as their individual treatment goals. Coming up with a plan together and helping a patient to improve their quality of life is what I love most about this job.</p><p>As a Colorado Native she understands the active population of Colorado and enjoys taking care of their orthopaedic needs. As a former athlete, she has sustained several sports injuries herself, so she also understands how important it is to get patients back to the life they love.</p><p>She is married to Justin, an Army Veteran and current aerospace engineer. They enjoy doing outdoor activities with their two daughters including skiing, mountain biking, and camping</p>102026-07-17 15:02:152026-10-06 16:59:56MDDoctor
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 = '31' 
    AND PP.type = '1'
idtitlepage_urlslugtype
735Cartilage Restoration/sports-medicine/cartilage-restoration-orthopaedic-specialists-colorado-springs-co/cartilage-restoration1
505Knee Arthroscopy/knee/knee-arthroscopy-orthopaedic-specialists-colorado-springs-co/knee-arthroscopy1
96Shoulder Joint Replacement/shoulder/shoulder-joint-replacement-orthopaedic-specialists-colorado-springs-co/shoulder-joint-replacement1
94Shoulder Arthroscopy/shoulder/shoulder-arthroscopy-orthopaedic-specialists-colorado-springs-co/shoulder-arthroscopy1
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 = '31' 
    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 = '31' 
ORDER BY 
    parent.specialty_name, 
    sp.specialty_name
idspecialty_nameslugparent_idpage_urlparent_nameparent_slug
15Kneeknee0/knee-orthopaedic-specialists-colorado-springs-co/
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 = '31'
idprovider_idlocation_idlocation_nameslugpage_urladdress1address2citystatezipcountryphonefaxemaillatitudelongitudeimagelocation_descriptionmap_iframeemergency_contactparking_informationstatuscreated_atupdated_at
1311North 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
2312South 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 = '31'
idprovider_ideducation_typeinstitutelocationyeardescriptionsort_ordertitle
1868313Sports Medicine, University of Colorado, Denver, COFellowship
1869312Orthopaedic Surgery, University of Connecticut, Farmington, CTResidency
1870311Virginia Commonwealth University, Richmond, VAMedical School
1871318BS is Biochemistry, University of California at Santa Barbara, Santa Barbara, CAUndergraduate
1872318BA in Mathematics, University of California at Santa Barbara, Santa Barbara, CAUndergraduate
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 = '31'
idprovider_idcertificate_typetitledescriptionyearsort_order
101831Memberships & Board CertificationAmerican Board of Orthopaedic Surgery
101931 American Academy of Orthopaedic Surgeons
102031 American Orthopaedic Society for Sports Medicine
102131 Arthroscopy Association of North America
102231 Ruth Jackson Orthopaedic Society
102331Team Physician (2019-2020)Colorado Avalanche Hockey
102431 Colorado Mammoth Lacrosse
102531 University of Colorado (Football and Men’s Basketball)
102631 Denver University Hockey
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 = 31
idprovider_idphotoembed_code
831<iframe width="560" height="315" src="https://www.youtube.com/embed/77XTPPqSUeI?si=_tbdjD9e4cdXw-ct" 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>
931<iframe width="560" height="315" src="https://www.youtube.com/embed/PwTYfj7iFVs?si=q1YEkaPqe5PrCKkD" 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>
1031<iframe width="560" height="315" src="https://www.youtube.com/embed/LntVC2Yov7A?si=shP7yk7E-HOw8UYm" 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>
1131<iframe width="560" height="315" src="https://www.youtube.com/embed/30qnEYZJPvY?si=cE7V9mWn__5CE4Aw" 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>
1231<iframe width="560" height="315" src="https://www.youtube.com/embed/hlG0rmEqSyw?si=x3-sSUNISEfPm_jF" 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>
1331<iframe width="560" height="315" src="https://www.youtube.com/embed/65IPPaREA-4?si=CUeDUsDu0IS0DSRF" 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>
1431<iframe width="560" height="315" src="https://www.youtube.com/embed/Cfl3G0OQIXI?si=ZREHGK-O5ebrfX_G" 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 = '31'
num
0
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 = '31' 
GROUP BY 
    t.id 
ORDER BY 
    t.created_on DESC 
LIMIT 
    0, 1000
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 = '31' 
    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
492NicoleDerby, PA-Cnicole-derby-pa-cNicole Derby, PA-CFemalenicole-derby-pa-c-1784569924.png<p>Nicole Derby, PA-C is a certified physician assistant working in close collaboration with Jamie L. Friedman, MD. Nicole earned a Bachelor degree from the Duke University Physician Assistant Program, Durham, NC. Dedicated to high-quality orthopaedic care, Nicole assists in patient evaluations, treatment planning, and surgical support to help patients recover and stay active. </p>0001<p>Nicole was born and raised in Rochester, New York. She completed her undergraduate degree at the University of Rochester in Rochester, NY where she majored in both Neuroscience and Psychology and played on the women’s varsity soccer team. She then attended Duke University in Durham, North Carolina and completed her Masters in Physician Assistant Studies.</p><p>After graduation, Nicole worked for an orthopedic practice in Albany, NY before joining Colorado Springs Orthopaedic Group, where she is focused on the treatment of orthopedic sports medicine injuries.</p><p>Nicole and her boyfriend moved to Colorado Springs in the summer of 2024. They thoroughly enjoy many of the outdoor activities Colorado has to offer, including trail hiking and biking.&nbsp; She also enjoys running, CrossFit, traveling and spending time at home with their two crazy cats.</p>002026-07-17 17:39:492026-08-03 22:34:52PAPhysician 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 = '31' 
    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' => 'jamie-l-friedman-md',
)
001
$_POST 
array (
)
001
$_GET 
array (
  'qs' => 'jamie-l-friedman-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/jamie-l-friedman-md/',
  'QUERY_STRING' => 'qs=jamie-l-friedman-md',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_QUERY_STRING' => 'qs=jamie-l-friedman-md',
  'REDIRECT_URL' => '/physician/jamie-l-friedman-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-109',
  'H2_STREAM_ID' => '109',
  '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/jamie-l-friedman-md/',
  'SCRIPT_URL' => '/physician/jamie-l-friedman-md/',
  'UNIQUE_ID' => 'avj8G9nzTe5gLFgPBCW-4wAA0Qo',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1877161-606-109',
  'REDIRECT_H2_STREAM_ID' => '109',
  '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/jamie-l-friedman-md/',
  'REDIRECT_SCRIPT_URL' => '/physician/jamie-l-friedman-md/',
  'REDIRECT_UNIQUE_ID' => 'avj8G9nzTe5gLFgPBCW-4wAA0Qo',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/profile.php',
  'REQUEST_TIME_FLOAT' => 1794702363.10846710205078125,
  'REQUEST_TIME' => 1794702363,
  'argv' => 
  array (
    0 => 'qs=jamie-l-friedman-md',
  ),
  'argc' => 1,
)
15 / 0