Template:TNG showdata/get crew test: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<!--{{#get_db_data: | <!--{{#get_db_data: | ||
db=tng_db | db=tng_db | ||
|from= tng_people OUTER JOIN wk1_datatable2_data ON tng_people.personID = wk1_datatable2_data.dtd_04 | |from= tng_people LEFT OUTER JOIN wk1_datatable2_data ON tng_people.personID = wk1_datatable2_data.dtd_04 | ||
<!-- |where wk1_datatable2_data.dtd_04 in (SELECT DISTINCT wk1_datatable2_data.dtd_04 FROM wk1_datatable2_data) --> | <!-- |where wk1_datatable2_data.dtd_04 in (SELECT DISTINCT wk1_datatable2_data.dtd_04 FROM wk1_datatable2_data) --> | ||
<!-- |limit=50 --> | <!-- |limit=50 --> | ||
| Line 19: | Line 19: | ||
SELECT tng_people.personID,tng_people.lastname,tng_people.firstname,MAX(wk1_datatable2_data.dtd_04) | SELECT tng_people.personID,tng_people.lastname,tng_people.firstname,MAX(wk1_datatable2_data.dtd_04),wk1_datatable2_data.dtd_07,wk1_datatable2_data.dtd_08 FROM tng_people OUTER JOIN wk1_datatable2_data ON tng_people.personID = wk1_datatable2_data.dtd_04 ORDER BY tng_people.personID ASC | ||
Revision as of 14:35, 22 September 2014
|order by=tng_people.personID ASC |data= GROUP BY tng_people.personID personID=tng_people.personID,tnglastname=tng_people.lastname,tngfirstname=tng_people.firstname,crewtngid=MAX(wk1_datatable2_data.dtd_04),crewlastname=wk1_datatable2_data.dtd_07,crewfirstname=wk1_datatable2_data.dtd_08}} {{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}