error executing querySELECT DISTINCT(p.id), p.url_identifier, pl.title,pl.short_description,p.price,pcl.title AS category_title, p.id_category, p.turnover_rank,pl.location,pl.numperson, pl.length, r.position, r.typo, MATCH (pl.title, pl.meta_keywords) AGAINST ('""' IN BOOLEAN MODE)*2 AS relevance1, MATCH (pl.short_description, pl.description) AGAINST ('""' IN BOOLEAN MODE) AS relevance2 FROM table_articles_references r LEFT JOIN table_products p ON (p.id=r.id_typo AND r.typo LIKE 'produkt') LEFT JOIN table_products_locations loc ON p.id=loc.id_product LEFT JOIN filters_products fp ON p.id=fp.id_product LEFT JOIN table_products_lang pl ON (p.id=pl.id_product AND pl.id_lang=1) LEFT JOIN table_products_categories_lang pcl ON (p.id_category=pcl.id_category AND pcl.id_lang=1) WHERE r.typo LIKE 'produkt' AND r.id_article= AND p.active='1' AND pcl.id_category NOT IN(10) AND (p.price BETWEEN 0 AND 999999) ORDER BY relevance1 DESC, relevance2 DESC, p.turnover_rank ASCYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.active='1' AND pcl.id_category NOT IN(10) AND (' at line 12