TYPE=VIEW
query=select cast(`db_account_9793090153`.`tbl_audit_sys`.`audit_sysdate` as date) AS `audit_date` from ((`db_account_9793090153`.`tbl_item_view` `b` join `db_account_9793090153`.`tbl_item` `d` on((`d`.`it_id` = `b`.`it_item_id`))) join `db_account_9793090153`.`tbl_audit_sys` on(((`d`.`it_id` = `db_account_9793090153`.`tbl_audit_sys`.`audit_field_id`) and (`db_account_9793090153`.`tbl_audit_sys`.`audit_table_id` = 103)))) group by cast(`db_account_9793090153`.`tbl_audit_sys`.`audit_sysdate` as date) order by cast(`db_account_9793090153`.`tbl_audit_sys`.`audit_sysdate` as date)
md5=741e22dcfe91156dc1703e4c7f1f3e89
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2014-01-01 21:20:13
create-version=1
source=select
\n  cast(`tbl_audit_sys`.`audit_sysdate` as date) AS `audit_date`
\nfrom
\n  ((`tbl_item_view` `b`
\n  join `tbl_item` `d` on ((`d`.`it_id` = `b`.`it_item_id`)))
\n  join `tbl_audit_sys` on (((`d`.`it_id` = `tbl_audit_sys`.`audit_field_id`) and (
\n  `tbl_audit_sys`.`audit_table_id` = 103))))
\ngroup by
\n  cast(`tbl_audit_sys`.`audit_sysdate` as date)
\norder by
\n  cast(`tbl_audit_sys`.`audit_sysdate` as date)
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select cast(`db_account_9793090153`.`tbl_audit_sys`.`audit_sysdate` as date) AS `audit_date` from ((`db_account_9793090153`.`tbl_item_view` `b` join `db_account_9793090153`.`tbl_item` `d` on((`d`.`it_id` = `b`.`it_item_id`))) join `db_account_9793090153`.`tbl_audit_sys` on(((`d`.`it_id` = `db_account_9793090153`.`tbl_audit_sys`.`audit_field_id`) and (`db_account_9793090153`.`tbl_audit_sys`.`audit_table_id` = 103)))) group by cast(`db_account_9793090153`.`tbl_audit_sys`.`audit_sysdate` as date) order by cast(`db_account_9793090153`.`tbl_audit_sys`.`audit_sysdate` as date)
