No problem. Sorry for the delay, though:
Code: Select all
SELECT
multilingual_body.value AS multilingual_body,
multilingual_extended.value AS multilingual_extended,
multilingual_title.value AS multilingual_title,
e.id,
e.authorid,
a.realname AS author,
e.allow_comments,
e.moderate_comments,
a.email,
e.timestamp,
e.comments,
e.title,
e.body,
e.extended,
e.trackbacks,
e.exflag,
e.isdraft,
e.last_modified,
a.username AS loginname
FROM
serendipity_entries e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT OUTER JOIN serendipity_entryproperties multilingual_body
ON (e.id = multilingual_body.entryid AND multilingual_body.property = 'multilingual_body_de')
LEFT OUTER JOIN serendipity_entryproperties multilingual_extended
ON (e.id = multilingual_extended.entryid AND multilingual_extended.property = 'multilingual_extended_de')
LEFT OUTER JOIN serendipity_entryproperties multilingual_title
ON (e.id = multilingual_title.entryid AND multilingual_title.property = 'multilingual_title_de')
WHERE
(MATCH(title,body,extended) AGAINST('memento') OR (
MATCH(multilingual_body.value) AGAINST('memento' )
OR MATCH(multilingual_extended.value) AGAINST('memento' )
OR MATCH(multilingual_title.value) AGAINST('memento' )
))
AND isdraft = 'false' AND timestamp <= 1330714800
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 7
Code: Select all
SELECT
multilingual_body.value AS multilingual_body,
multilingual_extended.value AS multilingual_extended,
multilingual_title.value AS multilingual_title,
e.id,
e.authorid,
a.realname AS author,
e.allow_comments,
e.moderate_comments,
a.email,
e.timestamp,
e.comments,
e.title,
e.body,
e.extended,
e.trackbacks,
e.exflag,
e.isdraft,
e.last_modified,
a.username AS loginname
FROM
serendipity_entries e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT OUTER JOIN serendipity_entryproperties multilingual_body
ON (e.id = multilingual_body.entryid AND multilingual_body.property = 'multilingual_body_de')
LEFT OUTER JOIN serendipity_entryproperties multilingual_extended
ON (e.id = multilingual_extended.entryid AND multilingual_extended.property = 'multilingual_extended_de')
LEFT OUTER JOIN serendipity_entryproperties multilingual_title
ON (e.id = multilingual_title.entryid AND multilingual_title.property = 'multilingual_title_de')
WHERE
(MATCH(title,body,extended) AGAINST('memento*' IN BOOLEAN MODE) OR (
MATCH(multilingual_body.value) AGAINST('memento*' IN BOOLEAN MODE)
OR MATCH(multilingual_extended.value) AGAINST('memento*' IN BOOLEAN MODE)
OR MATCH(multilingual_title.value) AGAINST('memento*' IN BOOLEAN MODE)
))
AND isdraft = 'false' AND timestamp <= 1330714800
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 7
Search string is "Memento" again. If search succeeds (multilingual plugin deactivated), it gives back exactly one article. If it fails (multilingual plugin activated), it shows all currently available 749 articles.
The first statement returns an error:
Code: Select all
#1191 - Can't find FULLTEXT index matching the column list
The second statement shows the first seven articles (due to the "LIMIT 7" part) instead of showing just one article where the keyword "Memento" was used.