source: oup/current/selects.txt@ 42

Last change on this file since 42 was 10, checked in by alloc, 18 years ago
  • Property svn:executable set to *
File size: 349 bytes
Line 
1SELECT (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
3SELECT (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.