Array
(
[directoryCrumbs] => a:4:{i:0;O:3:"Url":2:{s:4:"name";s:4:"Home";s:8:"location";s:1:"/";}i:1;O:3:"Url":2:{s:4:"name";s:9:"Directory";s:8:"location";s:11:"/directory/";}i:2;O:3:"Url":2:{s:4:"name";s:13:"Equine Health";s:8:"location";s:33:"/directory/category/EquineHealth/";}i:3;O:3:"Url":2:{s:4:"name";s:5:"Reiki";s:8:"location";s:26:"/directory/category/Reiki/";}}
[noProfilePhoto] => 0
[tempDBStoreCT] => 1
[sqlDebug] => SELECT * from eventResults WHERE e_id = 1 and c_id = 1 SELECT * from eventResults WHERE e_id = 1 and c_id = 2 SELECT *,(`r4` IS NULL or `r4` ='') as isNull, (`r1` = 'DNQ' or `r2` = 'DNQ' or `r3` = 'DNQ' or `r4` = 'DNQ' ) as dnq from eventResults WHERE e_id = 1 and c_id = 3 ORDER BY dnq ASC, isNull ASC, CAST(`r4` AS DECIMAL(10,2)) ASC
[tempDBStore] =>
[lastDBQuery] => LastSQL:
v.*, Count( r.id ) AS totalRates, SUM(r.rating) AS totalRating, AVG(r.rating) as rateAvg FROM videos as v LEFT JOIN ratings as r ON v.id = r.typeid AND r.`type` = 'videos' WHERE v.status = 1 AND v.category = 901 GROUP BY v.id ORDER BY v.featured DESC, v.category ASC, v.viewed DESC LIMIT 13
)