|
Revision 423, 385 bytes
(checked in by hirokai, 4 years ago)
|
queries
|
- Property svn:eol-style set to
native
- Property svn:keywords set to
Author Date Id Revision
|
| Line | |
|---|
| 1 |
SELECT l.ID AS linkNum, x.catID AS category, l.url, l.name |
|---|
| 2 |
FROM links AS l, linksCategoriesXRef AS x |
|---|
| 3 |
WHERE submitter = "neoliminal" |
|---|
| 4 |
AND l.ID = x.linkID |
|---|
| 5 |
ORDER BY l.linkNum; |
|---|
| 6 |
|
|---|
| 7 |
SELECT l.ID AS linkNum, g.name AS category, l.name |
|---|
| 8 |
FROM links AS l, linksGroups AS g, linksCategoriesXRef AS x |
|---|
| 9 |
WHERE submitter = "neoliminal" |
|---|
| 10 |
and l.ID = x.linkID AND g.ID = x.catID |
|---|
| 11 |
ORDER BY l.ID; |
|---|
| 12 |
|
|---|
