user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'How-to" Train on Fire Extinguishers", sum(if(f.mid=24, if(f.ceo is not null, 10,' at line 1 query: select f.company_name, sum(if(f.mid=19, if(f.ceo is not null, 10, 1), null)) "7/19/23 - OSHA Enforcement Updates", sum(if(f.mid=20, if(f.ceo is not null, 10, 1), null)) "8/16/23 - Getting Better Results from Safety - A Psychological Approach", sum(if(f.mid=21, if(f.ceo is not null, 10, 1), null)) "8/31/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification", sum(if(f.mid=22, if(f.ceo is not null, 10, 1), null)) "9/20/23 - Predicting Impactful Weather Events", sum(if(f.mid=23, if(f.ceo is not null, 10, 1), null)) "10/18/23 - "How-to" Train on Fire Extinguishers", sum(if(f.mid=24, if(f.ceo is not null, 10, 1), null)) "10/31/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification", sum(if(f.mid=25, if(f.ceo is not null, 10, 1), null)) "11/15/23 - Are You Using Ladders Safely?", sum(if(f.mid=26, if(f.ceo is not null, 10, 1), null)) "11/28/23 - EPA Seminar", sum(if(f.mid=27, if(f.ceo is not null, 10, 1), null)) "12/5/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification", sum(if(f.mid=28, if(f.ceo is not null, 10, 1), null)) "12/20/23 - Sleep Deprivation: An Unseen Hazard in the Workplace ", sum(if(f.mid=29, if(f.ceo is not null, 10, 1), null)) "1/17/24 - Silence is Not Golden: Why and How to Communicate During a Crisis", sum(if(f.mid=30, if(f.ceo is not null, 10, 1), null)) "1/30/24 - OSHA Recordkeeping Workshop", sum(if(f.mid=31, if(f.ceo is not null, 10, 1), null)) "2/21/24 - Be Heart Smart", sum(if(f.mid=32, if(f.ceo is not null, 10, 1), null)) "3/19/24 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification", sum(if(f.mid=33, if(f.ceo is not null, 10, 1), null)) "3/20/24 - HEALTHY BACKS & BODIES™ for the Industrial Athlete", sum(if(f.mid=34, if(f.ceo is not null, 10, 1), null)) "4/17/24 - Legalization of Marijuana and Current Drug Trends", sum(if(f.mid=38, if(f.ceo is not null, 10, 1), null)) "5/1/24 - Aerial Lift Training", sum(if(f.mid=40, if(f.ceo is not null, 10, 1), null)) "5/2/24 - Aerial Lift Training - AM", sum(if(f.mid=39, if(f.ceo is not null, 10, 1), null)) "5/2/24 - Aerial Lift Training - PM", sum(if(f.mid=35, if(f.ceo is not null, 10, 1), null)) "5/15/24 - Lockout / Tagout / Tryout – Common Mistakes and Misconceptions", sum(if(f.mid=37, if(f.ceo is not null, 10, 1), null)) "6/12/24 - The Importance of Personal Protective Equipment", sum(if(f.mid=36, if(f.ceo is not null, 10, 1), null)) "6/18/24 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification" from company_meetings_v f group by f.company_name ORDER BY company_name ASC LIMIT 0, 50 in /hsphere/local/home/summit/thesummitcountysafetycouncil.org/sites/all/modules/meeting/meeting.pages.inc on line 108.
Companysort icon7/19/23 - OSHA Enforcement Updates8/16/23 - Getting Better Results from Safety - A Psychological Approach8/31/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification9/20/23 - Predicting Impactful Weather Events10/18/23 - "How-to" Train on Fire Extinguishers10/31/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification11/15/23 - Are You Using Ladders Safely?11/28/23 - EPA Seminar12/5/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification12/20/23 - Sleep Deprivation: An Unseen Hazard in the Workplace 1/17/24 - Silence is Not Golden: Why and How to Communicate During a Crisis1/30/24 - OSHA Recordkeeping Workshop2/21/24 - Be Heart Smart3/19/24 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification3/20/24 - HEALTHY BACKS & BODIES™ for the Industrial Athlete4/17/24 - Legalization of Marijuana and Current Drug Trends5/1/24 - Aerial Lift Training5/2/24 - Aerial Lift Training - AM5/2/24 - Aerial Lift Training - PM5/15/24 - Lockout / Tagout / Tryout – Common Mistakes and Misconceptions6/12/24 - The Importance of Personal Protective Equipment6/18/24 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification