Tag: Query

sql order by – Mysql, how to sort by query string with full text search MATCH AGAINST

Ex I have table:

ID name
1 bcd def abc
2 def abc
3 abc

I'm looking for boolean full-text searches like

SELECT * FROM table WHERE MATCH (name) VS (* abc * & # 39; IN BOOLEAN MODE)

how to arrange when abc is the first of text order results as follows:

ID name
1 abc
2 def abc
3 bcd def abc

If the position is & # 39; abc & # 39; is not, a head is pushed down

SQL Server – SQL query date range

I have a query to run on access. I wanted to retrieve them in SQL.

I have a table called test that contains the date and id fields. I try to return all records between 01.12.19 and 12.06.19 and execute them, but return the empty fields. Is the error displayed?

SELECT Date, ID FROM PROOF where & # 39; Date & # 39; BETWEEN & # 39; 12 / 01/2019 & # 39; AND & # 39; 12/06/2019 & # 39;

Reference query – eigenvalues ​​and domain of the Laplace Beltrami operator

Accept $ (M, g) $ is a compact Riemannian manifold without boundary where $ g $ is the Riemann metric. To let $ L: = – Delta $ be the Laplace Beltrami operator on $ M $ defined by $ Delta cdot = text {div} ( nabla cdot) $, I read in many books / papers that the Laplace-Beltrami operator on a closed Riemannian manifold has a positive discrete spectrum whose eigenvalues ​​accumulate at infinity. Here are some questions:

  1. What is the domain and reach of $ Delta $ to have the spectrum described above? Do you treat $ Delta $ as a desly defined unrestricted operator $ L ^ {2} (M) $ to $ L ^ {2} (M) $ with domain $ W ^ {1,2} (M) $ (or $ W ^ {2,2} (M) $?)? Or you think $ Delta $ as a limited operator? For example from $ W ^ {2,2} (M) $ to $ L ^ {2} $,

  2. Define weak solutions of $ Delta $ using the identities of the green
    $$ int_ {M} u Delta v text {Vol} _ {g} = – int_ {M} g ( nabla u, nabla v) text {Vol} _ {g} = int_ { M} v Delta u text {Vol} _ {g}, $$
    Does not the goal then have to be a dual space? Something like $ (W ^ {1,2} (M)) ^ {*} $?

  3. What is the exact formulation of spectrum and eigenvalues ​​of $ Delta $, provided you know the right domain and reach?

  4. Do you know a hint where this is discussed in detail? By that I mean an indication of where the domain, range, range of $ Delta $ on $ (M, g) $ is being discussed?

Cheers,
Martin

Drag the taxonomy field of the custom contribution type to the new query

I have a custom post type named companion, Through Companion, I create articles that are then mapped to my custom taxonomy issue companion, Imagine issueCompanion as a publication that appears periodically like a journal. I have another custom taxonomy called "Topic" that behaves like categories and is linked to every item in Companion.

I'll show this on the frontend taxonomy-issueCompanion.php, On this page I have to display the topic of each article next to each article. The articles are easy to include because they come with the regular WordPress loop (if have_posts () and have_posts ()), but I do not seem to be on the topic of taxonomy for each article displayed.

How do I display the corresponding issues of each article? In other words, how can I display a custom taxonomy (topic) for the contribution of a custom contribution type (Companion)? I feel like I did it 100 times but this time it does not seem to work for me.

Thank you for every input

Query Performance – SELECT optimization in Postgresql 10

I want to select the last unique lines based on the time.

    SELECT DISTINCT ON (title) *
FROM eco.tracks WHERE id> (SELECT id FROM eco.tracks WHERE time_track <((SELECT time_track FROM eco.tracks ORDER BY id DESC LIMIT 1) - INTERVAL & # 39; 300 seconds & # 39;) ORDER BY id DESC LIMIT 1 )
ORDER BY track, time_track DESC;

It gives me 20s, that's too slow.
If I replace ID with real value. it gives me 2ms

                    SELECT DISTINCT ON (title) *
FROM eco.tracks WHERE id> 48000000
ORDER BY track, time_track DESC;

This query

SELECT id FROM eco.tracks WHERE Time Track <((SELECT Time Track FROM eco.tracks ORDER BY id DESC LIMIT 1) - INTERVAL & # 39; 300 seconds & nds; ORDER BY id DESC LIMIT 1

only gives 2ms ..

What is wrong?!

Database – Can anyone help fix this slow query in WordPress?

I used the Query Monitor plugin to find slow queries on my WordPress site. The below mentioned WP_Query-> get_posts () takes about .3646 polling time of the entire database polling time of .3976.

SELECT wp_posts.ID
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WO 1 = 1
AND wp_posts.ID NOT IN (203598)
AND (wp_term_relationships.term_taxonomy_id IN (17)
OR wp_term_relationships.term_taxonomy_id IN (11652,20693,21952,23971,24907,24908,25928))
AND wp_posts.post_type = & # 39; post & # 39;
AND ((wp_posts.post_status = & # 39; publish & # 39;))
GROUP BY wp_posts.ID
ORDER TO wp_posts.post_date DESC
LIMIT 0, 6

I suspect it has something to do with the over 20,000 tags used in posts on my site. Is that so? If so, how do you suggest correcting this slow query? Or how do I go about deleting tags that are not used in more than 5 posts of all posts on the site?

Please help.

Data Structures – Can anyone explain how the MO algorithm works with the update query?

Thank you for sending a reply to Computer Science Stack Exchange!

  • Please be sure too answer the question, Provide details and share your research!

But avoid …

  • Ask for help, clarification or answering other questions.
  • Make statements based on opinions; Cover them with references or personal experience.

Use MathJax to format equations. Mathjax reference.

For more information, see our tips for writing great answers.

Why does this query return a result in MySQL but not in PHP?

I have a query that does not return a PHP result for a particular search term (which I believe), but when I test it directly in MySQL, it returns one. Other keywords are okay.

SELECT ID,
CONCAT_WS (& # 39 ;,
TRIM (SUBSTRING_INDEX (
SUBSTRING (`text`, 1, INSTR (` text`, & # 39; rig & # 39;) - 1),
& # 39; & # 39 ;,
-8th)
)
TRIM (SUBSTRING_INDEX (
SUBSTRING (`text`, INSTR (` text`, & # 39; rig & # 39;),
& # 39; & # 39 ;,
7)
)
) as `sample`,` title`, `url`
FROM `Documents` WHERE TO MATCH (text)
VS ("rig" & BOOLEAN MODE) OR GAME (title)
AGAINST ("RIG" & IN BOOLEAN MODE)

PHP:

if (! $ result = $ mysqliSiteSearch-> query ($ query)) send ("3149", "e");
$ hitArray = array ();
while ($ row = $ result-> fetch_assoc ()) {$ hitArray[]= $ row; }

I have set up a TXT log file to record the result of:

print_r ($ result, true)

I have tested another search term that returns 8 results both directly in MySQL and when running the PHP script. My log file shows the following:

mysqli_result object
(
    [current_field] => 0
    [field_count] => 4
    [lengths] => 
    [num_rows] => 8
    [type] => 0
)

I then test the search term "rig", which returns a line directly in MySQL when testing the same query, but when I run my PHP script, I get no hit and my log file shows:

mysqli_result object
(
    [current_field] => 0
    [field_count] => 4
    [lengths] => 
    [num_rows] => 0
    [type] => 0
)

Sure, I miss something, but what?

Thank you for your time and your help.

Hydra. Need help setting up a query! (Reward from me)

hydra -l ZOnEx -P / home / 22 / documents / top WEBSITE.COM http-get-form
"/ login: username = ^ USER ^ & password = ^ PASS ^ & act = login & submit = Login: S = Logout: C = __ cfduid = dc7dc335f1591484f690d3626677f462d1561143346;
language = en_EN;
Date = 2% 7CSat% 2C% 2022% 20Jun% 202019% 2007% 3A11% 3A08% 20GMT;
PHPSESSID = 8d8d10696b5b9146c722f0d63ad9aea3 "-vV -f

Hydra returns 0 password found on my own account. What could be wrong with the above query? I can simply log in to the account

https://website.com/login?username=^ZOnEx^&password=^qwerty^&act=login&submit=Login

As I found out, this website needs cookies for a successful login. It works in Chrome and Firefox with cookies enabled.

Thanks guys in advance, I'll send $ 20 in BTC for the right query.

Info about burp:

POST / Login HTTP / 1.1
Host: https://WEBSITE.COM
User-Agent: Mozilla / 5.0 (X11; Ubuntu; Linux x86_64; rv: 61.0) Gecko / 20100101 Firefox / 61.0
Accept: text / html, application / xhtml + xml, application / xml; q = 0.9, * / *; q = 0.8
Acceptance language: en-US, en; q = 0.5
Accept-Encoding: gzip, deflate
Referer: https://WEBSITE.COM
Content Type: application / x-www-form-urlencoded
Content length: 55
Cookie: __cfduid = dc7dc335f1591484f690d3626677f462d1561143346; language = en_EN; Date = 2% 7CSat% 2C% 2022% 20Jun% 202019% 2007% 3A11% 3A08% 20GMT; PHPSESSID = 8d8d10696b5b9146c722f0d63ad9aea3
Connection: close
Upgrade Insecure Requests: 1

Username = ZOnEx & Password = qwerty & act = login & submit = Login