TYPE=VIEW
query=select `db_account_9793090153`.`tbl_invoice_list`.`in_list_join_id` AS `join_in_list_join_id`,sum(`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty`) AS `join_in_list_link_qty`,count(distinct `db_account_9793090153`.`tbl_invoice_list`.`in_list_id`) AS `join_in_list_link_count` from (`db_account_9793090153`.`tbl_invoice_det` join `db_account_9793090153`.`tbl_invoice_list` on((`db_account_9793090153`.`tbl_invoice_list`.`in_list_id` = `db_account_9793090153`.`tbl_invoice_det`.`in_det_list_id`))) where (`db_account_9793090153`.`tbl_invoice_list`.`in_list_join_id` <> 0) group by `db_account_9793090153`.`tbl_invoice_list`.`in_list_join_id`
md5=152b2a5668b6c35fafdd9fda05a06859
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2014-01-01 21:20:12
create-version=1
source=select `tbl_invoice_list`.`in_list_join_id` AS `join_in_list_join_id`,sum(`tbl_invoice_det`.`in_det_qty`) AS `join_in_list_link_qty`,count(distinct `tbl_invoice_list`.`in_list_id`) AS `join_in_list_link_count` from (`tbl_invoice_det` join `tbl_invoice_list` on((`tbl_invoice_list`.`in_list_id` = `tbl_invoice_det`.`in_det_list_id`))) where (`tbl_invoice_list`.`in_list_join_id` <> 0) group by `tbl_invoice_list`.`in_list_join_id`
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select `db_account_9793090153`.`tbl_invoice_list`.`in_list_join_id` AS `join_in_list_join_id`,sum(`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty`) AS `join_in_list_link_qty`,count(distinct `db_account_9793090153`.`tbl_invoice_list`.`in_list_id`) AS `join_in_list_link_count` from (`db_account_9793090153`.`tbl_invoice_det` join `db_account_9793090153`.`tbl_invoice_list` on((`db_account_9793090153`.`tbl_invoice_list`.`in_list_id` = `db_account_9793090153`.`tbl_invoice_det`.`in_det_list_id`))) where (`db_account_9793090153`.`tbl_invoice_list`.`in_list_join_id` <> 0) group by `db_account_9793090153`.`tbl_invoice_list`.`in_list_join_id`
