Ygthkb

Promise.all returning empty objects

A sequence of orthogonal projection in Hilbert space

Do we still track damage on indestructible creatures?

Identical projects by students at two different colleges: still plagiarism?

Problems formatting part entries in ToC with `titletoc`

Is layered encryption more secure than long passwords?

How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?

Can you say "leftside right"?

What's the reason that we have a different number of days each month?

How bad is a Computer Science course that doesn't teach Design Patterns?

Why did Ylvis use "go" instead of "say" in phrases like "Dog goes 'woof'"?

Players preemptively rolling, even though their rolls are useless or are checking the wrong skills

Does copper wire need to say it's copper?

Crack the bank account's password!

Why is Shelob considered evil?

How do I avoid the "chosen hero" feeling?

Is it possible to detect 100% of SQLi with a simple regex?

Is it really OK to use "because of"?

What does an unprocessed RAW file look like?

Is there any danger of my neighbor having my wife's signature?

What happened to Hermione’s clothing and other possessions after she wiped her parents’ memories of her?

What is an explicit bijection in combinatorics?

Why do single electrical receptacles exist?

Are there historical references that show that "diatonic" is a version of 'di-tonic' meaning 'two tonics'?

repalce query with left join and not in

MySQL : LEFT JOIN not fetching required dataMySQL select with left join queryGrouping results with left and inner join with zero countsLEFT JOIN DEFAULT NULL VALUEleft join on closest dateQuery with WHERE NOT and NOT IN with subqueryLeft Join Not returning rows when date is in range of longer than 1 dayMySQL: SELECT and JOIN with not exists values?How filter Not NULL rows after multiple LEFT JOIN?MYSQL ONLY RIGHT JOIN WHEN LEFT SIDE NULL

-1

i write a query with NOT EXIST like this

> select id_request,username_request   from darkhast_follower  where

> darkhast_follower.id_request != '9762952594'     AND

> darkhast_follower.status =0     AND NOT exists ( select null

>                from log_follow 

>                where log_follow.other_id = darkhast_follower.id_request 

>                AND log_follow.id= '9762952594' LIMIT 1)  LIMIT 1

i want change them to NOT IN OR LEFT JOIN

plz help me

mysql query-performance query

share

edited 1 min ago

Marvan Eimaz

asked 9 mins ago

Marvan EimazMarvan Eimaz

42

add a comment | 

-1

i write a query with NOT EXIST like this

> select id_request,username_request   from darkhast_follower  where

> darkhast_follower.id_request != '9762952594'     AND

> darkhast_follower.status =0     AND NOT exists ( select null

>                from log_follow 

>                where log_follow.other_id = darkhast_follower.id_request 

>                AND log_follow.id= '9762952594' LIMIT 1)  LIMIT 1

i want change them to NOT IN OR LEFT JOIN

plz help me

mysql query-performance query

share

edited 1 min ago

Marvan Eimaz

asked 9 mins ago

Marvan EimazMarvan Eimaz

42

add a comment | 

i write a query with NOT EXIST like this

> select id_request,username_request   from darkhast_follower  where

> darkhast_follower.id_request != '9762952594'     AND

> darkhast_follower.status =0     AND NOT exists ( select null

>                from log_follow 

>                where log_follow.other_id = darkhast_follower.id_request 

>                AND log_follow.id= '9762952594' LIMIT 1)  LIMIT 1

i want change them to NOT IN OR LEFT JOIN

plz help me

mysql query-performance query

share

edited 1 min ago

Marvan Eimaz

asked 9 mins ago

Marvan EimazMarvan Eimaz

42

> select id_request,username_request   from darkhast_follower  where

> darkhast_follower.id_request != '9762952594'     AND

> darkhast_follower.status =0     AND NOT exists ( select null

>                from log_follow 

>                where log_follow.other_id = darkhast_follower.id_request 

>                AND log_follow.id= '9762952594' LIMIT 1)  LIMIT 1

share

edited 1 min ago

Marvan Eimaz

asked 9 mins ago

Marvan EimazMarvan Eimaz

42

share

edited 1 min ago

Marvan Eimaz

asked 9 mins ago

Marvan EimazMarvan Eimaz

42

asked 9 mins ago

Marvan EimazMarvan Eimaz

42

asked 9 mins ago

Marvan EimazMarvan Eimaz

42