Rodeo (29)

Array
(
    [noProfilePhoto] => 0
    [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  GROUP BY v.id  ORDER BY  v.featured DESC, v.viewed  DESC  LIMIT 15

    [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:25:"Competition Associations ";s:8:"location";s:44:"/directory/category/CompetitionAssociations/";}i:3;O:3:"Url":2:{s:4:"name";s:5:"Rodeo";s:8:"location";s:26:"/directory/category/Rodeo/";}}
)

					

Array
(
    [runVars] => category/CompetitionAssociations/Rodeo
    [PHPSESSID] => oqqjift66fnavj6k1ojh8phlr4
    [OAID] => 2e3502846a5e29e0e1e1d10e43fa5dd3
    [sub] => 
    [func] => browse
    [cat] => 233
    [country] => 1
    [page] => 1
    [searching] => 11
)

						

Array
(
    [PHPSESSID] => oqqjift66fnavj6k1ojh8phlr4
    [OAID] => 2e3502846a5e29e0e1e1d10e43fa5dd3
)