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 = 583501 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 = 583501 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] => 583501
                        )

                )

            [3] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmMgr.class
                    [line] => 95
                    [function] => getReviewsByFirmId
                    [class] => ReviewSet
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 583501
                        )

                )

            [4] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmAction.class
                    [line] => 309
                    [function] => getReviewsDataByFirmId
                    [class] => BizFirmMgr
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 583501
                        )

                )

            [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
                        (
                        )

                )

            [7] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Modules/router.php
                    [line] => 199
                    [args] => Array
                        (
                            [0] => /home/soadmin/domains/2findlocal.com/CodeBase/Modules/firm.php
                        )

                    [function] => include_once
                )

            [8] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/Main/Web/index.php
                    [line] => 5
                    [args] => Array
                        (
                            [0] => /home/soadmin/domains/2findlocal.com/CodeBase/Modules/router.php
                        )

                    [function] => include
                )

        )

    [previous:Exception:private] => 
)
ErrorListException