Skip to content

Instantly share code, notes, and snippets.

@masonjo

masonjo/MSS Not G5.sql

Created May 22, 2019 00:10
Show Gist options
  • Save masonjo/ad9ae54d084dbbcf85dd76b5fc40e8ce to your computer and use it in GitHub Desktop.
Save masonjo/ad9ae54d084dbbcf85dd76b5fc40e8ce to your computer and use it in GitHub Desktop.
Download ZIP
MSS Not G5 Mysql statement
Raw
MSS Not G5.sql
SELECT ls.datecreated AS Added_MSS,practice.ID, practice.Name,practice.contact_name FROM practice,finances,lateststatus AS ls WHERE ls.practice_id=practice.ID AND practice.`status` = 'Active' AND in_count=1 AND practice.ID=finances.practice_id AND finances.mss=1 AND g5!='true' AND bom!='true' AND statustype='Added MSS' GROUP BY ID ORDER BY Added_MSS ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment