rendered paste body $stmt = "SELECT
fld_id,
fld_title,
fld_type,
fld_report_form_required,
fld_anonymous_form_required,
fld_close_form_required,
" . self::getDBValueFieldSQL() . " as value,
icf_value,
icf_value_date,
icf_value_integer,
fld_min_role
FROM
(
" . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "custom_field,
" . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "project_custom_field
)
LEFT JOIN
" . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "issue_custom_field
ON
pcf_fld_id=icf_fld_id AND
icf_iss_id=" . Misc::escapeInteger($iss_id) . "
WHERE
pcf_fld_id=fld_id AND
pcf_prj_id=" . Misc::escapeInteger($prj_id) . " AND
fld_min_role <= " . $usr_role;