<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

ERROR - 2024-05-26 00:38:31 --> Query error: Unknown column 'tbl.vendor_name' in 'where clause' - Invalid query: SELECT *
FROM .`coal_getting` `tbl`
LEFT JOIN `vendor` `vnd` ON `tbl`.`vendor_id`=`vnd`.`vendor_id`
LEFT JOIN `trans_status` `sts` ON `tbl`.`coal_get_status`=`sts`.`trans_status`
WHERE `coal_get_date` >= '20240501'
AND `coal_get_date` <= '20240526'
AND (
			tbl.vendor_name LIKE '%%'
			OR `tbl`.`vehicle_id` LIKE '%%'
			OR `tbl`.`vehicle_number` LIKE '%%')
