Sfrgttk

How to notate time signature switching consistently every measure

What to do when moving next to a bird sanctuary with a loosely-domesticated cat?

Loose spokes after only a few rides

How do you keep chess fun when your opponent constantly beats you?

Why can I use a list index as an indexing variable in a for loop?

Short story: man watches girlfriend's spaceship entering a 'black hole' (?) forever

Match Roman Numerals

What is the motivation for a law requiring 2 parties to consent for recording a conversation

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

Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?

Ubuntu Server install with full GUI

Mathematics of imaging the black hole

Can an undergraduate be advised by a professor who is very far away?

Button changing its text & action. Good or terrible?

Is bread bad for ducks?

Correct punctuation for showing a character's confusion

Why doesn't UInt have a toDouble()?

Old scifi movie from the 50s or 60s with men in solid red uniforms who interrogate a spy from the past

If climate change impact can be observed in nature, has that had any effect on rural, i.e. farming community, perception of the scientific consensus?

Pokemon Turn Based battle (Python)

Finding the area between two curves with Integrate

Can withdrawing asylum be illegal?

Keeping a retro style to sci-fi spaceships?

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

Need Help to build mysql query as described following

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

0

I have subcrition plan Like, Monthly,Quarterly,Annualy. Every plan have different Level Like, Gold, Silver, Bronze,Platinum, Diamond. All this stored in tbl_subcrition. I am trying to select all data in single quiry 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"
}

Annualy = {
level_id="Gold",
level_id= "Silver",
level_id="Bronze",
level_id="Platinum",
level_id="Diamond"
}

I think This can achive by different queries(single query for every plan) But i want this output in single query with different plan and every plan have its Levele.

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 = "Annualy".

Please suggest.

mysql

share

asked 2 mins ago

Narayan GholapNarayan Gholap

1

New contributor

Narayan Gholap 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 subcrition plan Like, Monthly,Quarterly,Annualy. Every plan have different Level Like, Gold, Silver, Bronze,Platinum, Diamond. All this stored in tbl_subcrition. I am trying to select all data in single quiry 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"
}

Annualy = {
level_id="Gold",
level_id= "Silver",
level_id="Bronze",
level_id="Platinum",
level_id="Diamond"
}

I think This can achive by different queries(single query for every plan) But i want this output in single query with different plan and every plan have its Levele.

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 = "Annualy".

Please suggest.

mysql

share

asked 2 mins ago

Narayan GholapNarayan Gholap

1

New contributor

Narayan Gholap 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 subcrition plan Like, Monthly,Quarterly,Annualy. Every plan have different Level Like, Gold, Silver, Bronze,Platinum, Diamond. All this stored in tbl_subcrition. I am trying to select all data in single quiry 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"
}

Annualy = {
level_id="Gold",
level_id= "Silver",
level_id="Bronze",
level_id="Platinum",
level_id="Diamond"
}

I think This can achive by different queries(single query for every plan) But i want this output in single query with different plan and every plan have its Levele.

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 = "Annualy".

Please suggest.

mysql

share

asked 2 mins ago

Narayan GholapNarayan Gholap

1

New contributor

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

share

asked 2 mins ago

Narayan GholapNarayan Gholap

1

New contributor

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

share

asked 2 mins ago

Narayan GholapNarayan Gholap

1

New contributor

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

asked 2 mins ago

Narayan GholapNarayan Gholap

1

New contributor

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

asked 2 mins ago

Narayan GholapNarayan Gholap

1