Sfrgttk

Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?

How to type this arrow in math mode?

How come people say “Would of”?

Did any laptop computers have a built-in 5 1/4 inch floppy drive?

Output the Arecibo Message

Why is this code so slow?

A female thief is not sold to make restitution -- so what happens instead?

What is preventing me from simply constructing a hash that's lower than the current target?

How to notate time signature switching consistently every measure

Button changing its text & action. Good or terrible?

Why didn't the Event Horizon Telescope team mention Sagittarius A*?

What is the meaning of Triage in Cybersec world?

Deal with toxic manager when you can't quit

Can we generate random numbers using irrational numbers like π and e?

How to support a colleague who finds meetings extremely tiring?

ELI5: Why they say that Israel would have been the fourth country to land a spacecraft on the Moon and why they call it low cost?

A word that means fill it to the required quantity

Likelihood that a superbug or lethal virus could come from a landfill

Is it safe to harvest rainwater that fell on solar panels?

Match Roman Numerals

Is there a way to generate a uniformly distributed point on a sphere from a fixed amount of random real numbers?

How to add class in ko template in magento2

Why couldn't they take pictures of a closer black hole?

The phrase "to the numbers born"?

Build MySQL query as described

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I have subscription plans like Monthly, Quarterly,and Annually. Every plan has a different level e.g. Gold, Silver, Bronze, Platinum, and Diamond.

All this is stored in tbl_subscription. I am trying to select all data in single query with bunch of plan like:

Monthly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Quarterly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Annually = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

I think this can be achieved with different queries (single query for every plan) but I want this output from a single query with different plan and every plan has its Level.

Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Monthly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Quarterly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Annually"

Please suggest ways to achieve this.

mysql query

share|improve this question

edited 3 mins ago

Paul White♦

54.2k14288461

asked 23 mins ago

Narayan Narayan

1

New contributor

Narayan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have subscription plans like Monthly, Quarterly,and Annually. Every plan has a different level e.g. Gold, Silver, Bronze, Platinum, and Diamond.

All this is stored in tbl_subscription. I am trying to select all data in single query with bunch of plan like:

Monthly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Quarterly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Annually = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

I think this can be achieved with different queries (single query for every plan) but I want this output from a single query with different plan and every plan has its Level.

Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Monthly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Quarterly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Annually"

Please suggest ways to achieve this.

mysql query

share|improve this question

edited 3 mins ago

Paul White♦

54.2k14288461

asked 23 mins ago

Narayan Narayan

1

New contributor

Narayan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have subscription plans like Monthly, Quarterly,and Annually. Every plan has a different level e.g. Gold, Silver, Bronze, Platinum, and Diamond.

All this is stored in tbl_subscription. I am trying to select all data in single query with bunch of plan like:

Monthly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Quarterly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Annually = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

I think this can be achieved with different queries (single query for every plan) but I want this output from a single query with different plan and every plan has its Level.

Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Monthly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Quarterly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Annually"

Please suggest ways to achieve this.

mysql query

share|improve this question

edited 3 mins ago

Paul White♦

54.2k14288461

asked 23 mins ago

Narayan Narayan

1

New contributor

Narayan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Monthly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Quarterly = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Annually = {

level_id="Gold", 

level_id= "Silver", 

level_id="Bronze",

level_id="Platinum", 

level_id="Diamond"

}  

Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Monthly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Quarterly"



Select level_typ,level_id,plan 

From tbl_subscription 

WHERE Where userID = myuser_id 

AND Status = "Active" 

AND plan_type = "Annually"

share|improve this question

edited 3 mins ago

Paul White♦

54.2k14288461

asked 23 mins ago

Narayan Narayan

1

New contributor

Narayan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 3 mins ago

Paul White♦

54.2k14288461

asked 23 mins ago

Narayan Narayan

1

New contributor

Narayan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 3 mins ago

Paul White♦

54.2k14288461

edited 3 mins ago

Paul White♦

54.2k14288461

asked 23 mins ago

Narayan Narayan

1

New contributor

Narayan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 23 mins ago

Narayan Narayan

1