Guestbook

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 0, 10' at line 1 query: SELECT node.nid, timestamp, node.title AS node_title, node.changed AS node_changed, node_data_field_city.field_city_value AS node_data_field_city_field_city_value, node_data_field_email.field_email_email AS node_data_field_email_field_email_email, node_data_field_web.field_web_url AS node_data_field_web_field_web_url, node_data_field_web.field_web_title AS node_data_field_web_field_web_title, node_data_field_web.field_web_attributes AS node_data_field_web_field_web_attributes, node.created AS node_created, node_data_field_risposta.field_risposta_value AS node_data_field_risposta_field_risposta_value, node_data_field_risposta.field_risposta_format AS node_data_field_risposta_field_risposta_format FROM node node LEFT JOIN content_type_message node_data_field_city ON node.vid = node_data_field_city.vid LEFT JOIN content_type_message node_data_field_email ON node.vid = node_data_field_email.vid LEFT JOIN content_type_message node_data_field_web ON node.vid = node_data_field_web.vid LEFT JOIN content_type_message node_data_field_risposta ON node.vid = node_data_field_risposta.vid LEFT JOIN localizernode loc ON loc.nid=node.nid LEFT JOIN(SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language UNION SELECT 2 AS weight, CAST('fr' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('it' 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('en' AS CHAR(10)) AS language UNION SELECT 2 AS weight, CAST('fr' AS CHAR(10)) AS language UNION SELECT 1 AS weight, CAST('it' 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 ( (node.type IN ('message')) AND ('applylocalizer'='applylocalizer') ) ORDER BY ASC LIMIT 0, 10 in /accounts/psegno_b401/www/.sandbox/luxrest-venice.com/webroot/includes/database.mysqli.inc on line 151.