bt_categorytreeentry.clientid	bt_categorytreeentry.createdon	bt_categorytreeentry.decoupled	bt_categorytreeentry.executepositionmarker	bt_categorytreeentry.id	bt_categorytreeentry.main	bt_categorytreeentry.modifiedbyoid	bt_categorytreeentry.modifiedon	bt_categorytreeentry.objectid	bt_categorytreeentry.recorddeleted	bt_categorytreeentry.recorddeletedby	bt_categorytreeentry.recorddeletedon	bt_categorytreeentry.recordposition	bt_categorytreeentry.stage	bt_categorytreeentry.treeid	bt_categorytreeentry.uid	bt_dynamiccontent.additionalemail	bt_dynamiccontent.additionalurl	bt_dynamiccontent.additionalurlinfo	bt_dynamiccontent.allowcomments	bt_dynamiccontent.allowsharing	bt_dynamiccontent.author	bt_dynamiccontent.category	bt_dynamiccontent.categoryoid	bt_dynamiccontent.comment	bt_dynamiccontent.conditions	bt_dynamiccontent.contentcode	bt_dynamiccontent.contentnumber	bt_dynamiccontent.costs	bt_dynamiccontent.createdon	bt_dynamiccontent.date	bt_dynamiccontent.datedescription	bt_dynamiccontent.datevalidationend	bt_dynamiccontent.datevalidationstart	bt_dynamiccontent.deadline	bt_dynamiccontent.departmentoid	bt_dynamiccontent.description	bt_dynamiccontent.descriptionshort	bt_dynamiccontent.discount	bt_dynamiccontent.displayenddate	bt_dynamiccontent.displaystartdate	bt_dynamiccontent.duration	bt_dynamiccontent.email	bt_dynamiccontent.enddate	bt_dynamiccontent.eventdate	bt_dynamiccontent.eventtextoid	bt_dynamiccontent.eventtype	bt_dynamiccontent.executepositionmarker	bt_dynamiccontent.externalid	bt_dynamiccontent.externalid2	bt_dynamiccontent.feerequired	bt_dynamiccontent.firstname	bt_dynamiccontent.globalcontentid	bt_dynamiccontent.id	bt_dynamiccontent.internalname	bt_dynamiccontent.issue	bt_dynamiccontent.journal	bt_dynamiccontent.journalauthor	bt_dynamiccontent.lastname	bt_dynamiccontent.link	bt_dynamiccontent.linktext	bt_dynamiccontent.literature	bt_dynamiccontent.locale	bt_dynamiccontent.location	bt_dynamiccontent.logonneededforpicturefull	bt_dynamiccontent.logonneededforpicturepreview	bt_dynamiccontent.logonneededforpicturezoom	bt_dynamiccontent.matrixurl	bt_dynamiccontent.memberoid	bt_dynamiccontent.modifiedbyoid	bt_dynamiccontent.modifiedon	bt_dynamiccontent.name	bt_dynamiccontent.new	bt_dynamiccontent.organizer	bt_dynamiccontent.parentid	bt_dynamiccontent.paymentdescription	bt_dynamiccontent.picturefullalign	bt_dynamiccontent.picturefullheight	bt_dynamiccontent.picturefullmediumid	bt_dynamiccontent.picturefullurl	bt_dynamiccontent.picturefullwidth	bt_dynamiccontent.picturepreviewalign	bt_dynamiccontent.picturepreviewdescription	bt_dynamiccontent.picturepreviewheight	bt_dynamiccontent.picturepreviewmediumid	bt_dynamiccontent.picturepreviewtitle	bt_dynamiccontent.picturepreviewurl	bt_dynamiccontent.picturepreviewwidth	bt_dynamiccontent.picturezoomalign	bt_dynamiccontent.picturezoomheight	bt_dynamiccontent.picturezoommediumid	bt_dynamiccontent.picturezoomurl	bt_dynamiccontent.picturezoomwidth	bt_dynamiccontent.placeofevent	bt_dynamiccontent.prooved	bt_dynamiccontent.properties	bt_dynamiccontent.recorddeleted	bt_dynamiccontent.recorddeletedby	bt_dynamiccontent.recorddeletedon	bt_dynamiccontent.recordposition	bt_dynamiccontent.registration	bt_dynamiccontent.relayclientid	bt_dynamiccontent.scaletype	bt_dynamiccontent.sessioncode	bt_dynamiccontent.showdownloadinlist	bt_dynamiccontent.source	bt_dynamiccontent.speaker	bt_dynamiccontent.special	bt_dynamiccontent.stateprotected	bt_dynamiccontent.subclientvisible	bt_dynamiccontent.subtitle	bt_dynamiccontent.superclientvisible	bt_dynamiccontent.tags	bt_dynamiccontent.target	bt_dynamiccontent.targetgroup	bt_dynamiccontent.telefax	bt_dynamiccontent.telephone	bt_dynamiccontent.theme	bt_dynamiccontent.translationcomment	bt_dynamiccontent.translationenddate	bt_dynamiccontent.translationstartdate	bt_dynamiccontent.translationstatus	bt_dynamiccontent.typeoid	bt_dynamiccontent.usedateautodelete	bt_dynamiccontent.usedatevalidation	bt_dynamiccontent.usercontent	bt_dynamiccontent.visible
1	2018-05-28 15:03:56.936	false	true	17974d01-303c-4a88-83f8-f2ed1feca934	false	null	2018-08-16 06:38:24.817	3105ceb6-ab42-4c3d-8114-aa15bb67ed79	0	null	0001-01-01 00:00:00.0	0	2	ce029233-2ef4-41d4-9912-2d4ad2cc773d	bt_DynamicContent				false	false		0	null			ct1137	1137		2016-03-29 12:24:09.0	2018-06-25 00:00:00.0		2016-03-29 00:00:00.0	2016-03-29 00:00:00.0	0000-12-29	null	<div> <p></p> </div> <div class="panel panel-default col-xs-12"> <figure class="panel-body col-xs-12 col-sm-3" data-same-height-group="figure"><a href="https://www.bgbl.de/xaver/bgbl/start.xav?start=%2F%2F*%5B%40attr_id%3D%27bgbl117s1966.pdf%27%5D#__bgbl__%2F%2F*%5B%40attr_id%3D%27bgbl117s1966.pdf%27%5D__1522923261536" target="_blank"><img src="../../../../../../media/upload/superClient/20180529/ThumbStrSchGes.JPG" alt="" class="img-responsive center-block" style="border: 2px solid #ddd;" /></a></figure> <div class="panel-body col-xs-12 col-sm-9"><a href="https://www.bgbl.de/xaver/bgbl/start.xav?start=%2F%2F*%5B%40attr_id%3D%27bgbl117s1966.pdf%27%5D#__bgbl__%2F%2F*%5B%40attr_id%3D%27bgbl117s1966.pdf%27%5D__1522923261536" target="_blank"><strong>Strahlenschutzgesetz</strong></a></div> <div class="panel-body col-xs-12 col-sm-9"> <p>Gesetz zur Neuordnung des Rechts zum Schutz vor der sch&auml;dlichen Wirkung ionisierender Strahlung vom 27. Juni 2017</p> </div> </div> <div class="panel panel-default col-xs-12"> <figure class="panel-body col-xs-12 col-sm-3" data-same-height-group="figure"><a href="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2014:013:0001:0073:DE:PDF" target="_blank"><img src="../../../../../../media/upload/superClient/20180601/thumb_euratom_richtlinie.JPG" alt="" caption="false" class="img-responsive center-block" style="border: 2px solid #ddd;" /></a></figure> <div class="panel-body col-xs-12 col-sm-9"><a href="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2014:013:0001:0073:DE:PDF" target="_blank"><strong>Richtlinie 2013/59/Euratom-Richtlinie</strong></a></div> <div class="panel-body col-xs-12 col-sm-9"> <p>Quelle: Amtsblatt der Europäischen Union</p> </div> </div> <div class="panel panel-default col-xs-12"> <figure class="panel-body col-xs-12 col-sm-3" data-same-height-group="figure"><a href="http://www.bmub.bund.de/fileadmin/Daten_BMU/Download_PDF/Strahlenschutz/richtlinie_2013_59_euratom_inhalt_bf.pdf" target="_blank"><img src="../../../../../../media/upload/superClient/20180601/thumb_euratom_inhaltsverzeichnis.JPG" caption="false" class="img-responsive center-block" style="border: 2px solid #ddd;" /></a></figure> <div class="panel-body col-xs-12 col-sm-9"><a href="http://www.bmub.bund.de/fileadmin/Daten_BMU/Download_PDF/Strahlenschutz/richtlinie_2013_59_euratom_inhalt_bf.pdf" target="_blank"><strong>2013/59/Euratom &ndash; Inhaltsverzeichnis</strong></a></div> <div class="panel-body col-xs-12 col-sm-9"> <p>Quelle: Bundesministerium für Umwelt, Naturschutz, Bau und Reaktorsicherheit</p> </div> </div> <div class="panel panel-default col-xs-12"> <figure class="panel-body col-xs-12 col-sm-3" data-same-height-group="figure"><a href="http://www.bmub.bund.de/fileadmin/Daten_BMU/Download_PDF/Strahlenschutz/richtlinie_2013_59_euratom_begriffe_bf.pdf" target="_blank"><img src="../../../../../../media/upload/superClient/20180601/thumb_euratom_begriffsbestimmungen.JPG" alt="" caption="false" class="img-responsive center-block" style="border: 2px solid #ddd;" /></a></figure> <div class="panel-body col-xs-12 col-sm-9"><a href="http://www.bmub.bund.de/fileadmin/Daten_BMU/Download_PDF/Strahlenschutz/richtlinie_2013_59_euratom_begriffe_bf.pdf" target="_blank"><strong>Richtlinie 2013/59/Euratom &ndash; Begriffsbestimmungen</strong></a></div> <div class="panel-body col-xs-12 col-sm-9"> <p>Quelle: Bundesministerium für Umwelt, Naturschutz, Bau und Reaktorsicherheit</p> </div> </div> <div class="panel panel-default col-xs-12"> <figure class="panel-body col-xs-12 col-sm-3" data-same-height-group="figure"><a href="https://www.thieme-connect.de/products/ejournals/html/10.1055/s-0034-1368939" target="_blank"><img src="../../../../../../media/upload/superClient/20180601/thumb_euratom_positionspapier.JPG" alt="" caption="false" class="img-responsive center-block" style="border: 2px solid #ddd;" /></a></figure> <div class="panel-body col-xs-12 col-sm-9"><a href="http://www.thieme-connect.de/products/ejournals/html/10.1055/s-0034-1368939" target="_blank"><strong>Positionspapier zur Umsetzung des Entwurfs der EU-Richtlinie &bdquo;Euratom Basic Safety Standards&ldquo;</strong></a></div> <div class="panel-body col-xs-12 col-sm-9"> <p>Quelle: Vorstand der AG Physik und Technik der Dt. R&ouml;ntgengesellschaft</p> </div> </div>	<p>Aktuelle Informationen zur EURATOM-Richtlinie und dem Strahlenschutzgesetz</p>		0001-01-01 00:00:00.0	0001-01-01 00:00:00.0			0001-01-01 00:00:00.0	0001-01-01 00:00:00.0	null		true	Germany3068		false		null	3105ceb6-ab42-4c3d-8114-aa15bb67ed79	EURATOM								de_DE	Healthcare IT/EURATOM/EURATOM-Richtlinie	false	false	false		null	11557	2018-06-25 11:48:06.053	EURATOM-Richtlinie 2013/59 & Strahlenschutzgesetz	false		null		left		null			left			d5c8568e-e93e-4a4b-a605-f772c02bf30c		upload/Standard/superClient/20161024/euratom_richtlinien_kategorieiunu5hyvw0h0both.jpg		left		null				true		0	null	0001-01-01 00:00:00.0	1127	false	1	both		false			false	false	false		false	EURATOM										60bf0302-1702-468f-8a96-e5d39b4e39b8	false	false	false	true

SELECT * FROM bt_categorytreeentry INNER JOIN ela_dynamiccontent ON (bt_categorytreeentry.objectId = ela_dynamiccontent.id AND ela_dynamiccontent.locale = 'de_DE') AND ela_dynamiccontent.recordDeleted = 0 WHERE (bt_categorytreeentry.main = 'true' AND bt_categorytreeentry.uid = 'bt_DynamicContent' AND ela_dynamiccontent.typeOID NOT IN ('7c60ae95-f928-424a-8a72-8e4c1b74b12c','3d677450-3555-430f-9bbd-00d9a8e71b9b','0ae6bd2b-541a-4af3-9f77-99395ead207a','0c679d96-5ca6-478c-a3e6-d4291ab14a35') AND bt_categorytreeentry.treeId = 'ce029233-2ef4-41d4-9912-2d4ad2cc773d' AND bt_categorytreeentry.recordPosition < '0') AND bt_categorytreeentry.recordDeleted = 0 ORDER BY bt_categorytreeentry.recordposition desc LIMIT 2=============================