|
1
|
SELECT
|
|
2
|
${table}.*,
|
|
3
|
${table}_log.operation,
|
|
4
|
${table}_log.status,
|
|
5
|
${table}_log.date
|
|
6
|
FROM
|
|
7
|
${table},
|
|
8
|
${table}_log,
|
|
9
|
(SELECT ${idField}, max(date) AS maxdate
|
|
10
|
FROM ${table}_log
|
|
11
|
GROUP BY ${idField}) AS TAB
|
|
12
|
WHERE
|
|
13
|
TAB.maxdate = ${table}_log.date AND
|
|
14
|
TAB.${idField} = ${table}_log.${idField} AND
|
|
15
|
TAB.${idField} = ${table}.${idField}
|
|
16
|
#if (${from})
|
|
17
|
AND ${table}_log.date >= '${from}'
|
|
18
|
#end
|
|
19
|
#if (${until})
|
|
20
|
AND ${table}_log.date <= '${until}'
|
|
21
|
#end
|
|
22
|
ORDER BY ${table}_log.date;
|