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