SELECT F.*, C.CountryCode, C.CountryName, A.*, F.ZipCode as ZipCode, FT.FirmTransactionId FROM Firm F LEFT JOIN Country C ON F.CountryId=C.CountryId LEFT JOIN Account A on F.AccountId=A.AccountId LEFT JOIN FirmTransaction FT on FT.FirmId=F.FirmId WHERE F.FirmSubdomain = 'handyman-california'
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/Firm/FirmModel.class
                    [line] => 63
                    [function] => Query
                    [class] => DataAccess
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT
		F.*,
		C.CountryCode,
		C.CountryName,
		A.*,
		F.ZipCode as ZipCode,
		FT.FirmTransactionId
		FROM
		Firm F
		LEFT JOIN Country C ON F.CountryId=C.CountryId
		LEFT JOIN Account A on F.AccountId=A.AccountId
		LEFT JOIN FirmTransaction FT on FT.FirmId=F.FirmId
		WHERE
		F.FirmSubdomain = 'handyman-california'
                        )

                )

            [2] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/Firm/FirmSet.class
                    [line] => 25
                    [function] => SelectFirmBySubdomain
                    [class] => FirmModel
                    [type] => ->
                    [args] => Array
                        (
                            [0] => handyman-california
                            [1] => 
                        )

                )

            [3] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmMgr.class
                    [line] => 82
                    [function] => getFirmBySubdomain
                    [class] => FirmSet
                    [type] => ->
                    [args] => Array
                        (
                            [0] => handyman-california
                            [1] => 
                        )

                )

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

                )

            [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] => 20
                    [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