Unknown column 'rural' in 'where clause': SELECT * FROM propiedades  WHERE id = rural-hotels   ORDER BY alta DESC