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=20402 AND n.CategoryId in (8497,8499,8109)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=20402 AND n.CategoryId in (8497,8499,8109)
)
)
[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] => 20402
[2] => 8497,8499,8109
)
)
[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] => 20402
[2] => Array
(
[0] => 8497
[1] => 8499
[2] => 8109
)
)
)
[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] => 20402
[2] => Array
(
[0] => 8497
[1] => 8499
[2] => 8109
)
)
)
[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