SELECT  `act_log_head`.`act_log_id` as 'act_log_head.act_log_id', `act_log_head`.`act_log_id` as 'act_log_head.act_log_id', `act_log_head`.`act_log_cat_id` as 'act_log_head.act_log_cat_id', `master_log_category`.`act_log_cat` as 'master_log_category.act_log_cat', `act_log_head`.`act_date` as 'act_log_head.act_date', `act_log_head`.`expedition_code` as 'act_log_head.expedition_code', `master_expedition`.`expedition_name` as 'master_expedition.expedition_name', `act_log_head`.`vehicle_type_id` as 'act_log_head.vehicle_type_id', `master_vehicle_type`.`vehicle_type` as 'master_vehicle_type.vehicle_type', `act_log_head`.`vehicle_number` as 'act_log_head.vehicle_number', `act_log_head`.`container_number` as 'act_log_head.container_number', `act_log_head`.`name` as 'act_log_head.name', `act_log_head`.`co_driver` as 'act_log_head.co_driver', `act_log_head`.`log_status_id` as 'act_log_head.log_status_id', `master_log_status`.`log_status` as 'master_log_status.log_status' FROM  `act_log_head` LEFT JOIN `master_vehicle_type` ON `master_vehicle_type`.`vehicle_type_id` = `act_log_head`.`vehicle_type_id`  LEFT JOIN `master_expedition` ON `master_expedition`.`expedition_code` = `act_log_head`.`expedition_code`  LEFT JOIN `master_log_category` ON `master_log_category`.`act_log_cat_id` = `act_log_head`.`act_log_cat_id`  LEFT JOIN `master_log_status` ON `master_log_status`.`log_status_id` = `act_log_head`.`log_status_id` WHERE `act_log_head`.`log_status_id` <> :where_0
Array
(
    [0] => Array
        (
            [name] => :where_0
            [value] => 6
            [type] =>
        )

)

SELECT DISTINCT  `act_log_cat_id` as 'act_log_cat_id', `act_log_cat` as 'act_log_cat' FROM  `master_log_category` WHERE (`act_log_type` = :where_1 )
Array
(
    [0] => Array
        (
            [name] => :where_1
            [value] => WH
            [type] =>
        )

)

SELECT DISTINCT  `expedition_code` as 'expedition_code', `expedition_name` as 'expedition_name' FROM  `master_expedition`
Array
(
)

SELECT DISTINCT  `vehicle_type_id` as 'vehicle_type_id', `vehicle_type` as 'vehicle_type' FROM  `master_vehicle_type`
Array
(
)

SELECT DISTINCT  `log_status_id` as 'log_status_id', `log_status` as 'log_status' FROM  `master_log_status`
Array
(
)

SELECT  act_log_head.act_log_id as dteditor_pkey, master_customer.customer_code as customer_code, master_customer.customer_name as customer_name FROM  act_log_head as act_log_head  JOIN `link_log_customer` ON `act_log_head`.`act_log_id` = `link_log_customer`.`act_log_id`   JOIN `master_customer` ON `master_customer`.`customer_code` = `link_log_customer`.`customer_code`
Array
(
)

SELECT DISTINCT  `customer_code` as 'customer_code', `customer_name` as 'customer_name' FROM  `master_customer`
Array
(
)

INSERT INTO  `act_log_head`  ( `act_log_id`, `act_log_cat_id`, `act_date`, `expedition_code`, `vehicle_type_id`, `vehicle_number`, `container_number`, `name`, `co_driver`, `log_status_id` ) VALUES (  :act_log_id,  :act_log_cat_id,  :act_date,  :expedition_code,  :vehicle_type_id,  :vehicle_number,  :container_number,  :name,  :co_driver,  :log_status_id )
Array
(
    [0] => Array
        (
            [name] => :act_log_id
            [value] =>
            [type] =>
        )

    [1] => Array
        (
            [name] => :act_log_cat_id
            [value] => 3
            [type] =>
        )

    [2] => Array
        (
            [name] => :act_date
            [value] => 2016-08-03
            [type] =>
        )

    [3] => Array
        (
            [name] => :expedition_code
            [value] => TOP1
            [type] =>
        )

    [4] => Array
        (
            [name] => :vehicle_type_id
            [value] => 2
            [type] =>
        )

    [5] => Array
        (
            [name] => :vehicle_number
            [value] =>
            [type] =>
        )

    [6] => Array
        (
            [name] => :container_number
            [value] =>
            [type] =>
        )

    [7] => Array
        (
            [name] => :name
            [value] =>
            [type] =>
        )

    [8] => Array
        (
            [name] => :co_driver
            [value] =>
            [type] =>
        )

    [9] => Array
        (
            [name] => :log_status_id
            [value] => 11
            [type] =>
        )

)

INSERT INTO  `link_log_customer`  ( `act_log_id`, `customer_code` ) VALUES (  :act_log_id,  :customer_code )
Array
(
    [0] => Array
        (
            [name] => :act_log_id
            [value] =>
            [type] =>
        )

    [1] => Array
        (
            [name] => :customer_code
            [value] => 2
            [type] =>
        )

)

INSERT INTO  `link_log_customer`  ( `act_log_id`, `customer_code` ) VALUES (  :act_log_id,  :customer_code )
Array
(
    [0] => Array
        (
            [name] => :act_log_id
            [value] =>
            [type] =>
        )

    [1] => Array
        (
            [name] => :customer_code
            [value] => 3
            [type] =>
        )

)

SELECT  `act_log_head`.`act_log_id` as 'act_log_head.act_log_id', `act_log_head`.`act_log_id` as 'act_log_head.act_log_id', `act_log_head`.`act_log_cat_id` as 'act_log_head.act_log_cat_id', `master_log_category`.`act_log_cat` as 'master_log_category.act_log_cat', `act_log_head`.`act_date` as 'act_log_head.act_date', `act_log_head`.`expedition_code` as 'act_log_head.expedition_code', `master_expedition`.`expedition_name` as 'master_expedition.expedition_name', `act_log_head`.`vehicle_type_id` as 'act_log_head.vehicle_type_id', `master_vehicle_type`.`vehicle_type` as 'master_vehicle_type.vehicle_type', `act_log_head`.`vehicle_number` as 'act_log_head.vehicle_number', `act_log_head`.`container_number` as 'act_log_head.container_number', `act_log_head`.`name` as 'act_log_head.name', `act_log_head`.`co_driver` as 'act_log_head.co_driver', `act_log_head`.`log_status_id` as 'act_log_head.log_status_id', `master_log_status`.`log_status` as 'master_log_status.log_status' FROM  `act_log_head` LEFT JOIN `master_vehicle_type` ON `master_vehicle_type`.`vehicle_type_id` = `act_log_head`.`vehicle_type_id`  LEFT JOIN `master_expedition` ON `master_expedition`.`expedition_code` = `act_log_head`.`expedition_code`  LEFT JOIN `master_log_category` ON `master_log_category`.`act_log_cat_id` = `act_log_head`.`act_log_cat_id`  LEFT JOIN `master_log_status` ON `master_log_status`.`log_status_id` = `act_log_head`.`log_status_id` WHERE `act_log_head`.`log_status_id` <> :where_0 AND `act_log_head`.`act_log_id` = :where_1
Array
(
    [0] => Array
        (
            [name] => :where_0
            [value] => 6
            [type] =>
        )

    [1] => Array
        (
            [name] => :where_1
            [value] =>
            [type] =>
        )

)

SELECT DISTINCT  `act_log_cat_id` as 'act_log_cat_id', `act_log_cat` as 'act_log_cat' FROM  `master_log_category` WHERE (`act_log_type` = :where_1 )
Array
(
    [0] => Array
        (
            [name] => :where_1
            [value] => WH
            [type] =>
        )

)

SELECT DISTINCT  `expedition_code` as 'expedition_code', `expedition_name` as 'expedition_name' FROM  `master_expedition`
Array
(
)

SELECT DISTINCT  `vehicle_type_id` as 'vehicle_type_id', `vehicle_type` as 'vehicle_type' FROM  `master_vehicle_type`
Array
(
)

SELECT DISTINCT  `log_status_id` as 'log_status_id', `log_status` as 'log_status' FROM  `master_log_status`
Array
(
)

SELECT  act_log_head.act_log_id as dteditor_pkey, master_customer.customer_code as customer_code, master_customer.customer_name as customer_name FROM  act_log_head as act_log_head  JOIN `link_log_customer` ON `act_log_head`.`act_log_id` = `link_log_customer`.`act_log_id`   JOIN `master_customer` ON `master_customer`.`customer_code` = `link_log_customer`.`customer_code`
Array
(
)

SELECT DISTINCT  `customer_code` as 'customer_code', `customer_name` as 'customer_name' FROM  `master_customer`
Array
(
)

SELECT  `act_log_head`.`act_log_id` as 'act_log_head.act_log_id', `act_log_head`.`act_log_id` as 'act_log_head.act_log_id', `act_log_head`.`act_log_cat_id` as 'act_log_head.act_log_cat_id', `master_log_category`.`act_log_cat` as 'master_log_category.act_log_cat', `act_log_head`.`act_date` as 'act_log_head.act_date', `act_log_head`.`expedition_code` as 'act_log_head.expedition_code', `master_expedition`.`expedition_name` as 'master_expedition.expedition_name', `act_log_head`.`vehicle_type_id` as 'act_log_head.vehicle_type_id', `master_vehicle_type`.`vehicle_type` as 'master_vehicle_type.vehicle_type', `act_log_head`.`vehicle_number` as 'act_log_head.vehicle_number', `act_log_head`.`container_number` as 'act_log_head.container_number', `act_log_head`.`name` as 'act_log_head.name', `act_log_head`.`co_driver` as 'act_log_head.co_driver', `act_log_head`.`log_status_id` as 'act_log_head.log_status_id', `master_log_status`.`log_status` as 'master_log_status.log_status' FROM  `act_log_head` LEFT JOIN `master_vehicle_type` ON `master_vehicle_type`.`vehicle_type_id` = `act_log_head`.`vehicle_type_id`  LEFT JOIN `master_expedition` ON `master_expedition`.`expedition_code` = `act_log_head`.`expedition_code`  LEFT JOIN `master_log_category` ON `master_log_category`.`act_log_cat_id` = `act_log_head`.`act_log_cat_id`  LEFT JOIN `master_log_status` ON `master_log_status`.`log_status_id` = `act_log_head`.`log_status_id` WHERE `act_log_head`.`log_status_id` <> :where_0
Array
(
    [0] => Array
        (
            [name] => :where_0
            [value] => 6
            [type] =>
        )

)

SELECT DISTINCT  `act_log_cat_id` as 'act_log_cat_id', `act_log_cat` as 'act_log_cat' FROM  `master_log_category` WHERE (`act_log_type` = :where_1 )
Array
(
    [0] => Array
        (
            [name] => :where_1
            [value] => WH
            [type] =>
        )

)

SELECT DISTINCT  `expedition_code` as 'expedition_code', `expedition_name` as 'expedition_name' FROM  `master_expedition`
Array
(
)

SELECT DISTINCT  `vehicle_type_id` as 'vehicle_type_id', `vehicle_type` as 'vehicle_type' FROM  `master_vehicle_type`
Array
(
)

SELECT DISTINCT  `log_status_id` as 'log_status_id', `log_status` as 'log_status' FROM  `master_log_status`
Array
(
)

SELECT  act_log_head.act_log_id as dteditor_pkey, master_customer.customer_code as customer_code, master_customer.customer_name as customer_name FROM  act_log_head as act_log_head  JOIN `link_log_customer` ON `act_log_head`.`act_log_id` = `link_log_customer`.`act_log_id`   JOIN `master_customer` ON `master_customer`.`customer_code` = `link_log_customer`.`customer_code`
Array
(
)

SELECT DISTINCT  `customer_code` as 'customer_code', `customer_name` as 'customer_name' FROM  `master_customer`
Array
(
)