Accessibility Tools

Patient-Specific Shoulder Replacement

Shoulder Service

Colorado Springs Orthopaedic Group

Your shoulder is one of the body's most mobile joints, allowing you to reach, lift, rotate, and perform countless everyday movements. Because of this mobility, the shoulder can also be susceptible to injuries, overuse, arthritis, and other conditions that cause pain and limit movement.

CSOG provides comprehensive evaluation and treatment for a wide range of shoulder conditions, from sports injuries and tendon problems to arthritis, instability, and fractures. Depending on your condition, treatment may include physical therapy, activity modification, medications, injections, minimally invasive procedures, or surgery.

Our shoulder specialists take the time to understand your symptoms, activity level, and goals so you can receive treatment designed to reduce pain, improve function, and help you get back to the activities that are important to you.

What is Patient-Specific Shoulder Replacement?

Shoulder replacement, also referred to as shoulder arthroplasty, is a procedure in which the damaged articulating parts of the shoulder joint are removed and replaced with artificial prostheses to restore shoulder function.

The shoulder is a highly movable body joint that allows various movements of the arm. It is a ball-and-socket joint, where the head of the humerus (upper arm bone) articulates with the socket of the scapula (shoulder blade) called the glenoid. The two articulating surfaces of the bones are covered with cartilage, which prevents friction between the moving bones. The cartilage is lubricated by synovial fluid. Tendons and ligaments around the shoulder joint provide strength and stability to the joint.

Shoulder replacement is a demanding procedure with a known complication rate. Most complications are connected with the malposition of the glenoid component of the shoulder. Patient-specific shoulder replacement was developed to counter this deficiency and offer increased accuracy in the placement of the glenoid component, which improves the likelihood of an optimal outcome. Patient-specific shoulder replacement is an innovative technology in shoulder replacement surgery. It is an advanced procedure using an individualized patient-specific shoulder implant for the replacement of shoulder components. The difference with patient-specific shoulder replacement from standard shoulder replacement surgery is the use of an MRI scan prior to the surgery that provides a clear view of the shape and structure of the shoulder joint, especially the glenoid component. Based on the MRI images, your surgeon calculates the precise cutting measurements that help the surgeon to remove the required amount of bone, at specific angles. This customized cut provides better implantation, more reliable alignment, and removal of less bone. Accurate glenoid component placement is of utmost importance in shoulder arthroplasty. Improperly placed implants are at risk of dislocation, increased component wear and loosening, and the need for revision surgery.

What are the Indications for Patient-Specific Shoulder Replacement?

Your surgeon may recommend patient-specific shoulder replacement for conditions such as osteoarthritis or rheumatoid arthritis of the shoulder joint when medication, injections, physical therapy, and activity changes have not helped to relieve the pain or improve shoulder function, severe shoulder joint trauma, or for a revision/failed shoulder replacement surgery.

What Does Preparation for Patient-Specific Shoulder Replacement Involve?

The preoperative preparation is similar to most shoulder replacement procedures. But contrary to traditional techniques, patient-specific shoulder replacement involves careful planning and utilizes a series of CT scans to generate 3D images of an individual’s unique shoulder joint anatomy. These images enable your surgeon to design a personalized pre-surgical plan and patient-specific instrumentation to facilitate a more precise glenoid component positioning.

In general, preparation for patient-specific shoulder replacement may involve the following steps:

  • A review of your medical history and a physical examination by your doctor to check for any medical issues that need to be addressed prior to surgery.
  • Diagnostic tests such as blood work and imaging to help detect any abnormalities that could compromise the safety of the procedure.
  • You will be asked if you have allergies to medications, anesthesia, or latex.
  • You should inform your doctor of any medications or supplements that you are taking or any conditions you have such as heart or lung disease.
  • You may be asked to avoid medications such as blood thinners or anti-inflammatories for a specific period prior to surgery.
  • You should refrain from alcohol or tobacco at least a few days prior to the surgery and several days after as they can hinder the healing process.
  • You should not consume solids or liquids at least 8 hours prior to surgery.
  • You should arrange for someone to drive you home after surgery.
  • A signed informed consent form will be obtained from you after the pros and cons of the surgery have been explained.

What is the Procedure for Patient-Specific Shoulder Replacement?

Patient-specific shoulder replacement surgery is usually performed under general anesthesia. A surgical cut is made over the shoulder to expose the shoulder joint, and the upper arm bone is dislocated from the shoulder socket. The surface of the socket is cleaned and the damaged or arthritic bone is removed using a reamer. A patient-specific shoulder implant is then placed as per pre-surgical planning and patient-specific surgical guides. The preoperative plan and patient-specific instrumentation help to increase the procedure's efficiency, as well as preserve bone and optimize the positioning of the implant. With all the new components in place, the shoulder joint is tested through its range of motion. At the end of the procedure, muscles and other soft-tissue structures are positioned back to cover the shoulder joint, and the incision is closed with sutures and covered with a sterile dressing.

What Does Postoperative Care for Patient-Specific Shoulder Replacement Involve?

In general, postoperative care instructions and recovery after patient-specific shoulder replacement will involve the following steps:

  • You will be transferred to the recovery area where your nurse will closely observe you for any allergic/anesthetic reactions and monitor your vital signs as you recover.
  • You may need to stay in the hospital for at least 2 to 3 days before discharge to home.
  • You are likely to experience pain, swelling, and discomfort in the shoulder area. Pain and anti-inflammatory medications are provided as needed to address these.
  • Your arm will be secured with an immobilizer or assistive device such as a sling for the first few weeks to facilitate healing and protect the repair.
  • Instructions on surgical site care and bathing will be provided to keep the surgical site clean and dry.
  • Refrain from overhead activities and lifting heavy weights for the first couple of months. A gradual increase in activities over a period of time is recommended.
  • You will need to take off work for at least a week to rest and promote healing.
  • You will not be able to drive until you are fully fit and able to hold the steering wheel comfortably in both arms.
  • An individualized physical therapy protocol will be designed to help strengthen shoulder muscles and optimize shoulder function.
  • Most patients are able to resume their normal activities in a month or two after surgery; however, returning to sports may take at least 6 months or longer.
  • Refrain from driving until you are fully fit and receive your doctor’s consent.
  • A periodic follow-up appointment will be scheduled to monitor your progress.

What are the Risks and Complications of Patient-Specific Shoulder Replacement?

Patient-specific shoulder replacement is a relatively safe procedure; however, as with any surgery, some risks and complications may occur, such as:

  • Infection
  • Blood clots
  • Injury to nerves and vessels
  • Bleeding
  • Instability
  • Stiffness
  • Swelling and pain
  • Anesthetic/allergic reaction

For more information about our services or to schedule an appointment, call us at or click here to request an appointment online. We'll respond to you as soon as possible.

How Can You Reach CSOG Shoulder Center
  • Send a Referral
  • Send Medical Records
  • Additional Inquires
Colorado Springs Locations
Orthopaedic Care Across Colorado Springs

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

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

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

6140 Tutt Blvd
Suite 110
Colorado Springs, CO 80923

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

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/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.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/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/' 
        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/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()3
003
WARNING: The first few results returned by this query are the same as returned by 2 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    id = '4'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
40Shouldershoulder/shoulder-orthopaedic-specialists-colorado-springs-co/012026-07-15 17:55:08
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialtiesconstPRIMARYPRIMARY4const1100.00
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Speciality.phprawQuerySingle()50
/home/csogy/public_html/includes/speacialist-list.phpgetRecord()3
/home/csogy/public_html/includes/shoulder-speacialist.phprequire_once()1
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
004
(
    SELECT 
        D.id, 
        D.designation, 
        D.slug, 
        D.short_title, 
        D.provider_type, 
        D.photo, 
        PT.sh_name, 
        PT.type AS p_type, 
        0 as dr_short_title, 
        0 as dr_id, 
        0 as dr_slug 
    FROM 
        cs_providers D 
        INNER JOIN cs_provider_specialties PS ON PS.provider_id = D.id 
        INNER JOIN cs_provider_type PT ON FIND_IN_SET(PT.id, D.provider_type) > 0 
    WHERE 
        PS.specialty_id = '4' 
        AND D.status = 1 
    GROUP BY 
        D.id
) 
UNION 
    (
        SELECT 
            A.id, 
            A.designation, 
            A.slug, 
            A.short_title, 
            A.provider_type, 
            A.photo, 
            PT.sh_name, 
            PT.type AS p_type, 
            D.short_title AS dr_short_title, 
            D.id as dr_id, 
            D.slug as dr_slug 
        FROM 
            cs_provider_specialties PS 
            INNER JOIN cs_providers D ON D.id = PS.provider_id 
            INNER JOIN cs_provider_assistant PA ON PA.doctor_id = D.id 
            INNER JOIN cs_providers A ON A.id = PA.assistant_id 
            INNER JOIN cs_provider_type PT ON FIND_IN_SET(PT.id, A.provider_type) > 0 
        WHERE 
            PS.specialty_id = '4' 
            AND FIND_IN_SET(1, D.provider_type) > 0 
            AND D.status = 1 
            AND A.status = 1 
        GROUP BY 
            A.id
    ) 
ORDER BY 
    provider_type, 
    short_title
iddesignationslugshort_titleprovider_typephotosh_namep_typedr_short_titledr_iddr_slug
39Fellowship Trained & Board Certified Orthopedic Surgeoncraig-a-yager-mdCraig A. Yager, MD1craig-a-yager-md-1784566587.pngMDDoctor000
31Fellowship Trained & Board Certified Orthopedic Surgeonjamie-l-friedman-mdJamie L. Friedman, MD1jamie-l-friedman-md-1784567065.pngMDDoctor000
33Fellowship Trained & Board Certified Orthopedic Surgeonjohn-c-redfern-mdJohn C. Redfern, MD1john-c-redfern-md-1784566994.pngMDDoctor000
58kristen-reiss-pa-cKristen Reiss, PA-C2kristen-reiss-pa-c-1784570323.pngPAPhysician AssistantCraig A. Yager, MD39craig-a-yager-md
49nicole-derby-pa-cNicole Derby, PA-C2nicole-derby-pa-c-1784569924.pngPAPhysician AssistantJamie L. Friedman, MD31jamie-l-friedman-md
54phillip-falender-pa-cPhillip Falender, PA-C2phillip-falender-1791190973.jpgPAPhysician AssistantJohn C. Redfern, MD33john-c-redfern-md
126rebecca-debalski-pa-cRebecca DeBalski, PA-C2rebecca-debalski-pac-1790826550.jpgPAPhysician AssistantCraig A. Yager, MD39craig-a-yager-md
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPTALL6100.00Using temporary
1PRIMARYPSALL8010.00Using where; Using join buffer (hash join)
1PRIMARYDeq_refPRIMARYPRIMARY4csogy_csog_db.PS.provider_id110.00Using where
2UNIONPTALL6100.00Using temporary
2UNIONPSALL8010.00Using where; Using join buffer (hash join)
2UNIONDeq_refPRIMARYPRIMARY4csogy_csog_db.PS.provider_id110.00Using where
2UNIONPAALL3510.00Using where; Using join buffer (hash join)
2UNIONAeq_refPRIMARYPRIMARY4csogy_csog_db.PA.assistant_id110.00Using where
3UNION RESULT<union1,2>ALLUsing temporary; Using filesort
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Provider.phprawQuery()529
/home/csogy/public_html/includes/speacialist-list.phpgetSpecalityListDrWithAssitents()4
/home/csogy/public_html/includes/shoulder-speacialist.phprequire_once()1
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
005
WARNING: The first few results returned by this query are the same as returned by 1 other queries!
SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '58' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
39craig-a-yager-mdCraigYager, MDCraig A. Yager, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/shoulder-speacialist.phprequire_once()1
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
006
SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '49' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
31jamie-l-friedman-mdJamie L.Friedman, MDJamie L. Friedman, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/shoulder-speacialist.phprequire_once()1
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
007
SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '54' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
33john-c-redfern-mdJohn C.Redfern, MDJohn C. Redfern, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/shoulder-speacialist.phprequire_once()1
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
008
WARNING: The first few results returned by this query are the same as returned by 1 other queries!
SELECT 
    T.id, 
    T.slug, 
    T.first_name, 
    T.last_name, 
    T.short_title, 
    S.specialty_name, 
    S.page_url AS s_page_url 
FROM 
    cs_providers T 
    INNER JOIN cs_provider_assistant PA ON PA.doctor_id = T.id 
    LEFT JOIN cs_provider_specialties PS ON PS.provider_id = PA.doctor_id 
    LEFT JOIN cs_specialties S ON S.id = PS.specialty_id 
WHERE 
    PA.assistant_id = '126' 
    AND T.status = '1' 
    AND (
        PS.list_of_order IS NULL 
        OR PS.list_of_order = (
            SELECT 
                MIN(ps_sub.list_of_order) 
            FROM 
                cs_provider_specialties ps_sub 
            WHERE 
                ps_sub.provider_id = T.id
        )
    ) 
ORDER BY 
    PS.list_of_order ASC
idslugfirst_namelast_nameshort_titlespecialty_names_page_url
39craig-a-yager-mdCraigYager, MDCraig A. Yager, MDSports Medicine/sports-medicine-orthopaedic-specialists-colorado-springs-co/
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1PRIMARYPAALL3510.00Using where; Using temporary; Using filesort
1PRIMARYTeq_refPRIMARYPRIMARY4csogy_csog_db.PA.doctor_id110.00Using where
1PRIMARYPSALL80100.00Using where; Using join buffer (hash join)
1PRIMARYSeq_refPRIMARYPRIMARY4csogy_csog_db.PS.specialty_id1100.00
2DEPENDENT SUBQUERYps_subALL8010.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Provider.phprawQuerySingle()688
/home/csogy/public_html/includes/speacialist-list.phpgetPysicianProfileByAssitent()57
/home/csogy/public_html/includes/shoulder-speacialist.phprequire_once()1
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
009
WARNING: The first few results returned by this query are the same as returned by 2 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    id = '4'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
40Shouldershoulder/shoulder-orthopaedic-specialists-colorado-springs-co/012026-07-15 17:55:08
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialtiesconstPRIMARYPRIMARY4const1100.00
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()68
/home/csogy/public_html/models/Speciality.phprawQuerySingle()50
/home/csogy/public_html/includes/specialty-sidebar.phpgetRecord()2
/home/csogy/public_html/includes/shoulder-sidebar.phprequire_once()20
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()104
010
WARNING: The first few results returned by this query are the same as returned by 2 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    parent_id = '4' 
    OR id = '4' 
GROUP BY 
    id
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
40Shouldershoulder/shoulder-orthopaedic-specialists-colorado-springs-co/012026-07-15 17:55:08
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialtiesindex_mergePRIMARY,idx_parentidx_parent,PRIMARY5,42100.00Using union(idx_parent,PRIMARY); Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Speciality.phprawQuery()60
/home/csogy/public_html/includes/specialty-sidebar.phpgetSubSplaityList()14
/home/csogy/public_html/includes/shoulder-sidebar.phprequire_once()20
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()104
011
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '4' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
94Shoulder Arthroscopy/shoulder/shoulder-arthroscopy-orthopaedic-specialists-colorado-springs-co/41shoulder-arthroscopy1
95Rotator Cuff Repair/shoulder/rotator-cuff-repair-orthopaedic-specialists-colorado-springs-co/41rotator-cuff-repair1
96Shoulder Joint Replacement/shoulder/shoulder-joint-replacement-orthopaedic-specialists-colorado-springs-co/41shoulder-joint-replacement1
97Minimally Invasive Shoulder Joint Replacement/shoulder/minimally-invasive-shoulder-joint-replacement-orthopaedic-specialists-colorado-springs-co/41minimally-invasive-shoulder-joint-replacement1
98SLAP Repair/shoulder/slap-repair-orthopaedic-specialists-colorado-springs-co/41slap-repair1
99Complex Shoulder Reconstruction/shoulder/complex-shoulder-reconstruction-orthopaedic-specialists-colorado-springs-co/41complex-shoulder-reconstruction1
100Shoulder Reconstruction Surgery/shoulder/shoulder-reconstruction-surgery-orthopaedic-specialists-colorado-springs-co/41shoulder-reconstruction-surgery1
101Proximal Biceps Tenodesis/shoulder/proximal-biceps-tenodesis-orthopaedic-specialists-colorado-springs-co/41proximal-biceps-tenodesis1
102Revision Shoulder Replacement/shoulder/revision-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/41revision-shoulder-replacement1
103Revision Shoulder Arthroplasty/shoulder/revision-shoulder-arthroplasty-orthopaedic-specialists-colorado-springs-co/41revision-shoulder-arthroplasty1
104Outpatient Shoulder Replacement/shoulder/outpatient-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/41outpatient-shoulder-replacement1
105Reverse Shoulder Replacement/shoulder/reverse-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/41reverse-shoulder-replacement1
106Sternoclavicular Joint Reconstruction/shoulder/sternoclavicular-joint-reconstruction-orthopaedic-specialists-colorado-springs-co/41sternoclavicular-joint-reconstruction1
107AC Joint Arthroplasty/shoulder/ac-joint-arthroplasty-orthopaedic-specialists-colorado-springs-co/41ac-joint-arthroplasty1
108AC Joint Stabilization/shoulder/ac-joint-stabilization-orthopaedic-specialists-colorado-springs-co/41ac-joint-stabilization1
109Open Shoulder Stabilization/shoulder/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/41open-shoulder-stabilization1
110Anterior Shoulder Stabilization/shoulder/anterior-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/41anterior-shoulder-stabilization1
111Posterior Shoulder Stabilization/shoulder/posterior-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/41posterior-shoulder-stabilization1
112Same Day Shoulder Surgery/shoulder/same-day-shoulder-surgery-orthopaedic-specialists-colorado-springs-co/41same-day-shoulder-surgery1
113Shoulder Labrum Reconstruction/shoulder/shoulder-labrum-reconstruction-orthopaedic-specialists-colorado-springs-co/41shoulder-labrum-reconstruction1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialties_condestions_proceduresALL8461.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Speciality.phprawQuery()36
/home/csogy/public_html/includes/specialty-sidebar.phpgetCondestion()26
/home/csogy/public_html/includes/shoulder-sidebar.phprequire_once()20
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()104
012
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '4' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
156Arthritis of the Shoulder/shoulder/arthritis-shoulder-orthopaedic-specialists-colorado-springs-co/42arthritis-of-the-shoulder1
157SLAP Tears/shoulder/slap-tears-orthopaedic-specialists-colorado-springs-co/42slap-tears1
158Biceps Tendon Rupture/shoulder/biceps-tendon-rupture-orthopaedic-specialists-colorado-springs-co/42biceps-tendon-rupture1
159Rotator Cuff Tear/shoulder/rotator-cuff-tear-orthopaedic-specialists-colorado-springs-co/42rotator-cuff-tear1
160Shoulder Fracture/shoulder/shoulder-fracture-orthopaedic-specialists-colorado-springs-co/42shoulder-fracture1
161Shoulder Instability/shoulder/shoulder-instability-orthopaedic-specialists-colorado-springs-co/42shoulder-instability1
162Frozen Shoulder/shoulder/frozen-shoulder-orthopaedic-specialists-colorado-springs-co/42frozen-shoulder1
163Fracture of the Shoulder Blade (Scapula)/shoulder/fracture-shoulder-blade-scapula-orthopaedic-specialists-colorado-springs-co/42fracture-of-the-shoulder-blade-scapula1
164Shoulder Trauma/shoulder/shoulder-trauma-orthopaedic-specialists-colorado-springs-co/42shoulder-trauma1
165Shoulder Ligament Injuries/shoulder/shoulder-ligament-injuries-orthopaedic-specialists-colorado-springs-co/42shoulder-ligament-injuries1
166Shoulder Impingement/shoulder/shoulder-impingement-orthopaedic-specialists-colorado-springs-co/42shoulder-impingement1
167Shoulder Dislocation/shoulder/shoulder-dislocation-orthopaedic-specialists-colorado-springs-co/42shoulder-dislocation1
168Shoulder Pain/shoulder/shoulder-pain-orthopaedic-specialists-colorado-springs-co/42shoulder-pain1
169Shoulder Labral Tear/shoulder/shoulder-labral-tear-orthopaedic-specialists-colorado-springs-co/42shoulder-labral-tear1
170Anterior Shoulder Instability/shoulder/anterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/42anterior-shoulder-instability1
171Posterior Shoulder Instability/shoulder/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/42posterior-shoulder-instability1
172Clavicle Fracture/shoulder/clavicle-fracture-orthopaedic-specialists-colorado-springs-co/42clavicle-fracture1
173Arthritis of the Shoulder/shoulder/arthritis-shoulder-orthopaedic-specialists-colorado-springs-co/42arthritis-of-the-shoulder1
174SLAP Tears/shoulder/slap-tears-orthopaedic-specialists-colorado-springs-co/42slap-tears1
175Biceps Tendon Rupture/shoulder/biceps-tendon-rupture-orthopaedic-specialists-colorado-springs-co/42biceps-tendon-rupture1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcs_specialties_condestions_proceduresALL8461.00Using where
FileFunctionLine
/home/csogy/public_html/models/YpoDatabase.phpquery()47
/home/csogy/public_html/models/Speciality.phprawQuery()36
/home/csogy/public_html/includes/specialty-sidebar.phpgetCondestion()46
/home/csogy/public_html/includes/shoulder-sidebar.phprequire_once()20
/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.phprequire_once()104
001
$_REQUEST
array (
)
001
$_POST
array (
)
001
$_GET
array (
)
001
$_SESSION
array (
)
001
$_COOKIE
array (
  'PHPSESSID' => 'adbf53d4138883daf6f46484e5767368',
)
001
$_FILES
array (
)
001
$_SERVER
array (
  'USER' => 'csogy',
  'HOME' => '/home/csogy',
  'SCRIPT_NAME' => '/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.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=adbf53d4138883daf6f46484e5767368',
  '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' => '1922844-609-475',
  'H2_STREAM_ID' => '475',
  '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/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-gAC7ojUlkocvPDucOwABDxI',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-475',
  'REDIRECT_H2_STREAM_ID' => '475',
  '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/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-gAC7ojUlkocvPDucOwABDxI',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/shoulder/patient-specific-shoulder-replacement-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702976.8091270923614501953125,
  'REQUEST_TIME' => 1794702976,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
12! / 0