$joinQuery apply LEFT JOIN but cannot show join table’s valuable

<?php $table = ‘fchan_mc_ee_hw’; $primaryKey = ‘id’; $columns = array( array( ‘db’ => ‘`s`.`surname`’, ‘dt’ => 0, ‘field’ => ‘sid’ ), array( ‘db’ => ‘`h`.`officer_id`’, ‘dt’ => 1, ‘field’ => ‘officer_id’ ), array( ‘db’ => ‘sum(if (`h`.`mc_ee_level_id` = 1,1,0 ))’, ‘dt’ => 2, ‘field’ =>’sum_of_L1′, ‘as’ => ‘sum_of_L1’ ), array( ‘db’ => ‘sum(if (`h`.`mc_ee_level_id` = … Continue reading $joinQuery apply LEFT JOIN but cannot show join table’s valuable