Skip to main content Help Control Panel

Logo

Le site des sports de nature associatifs

 

Search

SELECT *, (MATCH(title, source, introduction, overlay, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM yacs_articles AS articles WHERE ((articles.active='Y') AND NOT ((publish_date is NULL) OR (publish_date <= '0000-00-00')) AND (publish_date < '2022-12-04 12:34:36') AND ((expiry_date is NULL) OR (expiry_date <= '0000-00-00 00:00:00') OR (expiry_date > '2022-12-04 12:34:36'))) AND ((MATCH(title, source, introduction, overlay, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, source, introduction, overlay, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

SELECT sections.*, (MATCH(title, introduction, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM yacs_sections AS sections WHERE ((MATCH(title, introduction, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, introduction, description) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) AND ((sections.active='Y') AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2022-12-04 12:34:36'))) ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

SELECT *, (MATCH(title, introduction, description, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM yacs_categories AS categories WHERE ((MATCH(title, introduction, description, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, introduction, description, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) AND (categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2022-12-04 12:34:36')) ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

SELECT *, (MATCH(title, source, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) AS score FROM yacs_files AS files WHERE ((MATCH(title, source, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) < 1) AND ((MATCH(title, source, keywords) AGAINST('*' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), edit_date)))) > 0) AND (active='Y') ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

SELECT *, (MATCH(nick_name, full_name, introduction, description) AGAINST('+**' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), login_date)))) AS score FROM yacs_users AS users WHERE ((MATCH(nick_name, full_name, introduction, description) AGAINST('+**' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), login_date)))) < 1) AND ((MATCH(nick_name, full_name, introduction, description) AGAINST('+**' IN BOOLEAN MODE)/SQRT(GREATEST(1.1, DATEDIFF(NOW(), login_date)))) > 0.0) AND (users.active='Y') AND (users.capability IN ('S', 'M', 'A')) ORDER BY score DESC LIMIT 20
1064: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

You are searching for

Type one or several words.

Search in

Look in all or only one section.

No page has been found. This will happen with very short words (less than 4 letters), that are not fully indexed. This can happen as well if more than half of pages contain the searched words. Try to use most restrictive words and to suppress "noise" words.

Help
This search engine only display pages that have all words in it.

Also, only exact matches will be listed. Therefore "category" and "categories" won't give the same results. Note that "red" and "reds" may also give different results.

Monitor
Recent searches