Help to optimize a four queries in one

Databases
1

query 1

SELECT COUNT(*) as count7 FROM keno_tickets WHERE userid = '".$CURUSER['id']."' AND game = '7'"

query 2

SELECT COUNT(*) as count8 FROM keno_tickets WHERE userid = '".$CURUSER['id']."' AND game = '8'

query 3

SELECT COUNT(*) as count9 FROM keno_tickets WHERE userid = '".$CURUSER['id']."' AND game = '9'

query 4

SELECT COUNT(*) as countplay FROM keno_tickets WHERE userid = '".$CURUSER['id']."' AND checked = 'yes'

Thanks

2

SELECT COUNT(CASE WHEN game = 7 THEN 'ok' ELSE NULL END) as count7 , COUNT(CASE WHEN game = 8 THEN 'ok' ELSE NULL END) as count8 , COUNT(CASE WHEN game = 9 THEN 'ok' ELSE NULL END) as count9 , COUNT(CASE WHEN checked = 'yes' THEN 'ok' ELSE NULL END) as countplay FROM keno_tickets WHERE userid = '".$CURUSER['id']."' AND ( game IN (7,8,9) OR checked = 'yes' )

1 Like
3

Thank you r937, you are the best SQL Consultant in this forum!

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.