1 2 
2 1
3 4
4 3
4 5
5 1

1 Knock-knock
2 Cross the road
3 Lawyers
4 Walk into bar
5 Lightbulb

A man walks into a bar
How many lawyers win a case?

INSERT INTO `category` (`id`, `name`) VALUES ('1', 'Knock-knock'), ('2', 'Cross the road'), ('3', 'Lawyers'), ('4', 'Walk into bar'), ('5', 'Lightbulb');

INSERT INTO `jokecategory` (`jokeid`, `categoryid`) VALUES ('5', '1');

INSERT INTO `joke` (`id`, `joketext`, `jokedate`, `authorid`) VALUES ('4', 'How many lawyers win a case?', '2018-09-12', '1');

INSERT INTO `jokecategory` (`jokeid`, `categoryid`) VALUES ('1', '2'), ('2', '1'), ('3', '4'), ('4', '3'), ('4', '5');

INSERT INTO `joke` (`id`, `joketext`, `jokedate`, `authorid`) VALUES ('5', 'Knock knock who\'s there? Me. Me Who. Me not you.', '2018-09-18', '2');