source:
oup/_old_/text/selects.txt@
119
| Last change on this file since 119 was 46, checked in by , 18 years ago | |
|---|---|
| File size: 349 bytes | |
| Line | |
|---|---|
| 1 | SELECT (datfiles.name || "." || datfiles.extension) AS name, count(src_id) AS x, src_id FROM linkmap LEFT JOIN datfiles ON datfiles.id=src_id GROUP BY src_id ORDER BY x DESC |
| 2 | |
| 3 | SELECT (datfiles.name || "." || datfiles.extension) AS name, count(src_id) AS x, src_id FROM rawmap LEFT JOIN datfiles ON datfiles.id=src_id GROUP BY src_id ORDER BY x DESC |
Note:
See TracBrowser
for help on using the repository browser.
