SELECTk0_.lftASlft_0,k0_.lvlASlvl_1,k0_.rgtASrgt_2,k0_.deletedASdeleted_3,k0_.hidden_from_navAShidden_from_nav_4,k0_.ref_entity_nameASref_entity_name_5,k0_.internal_nameASinternal_name_6,k0_.idASid_7,k1_.langASlang_8,k1_.onlineASonline_9,k1_.titleAStitle_10,k1_.slugASslug_11,k1_.urlASurl_12,k1_.weightASweight_13,k1_.createdAScreated_14,k1_.updatedASupdated_15,k1_.idASid_16,k2_.typeAStype_17,k2_.ownerASowner_18,k2_.createdAScreated_19,k2_.updatedASupdated_20,k2_.ref_idASref_id_21,k2_.ref_entity_nameASref_entity_name_22,k2_.idASid_23,k0_.parent_idASparent_id_24,k1_.node_idASnode_id_25,k1_.public_node_version_idASpublic_node_version_id_26,k2_.node_translation_idASnode_translation_id_27,k2_.origin_idASorigin_id_28FROMkuma_nodesk0_LEFT JOINkuma_node_translationsk1_ONk0_.id=k1_.node_idAND (k1_.lang=?) LEFT JOINkuma_node_versionsk2_ONk1_.public_node_version_id=k2_.idAND (k1_.public_node_version_id=k2_.id) WHEREk0_.deleted=?AND ((k0_.hidden_from_nav<>1ORk0_.internal_nameISNOTNULL)) ORDER BYk1_.weightASC,k1_.titleASC
SELECTk0_.lftASlft_0,k0_.lvlASlvl_1,k0_.rgtASrgt_2,k0_.deletedASdeleted_3,k0_.hidden_from_navAShidden_from_nav_4,k0_.ref_entity_nameASref_entity_name_5,k0_.internal_nameASinternal_name_6,k0_.idASid_7,k1_.langASlang_8,k1_.onlineASonline_9,k1_.titleAStitle_10,k1_.slugASslug_11,k1_.urlASurl_12,k1_.weightASweight_13,k1_.createdAScreated_14,k1_.updatedASupdated_15,k1_.idASid_16,k2_.typeAStype_17,k2_.ownerASowner_18,k2_.createdAScreated_19,k2_.updatedASupdated_20,k2_.ref_idASref_id_21,k2_.ref_entity_nameASref_entity_name_22,k2_.idASid_23,k0_.parent_idASparent_id_24,k1_.node_idASnode_id_25,k1_.public_node_version_idASpublic_node_version_id_26,k2_.node_translation_idASnode_translation_id_27,k2_.origin_idASorigin_id_28FROMkuma_nodesk0_LEFT JOINkuma_node_translationsk1_ONk0_.id=k1_.node_idAND (k1_.lang=?)
LEFT JOINkuma_node_versionsk2_ONk1_.public_node_version_id=k2_.idAND (
k1_.public_node_version_id=k2_.id
)
WHEREk0_.deleted=?AND (
(
k0_.hidden_from_nav<>1ORk0_.internal_nameISNOTNULL
)
)
ORDER BYk1_.weightASC,k1_.titleASC
SELECTk0_.lftASlft_0,k0_.lvlASlvl_1,k0_.rgtASrgt_2,k0_.deletedASdeleted_3,k0_.hidden_from_navAShidden_from_nav_4,k0_.ref_entity_nameASref_entity_name_5,k0_.internal_nameASinternal_name_6,k0_.idASid_7,k1_.langASlang_8,k1_.onlineASonline_9,k1_.titleAStitle_10,k1_.slugASslug_11,k1_.urlASurl_12,k1_.weightASweight_13,k1_.createdAScreated_14,k1_.updatedASupdated_15,k1_.idASid_16,k2_.typeAStype_17,k2_.ownerASowner_18,k2_.createdAScreated_19,k2_.updatedASupdated_20,k2_.ref_idASref_id_21,k2_.ref_entity_nameASref_entity_name_22,k2_.idASid_23,k0_.parent_idASparent_id_24,k1_.node_idASnode_id_25,k1_.public_node_version_idASpublic_node_version_id_26,k2_.node_translation_idASnode_translation_id_27,k2_.origin_idASorigin_id_28FROMkuma_nodesk0_LEFT JOINkuma_node_translationsk1_ONk0_.id=k1_.node_idAND (k1_.lang='fr') LEFT JOINkuma_node_versionsk2_ONk1_.public_node_version_id=k2_.idAND (k1_.public_node_version_id=k2_.id) WHEREk0_.deleted=0AND ((k0_.hidden_from_nav<>1ORk0_.internal_nameISNOTNULL)) ORDER BYk1_.weightASC,k1_.titleASC;
SELECTredirect.idFROMkuma_redirectsredirectWHERE (?LIKEREPLACE(redirect.origin,'*','%')) AND ((redirect.domainISNULL) OR (redirect.domain='') OR (redirect.domain=?))
SELECTredirect.idFROMkuma_redirectsredirectWHERE
(
?LIKEREPLACE(redirect.origin,'*','%')
)
AND (
(redirect.domainISNULL)
OR (redirect.domain='')
OR (redirect.domain=?)
)
SELECTredirect.idFROMkuma_redirectsredirectWHERE ('/services'LIKEREPLACE(redirect.origin,'*','%')) AND ((redirect.domainISNULL) OR (redirect.domain='') OR (redirect.domain='www.stag.cciangazidja.com'));