Tous les liens

SELECT COUNT(links.link_url) as count, MIN(links.edit_date) as oldest_date, MAX(links.edit_date) as newest_date FROM `yacs_links` AS links LEFT JOIN `yacs_articles` AS articles ON (articles.id LIKE SUBSTRING_INDEX(links.anchor, ':', -1)) WHERE (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-07-11 10:16:05')) AND (links.edit_action != 'link:feed')
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT links.* FROM `yacs_links` AS links LEFT JOIN `yacs_articles` AS articles ON (articles.id LIKE SUBSTRING_INDEX(links.anchor, ':', -1)) WHERE (articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2025-07-11 10:16:05')) AND (links.edit_action != 'link:feed') ORDER BY links.edit_date DESC, links.title LIMIT 0,50
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed

SELECT * FROM `yacs_links` AS links GROUP BY links.link_url ORDER BY links.hits DESC, links.title LIMIT 0,7
144: Table './openconsortium/yacs_links' is marked as crashed and last (automatic?) repair failed