---

SELECT * FROM ela_dynamiccontent INNER JOIN bt_categorytreeentry ON (ela_dynamiccontent.id = bt_categorytreeentry.objectId) AND bt_categorytreeentry.recordDeleted = 0 WHERE (((ela_dynamiccontent.relayClientId = '1' ) AND ( ela_dynamiccontent.locale = 'de_DE' ) AND ( bt_categorytreeentry.treeId = 'd001cfd0-851d-434e-84bb-82e23be1abca' AND bt_categorytreeentry.uid = 'bt_DynamicContent' AND ( ela_dynamiccontent.useDateValidation = 'false' OR ( ela_dynamiccontent.useDateValidation = 'true' AND ela_dynamiccontent.dateValidationStart <= '2023-01-28 21:15:48' AND ela_dynamiccontent.dateValidationEnd >= '2023-01-28 21:15:48' ) ) AND ela_dynamiccontent.visible = 'true'))) AND ela_dynamiccontent.recordDeleted = 0 ORDER BY bt_categorytreeentry.main desc, bt_categorytreeentry.recordposition desc LIMIT 21=============================

---