Ygthkb

How can I differentiate duration vs starting time

Sri Keyuravati of krama tradition

What could cause an entire planet of humans to become aphasic?

Boss asked me to sign a resignation paper without a date on it along with my new contract

Why do objects rebound after hitting the ground?

How to deal with an underperforming subordinate?

How can I handle players killing my NPC outside of combat?

Putting a vertical line in each Histogram using GraphicsGrid

Did ancient Germans take pride in leaving the land untouched?

How to get a 2D Plot from a 3D Listplot?

In a post-apocalypse world, with no power and few survivors, would Satnav still work?

Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?

Would water spill from a bowl in a Bag of Holding?

Is "accuse people to be racist" grammatical?

Is Screenshot Time-tracking Common?

How to know if I am a 'Real Developer'

How can I put a period right after the algorithm's number in the algorithm's title?

Modern Algebraic Geometry and Analytic Number Theory

Can I legally make a website about boycotting a certain company?

Maybe pigeonhole problem?

What does an unprocessed RAW file look like?

Bursted bubble like details on material

"I showed the monkey himself in the mirror". Why is this sentence grammatical?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Two mysql select queries into one query

How to get non-deleted messages for one user_id if the same user_id appears in two tables at same time?Can I execute a prepared statement inside a MySQL SELECT?Slow performance of MySQL Join QueryMySQL Query Optimization - Indexes & Joins 12 million+ recordscompare results between two select queries MySQLPrivilege to select only user's own tuple only in mysqlHelp combining two MySQL queries to improve performanceHow to combine “SELECT” and “REPLACE INTO” when combining two MySQL tables into another?Does MySQL allows incoming queries while altering a table?SQL schema for movie rating and seenlist

0

user

id   |  name

1    |  A

2    |  B

article

id   | title | descritption

1    | wx    | xyz

2    | yz    | abc

article_rating

article_id(article->id)  |  given_by(user->id)  |  given_rating

   1                              2                  4

   2                              1                  3

saved_article

article_id(article->id)  |  saved_by(user->id) 

   1                              2            

I'm changing some buttons and icons depending on whether a user has rated/ saved an article or not. I'm using two select queries for that:

rated or not

SELECT given_rating as rating 

FROM article_rating 

WHERE  given_by=? AND article_id=?

saved or not

SELECT saved_by as saved 

FROM saved_article 

WHERE  saved_by=? AND article_id=?

So my question is how can i combine both into one mysql query efficiently??

mysql

share|improve this question

edited 2 mins ago

Share corn

asked 18 mins ago

Share cornShare corn

1

add a comment | 

0

user

id   |  name

1    |  A

2    |  B

article

id   | title | descritption

1    | wx    | xyz

2    | yz    | abc

article_rating

article_id(article->id)  |  given_by(user->id)  |  given_rating

   1                              2                  4

   2                              1                  3

saved_article

article_id(article->id)  |  saved_by(user->id) 

   1                              2            

I'm changing some buttons and icons depending on whether a user has rated/ saved an article or not. I'm using two select queries for that:

rated or not

SELECT given_rating as rating 

FROM article_rating 

WHERE  given_by=? AND article_id=?

saved or not

SELECT saved_by as saved 

FROM saved_article 

WHERE  saved_by=? AND article_id=?

So my question is how can i combine both into one mysql query efficiently??

mysql

share|improve this question

edited 2 mins ago

Share corn

asked 18 mins ago

Share cornShare corn

1

add a comment | 

user

id   |  name

1    |  A

2    |  B

article

id   | title | descritption

1    | wx    | xyz

2    | yz    | abc

article_rating

article_id(article->id)  |  given_by(user->id)  |  given_rating

   1                              2                  4

   2                              1                  3

saved_article

article_id(article->id)  |  saved_by(user->id) 

   1                              2            

I'm changing some buttons and icons depending on whether a user has rated/ saved an article or not. I'm using two select queries for that:

rated or not

SELECT given_rating as rating 

FROM article_rating 

WHERE  given_by=? AND article_id=?

saved or not

SELECT saved_by as saved 

FROM saved_article 

WHERE  saved_by=? AND article_id=?

So my question is how can i combine both into one mysql query efficiently??

mysql

share|improve this question

edited 2 mins ago

Share corn

asked 18 mins ago

Share cornShare corn

1

id   |  name

1    |  A

2    |  B

id   | title | descritption

1    | wx    | xyz

2    | yz    | abc

article_id(article->id)  |  given_by(user->id)  |  given_rating

   1                              2                  4

   2                              1                  3

article_id(article->id)  |  saved_by(user->id) 

   1                              2            

SELECT given_rating as rating 

FROM article_rating 

WHERE  given_by=? AND article_id=?

SELECT saved_by as saved 

FROM saved_article 

WHERE  saved_by=? AND article_id=?

share|improve this question

edited 2 mins ago

Share corn

asked 18 mins ago

Share cornShare corn

1

share|improve this question

edited 2 mins ago

Share corn

asked 18 mins ago

Share cornShare corn

1

asked 18 mins ago

Share cornShare corn

1

asked 18 mins ago

Share cornShare corn

1