A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS total, `trans_portfolio`.*, `mast_portfolio_category`.`portfolio_name`, `ma' at line 1

SELECT SQL_CALC_FOUND_ROWS trans_portfolio.ID, (select COUNT(trans_portfolio.ID) from trans_portfolio where trans_portfolio.company_id=) AS total, `trans_portfolio`.*, `mast_portfolio_category`.`portfolio_name`, `mast_portfolio_category`.`portfolio_id` as category_id, `mast_industry`.`industry_name`, `mast_industry`.`industry_id` FROM (`trans_portfolio`) JOIN `mast_portfolio_category` ON `mast_portfolio_category`.`portfolio_id` = `trans_portfolio`.`portfolio_cat_id` JOIN `mast_industry` ON `mast_industry`.`industry_id` = `trans_portfolio`.`portfolio_indstry_id` WHERE `trans_portfolio`.`company_id` IS NULL ORDER BY `trans_portfolio`.`ID` desc

Filename: /var/www/html/models/company_model.php

Line Number: 1541