Template:EAIn: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
{{#clear_external_data:}} | |||
{{#get_db_data: | |||
db=engy | |||
|from=ea_ew_in | |||
|where=epr='{{{EPR}}}' | |||
|limit=1 | |||
|data=updated=updated | |||
}}{{#vardefine: updated|{{#external_value:update}}}} | |||
{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine: total| {{#external_value:opt}}}} | {{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine: total| {{#external_value:opt}}}} | ||
{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=ewc=ewc,originregion=originregion,tin=tin}} | {{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=ewc=ewc,originregion=originregion,tin=tin}} |