SELECT n.*, nt.TownName, nt.CountryName, c.CountryCode, t.TownLat, t.TownLong, t.TownSubdomain, cat.CategoryPath FROM Nav n INNER JOIN NavTown nt ON n.LanguageCode=nt.LanguageCode AND n.TownId=nt.TownId INNER JOIN Country c ON n.CountryId=c.CountryId INNER JOIN Town t ON nt.TownId=t.TownId INNER JOIN Category cat ON n.CategoryId=cat.CategoryId WHERE n.LanguageCode='en' AND n.TownId=1747 AND n.CategoryId in (8423,8173,8098)
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/Nav/NavModel.class [line] => 13 [function] => Query [class] => DataAccess [type] => -> [args] => Array ( [0] => SELECT n.*, nt.TownName, nt.CountryName, c.CountryCode, t.TownLat, t.TownLong, t.TownSubdomain, cat.CategoryPath FROM Nav n INNER JOIN NavTown nt ON n.LanguageCode=nt.LanguageCode AND n.TownId=nt.TownId INNER JOIN Country c ON n.CountryId=c.CountryId INNER JOIN Town t ON nt.TownId=t.TownId INNER JOIN Category cat ON n.CategoryId=cat.CategoryId WHERE n.LanguageCode='en' AND n.TownId=1747 AND n.CategoryId in (8423,8173,8098) ) ) [2] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/Nav/NavSet.class [line] => 10 [function] => SelectNav [class] => NavModel [type] => -> [args] => Array ( [0] => en [1] => 1747 [2] => 8423,8173,8098 ) ) [3] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmMgr.class [line] => 249 [function] => getNav [class] => NavSet [type] => -> [args] => Array ( [0] => en [1] => 1747 [2] => Array ( [0] => 8423 [1] => 8173 [2] => 8098 ) ) ) [4] => Array ( [file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmAction.class [line] => 288 [function] => getNavData [class] => BizFirmMgr [type] => -> [args] => Array ( [0] => en [1] => 1747 [2] => Array ( [0] => 8423 [1] => 8173 [2] => 8098 ) ) ) [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