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 jos_fields AS a
LEFTJOIN`jos_languages`AS l ON l.lang_code = a.languageLEFTJOIN jos_users AS uc ON uc.id=a.checked_out
LEFTJOIN jos_viewlevels AS ag ON ag.id = a.access
LEFTJOIN jos_users AS ua ON ua.id = a.created_user_id
LEFTJOIN jos_fields_groups AS g ON g.id = a.group_id
LEFTJOIN`jos_fields_categories`AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id`ISNULLOR`fc`.`category_id`IN (:preparedArray1,:preparedArray2)) AND`a`.`access`IN (:preparedArray3,:preparedArray4)) AND
(`a`.`group_id` = 0OR`g`.`access`IN (:preparedArray5,:preparedArray6)) 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 ASC249μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
