Hi there. You have symptoms of hip, thigh, leg pain which is sudden shooting pain so this is most likely due to the protruded discs L4 L5 LS1 all contributing to the nerve root compression and these symptoms. Weight bearing problem could be because of rheumatoid arthritis.
You need to consult an orthopaedician/ neurosurgeon with your mri reports for planning surgical correction since pain killers are no good.
Continue treatment for rheumatoid arthritis and do back exercises till surgical relief. Take care and keep me posted.
or...if it's a flare up from the ra, heat and rest. it should be better within 3-5 days. if it's not, you know it's due to your spinal issues.
disc protusion at L4/L5/S is causing your hip and leg pain, because it pushes on your spinal cord nerve roots that supply your thighs and legs....you could have the protrusion removed by a consultant orthopedic surgeon or a neurosurgeon....pain reliefers and physiotherapy is not going to push the protrusion back....a simple surgery to remove it will relief the pain and any damage that could be caused by the constant pressure on your spinal cord at that part