Exception: Mysql2::Error: Lost connection to MySQL server during query:
(
SELECT DISTINCT contacts.email as email, people.first_name, people.last_name, name,
(CASE omem.type
WHEN 'Membership::Organizational::Dual' THEN 'US/Canadian Engineering & Technology Member'
WHEN 'Membership::Organizational::Engineering' THEN 'US/Canadian Engineering Member'
WHEN 'Membership::Organizational::CollegeAffiliate' THEN 'College Affiliate Member'
WHEN 'Membership::Organizational::K12' THEN 'K-12 Institutional Member'
WHEN 'Membership::Organizational::EngineeringTech4' THEN 'US/Canadian Technology 4 Year Member'
WHEN 'Membership::Organizational::EngineeringTech2' THEN 'US/Canadian Technology 2 Year Member'
WHEN 'Membership::Organizational::NonUSCanadian' THEN 'Non US/Canadian Engineering Member'
WHEN 'Membership::Organizational::International' THEN 'International Member'
WHEN 'Membership::Organizational::InternationalLdn' THEN 'International (Least Developed Nation) Member'
END
) AS program
FROM organizations
JOIN memberships omem ON omem.member_id = organizations.id AND omem.member_type = 'Organization' AND omem.type in ('Membership::Organizational::Dual','Membership::Organizational::EngineeringTech4','Membership::Organizational::EngineeringTech2','Membership::Organizational::CollegeAffiliate','Membership::Organizational::International','Membership::Organizational::InternationalLdn')
JOIN member_products ON membership_id = omem.id AND product_type = 'Membership::Base'
JOIN memberships reps ON reps.id = product_id
JOIN people ON reps.member_id = people.id AND reps.member_type = 'Person'
JOIN contacts ON contacts.id = electronic_contact_id
WHERE reps.start_date <= NOW() AND reps.grace_period_end_date >= NOW()
AND member_products.enabled is true
AND reps.type = 'Membership::Rep::Etc'
ORDER BY name)
Exception: Mysql2::Error: Lost connection to MySQL server during query:
(
SELECT DISTINCT contacts.email as email, people.first_name, people.last_name, name,
(CASE omem.type
WHEN 'Membership::Organizational::Dual' THEN 'US/Canadian Engineering & Technology Member'
WHEN 'Membership::Organizational::Engineering' THEN 'US/Canadian Engineering Member'
WHEN 'Membership::Organizational::CollegeAffiliate' THEN 'College Affiliate Member'
WHEN 'Membership::Organizational::K12' THEN 'K-12 Institutional Member'
WHEN 'Membership::Organizational::EngineeringTech4' THEN 'US/Canadian Technology 4 Year Member'
WHEN 'Membership::Organizational::EngineeringTech2' THEN 'US/Canadian Technology 2 Year Member'
WHEN 'Membership::Organizational::NonUSCanadian' THEN 'Non US/Canadian Engineering Member'
WHEN 'Membership::Organizational::International' THEN 'International Member'
WHEN 'Membership::Organizational::InternationalLdn' THEN 'International (Least Developed Nation) Member'
END
) AS program
FROM organizations
JOIN memberships omem ON omem.member_id = organizations.id AND omem.member_type = 'Organization' AND omem.type in ('Membership::Organizational::Dual','Membership::Organizational::EngineeringTech4','Membership::Organizational::EngineeringTech2','Membership::Organizational::CollegeAffiliate','Membership::Organizational::International','Membership::Organizational::InternationalLdn')
JOIN member_products ON membership_id = omem.id AND product_type = 'Membership::Base'
JOIN memberships reps ON reps.id = product_id
JOIN people ON reps.member_id = people.id AND reps.member_type = 'Person'
JOIN contacts ON contacts.id = electronic_contact_id
WHERE reps.start_date <= NOW() AND reps.grace_period_end_date >= NOW()
AND member_products.enabled is true
AND reps.type = 'Membership::Rep::Etc'
ORDER BY name)
ADVERTISEMENT
