'video' AS `brick`,
`d`.`id` AS `id`,
`d`.`key` AS `name`
FROM (`documents_elements` `e` join `documents` `d` on((`e`.`documentId` = `d`.`id`))) where ((`e`.`type` = 'areablock') and (`e`.`data` regexp 'video')) group by `d`.`id`
The Demmel Group is a group of medium-sized, family-owned enterprises with a total of some 1400 employees. The production locations are in Scheidegg and Weiler in the Allgäu region, Munich, Switzerland, China, Singapore and the US. The group’s core competencies are high-end products and system solutions in the fields of decorative parts and surfaces, control systems, electronics and mobile energy supply. Our main customers are in the automotive, mechanical engineering and household appliances industries.