ViewVC Help
View File | Revision Log | View Changeset | Root Listing
root/Oni2/oup/current/selects.txt
Revision: 10
Committed: Sat Aug 26 17:49:08 2006 UTC (19 years, 1 month 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
 

 









Properties






 

 Name
 Value
 




 

 svn:executable
 
 *