SELECT F.*, C.CountryCode, C.CountryName, A.*, F.ZipCode as ZipCode, FT.FirmTransactionId, FJ.FirmJson, FJ.MetaTitle, FJ.MetaDescription, FJ.Source, FJ.FirmSlugUrl 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 LEFT JOIN FirmJson FJ on FJ.FirmId=F.FirmId WHERE F.FirmId = 2788329 and F.LanguageCode= 'en'
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] => 42
                    [function] => Query
                    [class] => DataAccess
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT			      		          	          
		          F.*,	   
                  C.CountryCode,
                  C.CountryName,
                  A.*,
                  F.ZipCode as ZipCode,
                  FT.FirmTransactionId,
                  FJ.FirmJson,
                  FJ.MetaTitle,
                  FJ.MetaDescription,
                  FJ.Source,
                  FJ.FirmSlugUrl
			  	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
                LEFT JOIN FirmJson FJ on FJ.FirmId=F.FirmId
				WHERE
			    	F.FirmId = 2788329 and F.LanguageCode= 'en'
                        )

                )

            [2] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/Firm/FirmSet.class
                    [line] => 17
                    [function] => SelectFirmDataByArgs
                    [class] => FirmModel
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 2788329
                            [1] => en
                        )

                )

            [3] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmMgr.class
                    [line] => 77
                    [function] => getFirmDataByArgs
                    [class] => FirmSet
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 2788329
                            [1] => en
                        )

                )

            [4] => Array
                (
                    [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmAction.class
                    [line] => 241
                    [function] => getFirmData
                    [class] => BizFirmMgr
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 2788329
                            [1] => en
                        )

                )

            [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