First time here? Check out the FAQ!

Listings dropped for WarrentCounty

  • retag add tags

Hi, Our listings dropped for warren county Loginurl: Username: CWS

Our listings dropped from 1777 from 1255 and here are the examples of missing listings. Can you please look into this?mlsnumber :124289,124498,125609

This is the query we are running for residential class But when we run the below query we are only getting 627 listings

before it fail when that query ran We used to get 879 residential listings .

Nothing has change from our side. We started this issue from Mon 4/29/2019 11:54 AM, the listings dropped to 1777 to 1543 then later at Mon 4/29/2019 1:54 PM it dropped to 1282.

What happen at 11:54 am yesterday, anything change ? Hope this is more helpful

brokersolutions's avatar
asked 2019-04-30 15:51:06 -0500, updated 2019-04-30 15:52:26 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


Looks like some of the offices may have had their primary board removed or something.
When I use this query:
I get a count of Search Count: 926 for 1F_1 class.
The three you listed above have empty LO1_board_id.

bwolven's avatar
answered 2019-04-30 17:58:17 -0500, updated 2019-04-30 17:59:44 -0500
edit flag offensive 0 remove flag delete link


When we run that query we are only getting 626 records

Those three listings used to be asscoaited with Board Southern Adirondack Realtors, Inc.

brokersolutions's avatar brokersolutions (2019-05-01 09:55:03 -0500) edit

Are you sure you ran the query above including this part?

bwolven's avatar bwolven (2019-05-01 09:58:51 -0500) edit

When i do that we are getting 17419 records.We dont want that, we only want Southern Adirondack Realtors, Inc. records .

brokersolutions's avatar brokersolutions (2019-05-01 10:37:02 -0500) edit

You missed the "(" ... ")" around the board OR statement.

bwolven's avatar bwolven (2019-05-01 10:42:30 -0500) edit

that fix our issue

brokersolutions's avatar brokersolutions (2019-05-01 14:33:59 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer