Query: SELECT 
     seo_ngrams.ngram
    ,seo_ngrams.length
    ,b_seo_ngrams.frequency
    ,seo_ngrams.keyword
    ,seo_keywords.category
    ,seo_keywords.volume 
FROM 
seo_ngrams 
    LEFT JOIN 
seo_ngrams as b_seo_ngrams
    ON seo_ngrams.keyword=b_seo_ngrams.keyword && seo_ngrams.keyword=b_seo_ngrams.ngram
    LEFT JOIN
seo_keywords 
    ON seo_ngrams.keyword=seo_keywords.keyword 
WHERE (seo_ngrams.keyword = 'hartley\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\') && seo_ngrams.length='0' && seo_keywords.deleted_at IS NULL && seo_ngrams.department='OUTDOOR' && seo_ngrams.is_keyword='1' && seo_ngrams.category NOT IN ('DELETED','COMPETITOR','UNCATEGORISED')
ORDER BY volume DESC,length ASC
<br />MySQL Error: 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 '0' && seo_keywords.deleted_at IS NULL && seo_ngrams.department='OUTDOOR' && seo_' at line 16