Untitled

SELECT 
    jt.*
    
FROM 
    tixcorner.organiser o
INNER JOIN 
    tixcorner.event e ON o.id = e.organiserId
INNER JOIN  
    tixcorner.participant_type pt ON e.id = pt.eventId
INNER JOIN  
    tixcorner.json_template jt ON pt.id = jt.participantTypeId
WHERE 
    o.id = 61 and jsonType=4 and participantTypeId=77;