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 '- ON n.vid=text1_-.vid LEFT JOIN lo_node_revisions text2_- ON n.vid=text2_-.vid ' at line 1 query: SELECT n.nid FROM lo_node n LEFT JOIN lo_node_revisions text1_- ON n.vid=text1_-.vid LEFT JOIN lo_node_revisions text2_- ON n.vid=text2_-.vid LEFT JOIN lo_node text3_- ON n.vid=text3_-.vid LEFT JOIN lo_content_field_tilaus_loppuu tilaus ON n.vid=tilaus.vid LEFT JOIN lo_content_field_paino paino ON n.vid = paino.vid WHERE n.type="kohteen_tiedot" AND n.status=1 AND n.language="fi" AND (text1_-.body LIKE "%-%" OR text2_-.teaser LIKE "%-%" OR text3_-.title LIKE "%-%") AND `tilaus`.`field_tilaus_loppuu_value` <= "2013-06-19T19:06:17" AND `tilaus`.`field_tilaus_loppuu_value2` > "2013-06-19T19:06:17" ORDER BY `paino`.`field_paino_value` ASC, n.nid in /home/admin/public_html/sites/all/modules/search_mokki/search_mokki.module on line 885.