Useful database queries

In some cases, you may want to perform certain queries manually in the database. A few of these queries are listed below.

Lookup all activities a certain member joined

SELECT actname.valueEN as nameEN, actname.valueNL as nameNL, Activity.beginTime as date  FROM `Signup` LEFT JOIN `SignupList` ON `Signup`.`signuplist_id` = `SignupList`.`id` LEFT JOIN `Activity` ON `SignupList`.`activity_id` = `Activity`.`id` LEFT JOIN `ActivityLocalisedText` as actname ON `Activity`.`name_id` = actname.`id` WHERE `user_lidnr` = 999 ORDER BY date