Revision a5f30bf0
Von Stephan Köhler vor etwa 19 Jahren hinzugefügt
| SL/Form.pm | ||
|---|---|---|
| 1765 | 1765 |
$where = "quotation = '1'"; |
| 1766 | 1766 |
} |
| 1767 | 1767 |
|
| 1768 |
my $query = qq|SELECT id FROM $arap |
|
| 1769 |
WHERE id IN (SELECT MAX(id) FROM $arap |
|
| 1768 |
my $query = qq|SELECT MAX(id) FROM $arap |
|
| 1770 | 1769 |
WHERE $where |
| 1771 |
AND ${table}_id > 0)|;
|
|
| 1770 |
AND ${table}_id > 0|;
|
|
| 1772 | 1771 |
my $sth = $dbh->prepare($query); |
| 1773 | 1772 |
$sth->execute || $self->dberror($query); |
| 1774 | 1773 |
|
Auch abrufbar als: Unified diff
Merge von 682 aus unstable: sql-performance
SQL-Query optimiert fuer raussuchen letzer Kunde