Ask Your Question

Listings dropped for WarrentCounty

asked 2019-04-30 15:51:06 -0600

updated 2019-04-30 15:52:26 -0600

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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-04-30 17:58:17 -0600

updated 2019-04-30 17:59:44 -0600

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.

edit flag offensive delete link more


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 gravatar imagebrokersolutions ( 2019-05-01 09:55:03 -0600 )edit

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

bwolven gravatar imagebwolven ( 2019-05-01 09:58:51 -0600 )edit

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

brokersolutions gravatar imagebrokersolutions ( 2019-05-01 10:37:02 -0600 )edit

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

bwolven gravatar imagebwolven ( 2019-05-01 10:42:30 -0600 )edit

that fix our issue

brokersolutions gravatar imagebrokersolutions ( 2019-05-01 14:33:59 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-30 15:51:06 -0600

Seen: 517 times

Last updated: Apr 30 '19