---

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 = '57f290b5-5654-4ee0-a4c1-2343d6ece58f' AND bt_categorytreeentry.uid = 'bt_DynamicContent' AND ( ela_dynamiccontent.useDateValidation = 'false' OR ( ela_dynamiccontent.useDateValidation = 'true' AND ela_dynamiccontent.dateValidationStart <= '2023-01-28 20:47:55' AND ela_dynamiccontent.dateValidationEnd >= '2023-01-28 20:47:55' ) ) AND ela_dynamiccontent.visible = 'true'))) AND ela_dynamiccontent.recordDeleted = 0 ORDER BY bt_categorytreeentry.main desc, bt_categorytreeentry.recordposition desc LIMIT 11=============================

---