Skip to main content Help Control Panel
Le site des sports de nature associatifs | ||
SearchSELECT *, (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-08-12 18:41:11') AND ((expiry_date is NULL) OR (expiry_date <= '0000-00-00 00:00:00') OR (expiry_date > '2022-08-12 18:41:11'))) 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 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-08-12 18:41:11'))) ORDER BY score DESC LIMIT 20 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-08-12 18:41:11')) ORDER BY score DESC LIMIT 20 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 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 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. |
| |
page prepared in 0.12 seconds for Anonymous@3.236.225.157 - © Daniel Dupuis 2016 - login - about this site - privacy statement - powered by Yacs - information channels |