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