(SELECT ik.item_id, ik.ikind9_video_embed, i.item_name, i.item_des, i.user_id, n.name AS nation, c.name, CONVERT(i.item_created, DATETIME) AS createDate FROM itemkind9 AS ik JOIN items AS i ON(ik.item_id = i.item_id) INNER JOIN link_item_county AS ci ON (i.item_id = ci.item_id AND ci.ikind_table_id = '9') INNER JOIN list_county AS c ON(ci.list_id = c.list_id) INNER JOIN list_national AS n ON(c.national_list_id = n.list_id) WHERE i.item_status = 'live' ) UNION (SELECT ik.item_id, ik.ikind9_video_embed, i.item_name, i.item_des, i.user_id, n.name AS nation, '' AS name, CONVERT(i.item_created, DATETIME) AS createDate FROM itemkind9 AS ik JOIN items AS i ON(ik.item_id = i.item_id) INNER JOIN link_item_national AS ci ON (i.item_id = ci.item_id AND ci.ikind_table_id = '9') INNER JOIN list_national AS n ON(ci.list_id = n.list_id) WHERE i.item_status = 'live' ) ORDER BY createDate DESC [nativecode=1030 ** Got error 28 from storage engine]
Failed: DB Error: unknown error