Accessibility Tools

Open Shoulder Stabilization

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 Open Shoulder Stabilization?

Open shoulder stabilization is a surgical procedure performed to treat a condition called shoulder instability.

Shoulder instability is a chronic condition that causes the frequent dislocation of the shoulder joint. A dislocation occurs when the end of the humerus (the ball portion) partially or completely dislocates from the glenoid (the socket portion) of the shoulder. A partial dislocation is referred to as a subluxation while a complete separation is referred to as a dislocation. The repeated dislocation of the humerus out of its socket is called chronic shoulder instability. A tear in the labrum or rotator cuff and ligament tear in the front of the shoulder (a Bankart lesion) may lead to repeated shoulder dislocations.

Shoulder instability is commonly treated by a minimally invasive approach called arthroscopic shoulder stabilization surgery. However, too much bone loss, dislocation that cannot be reduced, severe damage to the supporting structures of the shoulder joint, chronic instability, or failure of a previous operation, may necessitate open shoulder stabilization surgery.

What is Anatomy of the Shoulder?

The shoulder is the most flexible joint in the body. When injury occurs, it can cause loosening and instability of the joint which can lead to partial or complete dislocation and pain. It is a ball and socket joint where the ball is formed by the head of the upper arm bone or humerus and the socket is formed by a shallow cavity in the shoulder blade called the glenoid. The glenoid is surrounded by a raised ridge of fibrous cartilage called the labrum which provides some depth to the socket increasing the stability of the joint. Stability is further enhanced by ligaments that form a capsule around the joint, as well as muscles and tendons which center the humeral head in the socket.

What are the Indications for Open Shoulder Stabilization?

The main indication for open shoulder stabilization is shoulder instability which may occur as a result of injury or trauma to the shoulder, falling on an outstretched hand, repetitive overhead activities from sports or occupation, loose shoulder ligaments, or an enlarged capsule. These may cause symptoms such as pain, swelling, bruising, numbness, visible deformity, and loss of function. When conservative treatment options such as medications, rest, and ice application fail to relieve shoulder instability, your surgeon may recommend open shoulder stabilization surgery. Shoulder stabilization surgery is done to improve stability and function to the shoulder joint and prevent recurrent dislocations.

What Does Preparation for Open Shoulder Stabilization Surgery Involve?

Preoperative preparation for open shoulder stabilization may involve the following steps:

  • A thorough examination is performed by your doctor to check for any medical issues that need to be addressed prior to surgery.
  • Depending on your medical history, social history, and age, you may need to undergo tests such as bloodwork and imaging to screen for 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, vitamins, or supplements that you are taking.
  • You may need to refrain from supplements or medications such as blood thinners or anti-inflammatories for a week or two prior to surgery.
  • You should refrain from alcohol or tobacco at least a few days prior to surgery.
  • You should not consume solids or liquids at least 8 hours prior to surgery.
  • A written consent will be obtained from you after the surgical procedure has been explained in detail.

What is the Procedure for Open Shoulder Stabilization Surgery?

The open shoulder stabilization procedure is performed under general anesthesia with you in a semi-reclined or beach-chair position and involves the following steps:

  • An incision of 10 cm is made at the front of the shoulder joint.
  • Retractors are used to separate the muscles of the joint and expose the coracoid process (a small hook-like process of the shoulder bone) and its attached tendons.
  • The coracoid process is freed of its attachments, and along with the conjoined tendon, is transected from its base.
  • Holes are drilled into the transected coracoid process.
  • The subscapularis muscle, which passes in front of the shoulder joint, is split in line with its fibers.
  • The capsule of the shoulder joint is entered and the glenoid is exposed and prepared to receive the coracoid.
  • The transected coracoid with the conjoined tendon is passed through the separated subscapularis muscle and fixed to the glenoid rim with screws through the previously drilled holes. This increases the glenoid surface and stabilizes the joint. The conjoined tendon and subscapularis muscle provide additional stability by acting as a sling.
  • This procedure treats chronic shoulder instability and decreases the possibility of future dislocations.
  • Upon completion, the instruments are withdrawn, the incision is closed and covered with a sterile bandage.

What Does Postoperative Care and Recovery for Open Shoulder Stabilization Surgery Involve?

Following the surgery, your arm is placed in a sling to rest the shoulder and promote healing. You may need to remain in the hospital for 2 to 3 days before discharge to home. Pain is controlled with medication and ice packs. You will be instructed to keep the surgical wound dry and wear your sling while sleeping for a few weeks after the procedure. The sling may be removed in 3 to 6 weeks. Rehabilitation usually begins early on the first postoperative day with finger movements and passive assisted range of motion exercises. A physical therapy program is recommended for 3 months after which you can return to your regular activities. 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 Open Shoulder Stabilization Surgery?

Open shoulder stabilization surgery is a relatively safe procedure; however, as with any surgery, some risks and complications may occur, such as the following:

  • Infection
  • Bleeding
  • Postoperative pain
  • Damage to surrounding structures
  • Stiffness or restricted motion
  • Thromboembolism or blood clots
  • Anesthetic/allergic reactions
  • Fracture or failure of union of the coracoid
  • Recurrence of instability

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/open-shoulder-stabilization-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/open-shoulder-stabilization-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/open-shoulder-stabilization-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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()99
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()99
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()99
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()99
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()99
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()99
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()102
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()102
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()102
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.phprequire_once()102
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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/shoulder/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/shoulder/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/shoulder/open-shoulder-stabilization-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-301',
  'H2_STREAM_ID' => '301',
  '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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/shoulder/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-eAC7ojUlkocvPDub4wABDwE',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-301',
  'REDIRECT_H2_STREAM_ID' => '301',
  '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/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/shoulder/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-eAC7ojUlkocvPDub4wABDwE',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/shoulder/open-shoulder-stabilization-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702968.47212696075439453125,
  'REQUEST_TIME' => 1794702968,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
12! / 0