Serendipity Forums

Code: Select all

Name          	Typ	    Kardinalität	Feld
PRIMARY              PRIMARY	1  	 	 	id 
staticentry_idx 	FULLTEXT	keine  	 	headline und content

Code: Select all

        $querystring = "SELECT $distinct s.*, a.realname
                          FROM {$serendipity['dbPrefix']}staticpages AS s
               LEFT OUTER JOIN {$serendipity['dbPrefix']}authors AS a
                            ON a.authorid = s.authorid
                         WHERE $find_part
                           AND s.publishstatus = 1
                           AND s.pass = ''
                               $group
                      ORDER BY timestamp DESC";

Code: Select all

echo $querystring;

Code: Select all

SELECT s.*, a.realname FROM serendipity_stm_staticpages AS s LEFT OUTER JOIN serendipity_stm_authors AS a ON a.authorid = s.authorid WHERE MATCH(headline,content) AGAINST('Inhaltlich') AND s.publishstatus = 1 AND s.pass = '' GROUP BY id ORDER BY timestamp DESC

Code: Select all

MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen). (die Abfrage dauerte 0.0012 sek)
SQL-Befehl:
SELECT s. * , a.realname
FROM serendipity_stm_staticpages AS s
LEFT OUTER JOIN serendipity_stm_authors AS a ON a.authorid = s.authorid
WHERE MATCH (
headline, content
)
AGAINST (
'Inhaltlich'
)
AND s.publishstatus =1
AND s.pass = ''
GROUP BY id
ORDER BY timestamp DESC 
LIMIT 0 , 30