WordPress database error: [Table 'wakafperak.aibim_project' doesn't exist]
select project_id, project_code, project_name_en as project_name, project_desc_en as project_desc, project_problem_statement_en as project_problem_statement, project_mechanism_en as project_mechanism, project_impact_en as project_impact, project_member_en as project_member, project_bank, project_main, project_target, project_duration, project_status, project_status_publish, bank_name, main_state, project_collection_close, sum(transaction_amount) as raised_amount, project_progress, (CASE WHEN project_target > COALESCE(sum( transaction_amount ), 0) THEN 'Aktif' ELSE 'SELESAI' END) AS target_status from aibim_project LEFT JOIN aibim_bank on project_bank = bank_id LEFT JOIN aibim_main on project_main = main_id LEFT JOIN aibim_transaction on transaction_project_link = project_id WHERE project_status = 'Telah Aktif' AND project_status_publish = 'Telah Aktif' GROUP BY project_id HAVING target_status = 'AKTIF' ORDER BY project_id DESC,project_name

WordPress database error: [Table 'wakafperak.aibim_project' doesn't exist]
select project_id, project_code, project_name_en as project_name, project_desc_en as project_desc, project_problem_statement_en as project_problem_statement, project_mechanism_en as project_mechanism, project_impact_en as project_impact, project_member_en as project_member, project_bank, project_main, project_target, project_duration, project_status, project_status_publish, bank_name, main_state, project_collection_close, sum(transaction_amount) as raised_amount, project_progress, (CASE WHEN project_target > COALESCE(sum( transaction_amount ), 0) THEN 'Aktif' ELSE 'SELESAI' END) AS target_status from aibim_project LEFT JOIN aibim_bank on project_bank = bank_id LEFT JOIN aibim_main on project_main = main_id LEFT JOIN aibim_transaction on transaction_project_link = project_id WHERE project_status = 'Telah Aktif' AND project_status_publish = 'Telah Aktif' GROUP BY project_id HAVING target_status = 'AKTIF' ORDER BY project_id DESC,project_name

{"id":398,"date":"2018-11-11T09:18:52","date_gmt":"2018-11-11T09:18:52","guid":{"rendered":"https:\/\/192.168.0.199\/portal\/?page_id=398"},"modified":"2018-11-11T09:21:03","modified_gmt":"2018-11-11T09:21:03","slug":"buy-waqf","status":"publish","type":"page","link":"https:\/\/www.wakafperak.gov.my\/en\/buy-waqf\/","title":{"rendered":"Buy Waqf"},"content":{"rendered":" ×<\/span>\r\n \r\n

\r\n

PLEASE SELECT THE WAQF PROJECT.<\/h5>\r\n \r\n \r\n \r\n \r\n \r\n <\/tbody>\r\n <\/table>\r\n
\r\n \tTotal<\/label>\r\n \r\n <\/div>\r\n
\r\n \t
-Minimum amount of each project is RM 10.00\r\n -The total amount should not exceed RM 30,000.00\r\n -RM 0.50 will be charged per transaction<\/p>\r\n <\/div>\r\n \r\n
\r\n \r\n <\/div>\r\n \r\n <\/div>\r\n \r\n
\r\n Back<\/span>\r\n
\r\n
myWaqf Form<\/h3>\r\n \r\n
Project Title : <\/div>\r\n
<\/span><\/div>\r\n
Waqf Amount : <\/div>\r\n
RM <\/span><\/div>\r\n
<\/div>\r\n <\/span>\r\n
\r\n \r\n \r\n \r\n
\r\n Category <\/span><\/label>\r\n \r\n <\/div>\r\n <\/span>\r\n \r\n \r\n
\r\n Full Name <\/span><\/label>\r\n \r\n <\/div>\r\n <\/span>\r\n \r\n
\r\n Address<\/label>\r\n \r\n \r\n \r\n - Address is required to issue a receipt<\/em><\/span><\/label>\r\n <\/div>\r\n <\/span>\r\n \r\n
\r\n City <\/span><\/label>\r\n \r\n <\/div>\r\n
\r\n Postcode <\/span><\/label>\r\n \r\n <\/div>\r\n <\/span>\r\n \r\n \r\n \r\n
\r\n State *<\/span><\/label>\r\n \r\n
\r\n Select All<\/label>\r\n \r\n <\/td>\r\n \r\n PROJECT TITLE<\/span>\r\n <\/th>\r\n \r\n BANK\r\n <\/th>\r\n \r\n STATE <\/th>\r\n \r\n COLLECTION GOAL(RM)\r\n <\/th>\r\n \r\n RAISED AMOUNT(RM)\r\n <\/th>\r\n \r\n WAQF AMOUNT(RM)\r\n <\/th>\r\n <\/tr>\r\n <\/thead>\r\n \r\n