Template:TNG showdata/get crew test: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
<!-- |limit=50 --> | <!-- |limit=50 --> | ||
|order by=tng_people.personID ASC <!--ID--> | |order by=tng_people.personID ASC <!--ID--> | ||
|data= GROUP BY tng_people.personID <!-- wk1_datatable2_data.dtd_04 --> 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}} | |data= GROUP BY tng_people.personID <!-- wk1_datatable2_data.dtd_04 --> 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}} | ||
<noinclude> | <noinclude> | ||
[[Category:Data retrieval templates]] | [[Category:Data retrieval templates]] | ||
| Line 17: | Line 17: | ||
GROUP BY t1.ID, T1.myName | GROUP BY t1.ID, T1.myName | ||
ORDER BY T1.ID, T2.myDate DESC | ORDER BY T1.ID, T2.myDate DESC | ||
SELECT tng_people.personID,tng_people.lastname,tng_people.firstname,MAX(wk1_datatable2_data.dtd_04)crewlastname=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:32, 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}}}}}}