Unknown column 'viviendas' in 'where clause': SELECT * FROM blog_posts  WHERE subcategoria_id = viviendas