Thank you for the reply.
You are right, I did not notice for images.
Code:
SELECT i.*, ie.*, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,117,208,128,209,207,145,155,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title
Incorrect key file for table '/tmp/#sql_2833_0.MYI'; try to repair it SQL=SELECT i.*, ie.*, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM jom17_content AS i LEFT JOIN jom17_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN jom17_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN jom17_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jom17_categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,117,208,128,209,207,145,155,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title LIMIT 0, 15
SELECT i.*, ie.*, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,206,96,117,208,128,209,207,145,155,205,161,160,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title
Incorrect key file for table '/tmp/#sql_2833_0.MYI'; try to repair it SQL=SELECT i.*, ie.*, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM jom17_content AS i LEFT JOIN jom17_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN jom17_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN jom17_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jom17_categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.state IN ( 1, -5 ) AND c.id IN (211,210,212,206,96,117,208,128,209,207,145,155,205,161,160,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,204,203,215,217,220,221) GROUP BY i.id ORDER BY i.created DESC, i.title LIMIT 0, 100
SELECT i.*, ie.*, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.id <> 0 AND i.state IN ( 1, -5 ) AND c.id IN (145,155,161,208,217) GROUP BY i.id ORDER BY i.created DESC, i.title
Incorrect key file for table '/tmp/#sql_2833_0.MYI'; try to repair it SQL=SELECT i.*, ie.*, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM jom17_content AS i LEFT JOIN jom17_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN jom17_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN jom17_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jom17_categories AS c ON c.id = rel.catid WHERE c.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-01-04 11:40:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-01-04 11:40:35' ) AND i.access <= 1 AND i.id <> 0 AND i.state IN ( 1, -5 ) AND c.id IN (145,155,161,208,217) GROUP BY i.id ORDER BY i.created DESC, i.title LIMIT 0, 5
To be honest, I don't know how to do that. I am a beginner in server and everything that goes with.