Code: Select all
// DEBUG:
// die($query);
$fetch_single = ($returncode == 'single' ? true: false);
if ($returncode == 'query') {
return $query;
}
$ret =& serendipity_db_query($query, $fetch_single, 'assoc');
Code: Select all
// DEBUG:
die($query);
$fetch_single = ($returncode == 'single' ? true: false);
if ($returncode == 'query') {
return $query;
}
$ret =& serendipity_db_query($query, $fetch_single, 'assoc');
Stan wrote:Abfrage:
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid, e.trackbacks, e.isdraft, e.allow_comments, e.last_modified, a.realname AS author, a.username AS loginname, a.email , e.body, e.extended FROM s9y_entries AS e LEFT JOIN s9y_authors a ON e.authorid = a.authorid LEFT JOIN s9y_entrycat ec ON e.id = ec.entryid LEFT JOIN s9y_category c ON ec.categoryid = c.categoryid LEFT JOIN s9y_authorgroups AS acl_a ON acl_a.authorid = 0 LEFT JOIN s9y_access AS acl_acc ON ( acl_acc.artifact_mode = 'read' AND acl_acc.artifact_type = 'category' AND acl_acc.artifact_id = c.categoryid ) WHERE isdraft = 'false' AND e.timestamp <= 1170160800 AND ( c.categoryid IS NULL OR ( acl_acc.groupid = 0) OR ( acl_acc.artifact_id IS NULL ) ) GROUP BY e.id ORDER BY timestamp DESC LIMIT 15
Ergebnis:
MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen). (die Abfrage dauerte 0.0006 sek)
SQL-Befehl: SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid, e.trackbacks, e.isdraft, e.allow_comments, e.last_modified, a.realname AS author, a.username AS loginname, a.email, e.body, e.extended
FROM s9y_entries AS e
LEFT JOIN s9y_authors a ON e.authorid = a.authorid
LEFT JOIN s9y_entrycat ec ON e.id = ec.entryid
LEFT JOIN s9y_category c ON ec.categoryid = c.categoryid
LEFT JOIN s9y_authorgroups AS acl_a ON acl_a.authorid =0
LEFT JOIN s9y_access AS acl_acc ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid )
WHERE isdraft = 'false'
AND e.timestamp <=1170160800
AND (
c.categoryid IS NULL
OR (
acl_acc.groupid =0
)
OR (
acl_acc.artifact_id IS NULL
)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
Code: Select all
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid,
e.trackbacks, e.isdraft, e.allow_comments, e.last_modified, a.realname AS author,
a.username AS loginname, a.email, e.body, e.extended
FROM s9y_entries AS e
LEFT OUTER JOIN s9y_authors a ON e.authorid = a.authorid
LEFT OUTER JOIN s9y_entrycat ec ON e.id = ec.entryid
LEFT OUTER JOIN s9y_category c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN s9y_authorgroups AS acl_a ON acl_a.authorid =0
LEFT OUTER JOIN s9y_access AS acl_acc ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid )
WHERE isdraft = 'false'
AND e.timestamp <=1170160800
AND (c.categoryid IS NULL OR (acl_acc.groupid = 0) OR (acl_acc.artifact_id IS NULL))
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
Code: Select all
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid,
e.trackbacks, e.isdraft, e.allow_comments, e.last_modified, a.realname AS author,
a.username AS loginname, a.email, e.body, e.extended
FROM s9y_entries AS e
LEFT OUTER JOIN s9y_authors a ON e.authorid = a.authorid
LEFT OUTER JOIN s9y_entrycat ec ON e.id = ec.entryid
LEFT OUTER JOIN s9y_category c ON ec.categoryid = c.categoryid
LEFT OUTER JOIN s9y_authorgroups AS acl_a ON acl_a.authorid =0
LEFT OUTER JOIN s9y_access AS acl_acc ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid )
WHERE isdraft = 'false'
AND e.timestamp <=1170160800
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
Code: Select all
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid,
e.trackbacks, e.isdraft, e.allow_comments, e.last_modified, a.realname AS author,
a.username AS loginname, a.email, e.body, e.extended
FROM s9y_entries AS e
LEFT OUTER JOIN s9y_authors a ON e.authorid = a.authorid
LEFT OUTER JOIN s9y_entrycat ec ON e.id = ec.entryid
LEFT OUTER JOIN s9y_category c ON ec.categoryid = c.categoryid
WHERE isdraft = 'false'
AND e.timestamp <=1170160800
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
Code: Select all
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid,
e.trackbacks, e.isdraft, e.allow_comments, e.last_modified, a.realname AS author,
a.username AS loginname, a.email, e.body, e.extended
FROM s9y_entries AS e
LEFT OUTER JOIN s9y_authors a ON e.authorid = a.authorid
WHERE isdraft = 'false'
AND e.timestamp <=1170160800
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
Code: Select all
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid,
e.trackbacks, e.isdraft, e.allow_comments, e.last_modified,
e.body, e.extended
FROM s9y_entries AS e
WHERE isdraft = 'false'
AND e.timestamp <=1170160800
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
Code: Select all
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid,
e.trackbacks, e.isdraft, e.allow_comments, e.last_modified,
e.body, e.extended
FROM s9y_entries AS e
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
Code: Select all
SELECT e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid,
e.trackbacks, e.isdraft, e.allow_comments, e.last_modified,
e.body, e.extended
FROM s9y_entries AS e
LIMIT 15
