#0 PHPSQLParser\exceptions\UnableToCreateSQLException->__construct(WHERE expression subtree, 2, Array ([expr_type] => subquery,[base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content"),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => id,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => ,[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_jreviews_categories,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => `option`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => option)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => )))), expr_type) called at [/home/s002190/public_html/libraries/jdiction/database/parser/builders/WhereBracketExpressionBuilder.php:119] #1 PHPSQLParser\builders\WhereBracketExpressionBuilder->build(Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.catid IN (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content") AND Listing.catid IN ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ) AND Listing.access IN ( 1) ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[2] => Array ([expr_type] => subquery,[base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content"),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => id,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => ,[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_jreviews_categories,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => `option`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => option)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => )))),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[6] => Array ([expr_type] => subquery,[base_expr] => ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS Category,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => ParentCategory,[base_expr] => AS ParentCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ParentCategory))),[hints] => ,[join_type] => CROSS,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS ParentCategory,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.published,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => published)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Category.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => access)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[10] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => colref,[base_expr] => Category.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => lft)),[sub_tree] => ),[13] => Array ([expr_type] => operator,[base_expr] => BETWEEN,[sub_tree] => ),[14] => Array ([expr_type] => colref,[base_expr] => ParentCategory.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => lft)),[sub_tree] => ),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => ParentCategory.rgt,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => rgt)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[18] => Array ([expr_type] => colref,[base_expr] => ParentCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => id)),[sub_tree] => ),[19] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[20] => Array ([expr_type] => const,[base_expr] => 7,[sub_tree] => )))),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => <=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-31 23:00:00",[sub_tree] => ))),[13] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[14] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => >=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-30 23:00:00",[sub_tree] => ))),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[18] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => )))))) called at [/home/s002190/public_html/libraries/jdiction/database/parser/builders/WhereBuilder.php:104] #2 PHPSQLParser\builders\WhereBuilder->buildWhereBracketExpression(Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.catid IN (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content") AND Listing.catid IN ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ) AND Listing.access IN ( 1) ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[2] => Array ([expr_type] => subquery,[base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content"),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => id,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => ,[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_jreviews_categories,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => `option`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => option)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => )))),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[6] => Array ([expr_type] => subquery,[base_expr] => ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS Category,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => ParentCategory,[base_expr] => AS ParentCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ParentCategory))),[hints] => ,[join_type] => CROSS,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS ParentCategory,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.published,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => published)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Category.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => access)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[10] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => colref,[base_expr] => Category.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => lft)),[sub_tree] => ),[13] => Array ([expr_type] => operator,[base_expr] => BETWEEN,[sub_tree] => ),[14] => Array ([expr_type] => colref,[base_expr] => ParentCategory.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => lft)),[sub_tree] => ),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => ParentCategory.rgt,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => rgt)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[18] => Array ([expr_type] => colref,[base_expr] => ParentCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => id)),[sub_tree] => ),[19] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[20] => Array ([expr_type] => const,[base_expr] => 7,[sub_tree] => )))),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => <=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-31 23:00:00",[sub_tree] => ))),[13] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[14] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => >=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-30 23:00:00",[sub_tree] => ))),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[18] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => )))))) called at [/home/s002190/public_html/libraries/jdiction/database/parser/builders/WhereBuilder.php:124] #3 PHPSQLParser\builders\WhereBuilder->build(Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.catid IN (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content") AND Listing.catid IN ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ) AND Listing.access IN ( 1) ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[2] => Array ([expr_type] => subquery,[base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content"),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => id,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => ,[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_jreviews_categories,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => `option`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => option)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => )))),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[6] => Array ([expr_type] => subquery,[base_expr] => ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS Category,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => ParentCategory,[base_expr] => AS ParentCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ParentCategory))),[hints] => ,[join_type] => CROSS,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS ParentCategory,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.published,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => published)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Category.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => access)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[10] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => colref,[base_expr] => Category.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => lft)),[sub_tree] => ),[13] => Array ([expr_type] => operator,[base_expr] => BETWEEN,[sub_tree] => ),[14] => Array ([expr_type] => colref,[base_expr] => ParentCategory.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => lft)),[sub_tree] => ),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => ParentCategory.rgt,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => rgt)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[18] => Array ([expr_type] => colref,[base_expr] => ParentCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => id)),[sub_tree] => ),[19] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[20] => Array ([expr_type] => const,[base_expr] => 7,[sub_tree] => )))),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => <=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-31 23:00:00",[sub_tree] => ))),[13] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[14] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => >=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-30 23:00:00",[sub_tree] => ))),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[18] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))))))) called at [/home/s002190/public_html/libraries/jdiction/database/parser/builders/SelectStatementBuilder.php:74] #4 PHPSQLParser\builders\SelectStatementBuilder->buildWHERE(Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.catid IN (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content") AND Listing.catid IN ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ) AND Listing.access IN ( 1) ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[2] => Array ([expr_type] => subquery,[base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content"),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => id,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => ,[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_jreviews_categories,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => `option`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => option)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => )))),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[6] => Array ([expr_type] => subquery,[base_expr] => ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS Category,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => ParentCategory,[base_expr] => AS ParentCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ParentCategory))),[hints] => ,[join_type] => CROSS,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS ParentCategory,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.published,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => published)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Category.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => access)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[10] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => colref,[base_expr] => Category.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => lft)),[sub_tree] => ),[13] => Array ([expr_type] => operator,[base_expr] => BETWEEN,[sub_tree] => ),[14] => Array ([expr_type] => colref,[base_expr] => ParentCategory.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => lft)),[sub_tree] => ),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => ParentCategory.rgt,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => rgt)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[18] => Array ([expr_type] => colref,[base_expr] => ParentCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => id)),[sub_tree] => ),[19] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[20] => Array ([expr_type] => const,[base_expr] => 7,[sub_tree] => )))),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => <=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-31 23:00:00",[sub_tree] => ))),[13] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[14] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => >=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-30 23:00:00",[sub_tree] => ))),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[18] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))))))) called at [/home/s002190/public_html/libraries/jdiction/database/parser/builders/SelectStatementBuilder.php:106] #5 PHPSQLParser\builders\SelectStatementBuilder->build(Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.listing_id`,[base_expr] => AS `Listing.listing_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.listing_id))),[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ,[delim] => ,),[1] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.slug`,[base_expr] => AS `Listing.slug`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.slug))),[base_expr] => Listing.alias,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => alias)),[sub_tree] => ,[delim] => ,),[2] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.slug`,[base_expr] => AS `Category.slug`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.slug))),[base_expr] => Category.alias,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => alias)),[sub_tree] => ,[delim] => ,),[3] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.title`,[base_expr] => AS `Listing.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.title))),[base_expr] => Listing.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => title)),[sub_tree] => ,[delim] => ,),[4] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.summary`,[base_expr] => AS `Listing.summary`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.summary))),[base_expr] => Listing.introtext,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => introtext)),[sub_tree] => ,[delim] => ,),[5] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.images`,[base_expr] => AS `Listing.images`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.images))),[base_expr] => Listing.images,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => images)),[sub_tree] => ,[delim] => ,),[6] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.hits`,[base_expr] => AS `Listing.hits`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.hits))),[base_expr] => Listing.hits,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => hits)),[sub_tree] => ,[delim] => ,),[7] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.cat_id`,[base_expr] => AS `Listing.cat_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.cat_id))),[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ,[delim] => ,),[8] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.user_id`,[base_expr] => AS `Listing.user_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.user_id))),[base_expr] => Listing.created_by,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by)),[sub_tree] => ,[delim] => ,),[9] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.author_alias`,[base_expr] => AS `Listing.author_alias`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.author_alias))),[base_expr] => Listing.created_by_alias,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by_alias)),[sub_tree] => ,[delim] => ,),[10] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.created`,[base_expr] => AS `Listing.created`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.created))),[base_expr] => Listing.created,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created)),[sub_tree] => ,[delim] => ,),[11] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.modified`,[base_expr] => AS `Listing.modified`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.modified))),[base_expr] => Listing.modified,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => modified)),[sub_tree] => ,[delim] => ,),[12] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.access`,[base_expr] => AS `Listing.access`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.access))),[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ,[delim] => ,),[13] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.state`,[base_expr] => AS `Listing.state`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.state))),[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ,[delim] => ,),[14] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.publish_up`,[base_expr] => AS `Listing.publish_up`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.publish_up))),[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ,[delim] => ,),[15] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.publish_down`,[base_expr] => AS `Listing.publish_down`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.publish_down))),[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ,[delim] => ,),[16] => Array ([expr_type] => const,[alias] => Array ([as] => 1,[name] => `Listing.extension`,[base_expr] => AS `Listing.extension`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.extension))),[base_expr] => 'com_content',[sub_tree] => ,[delim] => ,),[17] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.cat_id`,[base_expr] => AS `Category.cat_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.cat_id))),[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => ,),[18] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.title`,[base_expr] => AS `Category.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.title))),[base_expr] => Category.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => title)),[sub_tree] => ,[delim] => ,),[19] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.params`,[base_expr] => AS `Category.params`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.params))),[base_expr] => Category.params,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => params)),[sub_tree] => ,[delim] => ,),[20] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Directory.dir_id`,[base_expr] => AS `Directory.dir_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory.dir_id))),[base_expr] => Directory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => id)),[sub_tree] => ,[delim] => ,),[21] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Directory.title`,[base_expr] => AS `Directory.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory.title))),[base_expr] => Directory.desc,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => desc)),[sub_tree] => ,[delim] => ,),[22] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Directory.slug`,[base_expr] => AS `Directory.slug`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory.slug))),[base_expr] => Directory.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => title)),[sub_tree] => ,[delim] => ,),[23] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.criteria_id`,[base_expr] => AS `Criteria.criteria_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.criteria_id))),[base_expr] => Criteria.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => id)),[sub_tree] => ,[delim] => ,),[24] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.title`,[base_expr] => AS `Criteria.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.title))),[base_expr] => Criteria.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => title)),[sub_tree] => ,[delim] => ,),[25] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.criteria`,[base_expr] => AS `Criteria.criteria`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.criteria))),[base_expr] => Criteria.criteria,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => criteria)),[sub_tree] => ,[delim] => ,),[26] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.tooltips`,[base_expr] => AS `Criteria.tooltips`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.tooltips))),[base_expr] => Criteria.tooltips,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => tooltips)),[sub_tree] => ,[delim] => ,),[27] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.weights`,[base_expr] => AS `Criteria.weights`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.weights))),[base_expr] => Criteria.weights,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => weights)),[sub_tree] => ,[delim] => ,),[28] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.required`,[base_expr] => AS `Criteria.required`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.required))),[base_expr] => Criteria.required,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => required)),[sub_tree] => ,[delim] => ,),[29] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.state`,[base_expr] => AS `Criteria.state`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.state))),[base_expr] => Criteria.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => state)),[sub_tree] => ,[delim] => ,),[30] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `ListingType.config`,[base_expr] => AS `ListingType.config`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ListingType.config))),[base_expr] => Criteria.config,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => config)),[sub_tree] => ,[delim] => ,),[31] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.featured`,[base_expr] => AS `Listing.featured`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.featured))),[base_expr] => Field.featured,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Field,[1] => featured)),[sub_tree] => ,[delim] => ,),[32] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `User.user_id`,[base_expr] => AS `User.user_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User.user_id))),[base_expr] => User.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => id)),[sub_tree] => ,[delim] => ,),[33] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `User.name`,[base_expr] => AS `User.name`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User.name))),[base_expr] => User.name,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => name)),[sub_tree] => ,[delim] => ,),[34] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `User.username`,[base_expr] => AS `User.username`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User.username))),[base_expr] => User.username,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => username)),[sub_tree] => ,[delim] => ,),[35] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Claim.approved`,[base_expr] => AS `Claim.approved`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Claim.approved))),[base_expr] => Claim.approved,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => approved)),[sub_tree] => ,[delim] => ,),[36] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_rating`,[base_expr] => AS `Review.user_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_rating))),[base_expr] => Totals.user_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_rating)),[sub_tree] => ,[delim] => ,),[37] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_rating_count`,[base_expr] => AS `Review.user_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_rating_count))),[base_expr] => Totals.user_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_rating_count)),[sub_tree] => ,[delim] => ,),[38] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_criteria_rating`,[base_expr] => AS `Review.user_criteria_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_criteria_rating))),[base_expr] => Totals.user_criteria_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_criteria_rating)),[sub_tree] => ,[delim] => ,),[39] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_criteria_rating_count`,[base_expr] => AS `Review.user_criteria_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_criteria_rating_count))),[base_expr] => Totals.user_criteria_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_criteria_rating_count)),[sub_tree] => ,[delim] => ,),[40] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.review_count`,[base_expr] => AS `Review.review_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.review_count))),[base_expr] => Totals.user_comment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_comment_count)),[sub_tree] => ,[delim] => ,),[41] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_rating`,[base_expr] => AS `Review.editor_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_rating))),[base_expr] => Totals.editor_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_rating)),[sub_tree] => ,[delim] => ,),[42] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_rating_count`,[base_expr] => AS `Review.editor_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_rating_count))),[base_expr] => Totals.editor_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_rating_count)),[sub_tree] => ,[delim] => ,),[43] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_criteria_rating`,[base_expr] => AS `Review.editor_criteria_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_criteria_rating))),[base_expr] => Totals.editor_criteria_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_criteria_rating)),[sub_tree] => ,[delim] => ,),[44] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_criteria_rating_count`,[base_expr] => AS `Review.editor_criteria_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_criteria_rating_count))),[base_expr] => Totals.editor_criteria_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_criteria_rating_count)),[sub_tree] => ,[delim] => ,),[45] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_review_count`,[base_expr] => AS `Review.editor_review_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_review_count))),[base_expr] => Totals.editor_comment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_comment_count)),[sub_tree] => ,[delim] => ,),[46] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.media_count`,[base_expr] => AS `Listing.media_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.media_count))),[base_expr] => Totals.media_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count)),[sub_tree] => ,[delim] => ,),[47] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.video_count`,[base_expr] => AS `Listing.video_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.video_count))),[base_expr] => Totals.video_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count)),[sub_tree] => ,[delim] => ,),[48] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.photo_count`,[base_expr] => AS `Listing.photo_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.photo_count))),[base_expr] => Totals.photo_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count)),[sub_tree] => ,[delim] => ,),[49] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.audio_count`,[base_expr] => AS `Listing.audio_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.audio_count))),[base_expr] => Totals.audio_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count)),[sub_tree] => ,[delim] => ,),[50] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.attachment_count`,[base_expr] => AS `Listing.attachment_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.attachment_count))),[base_expr] => Totals.attachment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count)),[sub_tree] => ,[delim] => ,),[51] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.media_count_owner`,[base_expr] => AS `Listing.media_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.media_count_owner))),[base_expr] => (Totals.media_count - Totals.media_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.media_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.media_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count_user)),[sub_tree] => )),[delim] => ,),[52] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.video_count_owner`,[base_expr] => AS `Listing.video_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.video_count_owner))),[base_expr] => (Totals.video_count - Totals.video_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.video_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.video_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count_user)),[sub_tree] => )),[delim] => ,),[53] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.photo_count_owner`,[base_expr] => AS `Listing.photo_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.photo_count_owner))),[base_expr] => (Totals.photo_count - Totals.photo_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.photo_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.photo_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count_user)),[sub_tree] => )),[delim] => ,),[54] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.audio_count_owner`,[base_expr] => AS `Listing.audio_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.audio_count_owner))),[base_expr] => (Totals.audio_count - Totals.audio_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.audio_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.audio_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count_user)),[sub_tree] => )),[delim] => ,),[55] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.attachment_count_owner`,[base_expr] => AS `Listing.attachment_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.attachment_count_owner))),[base_expr] => (Totals.attachment_count - Totals.attachment_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.attachment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.attachment_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count_user)),[sub_tree] => )),[delim] => ,),[56] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.media_count_user`,[base_expr] => AS `Listing.media_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.media_count_user))),[base_expr] => Totals.media_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count_user)),[sub_tree] => ,[delim] => ,),[57] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.video_count_user`,[base_expr] => AS `Listing.video_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.video_count_user))),[base_expr] => Totals.video_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count_user)),[sub_tree] => ,[delim] => ,),[58] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.photo_count_user`,[base_expr] => AS `Listing.photo_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.photo_count_user))),[base_expr] => Totals.photo_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count_user)),[sub_tree] => ,[delim] => ,),[59] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.audio_count_user`,[base_expr] => AS `Listing.audio_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.audio_count_user))),[base_expr] => Totals.audio_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count_user)),[sub_tree] => ,[delim] => ,),[60] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.attachment_count_user`,[base_expr] => AS `Listing.attachment_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.attachment_count_user))),[base_expr] => Totals.attachment_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count_user)),[sub_tree] => ,[delim] => ,),[61] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_1),[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ,[delim] => ,),[62] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_2),[base_expr] => Totals.listing_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => listing_id)),[sub_tree] => ,[delim] => ,),[63] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_3),[base_expr] => Field.contentid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Field,[1] => contentid)),[sub_tree] => ,[delim] => ,),[64] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_4),[base_expr] => JreviewsCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => id)),[sub_tree] => ,[delim] => ,),[65] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_5),[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => ,),[66] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_6),[base_expr] => Directory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => id)),[sub_tree] => ,[delim] => ,),[67] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_7),[base_expr] => Criteria.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => id)),[sub_tree] => ,[delim] => ,),[68] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_8),[base_expr] => User.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => id)),[sub_tree] => ,[delim] => ,),[69] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_9),[base_expr] => Claim.claim_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => claim_id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_content,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_content)),[alias] => Array ([as] => 1,[name] => Listing,[base_expr] => AS Listing,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_content AS Listing,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_jreviews_listing_totals,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_listing_totals)),[alias] => Array ([as] => 1,[name] => Totals,[base_expr] => AS Totals,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Totals))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.listing_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => listing_id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Totals.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => 'com_content',[sub_tree] => )),[base_expr] => qat72_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content',[sub_tree] => ),[2] => Array ([expr_type] => table,[table] => qat72_jreviews_content,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_content)),[alias] => Array ([as] => 1,[name] => Field,[base_expr] => AS Field,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Field))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Field.contentid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Field,[1] => contentid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => )),[base_expr] => qat72_jreviews_content AS Field ON Field.contentid = Listing.id,[sub_tree] => ),[3] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => Array ([as] => 1,[name] => JreviewsCategory,[base_expr] => AS JreviewsCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => JreviewsCategory))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.`option`,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => option)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => 'com_content',[sub_tree] => )),[base_expr] => qat72_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content',[sub_tree] => ),[4] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => 'com_content',[sub_tree] => )),[base_expr] => qat72_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content',[sub_tree] => ),[5] => Array ([expr_type] => table,[table] => qat72_jreviews_directories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_directories)),[alias] => Array ([as] => 1,[name] => Directory,[base_expr] => AS Directory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Directory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.dirid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => dirid)),[sub_tree] => )),[base_expr] => qat72_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid,[sub_tree] => ),[6] => Array ([expr_type] => table,[table] => qat72_jreviews_criteria,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_criteria)),[alias] => Array ([as] => 1,[name] => Criteria,[base_expr] => AS Criteria,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Criteria.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.criteriaid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => criteriaid)),[sub_tree] => )),[base_expr] => qat72_jreviews_criteria AS Criteria ON Criteria.id = JreviewsCategory.criteriaid,[sub_tree] => ),[7] => Array ([expr_type] => table,[table] => qat72_users,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_users)),[alias] => Array ([as] => 1,[name] => User,[base_expr] => AS User,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => User.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.created_by,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by)),[sub_tree] => )),[base_expr] => qat72_users AS User ON User.id = Listing.created_by,[sub_tree] => ),[8] => Array ([expr_type] => table,[table] => qat72_jreviews_claims,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_claims)),[alias] => Array ([as] => 1,[name] => Claim,[base_expr] => AS Claim,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Claim))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Claim.listing_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => listing_id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Claim.user_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => user_id)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => colref,[base_expr] => Listing.created_by,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by)),[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Claim.approved,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => approved)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => )),[base_expr] => qat72_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.catid IN (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content") AND Listing.catid IN ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ) AND Listing.access IN ( 1) ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[2] => Array ([expr_type] => subquery,[base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content"),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => id,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => ,[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_jreviews_categories,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => `option`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => option)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => )))),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[6] => Array ([expr_type] => subquery,[base_expr] => ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS Category,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => ParentCategory,[base_expr] => AS ParentCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ParentCategory))),[hints] => ,[join_type] => CROSS,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS ParentCategory,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.published,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => published)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Category.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => access)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[10] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => colref,[base_expr] => Category.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => lft)),[sub_tree] => ),[13] => Array ([expr_type] => operator,[base_expr] => BETWEEN,[sub_tree] => ),[14] => Array ([expr_type] => colref,[base_expr] => ParentCategory.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => lft)),[sub_tree] => ),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => ParentCategory.rgt,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => rgt)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[18] => Array ([expr_type] => colref,[base_expr] => ParentCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => id)),[sub_tree] => ),[19] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[20] => Array ([expr_type] => const,[base_expr] => 7,[sub_tree] => )))),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => <=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-31 23:00:00",[sub_tree] => ))),[13] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[14] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => >=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-30 23:00:00",[sub_tree] => ))),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[18] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => )))))),[ORDER] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.created,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created)),[sub_tree] => ,[direction] => DESC)),[LIMIT] => Array ([offset] => ,[rowcount] => 20))) called at [/home/s002190/public_html/libraries/jdiction/database/parser/mysql-creator.php:92] #6 PHPSQLParser\PHPSQLCreator->create(Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.listing_id`,[base_expr] => AS `Listing.listing_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.listing_id))),[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ,[delim] => ,),[1] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.slug`,[base_expr] => AS `Listing.slug`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.slug))),[base_expr] => Listing.alias,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => alias)),[sub_tree] => ,[delim] => ,),[2] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.slug`,[base_expr] => AS `Category.slug`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.slug))),[base_expr] => Category.alias,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => alias)),[sub_tree] => ,[delim] => ,),[3] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.title`,[base_expr] => AS `Listing.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.title))),[base_expr] => Listing.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => title)),[sub_tree] => ,[delim] => ,),[4] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.summary`,[base_expr] => AS `Listing.summary`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.summary))),[base_expr] => Listing.introtext,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => introtext)),[sub_tree] => ,[delim] => ,),[5] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.images`,[base_expr] => AS `Listing.images`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.images))),[base_expr] => Listing.images,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => images)),[sub_tree] => ,[delim] => ,),[6] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.hits`,[base_expr] => AS `Listing.hits`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.hits))),[base_expr] => Listing.hits,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => hits)),[sub_tree] => ,[delim] => ,),[7] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.cat_id`,[base_expr] => AS `Listing.cat_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.cat_id))),[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ,[delim] => ,),[8] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.user_id`,[base_expr] => AS `Listing.user_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.user_id))),[base_expr] => Listing.created_by,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by)),[sub_tree] => ,[delim] => ,),[9] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.author_alias`,[base_expr] => AS `Listing.author_alias`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.author_alias))),[base_expr] => Listing.created_by_alias,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by_alias)),[sub_tree] => ,[delim] => ,),[10] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.created`,[base_expr] => AS `Listing.created`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.created))),[base_expr] => Listing.created,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created)),[sub_tree] => ,[delim] => ,),[11] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.modified`,[base_expr] => AS `Listing.modified`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.modified))),[base_expr] => Listing.modified,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => modified)),[sub_tree] => ,[delim] => ,),[12] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.access`,[base_expr] => AS `Listing.access`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.access))),[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ,[delim] => ,),[13] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.state`,[base_expr] => AS `Listing.state`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.state))),[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ,[delim] => ,),[14] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.publish_up`,[base_expr] => AS `Listing.publish_up`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.publish_up))),[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ,[delim] => ,),[15] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.publish_down`,[base_expr] => AS `Listing.publish_down`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.publish_down))),[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ,[delim] => ,),[16] => Array ([expr_type] => const,[alias] => Array ([as] => 1,[name] => `Listing.extension`,[base_expr] => AS `Listing.extension`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.extension))),[base_expr] => 'com_content',[sub_tree] => ,[delim] => ,),[17] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.cat_id`,[base_expr] => AS `Category.cat_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.cat_id))),[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => ,),[18] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.title`,[base_expr] => AS `Category.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.title))),[base_expr] => Category.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => title)),[sub_tree] => ,[delim] => ,),[19] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Category.params`,[base_expr] => AS `Category.params`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category.params))),[base_expr] => Category.params,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => params)),[sub_tree] => ,[delim] => ,),[20] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Directory.dir_id`,[base_expr] => AS `Directory.dir_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory.dir_id))),[base_expr] => Directory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => id)),[sub_tree] => ,[delim] => ,),[21] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Directory.title`,[base_expr] => AS `Directory.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory.title))),[base_expr] => Directory.desc,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => desc)),[sub_tree] => ,[delim] => ,),[22] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Directory.slug`,[base_expr] => AS `Directory.slug`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory.slug))),[base_expr] => Directory.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => title)),[sub_tree] => ,[delim] => ,),[23] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.criteria_id`,[base_expr] => AS `Criteria.criteria_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.criteria_id))),[base_expr] => Criteria.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => id)),[sub_tree] => ,[delim] => ,),[24] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.title`,[base_expr] => AS `Criteria.title`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.title))),[base_expr] => Criteria.title,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => title)),[sub_tree] => ,[delim] => ,),[25] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.criteria`,[base_expr] => AS `Criteria.criteria`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.criteria))),[base_expr] => Criteria.criteria,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => criteria)),[sub_tree] => ,[delim] => ,),[26] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.tooltips`,[base_expr] => AS `Criteria.tooltips`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.tooltips))),[base_expr] => Criteria.tooltips,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => tooltips)),[sub_tree] => ,[delim] => ,),[27] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.weights`,[base_expr] => AS `Criteria.weights`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.weights))),[base_expr] => Criteria.weights,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => weights)),[sub_tree] => ,[delim] => ,),[28] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.required`,[base_expr] => AS `Criteria.required`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.required))),[base_expr] => Criteria.required,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => required)),[sub_tree] => ,[delim] => ,),[29] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Criteria.state`,[base_expr] => AS `Criteria.state`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria.state))),[base_expr] => Criteria.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => state)),[sub_tree] => ,[delim] => ,),[30] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `ListingType.config`,[base_expr] => AS `ListingType.config`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ListingType.config))),[base_expr] => Criteria.config,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => config)),[sub_tree] => ,[delim] => ,),[31] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.featured`,[base_expr] => AS `Listing.featured`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.featured))),[base_expr] => Field.featured,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Field,[1] => featured)),[sub_tree] => ,[delim] => ,),[32] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `User.user_id`,[base_expr] => AS `User.user_id`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User.user_id))),[base_expr] => User.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => id)),[sub_tree] => ,[delim] => ,),[33] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `User.name`,[base_expr] => AS `User.name`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User.name))),[base_expr] => User.name,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => name)),[sub_tree] => ,[delim] => ,),[34] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `User.username`,[base_expr] => AS `User.username`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User.username))),[base_expr] => User.username,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => username)),[sub_tree] => ,[delim] => ,),[35] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Claim.approved`,[base_expr] => AS `Claim.approved`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Claim.approved))),[base_expr] => Claim.approved,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => approved)),[sub_tree] => ,[delim] => ,),[36] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_rating`,[base_expr] => AS `Review.user_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_rating))),[base_expr] => Totals.user_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_rating)),[sub_tree] => ,[delim] => ,),[37] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_rating_count`,[base_expr] => AS `Review.user_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_rating_count))),[base_expr] => Totals.user_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_rating_count)),[sub_tree] => ,[delim] => ,),[38] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_criteria_rating`,[base_expr] => AS `Review.user_criteria_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_criteria_rating))),[base_expr] => Totals.user_criteria_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_criteria_rating)),[sub_tree] => ,[delim] => ,),[39] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.user_criteria_rating_count`,[base_expr] => AS `Review.user_criteria_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.user_criteria_rating_count))),[base_expr] => Totals.user_criteria_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_criteria_rating_count)),[sub_tree] => ,[delim] => ,),[40] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.review_count`,[base_expr] => AS `Review.review_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.review_count))),[base_expr] => Totals.user_comment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => user_comment_count)),[sub_tree] => ,[delim] => ,),[41] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_rating`,[base_expr] => AS `Review.editor_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_rating))),[base_expr] => Totals.editor_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_rating)),[sub_tree] => ,[delim] => ,),[42] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_rating_count`,[base_expr] => AS `Review.editor_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_rating_count))),[base_expr] => Totals.editor_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_rating_count)),[sub_tree] => ,[delim] => ,),[43] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_criteria_rating`,[base_expr] => AS `Review.editor_criteria_rating`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_criteria_rating))),[base_expr] => Totals.editor_criteria_rating,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_criteria_rating)),[sub_tree] => ,[delim] => ,),[44] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_criteria_rating_count`,[base_expr] => AS `Review.editor_criteria_rating_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_criteria_rating_count))),[base_expr] => Totals.editor_criteria_rating_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_criteria_rating_count)),[sub_tree] => ,[delim] => ,),[45] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Review.editor_review_count`,[base_expr] => AS `Review.editor_review_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Review.editor_review_count))),[base_expr] => Totals.editor_comment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => editor_comment_count)),[sub_tree] => ,[delim] => ,),[46] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.media_count`,[base_expr] => AS `Listing.media_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.media_count))),[base_expr] => Totals.media_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count)),[sub_tree] => ,[delim] => ,),[47] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.video_count`,[base_expr] => AS `Listing.video_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.video_count))),[base_expr] => Totals.video_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count)),[sub_tree] => ,[delim] => ,),[48] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.photo_count`,[base_expr] => AS `Listing.photo_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.photo_count))),[base_expr] => Totals.photo_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count)),[sub_tree] => ,[delim] => ,),[49] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.audio_count`,[base_expr] => AS `Listing.audio_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.audio_count))),[base_expr] => Totals.audio_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count)),[sub_tree] => ,[delim] => ,),[50] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.attachment_count`,[base_expr] => AS `Listing.attachment_count`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.attachment_count))),[base_expr] => Totals.attachment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count)),[sub_tree] => ,[delim] => ,),[51] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.media_count_owner`,[base_expr] => AS `Listing.media_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.media_count_owner))),[base_expr] => (Totals.media_count - Totals.media_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.media_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.media_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count_user)),[sub_tree] => )),[delim] => ,),[52] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.video_count_owner`,[base_expr] => AS `Listing.video_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.video_count_owner))),[base_expr] => (Totals.video_count - Totals.video_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.video_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.video_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count_user)),[sub_tree] => )),[delim] => ,),[53] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.photo_count_owner`,[base_expr] => AS `Listing.photo_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.photo_count_owner))),[base_expr] => (Totals.photo_count - Totals.photo_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.photo_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.photo_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count_user)),[sub_tree] => )),[delim] => ,),[54] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.audio_count_owner`,[base_expr] => AS `Listing.audio_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.audio_count_owner))),[base_expr] => (Totals.audio_count - Totals.audio_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.audio_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.audio_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count_user)),[sub_tree] => )),[delim] => ,),[55] => Array ([expr_type] => bracket_expression,[alias] => Array ([as] => 1,[name] => `Listing.attachment_count_owner`,[base_expr] => AS `Listing.attachment_count_owner`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.attachment_count_owner))),[base_expr] => (Totals.attachment_count - Totals.attachment_count_user),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.attachment_count,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => -,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Totals.attachment_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count_user)),[sub_tree] => )),[delim] => ,),[56] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.media_count_user`,[base_expr] => AS `Listing.media_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.media_count_user))),[base_expr] => Totals.media_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => media_count_user)),[sub_tree] => ,[delim] => ,),[57] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.video_count_user`,[base_expr] => AS `Listing.video_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.video_count_user))),[base_expr] => Totals.video_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => video_count_user)),[sub_tree] => ,[delim] => ,),[58] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.photo_count_user`,[base_expr] => AS `Listing.photo_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.photo_count_user))),[base_expr] => Totals.photo_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => photo_count_user)),[sub_tree] => ,[delim] => ,),[59] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.audio_count_user`,[base_expr] => AS `Listing.audio_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.audio_count_user))),[base_expr] => Totals.audio_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => audio_count_user)),[sub_tree] => ,[delim] => ,),[60] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => `Listing.attachment_count_user`,[base_expr] => AS `Listing.attachment_count_user`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing.attachment_count_user))),[base_expr] => Totals.attachment_count_user,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => attachment_count_user)),[sub_tree] => ,[delim] => ,),[61] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_1),[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ,[delim] => ,),[62] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_2),[base_expr] => Totals.listing_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => listing_id)),[sub_tree] => ,[delim] => ,),[63] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_3),[base_expr] => Field.contentid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Field,[1] => contentid)),[sub_tree] => ,[delim] => ,),[64] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_4),[base_expr] => JreviewsCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => id)),[sub_tree] => ,[delim] => ,),[65] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_5),[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => ,),[66] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_6),[base_expr] => Directory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => id)),[sub_tree] => ,[delim] => ,),[67] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_7),[base_expr] => Criteria.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => id)),[sub_tree] => ,[delim] => ,),[68] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_8),[base_expr] => User.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => id)),[sub_tree] => ,[delim] => ,),[69] => Array ([expr_type] => colref,[alias] => Array ([as] => 1,[name] => JD_MAGIC_KEY_9),[base_expr] => Claim.claim_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => claim_id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_content,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_content)),[alias] => Array ([as] => 1,[name] => Listing,[base_expr] => AS Listing,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Listing))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_content AS Listing,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_jreviews_listing_totals,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_listing_totals)),[alias] => Array ([as] => 1,[name] => Totals,[base_expr] => AS Totals,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Totals))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Totals.listing_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => listing_id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Totals.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Totals,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => 'com_content',[sub_tree] => )),[base_expr] => qat72_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content',[sub_tree] => ),[2] => Array ([expr_type] => table,[table] => qat72_jreviews_content,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_content)),[alias] => Array ([as] => 1,[name] => Field,[base_expr] => AS Field,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Field))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Field.contentid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Field,[1] => contentid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => )),[base_expr] => qat72_jreviews_content AS Field ON Field.contentid = Listing.id,[sub_tree] => ),[3] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => Array ([as] => 1,[name] => JreviewsCategory,[base_expr] => AS JreviewsCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => JreviewsCategory))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.`option`,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => option)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => 'com_content',[sub_tree] => )),[base_expr] => qat72_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content',[sub_tree] => ),[4] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => 'com_content',[sub_tree] => )),[base_expr] => qat72_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content',[sub_tree] => ),[5] => Array ([expr_type] => table,[table] => qat72_jreviews_directories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_directories)),[alias] => Array ([as] => 1,[name] => Directory,[base_expr] => AS Directory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Directory))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Directory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Directory,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.dirid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => dirid)),[sub_tree] => )),[base_expr] => qat72_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid,[sub_tree] => ),[6] => Array ([expr_type] => table,[table] => qat72_jreviews_criteria,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_criteria)),[alias] => Array ([as] => 1,[name] => Criteria,[base_expr] => AS Criteria,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Criteria))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Criteria.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Criteria,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => JreviewsCategory.criteriaid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => JreviewsCategory,[1] => criteriaid)),[sub_tree] => )),[base_expr] => qat72_jreviews_criteria AS Criteria ON Criteria.id = JreviewsCategory.criteriaid,[sub_tree] => ),[7] => Array ([expr_type] => table,[table] => qat72_users,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_users)),[alias] => Array ([as] => 1,[name] => User,[base_expr] => AS User,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => User))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => User.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => User,[1] => id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.created_by,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by)),[sub_tree] => )),[base_expr] => qat72_users AS User ON User.id = Listing.created_by,[sub_tree] => ),[8] => Array ([expr_type] => table,[table] => qat72_jreviews_claims,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_claims)),[alias] => Array ([as] => 1,[name] => Claim,[base_expr] => AS Claim,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Claim))),[hints] => ,[join_type] => LEFT,[ref_type] => ON,[ref_clause] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Claim.listing_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => listing_id)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => colref,[base_expr] => Listing.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => id)),[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Claim.user_id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => user_id)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => colref,[base_expr] => Listing.created_by,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created_by)),[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Claim.approved,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Claim,[1] => approved)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => )),[base_expr] => qat72_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.catid IN (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content") AND Listing.catid IN ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ) AND Listing.access IN ( 1) ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[2] => Array ([expr_type] => subquery,[base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content"),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => id,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_jreviews_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_jreviews_categories)),[alias] => ,[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_jreviews_categories,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => `option`,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => option)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => )))),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.catid,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => catid)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[6] => Array ([expr_type] => subquery,[base_expr] => ( SELECT Category.id FROM qat72_categories AS Category, qat72_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[sub_tree] => Array ([SELECT] => Array ([0] => Array ([expr_type] => colref,[alias] => ,[base_expr] => Category.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => id)),[sub_tree] => ,[delim] => )),[FROM] => Array ([0] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => Category,[base_expr] => AS Category,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => Category))),[hints] => ,[join_type] => JOIN,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS Category,[sub_tree] => ),[1] => Array ([expr_type] => table,[table] => qat72_categories,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => qat72_categories)),[alias] => Array ([as] => 1,[name] => ParentCategory,[base_expr] => AS ParentCategory,[no_quotes] => Array ([delim] => ,[parts] => Array ([0] => ParentCategory))),[hints] => ,[join_type] => CROSS,[ref_type] => ,[ref_clause] => ,[base_expr] => qat72_categories AS ParentCategory,[sub_tree] => )),[WHERE] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Category.published,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => published)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Category.extension,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => extension)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "com_content",[sub_tree] => ),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Category.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => access)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[10] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ))),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => colref,[base_expr] => Category.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Category,[1] => lft)),[sub_tree] => ),[13] => Array ([expr_type] => operator,[base_expr] => BETWEEN,[sub_tree] => ),[14] => Array ([expr_type] => colref,[base_expr] => ParentCategory.lft,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => lft)),[sub_tree] => ),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => ParentCategory.rgt,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => rgt)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[18] => Array ([expr_type] => colref,[base_expr] => ParentCategory.id,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => ParentCategory,[1] => id)),[sub_tree] => ),[19] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[20] => Array ([expr_type] => const,[base_expr] => 7,[sub_tree] => )))),[7] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[8] => Array ([expr_type] => colref,[base_expr] => Listing.state,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => state)),[sub_tree] => ),[9] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[10] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => ),[11] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[12] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_up,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_up)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => <=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-31 23:00:00",[sub_tree] => ))),[13] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[14] => Array ([expr_type] => bracket_expression,[base_expr] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[sub_tree] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[1] => Array ([expr_type] => operator,[base_expr] => =,[sub_tree] => ),[2] => Array ([expr_type] => const,[base_expr] => "0000-00-00 00:00:00",[sub_tree] => ),[3] => Array ([expr_type] => operator,[base_expr] => OR,[sub_tree] => ),[4] => Array ([expr_type] => colref,[base_expr] => Listing.publish_down,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => publish_down)),[sub_tree] => ),[5] => Array ([expr_type] => operator,[base_expr] => >=,[sub_tree] => ),[6] => Array ([expr_type] => const,[base_expr] => "2014-07-30 23:00:00",[sub_tree] => ))),[15] => Array ([expr_type] => operator,[base_expr] => AND,[sub_tree] => ),[16] => Array ([expr_type] => colref,[base_expr] => Listing.access,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => access)),[sub_tree] => ),[17] => Array ([expr_type] => operator,[base_expr] => IN,[sub_tree] => ),[18] => Array ([expr_type] => in-list,[base_expr] => ( 1),[sub_tree] => Array ([0] => Array ([expr_type] => const,[base_expr] => 1,[sub_tree] => )))))),[ORDER] => Array ([0] => Array ([expr_type] => colref,[base_expr] => Listing.created,[no_quotes] => Array ([delim] => .,[parts] => Array ([0] => Listing,[1] => created)),[sub_tree] => ,[direction] => DESC)),[LIMIT] => Array ([offset] => ,[rowcount] => 20))) called at [/home/s002190/public_html/libraries/jdiction/database/jddatabase.php:605] #7 JdDatabase->addJoinKeys(SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, 'com_content' AS `Listing.extension`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Field.featured AS `Listing.featured`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM #__content AS Listing LEFT JOIN #__jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN #__jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN #__jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN #__categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN #__jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN #__jreviews_criteria AS Criteria ON Criteria.id = JreviewsCategory.criteriaid LEFT JOIN #__users AS User ON User.id = Listing.created_by LEFT JOIN #__jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( Listing.catid IN (SELECT id FROM #__jreviews_categories WHERE `option` = "com_content") AND Listing.catid IN ( SELECT Category.id FROM #__categories AS Category, #__categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ) AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ) AND Listing.access IN ( 1) ) ORDER BY Listing.created DESC LIMIT 20) called at [/home/s002190/public_html/libraries/jdiction/database/jddatabase.php:448] #8 JdDatabase->execute() called at [/home/s002190/public_html/libraries/joomla/database/database.php:1233] #9 JDatabase->loadRowList() called at [/home/s002190/public_html/libraries/jdiction/database/jddatabase.php:367] #10 JdDatabase->loadTranslation(, ASSOC) called at [/home/s002190/public_html/libraries/jdiction/database/jddatabase.php:256] #11 JdDatabase->loadObjectList() called at [/home/s002190/public_html/components/com_s2framework/s2framework/libs/model/model.php:405] #12 S2Model->find(all, Array ([fields] => Array (),[joins] => Array (),[conditions] => Array ([0] => Listing.catid IN (SELECT id FROM #__jreviews_categories WHERE `option` = "com_content"),[1] => Listing.catid IN ( SELECT Category.id FROM #__categories AS Category, #__categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[2] => Listing.state = 1,[3] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[4] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[5] => Listing.access IN ( 1)),[limit] => 20,[having] => Array ()), Array ([0] => plgAfterFind,[1] => afterFind,[2] => plgAfterAfterFind)) called at [/home/s002190/public_html/components/com_s2framework/s2framework/libs/model/model.php:104] #13 S2Model->findAll(Array ([fields] => Array (),[joins] => Array (),[conditions] => Array ([0] => Listing.catid IN (SELECT id FROM #__jreviews_categories WHERE `option` = "com_content"),[1] => Listing.catid IN ( SELECT Category.id FROM #__categories AS Category, #__categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 7 ),[2] => Listing.state = 1,[3] => ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2014-07-31 23:00:00" ),[4] => ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2014-07-30 23:00:00" ),[5] => Listing.access IN ( 1)),[limit] => 20,[having] => Array ())) called at [/home/s002190/public_html/components/com_jreviews/jreviews/controllers/modules/module_listings_controller.php:353] #14 ModuleListingsController->index(Array ([data] => Array ([module] => 1,[controller] => module_listings,[action] => index,[__raw] => Array ([module] => 1,[controller] => module_listings,[action] => index)),[form] => Array (),[url] => Array ([language] => en-GB,[lang] => en,[option] => com_content,[view] => category,[layout] => blog,[id] => 11,[Itemid] => 101),[language] => en-GB,[lang] => en,[option] => com_content,[view] => category,[layout] => blog,[id] => 11,[Itemid] => 101,[module] => Array ([listing_order] => rdate,[radius] => ,[distance] => 0,[summary] => 0,[summary_words] => 10,[show_category] => 0,[fields] => ,[editor_rating] => 0,[user_rating] => 0,[tmpl_suffix] => ,[tn_show] => 1,[tn_position] => top,[tn_mode] => crop,[tn_size] => 190x100,[extension] => com_content,[cat_auto] => 0,[dir] => ,[category] => 7,[listing] => ,[custom_where] => ,[custom_order] => ,[nav_position] => bottom,[orientation] => vertical,[slideshow] => 0,[slideshow_interval] => 6,[module_total] => 20,[module_limit] => 4,[columns] => 1,[show_numbers] => 0,[filter_listing_period] => ,[filter_review_period] => ,[filter_review_count] => ,[filter_avg_rating] => ,[compare] => 0,[moduleclass_sfx] => ,[owncache] => 1,[cache_time] => 900,[module_id] => 102,[controller] => module_listings),[module_id] => 102,[page] => 1,[secret] => B8biKMOp2eRBfNQ4,[token] => a0d50e167c0f37bac4b149f6b78c5d86,[default_limit] => 20)) called at [/home/s002190/public_html/components/com_s2framework/s2framework/dispatcher.php:310] #15 S2Dispatcher->dispatch(Array ([module] => Array ([listing_order] => rdate,[radius] => ,[distance] => 0,[summary] => 0,[summary_words] => 10,[show_category] => 0,[fields] => ,[editor_rating] => 0,[user_rating] => 0,[tmpl_suffix] => ,[tn_show] => 1,[tn_position] => top,[tn_mode] => crop,[tn_size] => 190x100,[extension] => com_content,[cat_auto] => 0,[dir] => ,[category] => 7,[listing] => ,[custom_where] => ,[custom_order] => ,[nav_position] => bottom,[orientation] => vertical,[slideshow] => 0,[slideshow_interval] => 6,[module_total] => 20,[module_limit] => 4,[columns] => 1,[show_numbers] => 0,[filter_listing_period] => ,[filter_review_period] => ,[filter_review_count] => ,[filter_avg_rating] => ,[compare] => 0,[moduleclass_sfx] => ,[owncache] => 1,[cache_time] => 900,[module_id] => 102,[controller] => module_listings),[module_id] => 102,[page] => 1,[data] => Array ([module] => 1,[controller] => module_listings,[action] => index),[secret] => B8biKMOp2eRBfNQ4,[token] => a0d50e167c0f37bac4b149f6b78c5d86)) called at [/home/s002190/public_html/components/com_jreviews/jreviews/includes/modules/helper.php:48] #16 JreviewsModuleHelper::renderModule(JRegistry Object ([] => stdClass Object ([listing_order] => rdate,[radius] => ,[distance] => 0,[summary] => 0,[summary_words] => 10,[show_category] => 0,[fields] => ,[editor_rating] => 0,[user_rating] => 0,[tmpl_suffix] => ,[tn_show] => 1,[tn_position] => top,[tn_mode] => crop,[tn_size] => 190x100,[extension] => com_content,[cat_auto] => 0,[dir] => ,[category] => 7,[listing] => ,[custom_where] => ,[custom_order] => ,[nav_position] => bottom,[orientation] => vertical,[slideshow] => 0,[slideshow_interval] => 6,[module_total] => 20,[module_limit] => 4,[columns] => 1,[show_numbers] => 0,[filter_listing_period] => ,[filter_review_period] => ,[filter_review_count] => ,[filter_avg_rating] => ,[compare] => 0,[moduleclass_sfx] => ,[owncache] => 1,[cache_time] => 900,[module_id] => 102,[controller] => module_listings))) #17 call_user_func_array(Array ([0] => JreviewsModuleHelper,[1] => renderModule), Array ([0] => JRegistry Object ([] => stdClass Object ([listing_order] => rdate,[radius] => ,[distance] => 0,[summary] => 0,[summary_words] => 10,[show_category] => 0,[fields] => ,[editor_rating] => 0,[user_rating] => 0,[tmpl_suffix] => ,[tn_show] => 1,[tn_position] => top,[tn_mode] => crop,[tn_size] => 190x100,[extension] => com_content,[cat_auto] => 0,[dir] => ,[category] => 7,[listing] => ,[custom_where] => ,[custom_order] => ,[nav_position] => bottom,[orientation] => vertical,[slideshow] => 0,[slideshow_interval] => 6,[module_total] => 20,[module_limit] => 4,[columns] => 1,[show_numbers] => 0,[filter_listing_period] => ,[filter_review_period] => ,[filter_review_count] => ,[filter_avg_rating] => ,[compare] => 0,[moduleclass_sfx] => ,[owncache] => 1,[cache_time] => 900,[module_id] => 102,[controller] => module_listings)))) called at [/home/s002190/public_html/libraries/joomla/cache/controller/callback.php:159] #18 JCacheControllerCallback->get(Array ([0] => JreviewsModuleHelper,[1] => renderModule), JRegistry Object ([] => stdClass Object ([listing_order] => rdate,[radius] => ,[distance] => 0,[summary] => 0,[summary_words] => 10,[show_category] => 0,[fields] => ,[editor_rating] => 0,[user_rating] => 0,[tmpl_suffix] => ,[tn_show] => 1,[tn_position] => top,[tn_mode] => crop,[tn_size] => 190x100,[extension] => com_content,[cat_auto] => 0,[dir] => ,[category] => 7,[listing] => ,[custom_where] => ,[custom_order] => ,[nav_position] => bottom,[orientation] => vertical,[slideshow] => 0,[slideshow_interval] => 6,[module_total] => 20,[module_limit] => 4,[columns] => 1,[show_numbers] => 0,[filter_listing_period] => ,[filter_review_period] => ,[filter_review_count] => ,[filter_avg_rating] => ,[compare] => 0,[moduleclass_sfx] => ,[owncache] => 1,[cache_time] => 900,[module_id] => 102,[controller] => module_listings)), 3c8380e2349355cffeab936fdc9e9139, 1, Array ([nopathway] => 1,[nohead] => 0,[nomodules] => 1,[modulemode] => 1,[mergehead] => 1)) called at [/home/s002190/public_html/libraries/joomla/application/module/helper.php:460] #19 JModuleHelper::moduleCache(stdClass Object ([id] => 102,[title] => Latest Music,[module] => mod_jreviews_listings,[position] => sidecolumn,[content] => ,[showtitle] => 1,[params] => {"listing_order":"rdate","radius":"","distance":"0","summary":"0","summary_words":"10","show_category":"0","fields":"","editor_rating":"0","user_rating":"0","tmpl_suffix":"","tn_show":"1","tn_position":"top","tn_mode":"crop","tn_size":"190x100","extension":"com_content","cat_auto":"0","dir":"","category":"7","listing":"","custom_where":"","custom_order":"","nav_position":"bottom","orientation":"vertical","slideshow":"0","slideshow_interval":"6","module_total":"20","module_limit":"4","columns":"1","show_numbers":"0","filter_listing_period":"","filter_review_period":"","filter_review_count":"","filter_avg_rating":"","compare":"0","moduleclass_sfx":"","owncache":"1","cache_time":"900"},[menuid] => 101,[user] => 0,[name] => jreviews_listings,[style] => ), JRegistry Object ([] => stdClass Object ([listing_order] => rdate,[radius] => ,[distance] => 0,[summary] => 0,[summary_words] => 10,[show_category] => 0,[fields] => ,[editor_rating] => 0,[user_rating] => 0,[tmpl_suffix] => ,[tn_show] => 1,[tn_position] => top,[tn_mode] => crop,[tn_size] => 190x100,[extension] => com_content,[cat_auto] => 0,[dir] => ,[category] => 7,[listing] => ,[custom_where] => ,[custom_order] => ,[nav_position] => bottom,[orientation] => vertical,[slideshow] => 0,[slideshow_interval] => 6,[module_total] => 20,[module_limit] => 4,[columns] => 1,[show_numbers] => 0,[filter_listing_period] => ,[filter_review_period] => ,[filter_review_count] => ,[filter_avg_rating] => ,[compare] => 0,[moduleclass_sfx] => ,[owncache] => 1,[cache_time] => 900,[module_id] => 102,[controller] => module_listings)), stdClass Object ([cachemode] => id,[class] => JreviewsModuleHelper,[method] => renderModule,[methodparams] => JRegistry Object ([] => stdClass Object ([listing_order] => rdate,[radius] => ,[distance] => 0,[summary] => 0,[summary_words] => 10,[show_category] => 0,[fields] => ,[editor_rating] => 0,[user_rating] => 0,[tmpl_suffix] => ,[tn_show] => 1,[tn_position] => top,[tn_mode] => crop,[tn_size] => 190x100,[extension] => com_content,[cat_auto] => 0,[dir] => ,[category] => 7,[listing] => ,[custom_where] => ,[custom_order] => ,[nav_position] => bottom,[orientation] => vertical,[slideshow] => 0,[slideshow_interval] => 6,[module_total] => 20,[module_limit] => 4,[columns] => 1,[show_numbers] => 0,[filter_listing_period] => ,[filter_review_period] => ,[filter_review_count] => ,[filter_avg_rating] => ,[compare] => 0,[moduleclass_sfx] => ,[owncache] => 1,[cache_time] => 900,[module_id] => 102,[controller] => module_listings)),[modeparams] => 3c8380e2349355cffeab936fdc9e9139,[cachegroup] => mod_jreviews_listings)) called at [/home/s002190/public_html/modules/mod_jreviews_listings/mod_jreviews_listings.php:41] #20 include(/home/s002190/public_html/modules/mod_jreviews_listings/mod_jreviews_listings.php) called at [/home/s002190/public_html/libraries/joomla/application/module/helper.php:173] #21 JModuleHelper::renderModule(stdClass Object ([id] => 102,[title] => Latest Music,[module] => mod_jreviews_listings,[position] => sidecolumn,[content] => ,[showtitle] => 1,[params] => {"listing_order":"rdate","radius":"","distance":"0","summary":"0","summary_words":"10","show_category":"0","fields":"","editor_rating":"0","user_rating":"0","tmpl_suffix":"","tn_show":"1","tn_position":"top","tn_mode":"crop","tn_size":"190x100","extension":"com_content","cat_auto":"0","dir":"","category":"7","listing":"","custom_where":"","custom_order":"","nav_position":"bottom","orientation":"vertical","slideshow":"0","slideshow_interval":"6","module_total":"20","module_limit":"4","columns":"1","show_numbers":"0","filter_listing_period":"","filter_review_period":"","filter_review_count":"","filter_avg_rating":"","compare":"0","moduleclass_sfx":"","owncache":"1","cache_time":"900"},[menuid] => 101,[user] => 0,[name] => jreviews_listings,[style] => ), Array ([name] => sidecolumn,[style] => j51_module)) called at [/home/s002190/public_html/libraries/joomla/document/html/renderer/module.php:107] #22 JDocumentRendererModule->render(stdClass Object ([id] => 102,[title] => Latest Music,[module] => mod_jreviews_listings,[position] => sidecolumn,[content] => ,[showtitle] => 1,[params] => {"listing_order":"rdate","radius":"","distance":"0","summary":"0","summary_words":"10","show_category":"0","fields":"","editor_rating":"0","user_rating":"0","tmpl_suffix":"","tn_show":"1","tn_position":"top","tn_mode":"crop","tn_size":"190x100","extension":"com_content","cat_auto":"0","dir":"","category":"7","listing":"","custom_where":"","custom_order":"","nav_position":"bottom","orientation":"vertical","slideshow":"0","slideshow_interval":"6","module_total":"20","module_limit":"4","columns":"1","show_numbers":"0","filter_listing_period":"","filter_review_period":"","filter_review_count":"","filter_avg_rating":"","compare":"0","moduleclass_sfx":"","owncache":"1","cache_time":"900"},[menuid] => 101,[user] => 0,[name] => jreviews_listings,[style] => ), Array ([name] => sidecolumn,[style] => j51_module), ) called at [/home/s002190/public_html/libraries/joomla/document/html/renderer/modules.php:39] #23 JDocumentRendererModules->render(sidecolumn, Array ([name] => sidecolumn,[style] => j51_module), ) called at [/home/s002190/public_html/libraries/joomla/document/html/html.php:371] #24 JDocumentHTML->getBuffer(modules, sidecolumn, Array ([name] => sidecolumn,[style] => j51_module)) called at [/home/s002190/public_html/libraries/joomla/document/html/html.php:652] #25 JDocumentHTML->_renderTemplate() called at [/home/s002190/public_html/libraries/joomla/document/html/html.php:433] #26 JDocumentHTML->render(, Array ([template] => j51_oxygen,[file] => index.php,[directory] => /home/s002190/public_html/templates,[params] => JRegistry Object ([] => stdClass Object ([colorStyle] => style1,[logoType] => image,[logoText] => Mais Kizomba,[sloganText] => Site oficial do Kizomba, Tarraxinha, Zouk e Semba,[sidecol_width] => 200,[col_pos] => col_r,[bg_state] => bg_scroll)))) called at [/home/s002190/public_html/includes/application.php:268] #27 JSite->render() called at [/home/s002190/public_html/index.php:48] Array ( [expr_type] => subquery [base_expr] => (SELECT id FROM qat72_jreviews_categories WHERE `option` = "com_content") [sub_tree] => Array ( [SELECT] => Array ( [0] => Array ( [expr_type] => colref [alias] => [base_expr] => id [no_quotes] => Array ( [delim] => [parts] => Array ( [0] => id ) ) [sub_tree] => [delim] => ) ) [FROM] => Array ( [0] => Array ( [expr_type] => table [table] => qat72_jreviews_categories [no_quotes] => Array ( [delim] => [parts] => Array ( [0] => qat72_jreviews_categories ) ) [alias] => [hints] => [join_type] => JOIN [ref_type] => [ref_clause] => [base_expr] => qat72_jreviews_categories [sub_tree] => ) ) [WHERE] => Array ( [0] => Array ( [expr_type] => colref [base_expr] => `option` [no_quotes] => Array ( [delim] => [parts] => Array ( [0] => option ) ) [sub_tree] => ) [1] => Array ( [expr_type] => operator [base_expr] => = [sub_tree] => ) [2] => Array ( [expr_type] => const [base_expr] => "com_content" [sub_tree] => ) ) ) )