SELECT '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`
Karriere und Ausbildung in der Demmel Gruppe