Accessibility Tools

Revision Hip Surgery

Hip Service

Colorado Springs Orthopaedic Group

Your hips support your body and help you walk, move, exercise, and perform everyday activities. Hip pain can develop from an injury, overuse, arthritis, or other conditions and may gradually limit your mobility and quality of life.

CSOG provides comprehensive care for a wide range of hip conditions, from sports injuries and tendon problems to arthritis, fractures, and degenerative joint conditions. Treatment may include physical therapy, medications, injections, activity modification, minimally invasive procedures, or hip replacement when appropriate.

Our specialists focus on finding the underlying cause of your symptoms and determining the most appropriate treatment for your needs. Whether you require nonsurgical care or advanced surgical treatment, our goal is to relieve pain, improve mobility, and help you return to the activities you enjoy.

What is Revision Hip Surgery?

Revision hip surgery is a repeat hip surgery performed in certain patients to correct the problems or complications of previous hip surgery and overcome its limitations.

The hip joint is one of the body's largest weight-bearing joints and is the point where the thighbone (femur) and pelvis (acetabulum) join. It is a ball-and-socket joint in which the head of the femur forms the ball, and the pelvic acetabulum forms the socket. The joint surface is covered by smooth articular cartilage that cushions and enables smooth movement of the joint. Stability of the hip joint is achieved by the labrum, ligaments, and tendons that encase the hip and support the hip movements. Any damage to these structures may warrant hip surgery.

Some of the hip conditions that may affect the hip joint structures necessitating hip surgery include:

  • Rupture of the labrum
  • Arthritis
  • Hip dysplasia
  • Avascular necrosis
  • Hip impingement or femoroacetabular impingement (FAI)
  • Hip bursitis
  • Snapping hip syndrome

What are the Indications for Revision Hip Surgery?

Revision hip surgery may be recommended when previous hip surgeries such as debridement, hip labrum repair, hip labrum reconstruction, femoral osteoplasty, and periacetabular osteotomy have failed to resolve painful and debilitating hip symptoms associated with the hip conditions.

What is the Procedure for Revision Hip Surgery?

Based on the hip condition and failure of the surgery to treat that condition, a patient may need to undergo revision hip surgery. The procedure is performed arthroscopically or as an open surgery under regional and general anesthesia. During an arthroscopic surgery, tiny incisions (portals), about a half-inch in length, are made around the joint area. Through one of the incisions, an arthroscope is passed. A camera attached to the arthroscope displays the images of the inside of the joint on a monitor, which allows your surgeon to view the damage and carry out the required repair. During an open surgery, a long incision of several centimeters is made over the hip joint to access the treatment area and carry out the required repair.

Some of the common revision hip surgeries include:

  • Hip labrum repair: This is a surgery employed for the treatment of a torn hip labrum. A hip labral tear is an injury to the labrum, the cartilage that surrounds the outside rim of your hip joint socket. The labrum helps to deepen the socket and provide stability to the joint. It also acts as a cushion and enables smooth movement of the joint. During hip labrum repair surgery, your surgeon repairs the torn tissue by sewing it back together or removes the torn piece all together, depending upon the cause and extent of the tear.
  • Hip labrum reconstruction: In some instances, where the hip labrum tear is severe and repair is not possible, your surgeon may perform a surgery called hip labrum reconstruction. In this surgery, a tissue graft is obtained from your own body (autograft) or a donor (allograft) and the graft is secured to the remaining part of the labrum utilizing durable stitching.
  • Surgery for snapping hip syndrome: Snapping hip syndrome is a condition in which you hear or feel a snapping sound in the hip when you swing your legs, run, walk or get up from a chair. The movement of muscles or tendons over a bony protrusion in the hip region or the presence of loose body fragments such as fragments of bone or cartilage in the joint space can give rise to the snapping sound. Common surgeries for snapping hip syndrome include:
    • Iliotibial band release: This procedure involves lengthening of the iliotibial band to decrease tension and hip snapping.
    • Iliopsoas tendon release: This procedure involves lengthening the iliopsoas tendon to decrease muscle tension and hip clicking.
    • Arthroscopic hip debridement: This procedure involves making small incisions at the hip joint cavity and removing bone or cartilage fragments.
  • Femoral osteoplasty: This is a surgery to correct femoroacetabular impingement (FAI), a condition characterized by excessive friction in the hip joint from the presence of bony irregularities, which damages the articular cartilage (the smooth white surface of the ball or socket) or the labral tissue (the lining of the edge of the socket). During femoral osteoplasty surgery, your surgeon removes excess bone from the femoral neck to make enough room for free motion of the hip joint, as well as repair any labral tears or cartilage damage caused by impingement.
  • Periacetabular osteoplasty: This is a surgery to correct hip dysplasia. Hip dysplasia is a condition that is seen in infants and young children as a result of developmental problems in the hip joint. The femur (thigh bone) partially or completely slips out of the hip socket causing dislocation at the hip joint. During periacetabular osteoplasty surgery, your surgeon trims the hip socket (acetabulum) so that the femoral head can be repositioned in the pelvis, inserts metal screws into the bone to stabilize it in the new position, and smooths out any bone deformities that may be causing pain.
  • Surgery for avascular necrosis: Avascular necrosis, also called osteonecrosis, is a condition in which bone death occurs because of inadequate blood supply to it. Lack of blood flow may occur when there is a fracture in the bone or a joint dislocation that may damage nearby blood vessels. Avascular necrosis can be treated by one of the following methods:
    • Core decompression: During this procedure, a portion of the inner layer of the bone is removed to relieve the pressure inside the bone. This decreases the pain and allows the growth of new blood vessels; thereby, stimulating new bone growth.
    • Bone transplant: Healthy bone harvested from another part of your body is grafted into the affected area.
    • Bone reshaping (osteotomy): This procedure is performed in advanced stages and involves reshaping of the bone which is done to decrease the stress placed over the affected bone.

What Does Postoperative Care for Revision Hip Surgery Involve?

In general, postoperative care instructions and recovery after revision hip surgery will involve the following:

  • 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 notice some pain, swelling, and discomfort in the operated area. Pain and anti-inflammatory medications are provided as needed.
  • You will be placed on assistive devices such as crutches with instructions on restricted weight-bearing for a specified period of time. You are encouraged to walk with assistance as frequently as possible to prevent blood clots.
  • Keep the surgical site clean and dry. Instructions on surgical site care and bathing will be provided.
  • Refrain from smoking as it can negatively affect the healing process.
  • Eating a healthy diet rich in vitamin D is strongly advised to promote healing and a faster recovery.
  • Refrain from strenuous activities for the first few months and lifting heavy weights for at least 6 months. Gradual increase in activities over a period of time is recommended.
  • An individualized physical therapy protocol will be designed to help strengthen hip muscles and optimize hip function.
  • Most patients are able to resume their normal activities in 3 to 4 weeks after surgery; however, return 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 Revision Hip Surgery?

Revision hip 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 nerves and vessels
  • Thromboembolism or blood clots
  • Dislocations (rarely)
  • Anesthetic/allergic reactions

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 Hip 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/hip/revision-hip-surgery-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/hip/revision-hip-surgery-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/hip/revision-hip-surgery-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 = '14'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
140Hiphip/hip-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:11:032026-07-15 18:11:03
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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()117
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 = '14' 
        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 = '14' 
            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
30Fellowship Trained & Board Certified Orthopedic Surgeond-alex-forrester-mdD. Alex Forrester, MD1d-alex-forrester-md-1784567112.pngMDDoctor000
32Fellowship Trained & Board Certified Orthopedic Surgeoneric-k-jepson-doEric K. Jepson, DO1eric-k-jepson-do-1784567040.pngMDDoctor000
29Fellowship Trained & Board Certified Orthopedic Surgeonmichael-feign-doMichael Feign, DO1michael-feign-do-1784567177.pngMDDoctor000
37Fellowship Trained & Board Certified Orthopedic Surgeonmichael-van-manen-doMichael Van Manen, DO1michael-van-manen-do-1784566704.pngMDDoctor000
26Fellowship Trained & Board Certified Orthopedic Surgeontyler-bron-mdTyler Bron, MD1tyler-bron-md-1784652250.pngMDDoctor000
63devin-pao-pa-cDevin Pao, PA-C2devin-pao-pa-c-1784569902.pngPAPhysician AssistantTyler Bron, MD26tyler-bron-md
42julia-beski-pa-cJulia Beski, PA-C2julia-beski-new-1791200195.jpgPAPhysician AssistantMichael Feign, DO29michael-feign-do
61robert-peterson-pa-cRobert Peterson, PA-C2robert-peterson-pa-c-1784570126.pngPAPhysician AssistantEric K. Jepson, DO32eric-k-jepson-do
53tyler-walker-pa-cTyler Walker, PA-C2tyler-walker-pa-c-1784570216.pngPAPhysician AssistantTyler Bron, MD26tyler-bron-md
59ellen-lopez-npEllen Lopez, NP3ellen-lopez-np-1784570191.pngNPNurse PractitionerTyler Bron, MD26tyler-bron-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()117
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 = '63' 
    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
26tyler-bron-mdTylerBron, MDTyler Bron, MDJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()117
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 = '42' 
    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
29michael-feign-doMichaelFeign, DOMichael Feign, DOJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()117
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 = '61' 
    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
32eric-k-jepson-doEric K.Jepson, DOEric K. Jepson, DOJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()117
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 = '53' 
    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
26tyler-bron-mdTylerBron, MDTyler Bron, MDJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()117
009
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 = '59' 
    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
26tyler-bron-mdTylerBron, MDTyler Bron, MDJoint Replacement/joint-replacement-orthopaedic-specialists-colorado-springs-co/
32eric-k-jepson-doEric K.Jepson, DOEric K. Jepson, DOJoint Replacement/joint-replacement-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/hip-speacialist.phprequire_once()1
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()117
010
WARNING: The first few results returned by this query are the same as returned by 2 other queries!
SELECT 
    * 
FROM 
    cs_specialties 
WHERE 
    id = '14'
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
140Hiphip/hip-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:11:032026-07-15 18:11:03
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
011
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 = '14' 
    OR id = '14' 
GROUP BY 
    id
idparent_idspecialty_nameslugpage_urlshort_descriptiondescriptioniconbanner_imageimageseo_titleseo_keywordsseo_descriptionsort_orderstatuscreated_atupdated_at
140Hiphip/hip-orthopaedic-specialists-colorado-springs-co/012026-07-15 18:11:032026-07-15 18:11:03
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
012
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '14' 
    AND type = '1'
idtitlepage_urlspecialty_idtypeslugstatus
446Revision Hip Surgery/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/141revision-hip-surgery1
447Femoroplasty/hip/femoroplasty-orthopaedic-specialists-colorado-springs-co/141femoroplasty1
448Hip Bursectomy/hip/hip-bursectomy-orthopaedic-specialists-colorado-springs-co/141hip-bursectomy1
449Ultrasound Guided Hip Injections/hip/ultrasound-guided-hip-injections-orthopaedic-specialists-colorado-springs-co/141ultrasound-guided-hip-injections1
450Nonsurgical Hip Treatments/hip/nonsurgical-hip-treatments-orthopaedic-specialists-colorado-springs-co/141nonsurgical-hip-treatments1
451Complex Hip Reconstruction Surgery/hip/complex-hip-reconstruction-surgery-orthopaedic-specialists-colorado-springs-co/141complex-hip-reconstruction-surgery1
452Posterior Hip Replacement/hip/posterior-hip-replacement-orthopaedic-specialists-colorado-springs-co/141posterior-hip-replacement1
453Hip Cartilage Repair/hip/hip-cartilage-repair-orthopaedic-specialists-colorado-springs-co/141hip-cartilage-repair1
454Hip Surgery/hip/hip-surgery-orthopaedic-specialists-colorado-springs-co/141hip-surgery1
455Core Muscle Repair/hip/core-muscle-repair-orthopaedic-specialists-colorado-springs-co/141core-muscle-repair1
456Outpatient Hip Replacement/hip/outpatient-hip-replacement-orthopaedic-specialists-colorado-springs-co/141outpatient-hip-replacement1
457Hip Resurfacing/hip/hip-resurfacing-orthopaedic-specialists-colorado-springs-co/141hip-resurfacing1
458Hip Labral Repair/hip/hip-labral-repair-orthopaedic-specialists-colorado-springs-co/141hip-labral-repair1
459Hip Preservation Surgery/hip/hip-preservation-surgery-orthopaedic-specialists-colorado-springs-co/141hip-preservation-surgery1
460Hip Fracture Surgery/hip/hip-fracture-surgery-orthopaedic-specialists-colorado-springs-co/141hip-fracture-surgery1
461Same Day Hip Replacement/hip/same-day-hip-replacement-orthopaedic-specialists-colorado-springs-co/141same-day-hip-replacement1
462Proximal Hamstring Repair/hip/proximal-hamstring-repair-orthopaedic-specialists-colorado-springs-co/141proximal-hamstring-repair1
463Physical Therapy for Hip/hip/physical-therapy-hip-orthopaedic-specialists-colorado-springs-co/141physical-therapy-for-hip1
464Hip Arthroscopy/hip/hip-arthroscopy-orthopaedic-specialists-colorado-springs-co/141hip-arthroscopy1
465Total Hip Replacement/hip/total-hip-replacement-orthopaedic-specialists-colorado-springs-co/141total-hip-replacement1
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
013
SELECT 
    * 
FROM 
    cs_specialties_condestions_procedures 
WHERE 
    specialty_id = '14' 
    AND type = '2'
idtitlepage_urlspecialty_idtypeslugstatus
484Osteoarthritis of the Hip/hip/osteoarthritis-hip-orthopaedic-specialists-colorado-springs-co/142osteoarthritis-of-the-hip1
485Inflammatory Arthritis of the Hip/hip/inflammatory-arthritis-hip-orthopaedic-specialists-colorado-springs-co/142inflammatory-arthritis-of-the-hip1
486Hip Injury/hip/hip-injury-orthopaedic-specialists-colorado-springs-co/142hip-injury1
487Hip Pain/hip/hip-pain-orthopaedic-specialists-colorado-springs-co/142hip-pain1
488Hip Fracture/hip/hip-fracture-orthopaedic-specialists-colorado-springs-co/142hip-fracture1
489Pelvic Fractures/hip/pelvic-fractures-orthopaedic-specialists-colorado-springs-co/142pelvic-fractures1
490Hip Bursitis/hip/hip-bursitis-orthopaedic-specialists-colorado-springs-co/142hip-bursitis1
491Hip Instability/hip/hip-instability-orthopaedic-specialists-colorado-springs-co/142hip-instability1
492Femoroacetabular Impingement/hip/femoroacetabular-impingement-orthopaedic-specialists-colorado-springs-co/142femoroacetabular-impingement1
493Hip Dislocation/hip/hip-dislocation-orthopaedic-specialists-colorado-springs-co/142hip-dislocation1
494Hip Labral Tear/hip/hip-labral-tear-orthopaedic-specialists-colorado-springs-co/142hip-labral-tear1
495Hip Ligament Injuries/hip/hip-ligament-injuries-orthopaedic-specialists-colorado-springs-co/142hip-ligament-injuries1
496Gluteus Medius Tear/hip/gluteus-medius-tear-orthopaedic-specialists-colorado-springs-co/142gluteus-medius-tear1
497Proximal Femoral Fracture/hip/proximal-femoral-fracture-orthopaedic-specialists-colorado-springs-co/142proximal-femoral-fracture1
498Stress Fractures of the Hip/hip/stress-fractures-hip-orthopaedic-specialists-colorado-springs-co/142stress-fractures-of-the-hip1
499Post-Traumatic Hip Arthritis/hip/post-traumatic-hip-arthritis-orthopaedic-specialists-colorado-springs-co/142post-traumatic-hip-arthritis1
500Hip Adductor Injuries/hip/hip-adductor-injuries-orthopaedic-specialists-colorado-springs-co/142hip-adductor-injuries1
501Acetabular Fracture/hip/acetabular-fracture-orthopaedic-specialists-colorado-springs-co/142acetabular-fracture1
502Hip Muscle Strain/hip/hip-muscle-strain-orthopaedic-specialists-colorado-springs-co/142hip-muscle-strain1
503Hip Tendonitis/hip/hip-tendonitis-orthopaedic-specialists-colorado-springs-co/142hip-tendonitis1
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/hip-sidebar.phprequire_once()20
/home/csogy/public_html/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.phprequire_once()120
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' => '/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_URI' => '/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REMOTE_PORT' => '30550',
  'SCRIPT_FILENAME' => '/home/csogy/public_html/hip/revision-hip-surgery-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-873',
  'H2_STREAM_ID' => '873',
  '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/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'SCRIPT_URL' => '/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'UNIQUE_ID' => 'avj-kgC7ojUlkocvPDudBAABDws',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_H2_STREAM_TAG' => '1922844-609-873',
  'REDIRECT_H2_STREAM_ID' => '873',
  '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/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_SCRIPT_URL' => '/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co/',
  'REDIRECT_UNIQUE_ID' => 'avj-kgC7ojUlkocvPDudBAABDws',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/hip/revision-hip-surgery-orthopaedic-specialists-colorado-springs-co.php',
  'REQUEST_TIME_FLOAT' => 1794702994.7871859073638916015625,
  'REQUEST_TIME' => 1794702994,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
13! / 0