:

select *, tn.short_description as short_desc , tn.description as long_desc from tbl_trek_notes tn where tn.notes_tab=1 and tn.trek_id=trek order by tn.sequence