Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add hours per skate config #63

Open
kami-nashi opened this issue Mar 25, 2022 · 0 comments
Open

Add hours per skate config #63

kami-nashi opened this issue Mar 25, 2022 · 0 comments
Labels
enhancement New feature or request
Projects

Comments

@kami-nashi
Copy link
Owner

select fsBoots.bootsName,
fsBoots.bootsModel,
fsBlades.bladesName,
fsBlades.bladesModel,
sConfig.aSkateConfigID,
sum(iTime.ice_time)/60 as ConfigTime
from uSkateConfig sConfig
INNER JOIN uSkaterBoots fsBoots ON sConfig.uSkaterUUID = fsBoots.uSkaterUUID
and sConfig.uSkaterBootsID = fsBoots.bootID
INNER JOIN uSkaterBlades fsBlades ON sConfig.uSkaterUUID = fsBlades.uSkaterUUID
and sConfig.uSkaterBladesID = fsBlades.bladeID
INNER JOIN ice_time iTime ON sConfig.uSkaterUUID = iTime.uSkaterUUID
and sConfig.aSkateConfigID = iTime.uSkaterConfig
WHERE sConfig.uSkaterUUID = '1'
GROUP BY sConfig.aSkateConfigID
-- HAVING ConfigTime < 60

Screenshot from 2022-03-24 22-39-59

@kami-nashi kami-nashi added the enhancement New feature or request label Mar 25, 2022
@kami-nashi kami-nashi added this to To do - Bugs in General via automation Mar 25, 2022
@kami-nashi kami-nashi moved this from To do - Bugs to To do - Features in General Mar 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
General
  
To do - Features
Development

No branches or pull requests

1 participant