Skip to content

Instantly share code, notes, and snippets.

@cabloo

cabloo/get-part-counts.sql

Created July 7, 2018 18:36
Show Gist options
  • Save cabloo/7dc9288897986ce99f59f6e5e2c5489a to your computer and use it in GitHub Desktop.
Save cabloo/7dc9288897986ce99f59f6e5e2c5489a to your computer and use it in GitHub Desktop.
Download ZIP
Get number of uses of each part in SynergyCP
Raw
get-part-counts.sql
SELECT parts.name, COUNT(*) FROM part_server INNER JOIN parts on parts.id = part_server.part_id GROUP BY part_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment