Template:TNG showdata/get crew test
Jump to navigation
Jump to search
db=tng_db |from= tng_people JOIN wk1_datatable2_data ON wk1_datatable2_data.dtd_04 = (SELECT TOP 1 dtd_04 FROM wk1_datatable2_data WHERE dtd_04 = tng_people.personID) |order by=tng_people.personID ASC |data=personID=tng_people.personID,tnglastname=tng_people.lastname,tngfirstname=tng_people.firstname,crewlastname=wk1_datatable2_data.dtd_07,crewfirstname=wk1_datatable2_data.dtd_08}} {{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}