SELECT t1.*, IF(t1.Author='' OR t1.Author IS NULL, CONCAT(t2.FirstName,' ', t2.LastName), Author) AS Author FROM Review AS t1 LEFT JOIN Account AS t2 ON t1.AccountId = t2.AccountId WHERE t1.FirmId = 12143671 AND t1.ReviewStatus < 99 ORDER BY 1 DESC;
ErrorListException Object ( [a_errors:protected] => Array ( [0] => BackOfficeError Object ( [s_code:protected] => [s_text:protected] => Unable to execute database query [a_fields:protected] => Array ( ) [s_category:protected] => backOffice ) ) [message:protected] => [string:Exception:private] => [code:protected] => 0 [file:protected] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/DataAccess.class [line:protected] => 184 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/DataAccess.class [line] => 100 [function] => error [class] => DataAccess [type] => -> [args] => Array ( [0] => QUERY.FAILURE ) ) [1] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/Review/ReviewModel.class [line] => 100 [function] => Query [class] => DataAccess [type] => -> [args] => Array ( [0] => SELECT t1.*, IF(t1.Author='' OR t1.Author IS NULL, CONCAT(t2.FirstName,' ', t2.LastName), Author) AS Author FROM Review AS t1 LEFT JOIN Account AS t2 ON t1.AccountId = t2.AccountId WHERE t1.FirmId = 12143671 AND t1.ReviewStatus < 99 ORDER BY 1 DESC; ) ) [2] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/Review/ReviewSet.class [line] => 18 [function] => SelectReviewsByFirmId [class] => ReviewModel [type] => -> [args] => Array ( [0] => 12143671 ) ) [3] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmMgr.class [line] => 95 [function] => getReviewsByFirmId [class] => ReviewSet [type] => -> [args] => Array ( [0] => 12143671 ) ) [4] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmAction.class [line] => 309 [function] => getReviewsDataByFirmId [class] => BizFirmMgr [type] => -> [args] => Array ( [0] => 12143671 ) ) [5] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Actions/ActionBase.class [line] => 56 [function] => execute [class] => BizFirmAction [type] => -> [args] => Array ( ) ) [6] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Modules/firm.php [line] => 10 [function] => run [class] => ActionBase [type] => -> [args] => Array ( ) ) ) [previous:Exception:private] => )ErrorListException