Advertisement
aliGo

ZpmdGridController#zpmd

Jul 4th, 2022
14
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. select zpmdpresen0_.id as id1_14_, zpmdpresen0_.category_id as category2_14_, zpmdpresen0_.category_name as category3_14_, zpmdpresen0_.date_create as date_cre4_14_, zpmdpresen0_.diff as diff5_14_, zpmdpresen0_.has_related_document as has_rela6_14_, zpmdpresen0_.mcode as mcode7_14_, zpmdpresen0_.mo_full_name as mo_full_8_14_, zpmdpresen0_.mo_id as mo_id9_14_, zpmdpresen0_.mo_short_name as mo_shor10_14_, zpmdpresen0_.parent_zpmd_id as parent_11_14_, zpmdpresen0_.podr_code as podr_co12_14_, zpmdpresen0_.podr_id as podr_id13_14_, zpmdpresen0_.podr_name as podr_na14_14_, zpmdpresen0_.profile as profile15_14_, zpmdpresen0_.date_recieve as date_re16_14_, zpmdpresen0_.received as receive17_14_, zpmdpresen0_.region as region18_14_, zpmdpresen0_.related_document_id as related19_14_, zpmdpresen0_.repeated_zpmd_id as repeate20_14_, zpmdpresen0_.request_name as request21_14_, zpmdpresen0_.request_number as request22_14_, zpmdpresen0_.date_send as date_se23_14_, zpmdpresen0_.status as status24_14_, zpmdpresen0_.theme_category_id as theme_c25_14_, zpmdpresen0_.theme_id as theme_i26_14_, zpmdpresen0_.theme_name as theme_n27_14_, zpmdpresen0_.total as total28_14_, zpmdpresen0_.user_full_name as user_fu29_14_, zpmdpresen0_.user_id as user_id30_14_, zpmdpresen0_.usl_id as usl_id31_14_, zpmdpresen0_.usl_name as usl_nam32_14_ from zpmd.zpmd_view zpmdpresen0_ where lower(zpmdpresen0_.region)=? and 1=1 and (zpmdpresen0_.status=? or zpmdpresen0_.status=? or zpmdpresen0_.status=? or zpmdpresen0_.status=?) order by zpmdpresen0_.date_create desc limit ?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement