Accessibility Tools

Posterior Shoulder Instability

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 Posterior Shoulder Instability?

Posterior shoulder instability, also known as posterior glenohumeral instability, is a condition in which the head of the humerus (upper arm bone) dislocates or subluxes posteriorly from the glenoid (socket portion of the shoulder) as a result of significant trauma. A partial dislocation is referred to as a subluxation whereas a complete separation is referred to as a dislocation.

Posterior shoulder instability occurs when considerable force is applied through the arm when the arm is extended in front of the body, rupturing the shoulder capsule, ligaments, and labrum.

Posterior shoulder instability is commonly noted in athletes involved in high contact or overhead sports, such as American football, baseball, weight lifting, rugby, gymnastics, and people involved in heavy bench pressing. Posterior shoulder instability is far less common than anterior shoulder instability and accounts for only about 5 percent of all shoulder instabilities.

What is Anatomy of the Shoulder?

The shoulder joint (glenohumeral joint) is a ball and socket joint. A ball at the top of the upper arm bone (the humerus) fits neatly into a socket, called the glenoid, which is part of the shoulder blade (scapula). The labrum is a ring of fibrous cartilage surrounding the glenoid, which helps in stabilizing the shoulder joint. Tendons and ligaments around the shoulder joint provide additional strength and stability to the joint.

What are the Causes of Posterior Shoulder Instability?

Some of the causes and risk factors of posterior shoulder instability include:

  • Fall on an outstretched hand
  • Seizures
  • Electrocution
  • Proximal humeral fractures, especially lesser tuberosity and/or anatomical humeral neck fracture
  • Reverse Hill-Sachs fracture, an impaction fracture of the anteromedial humeral head
  • Reverse osseous Bankart fracture, a fracture of the posteroinferior rim of the glenoid
  • Developmental anomalies, such as glenoid dysplasia, glenoid hypoplasia, and posterior glenoid rim deficiency
  • Bennett lesion, a condition characterized by calcification of the posterior band of the inferior glenohumeral ligament

What are the Signs and Symptoms of Posterior Shoulder Instability?

Some of the signs and symptoms associated with posterior shoulder instability include:

  • Posterior shoulder pain with activity
  • Pain with adduction, flexion, as well as internal rotation of the arm
  • Posterior rotator cuff weakness
  • Stiffness and decreased range of motion
  • Numbness, tingling, or burning sensation
  • Painful clicking or catching in movements
  • Tenderness on palpation of the posterior joint line
  • Swelling and bruising of the shoulder
  • Visible deformity and loss of function of the shoulder

How is Posterior Shoulder Instability Diagnosed?

Posterior shoulder instability is diagnosed with a review of your symptoms, medical history, and a physical examination of the shoulder where your doctor will assess the extent of injury by palpating the shoulder area to check for points of tenderness and prompting shoulder motion to check for range of motion and strength. During examination, specific diagnostic tests such as Posterior Load and Shift Test; Posterior Drawer Test; the Jerk test; the Kim Test; and Posterior Apprehension/Stress Test may be ordered to assess the degree of posterior instability. In addition to routine X-ray exams such as AP and lateral views to check for bony abnormalities, your doctor may specifically order an axillary lateral view as it provides the most diagnostic information for a posterior subluxation or dislocation. CT scans and MRIs may also be ordered for a detailed evaluation of the bone quality and morphology and to detect any soft tissue lesions that may be contributing to posterior shoulder instability.

What is the Treatment for Posterior Shoulder Instability?

The treatment options for posterior shoulder instability involve both conservative as well as surgical treatment.

Conservative Treatment

  • Closed reduction: Following a dislocation, your surgeon can often externally manipulate the shoulder joint, usually under anesthesia, realigning it into proper position.
  • Medications: Over-the-counter pain medications and NSAIDs can help reduce the pain and swelling. Steroidal injections may also be administered to decrease swelling.
  • Rest: Rest the injured shoulder and avoid activities that require overhead motion. A sling may be worn for 2 weeks to facilitate healing.
  • Ice: Ice packs should be applied to the affected area for 20 minutes every hour.

Surgical Treatment

When conservative treatment options fail to relieve shoulder instability, your surgeon may recommend shoulder stabilization surgery. Posterior shoulder stabilization surgery is performed to improve the stability and function of the shoulder joint and prevent recurrent dislocations. It can be performed arthroscopically or through open surgery, depending on your condition.

Arthroscopy is a surgical procedure in which an arthroscope, a small flexible tube with a light and video camera at the end, is inserted into a joint to evaluate and treat the condition. It is a minimally invasive surgery and is performed through two tiny incisions (portals), about half-inch in length, made around the joint area. Through one of the incisions, an arthroscope is passed. The camera attached to the arthroscope displays the images of the inside of the joint on the television monitor, which allows your surgeon to carry out the required repair accordingly through tiny surgical instruments that are passed through the other incisions.

Open surgery is mostly required to correct severe instability. During this surgery, a large surgical cut is made on the shoulder and the muscles under it are moved apart to obtain access to the joint capsule, labrum, and ligaments. These soft tissue structures are then reattached, tightened, or repaired accordingly depending on the extent of tissue injury and closed with sutures.

The surgery is followed by rehabilitation to restore range of motion and strength of the shoulder joint.

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/posterior-shoulder-instability-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/posterior-shoulder-instability-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/posterior-shoulder-instability-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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()98
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()98
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()98
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()98
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()98
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()98
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.phprequire_once()101
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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/shoulder/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/shoulder/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/shoulder/posterior-shoulder-instability-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-679',
  'H2_STREAM_ID' => '679',
  '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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/shoulder/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-iQC7ojUlkocvPDucowABDwM',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-679',
  'REDIRECT_H2_STREAM_ID' => '679',
  '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/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/shoulder/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-iQC7ojUlkocvPDucowABDwM',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/shoulder/posterior-shoulder-instability-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702985.940145969390869140625,
  'REQUEST_TIME' => 1794702985,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
12! / 0