Sponsoren

Cafe Der Witz

Café Der Witz is een gezellig en sfeervol bruin café in hartje Groningen. Een kroeg die voor een ieder wat te bieden heeft. Door de ruime openingstijden trekt Der Witz een breed publiek aan. Dit zowel overdag, aan het einde van de middag of in de avond.

 

Een uitstekende gelegenheid om te ontladen. Het assortiment aan dranken is zeer uiteenlopend, waarbij vooral de vele soorten bier opvallen. Der Witz mag zich met zijn tien verschillende bieren aan de tap en nog vele op de fles tot een echt biercafé rekenen.

 

De wintermaanden in Der Witz worden gekenmerkt door knusheid, warme chocolademelk, glühwein, bokbier en gezelligheid; heerlijk warm achter het raam uitkijkend over de koude markt. In de zomer is er een groot gezellig terras op de grote markt waar tot diep in de nacht van de warme dagen genoten kan worden. Kortom, Der Witz: "Voor elk wat wils!" 

Café der Witz - Grote Markt 47 - Tel. 050 3141417

(default) 44 queries took 30 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `contentgroups`449
2DESCRIBE `contentgroups_htmlpages`4410
3DESCRIBE `htmlpages`7710
4SET NAMES 'UTF8'00
5SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 LIMIT 1110
6SELECT `ContentgroupsHtmlpage`.`id`, `ContentgroupsHtmlpage`.`htmlpage_id`, `ContentgroupsHtmlpage`.`contentgroup_id`, `ContentgroupsHtmlpage`.`ordering` FROM `contentgroups_htmlpages` AS `ContentgroupsHtmlpage` WHERE `ContentgroupsHtmlpage`.`contentgroup_id` = (9) ORDER BY `ContentgroupsHtmlpage`.`ordering` ASC 17170
7SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 108 110
8SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 112 110
9SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 101 110
10SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 104 110
11SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 105 110
12SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 85 110
13SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 44 110
14SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 54 110
15SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 45 110
16SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 113 110
17SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 107 110
18SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 102 110
19SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 86 110
20SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 103 110
21SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 41 110
22SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 42 110
23SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 110 110
24SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
25SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
26SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
27SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
28SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
29SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
30SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
31SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
32SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
33SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
34SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
35SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
36SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
37SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
38SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
39SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
40SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
41SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id`, `ContentgroupsHtmlpage`.`id`, `ContentgroupsHtmlpage`.`htmlpage_id`, `ContentgroupsHtmlpage`.`contentgroup_id`, `ContentgroupsHtmlpage`.`ordering` FROM `htmlpages` AS `Htmlpage` JOIN `contentgroups_htmlpages` AS `ContentgroupsHtmlpage` ON (`ContentgroupsHtmlpage`.`contentgroup_id` = 9 AND `ContentgroupsHtmlpage`.`htmlpage_id` = `Htmlpage`.`id`) 17170
42SELECT `Newsitem`.`id`, `Newsitem`.`title`, `Newsitem`.`message`, `Newsitem`.`preview` FROM `newsitems` AS `Newsitem` LEFT JOIN `metagroups` AS `Metagroup` ON (`Newsitem`.`metagroup_id` = `Metagroup`.`id`) WHERE isledenonly = 0 AND (metagroup_id = 31 OR metagroup_id = 3 OR metagroup_id = 45 OR metagroup_id = 35 OR metagroup_id = 34 OR metagroup_id = 33 OR metagroup_id = 32 OR metagroup_id = 36 OR metagroup_id = 42 OR metagroup_id = 40 OR metagroup_id = 39 OR metagroup_id = 43 OR metagroup_id = 15 OR metagroup_id = 14 OR metagroup_id = 50 OR metagroup_id = 51 OR metagroup_id = 41 ) AND (enddate > now() OR enddate = "0000-00-00 00:00:00" or enddate is null or enddate < date) AND date < now() ORDER BY `date` desc LIMIT 4441
43SELECT `Attachment`.`internalfilename`, `Attachment`.`showafter`, `Attachment`.`id`, `Attachment`.`size`, `Attachment`.`filename`, `Attachment`.`title`, `Attachment`.`categorie`, `Attachment`.`isloginrequired`, `Attachment`.`isdownload`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`user_id`, `AttachmentsNewsitem`.`id`, `AttachmentsNewsitem`.`attachment_id`, `AttachmentsNewsitem`.`newsitem_id` FROM `attachments` AS `Attachment` JOIN `attachments_newsitems` AS `AttachmentsNewsitem` ON (`AttachmentsNewsitem`.`newsitem_id` IN (424, 396, 392, 388) AND `AttachmentsNewsitem`.`attachment_id` = `Attachment`.`id`) 110
44SELECT `Calendaritem`.`id`, `Calendaritem`.`calendar_id`, `Calendaritem`.`startdate`, `Calendaritem`.`enddate`, `Calendaritem`.`title`, `Calendaritem`.`info`, `Calendaritem`.`location`, `Calendaritem`.`url`, `Calendaritem`.`modified`, `Calendaritem`.`created`, `Calendar`.`id`, `Calendar`.`name` FROM `calendaritems` AS `Calendaritem` LEFT JOIN `calendars` AS `Calendar` ON (`Calendaritem`.`calendar_id` = `Calendar`.`id`) WHERE calendar_id = 1 AND ((enddate > now() or enddate = "0000-00-00 00:00:00" or enddate is null or enddate < startdate) OR (enddate is null OR enddate < now())) AND startdate > now() ORDER BY `startdate` ASC 000