Error
  • Incorrect key file for table '#sql_35c_0.MYI'; try to repair it SQL=SELECT c.title as title, s.title as section, cat.title as category, CONCAT('index.php?option=com_content&view=article&id=', c.id) as link , c.catid as catslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_content as c, jos_sections as s, jos_categories as cat WHERE c.sectionid = s.id AND c.catid = cat.id AND c.state = '1' AND s.published = '1' AND cat.published = '1' AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2016-06-29 03:33:15' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2016-06-29 03:33:15' ) AND c.access <= '0' ORDER BY s.title, cat.title,c.title

    This was your SQL:

    SELECT c.title as title, s.title as section, cat.title as category, CONCAT('index.php?option=com_content&view=article&id=', c.id) as link , c.catid as catslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_content as c, jos_sections as s, jos_categories as cat WHERE c.sectionid = s.id AND c.catid = cat.id AND c.state = '1' AND s.published = '1' AND cat.published = '1' AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2016-06-29 03:33:15' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2016-06-29 03:33:15' ) AND c.access <= '0' ORDER BY s.title, cat.title,c.title

    End of SQL