Error Number: 1146
Table 'mybe2_beyond.data_agen' doesn't exist
SELECT `a`.*, `b`.`nama` AS `jabatan` FROM `data_agen` `a` LEFT JOIN `tr_jabatan` `b` ON `b`.`id` = `a`.`jabatan` WHERE `a`.`jabatan` IN('1', '11', '12') AND `a`.`aktifasi` = '1' ORDER BY (SELECT COUNT(id_prop) as jumlah FROM data_property WHERE agen = a.kode_agen AND status = '0' and web_publish =1) DESC
Filename: modules/public_page/models/M_public.php
Line Number: 50