source of results – The SharePoint 2016 query generator inserts "ContentTypeId" instead of "ContentType"

In on-premises SharePoint 2016, I was having trouble getting results based on a content type that I had created when trying to configure a result source to search for that type of content . I finally decided to see what I had done on a working SharePoint 2013 site, when I realized that using the result source query generator in 2016 , when I choose "ContentType" and click "Add a property filter", the query generator actually inserted "ContentTypeId", not "ContentType". It baffled me a little. I just wanted to post this, in case someone has a similar problem. Once I manually edited the inserted text to simply delete the "Id" at the end of "ContentType", the source of the results worked as I expected. Is this a bug in SharePoint 2016 or is it expected to be in one way or another? If so, where do you report bugs in SharePoint to Microsoft?

enter description of image here

content – Blocking URL in bing always appears in search results

I am trying to prevent a URL from appearing in the search results. I am the site's webmaster, and the content has been removed, I used the blocking URL link 2 days ago and it still appears. I used the content removal tool last night and the status says "finished" and again the link still appears.

How can I remove them as soon as possible!

How to stop Impala query results on the command line

Suppose I execute this request:

select db_name from mygianttable

in the Impala command line (impala-shell) and returns 150,000 lines. Is there a way to cancel / prevent the results from showing? I tried to press CTRL-C, but nothing happened.

I need a pagination like this Results 1-28 of 246 in magento

I need a pagination like this Showing 1-28 of 246 results in magento2 instead of default magento 28 items

postgresql – Are the triggers and their results visible in the same order as the original operations?

I created a simple trigger

    id int,
    v1 text,
    v2 text

    id serial primary key,
    v1 text

CREATE OR REPLACE FUNCTION emit_event_for_v1()
RETURNS trigger AS '
        IF OLD.v1 != NEW.v1 THEN
            INSERT INTO events (v1)
            VALUES (NEW.v1);
        END IF;
        RETURN NULL;
' LANGUAGE 'plpgsql';


INSERT INTO data VALUES (1, '', '');

After that, I launched many clients (25) making numerous updates (500 each) on the
The data.

UPDATE data SET v1 = $1 WHERE id = 1

with $1 being $WORKER_ID : $ITER_ID. In the end, I checked that the last
event inserted (SELECT id, v1 FROM events ORDER BY id DESC) corresponds to the current
data status (SELECT v1 FROM data WHERE id = 1).

I also checked that id of the last event is equal to the number of updates
((25 * 500). And it is.

My question is, does it work? Results of insertions into triggers
still visible in the same order as the original update that triggered the trigger?
Or did I just get lucky in my tests (like 50 times in a row)?

How to filter Youtube search results by language?

I want to get the video result in a specific language.

I want a filler like this:

test, lang:ru

enter description of image here
Didn't work

Or maybe in the url parameters filter:

Didn't work too

Can someone give me advice on how to filter YouTube results by language.

Inconsistencies of modern search results on SharePoint 2019 site

I am trying to understand the modern search experience with SharePoint 2019 on site. There seems to be some inconsistency in the results that present the results of the new modern "immediate" search box, I think this is what is called. In this example. I have a modern OOTB communication site, with a news article (my computer site is now online) and a modern page (request a service).

As you can see in the first screenshot, on the SharePoint home page, the two results are immediately displayed when a user places the cursor in the search box, exactly what I want.

Search results on the SharePoint home page

The second screenshot is the search box on the My IT Communication site. You can see that the search results that appear in the modern search box do not contain the "Request a service" page. And in fact, doesn't list any files.

Immediate results from the search field of my computer communication site

The third screenshot shows that the page is actually indexed and is displayed on the search results screen:

Search results on my computer communication site

Did I miss something? Shouldn't the "Request a service" page appear in the immediate search box results? Is there a file type restriction on this modern search box? And if so, is it configurable? I have spent a lot of time googling this and reading the "documentation", but I haven't found much substance that will help me understand how this modern search box works, and if it can be configured.

python – Haversine Distance – Incorrect results

I use the following code to find the haversine distance

def haversine_np(lon1, lat1, lon2, lat2):

    lon1, lat1, lon2, lat2 = map(np.radians, (lon1, lat1, lon2, lat2))

    dlon = lon2 - lon1
    dlat = lat2 - lat1

    a = np.sin(dlat/2.0)**2 + np.cos(lat1) * np.cos(lat2) * np.sin(dlon/2.0)**2

    c = 2 * np.arcsin(np.sqrt(a))
    km =  6372.8 * c
    return km

For lat1 and long1, I used values 24.885164 & 67.034685 respectively. For lat2 and long2, I used values 24.875454 & 67.031416 respectively. The distance I get is 0.55 km, but most online calculators give an answer of 1.1 km. What can be the possible error?

Does anyone know how to display additional data, on the number of jobs on the page, in Google search results?

I noticed that when I search for jobs on Google, for example "plumber jobs in Melbourne", some results contain pre-added data "407 jobs" before displaying the normal meta description.

example of search result

Anyone know what the search did to get this data displayed in Google search results?

path alias – Pathauto generates strange results with Drupal Commerce

I tried to create a template using the Drupal Commerce 2 categories and the product title.


When I generate the URL alias, I get http: // localhost: 8080 / diagnostics-systems / products-18.

When I generate with the pattern:


everything comes out correctly.

I have set the maximum number of generated URL characters to 255, but these even seem to be getting close. Ideas?