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 50, 50 in /hsphere/local/home/summit/thesummitcountysafetycouncil.org/sites/all/modules/meeting/meeting.pages.inc on line 108.
Company | 7/19/23 - OSHA Enforcement Updates | 8/16/23 - Getting Better Results from Safety - A Psychological Approach | 8/31/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification | 9/20/23 - Predicting Impactful Weather Events | 10/18/23 - "How-to" Train on Fire Extinguishers | 10/31/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification | 11/15/23 - Are You Using Ladders Safely? | 11/28/23 - EPA Seminar | 12/5/23 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification | 12/20/23 - Sleep Deprivation: An Unseen Hazard in the Workplace | 1/17/24 - Silence is Not Golden: Why and How to Communicate During a Crisis | 1/30/24 - OSHA Recordkeeping Workshop | 2/21/24 - Be Heart Smart | 3/19/24 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification | 3/20/24 - HEALTHY BACKS & BODIES™ for the Industrial Athlete | 4/17/24 - Legalization of Marijuana and Current Drug Trends | 5/1/24 - Aerial Lift Training | 5/2/24 - Aerial Lift Training - AM | 5/2/24 - Aerial Lift Training - PM | 5/15/24 - Lockout / Tagout / Tryout – Common Mistakes and Misconceptions | 6/12/24 - The Importance of Personal Protective Equipment | 6/18/24 - CPR, First Aid, AED, Bloodborne Pathogen, Stop the Bleed Certification |