SELECT *
FROM kbk_wf_profiles
WHERE published = 1ORDERBY ordering ASC339μs4.67KB/components/com_jce/editor/libraries/classes/application.php:284Copy
SELECTDISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM kbk_fields AS a
LEFTJOIN`kbk_languages`AS l ON l.lang_code = a.languageLEFTJOIN kbk_users AS uc ON uc.id=a.checked_out
LEFTJOIN kbk_viewlevels AS ag ON ag.id = a.access
LEFTJOIN kbk_users AS ua ON ua.id = a.created_user_id
LEFTJOIN kbk_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND`a`.`access`IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0OR`g`.`access`IN (:preparedArray3,:preparedArray4)) AND`a`.`state` = :state) AND
(`a`.`group_id` = 0OR`g`.`state` = :gstate) AND`a`.`only_use_in_subform` = :only_use_in_subform
ORDERBY a.ordering ASC1.91ms7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
