Building the Vehicles
Location: Humbolt County, California, USA
2006-04-18 22:22:42.0
content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content
next ->
| struct |
|---|
| ENTRYLIST |
1,2,3,4
|
| NEXTID |
2
|
| PREVID |
0
|
| query |
| query |
| RESULTSET |
| query |
| |
CID |
EID |
| 1 |
2
|
1
|
| 2 |
2
|
2
|
| 3 |
3
|
3
|
| 4 |
6
|
4
|
|
| CACHED |
false
|
| EXECUTIONTIME |
0
|
| SQL |
SELECT
e.id AS eid
,c.id AS cid
FROM b_entry AS e
LEFT JOIN b_category AS c ON c.id = e.category_id
WHERE e.live = 1 AND c.live = 1
ORDER BY c.sort ASC, e.sort ASC
|
|
| struct |
|---|
| NEXTID |
2
|
| PREVID |
4
|
| 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 > 1 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 <1 ORDER BY sort ASC LIMIT 1
|
|
|
| query |
| query |
| RESULTSET |
| query |
| |
CID |
CLIVE |
CONTENT |
CTITLE |
EID |
ELIVE |
ENTRY_DATE |
ETITLE |
LOCATION |
NAME |
PREVIEW |
UID |
| 1 |
2
|
1
|
content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content content
|
Preperations
|
1
|
1
|
2006-04-18 22:22:42.0
|
Building the Vehicles
|
Humbolt County, California, USA
|
Phillip J. Fry
|
preview preview preview preview preview preview preview preview preview preview preview preview preview preview preview
|
1
|
|
| CACHED |
false
|
| EXECUTIONTIME |
15
|
| 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 = 1
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 |
15
|
| 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 = 1
and c.live = 1 and e.live = 1
|
|