---

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 = '5a17590d-2914-4458-a73c-ec0fa0d8bd75' AND bt_categorytreeentry.uid = 'bt_DynamicContent' AND ( ela_dynamiccontent.useDateValidation = 'false' OR ( ela_dynamiccontent.useDateValidation = 'true' AND ela_dynamiccontent.dateValidationStart <= '2022-10-05 11:30:06' AND ela_dynamiccontent.dateValidationEnd >= '2022-10-05 11:30:06' ) ) AND ela_dynamiccontent.visible = 'true'))) AND ela_dynamiccontent.recordDeleted = 0 ORDER BY bt_categorytreeentry.main desc, bt_categorytreeentry.recordposition desc LIMIT 11=============================

---