ViewVC Help
View File | Revision Log | View Changeset | Root Listing
root/Oni2/oup/current/text/selects.txt
Revision: 46
Committed: Sat Dec 23 16:26:43 2006 UTC (18 years, 11 months ago) by alloc
Content type: text/plain
File size: 349 byte(s)
Log Message: 










File Contents











#

Content



 
 
 
 
 
 

 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