- user warning: Incorrect key file for table 'node'; try to repair it
query: SELECT COUNT(*) FROM node n LEFT JOIN localizernode loc ON loc.nid=n.nid LEFT JOIN( SELECT -100 AS weight, CAST('it' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 0 AS weight, CAST('sl' AS CHAR(10)) AS language ) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) AS minweight from localizernode loc2 LEFT JOIN ( SELECT -100 AS weight, CAST('it' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 0 AS weight, CAST('sl' AS CHAR(10)) AS language ) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) AND ( n.promote = 1 AND n.status = 1 ) in /home/maieuta/public_html/includes/database.mysql.inc on line 172.
- user warning: Incorrect key file for table 'node'; try to repair it
query: SELECT n.nid, n.sticky, n.created FROM node n LEFT JOIN localizernode loc ON loc.nid=n.nid LEFT JOIN( SELECT -100 AS weight, CAST('it' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 0 AS weight, CAST('sl' AS CHAR(10)) AS language ) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) AS minweight from localizernode loc2 LEFT JOIN ( SELECT -100 AS weight, CAST('it' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 0 AS weight, CAST('sl' AS CHAR(10)) AS language ) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) AND ( n.promote = 1 AND n.status = 1 ) ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /home/maieuta/public_html/includes/database.mysql.inc on line 172.