Could not execute SELECT COUNT(*) FROM ( SELECT date.dateID, year, month, day, hour, minute, second, countryID, rough, descriptif, source, sourceAuteur, status FROM event, date WHERE match(descriptif) against('%Chute du Mur de Berlin%' IN BOOLEAN MODE) AND event.languageID = 'fr' AND event.dateID = date.dateID UNION SELECT date.dateID, date.year, date.month, date.day, hour, minute, second, countryID, rough, descriptif, source, sourceAuteur, status FROM category, event, date WHERE match(category) against('%Chute du Mur de Berlin%' IN BOOLEAN MODE) AND category.languageID = 'fr' AND category.dateID = date.dateID AND date.dateID = event.dateID AND event.languageID = 'fr' ) as t1 LEFT JOIN kronoquiz USING(dateID) ORDER by t1.year, t1.month, t1.day, hour, minute, second, countryID statement... maybe invalid?