De opgegeven query is onjuist!
Table 'wehaadmi_fexpro.member_companies' doesn't exist
SELECT firstname,lastname,member_types.type,name,members.address,members.postalcode,members.place,CASE mycompany_members.mycompany WHEN 1 THEN CONCAT(SUBSTR(YEAR(members.birthday),3),".",SUBSTR(YEAR(members.carreer),3),".",SUBSTR(YEAR(mycompany_members.startdate),3),".",mycompany_members.mid_sequence) WHEN 5 THEN CONCAT(SUBSTR(YEAR(members.birthday),3),".",SUBSTR(YEAR(members.carreer),3),".",SUBSTR(YEAR(mycompany_members.startdate),3),".",mycompany_members.mid_sequence) ELSE NULL END AS membership_id FROM members LEFT JOIN mycompany_members ON mycompany_members.member = members.id AND mycompany = 1 LEFT JOIN member_companies ON members.primary_company = member_companies.id LEFT JOIN member_types ON mycompany_members.type = member_types.id WHERE active = 1 AND mycompany_members.type != 7 AND stick = 1 ORDER by lastname,firstname ASC