|
Last change
on this file since 44 was 10, checked in by alloc, 18 years ago |
|
|
-
Property svn:executable
set to
*
|
|
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.
