Error with query. - List Articles
SELECT
t1.id,
t1.title_es AS the_title,
t1.subtitle_es AS the_subtitle,
t1.desc_es AS the_body,
DATE_FORMAT(t1.date_add, '%d-%m-%Y') as date_add,
t3.name AS this_writer,
t4.foto,
t5.menu_es AS cat_title,
t5.url_es AS cat_url
FROM
web_articles AS t1
LEFT JOIN web_writers AS t3 ON (t3.id=t1.id_writer)
LEFT JOIN web_fotos AS t4 ON (t4.id_article=t1.id)
LEFT JOIN menu_web AS t5 ON t5.id=t1.id_cat
WHERE
t1.id>0
AND t1.active_state=1
AND t1.id_cat = '9' AND text_search = '"http:'
GROUP BY t1.id
ORDER BY
t1.date_add DESC
Unknown column 'text_search' in 'where clause'