Intermittent right lower abdominal pain
, suggest a right ureteric stone. Which due to incresed muscular contractions during intercourse could had lead to acute ureteric colic pain.
General abdominal pain is due to gastritis with is not subsiding due to your continued alcohol and drug intake, despite having gerd.
I would suggest that you get an ultrasound
of your abdomen done along with a routine urine test to look for the stone and start on a ppi tablet like omeprazole
Further management will depend upon the location, size and number of stones.
Hope i have been helpful.
Dr. Ashish Verma