Cacher is the code snippet organizer for pro developers

(
SELECT p.Description 
FROM tt_eMedications m 
  LEFT OUTER JOIN tts_pickListItems p ON m.MedicationID = p.id 
WHERE m.MasterIncidentID = tt_MasterIncident.MasterIncidentID 
ORDER BY m.MedicationsID 
LIMIT 3,1
)