| struct |
|---|
| NEXTID |
4
|
| PREVID |
2
|
| getNextEntry |
| struct |
|---|
| result |
| struct |
|---|
| CACHED |
false
|
| COLUMNLIST |
FIRSTID,NEXTID
|
| EXECUTIONTIME |
0
|
| RECORDCOUNT |
1
|
| SQL |
SELECT MIN(id) AS NextID
,(SELECT MIN(id) FROM b_entry) AS FirstID
FROM b_entry
WHERE id > 3 ORDER BY sort ASC LIMIT 1
|
|
|
| getPrevEntry |
| struct |
|---|
| result |
| struct |
|---|
| CACHED |
false
|
| COLUMNLIST |
LASTID,PREVID
|
| EXECUTIONTIME |
0
|
| RECORDCOUNT |
1
|
| SQL |
SELECT MAX(id) AS PrevID
,(SELECT MAX(id) FROM b_entry) AS lastID
FROM b_entry
WHERE id <3 ORDER BY sort ASC LIMIT 1
|
|
|
| query |
| query |
| RESULTSET |
| query |
| |
CID |
CLIVE |
CONTENT |
CTITLE |
EID |
ELIVE |
ENTRY_DATE |
ETITLE |
LOCATION |
NAME |
PREVIEW |
UID |
| 1 |
3
|
1
|
ok?
|
Burma
|
3
|
1
|
0006-08-02 00:00:00.0
|
Brian is Eaten by Burmese Pythons
|
[empty string]
|
Phillip J. Fry
|
preview
|
1
|
|
| CACHED |
false
|
| EXECUTIONTIME |
0
|
| SQL |
select e.title as etitle,e.id as eid,e.location,e.entry_date,e.preview,e.content,e.live as elive,
c.title as ctitle,c.id as cid,c.live as clive,
u.name,u.id as uid
from b_entry as e
left join b_category as c on c.id = e.category_id
left join b_users as u on u.id = e.user_id
where e.id = 3
and c.live = 1 and e.live = 1
|
|
| result |
| struct |
|---|
| CACHED |
false
|
| COLUMNLIST |
CID,CLIVE,CONTENT,CTITLE,EID,ELIVE,ENTRY_DATE,ETITLE,LOCATION,NAME,PREVIEW,UID
|
| EXECUTIONTIME |
0
|
| RECORDCOUNT |
1
|
| SQL |
select e.title as etitle,e.id as eid,e.location,e.entry_date,e.preview,e.content,e.live as elive,
c.title as ctitle,c.id as cid,c.live as clive,
u.name,u.id as uid
from b_entry as e
left join b_category as c on c.id = e.category_id
left join b_users as u on u.id = e.user_id
where e.id = 3
and c.live = 1 and e.live = 1
|
|