Echec : 145 Table './faton/lien_article_nomenclature' is marked as crashed and should be repaired
CREATE TEMPORARY TABLE tmp_table_recherche_avancee (INDEX tmp_idx_pdt (id_pdt),INDEX tmp_idx_tit (id_tit)) AS SELECT SQL_CALC_FOUND_ROWS
tp.* , ta.id_art, ta.id_type_art, ta.libelle_art, ta.sous_titre_art, tt.ordre_tit, IF(NULLIF(tp2.actif_pdt,'0') IS NULL, NULL, tp2.numerique_maitre_pdt) as has_numeric
FROM table_produit as tp LEFT JOIN table_article as ta ON tp.id_pdt = ta.id_pdt LEFT JOIN table_titre as tt ON tp.id_tit = tt.id_tit LEFT JOIN lien_article_nomenclature as lan ON ta.id_art = lan.id_art LEFT JOIN table_produit as tp2 ON tp.id_pdt = tp2.numerique_maitre_pdt LEFT JOIN lien_article_auteur as laa ON ta.id_art = laa.id_art LEFT JOIN table_auteur as tau ON laa.id_aut = tau.id_aut LEFT JOIN table_produit_version_occasion tpo ON (tp.id_pdt = tpo.id_pdt) WHERE tp.id_type_pdt IN ( 1 , 5, 6, 10 ) AND tp.flag_sup_pdt = '0' AND tp.actif_pdt = '1' AND tp.archive_pdt = '0' AND tp.id_tit = '2' AND tau.id_aut = '5061' AND tp.code_pdt != '3LIV00142' AND tp.code_pdt != '3LIV00143' AND tp.code_pdt != '4LIV00084' AND tp.code_pdt != '4LIV00085' AND tp.code_pdt != '4LIV00086' AND tp.code_pdt != '4LIV00087' AND tp.code_pdt != '4LIV00088' AND tp.code_pdt != '4LIV00089' AND tp.code_pdt != '4LIV00090' AND tp.code_pdt != '3LIV00150' AND tp.code_pdt != '3LIV00151' AND tp.code_pdt != '3LIV00152' AND tp.code_pdt != '3LIV00153' AND tp.code_pdt != '3LIV00154' AND ( tp.id_vers NOT IN (9) OR tpo.stock_occasion_pdt > 0 ) GROUP BY tp.id_pdt, ta.id_art ORDER BY tt.ordre_tit, tp.date_pdt DESC, tp.num_pdt DESC , ordre_art ;