{supertable/ table} {bodywidth 20 15 15 auto} {active disable}

 Complainant's Name {headrow}  County of Complaint  City of Complaint  Short Description

{/supertable} {supertable query} {query/} SELECT jos_users.name, complaints.your_county, complaints.short_description, complaints.id, jos_jsn_users.city, CONCAT('index.php/show-complaint?rec=', complaints.id) AS ThisRec FROM complaints INNER JOIN jos_users ON complaints.`current_user` = jos_users.id INNER JOIN jos_jsn_users ON jos_users.id = jos_jsn_users.id {/query} {bodywidth 20 15 15 auto} {tbody/} {cell/}{text.data name}{/cell} {cell/}{text.data your_county}{/cell} {cell/}{text.data city}{/cell}{cell/}{text.data short_description}{link.data ThisRec}}{/cell} {/tbody} {/supertable}