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 = 6766490 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 = 6766490 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] => 6766490
)
)
[3] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmMgr.class
[line] => 95
[function] => getReviewsByFirmId
[class] => ReviewSet
[type] => ->
[args] => Array
(
[0] => 6766490
)
)
[4] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmAction.class
[line] => 309
[function] => getReviewsDataByFirmId
[class] => BizFirmMgr
[type] => ->
[args] => Array
(
[0] => 6766490
)
)
[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