SELECT *  
FROM db_buscador
WHERE 
 activo != ''  And habitaciones = 9 Limit 10000