SELECT
    
    *,
    support_comment AS support_comment_clean
    

FROM

    support_ticket,
    projects AS pt
    
WHERE

    pt.project_id =support_ticket.project_id
     
##project_id##

ORDER BY

    support_ticket.add_date DESC
    
##limit##