Incorrect key file for table '/tmp/#sql_d4e_0.MYI'; try to repair it SQL=SELECT a.id, a.catid, a.sectionid AS secid, a.title AS atitle, c.title AS ctitle, s.title AS stitle, a.introtext, a.fulltext, a.created, u.name, a.created_by_alias, a.hits, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS catslug FROM bn_content AS a INNER JOIN bn_sections AS s ON s.id = a.sectionid INNER JOIN bn_categories AS c ON c.id = a.catid LEFT JOIN bn_users AS u ON u.id = a.created_by WHERE a.state = 1 AND a.sectionid > 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-07-19 13:23:08') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-19 13:23:08') AND ((TO_DAYS('2018-07-19') - TO_DAYS(a.created)) <= '720') AND s.access <= 0 AND c.access <= 0 AND a.access <= 0 AND (s.id=1 OR s.id=2 OR s.id=3 OR s.id=4 OR s.id=5 OR s.id=6 OR s.id=7) AND s.published = 1 AND c.published = 1 ORDER BY a.hits DESC LIMIT 0, 4
Календарь выпусков
Incorrect key file for table '/tmp/#sql_d4e_0.MYI'; try to repair it SQL=SELECT a.id, a.catid, a.sectionid AS secid, a.title AS atitle, c.title AS ctitle, s.title AS stitle, a.introtext, a.fulltext, a.created, u.name, a.created_by_alias, a.hits, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS catslug FROM bn_content AS a INNER JOIN bn_sections AS s ON s.id = a.sectionid INNER JOIN bn_categories AS c ON c.id = a.catid LEFT JOIN bn_users AS u ON u.id = a.created_by WHERE a.state = 1 AND a.sectionid > 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-07-19 13:23:08') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-19 13:23:08') AND s.access <= 0 AND c.access <= 0 AND a.access <= 0 AND (s.id=1 OR s.id=2 OR s.id=3 OR s.id=4 OR s.id=5 OR s.id=6 OR s.id=7) AND s.published = 1 AND c.published = 1 ORDER BY a.created DESC LIMIT 0, 4
Следуй за белым кроликом
wrabbit