JDatabaseQueryMysqli Object ( [offset:protected] => 0 [limit:protected] => 0 [db:protected] => JFalangDatabase Object ( [_mlTableList] => Array ( [0] => categories [1] => contact_details [2] => content [3] => menu [4] => modules [5] => virtuemart_categories_en_gb [6] => virtuemart_products [7] => virtuemart_products_en_gb [8] => virtuemart_product_coord ) [_refTables] => Array ( [fieldTablePairs] => Array ( ) [tableAliases] => Array ( ) [reverseTableAliases] => Array ( ) [fieldAliases] => Array ( ) [fieldTableAliasData] => Array ( ) [fieldCount] => 1 ) [_skipSetRefTables] => [orig_limit] => 0 [orig_offset] => 0 [_table_prefix] => k3n91_ [profileData] => Array ( ) [name] => mysqli [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => compac_dk_01 [connection:protected] => mysqli Object ( [affected_rows] => 2 [client_info] => 5.5.37 [client_version] => 50537 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.33 [server_version] => 50533 [stat] => Uptime: 15199768 Threads: 4 Questions: 1258890668 Slow queries: 1820 Opens: 12436114 Flush tables: 1 Open tables: 512 Queries per second avg: 82.823 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 10194852 [warning_count] => 0 ) [count:protected] => 10 [cursor:protected] => [debug:protected] => [limit:protected] => 0 [log:protected] => Array ( ) [timings:protected] => Array ( ) [callStacks:protected] => Array ( ) [offset:protected] => 0 [options:protected] => Array ( [driver] => mysqli [host] => localhost [user] => i56243 [password] => Ty56SNcNRe [database] => compac_dk_01 [prefix] => k3n91_ [select] => 1 [port] => 3306 [socket] => ) [sql:protected] => JDatabaseQueryMysqli Object *RECURSION* [tablePrefix:protected] => k3n91_ [utf:protected] => 1 [errorNum:protected] => 0 [errorMsg:protected] => [transactionDepth:protected] => 0 [disconnectHandlers:protected] => Array ( ) ) [sql:protected] => [type:protected] => select [element:protected] => [select:protected] => JDatabaseQueryElement Object ( [name:protected] => SELECT [elements:protected] => Array ( [0] => a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference [1] => c.title AS category_title, c.alias AS category_alias, c.access AS category_access [2] => u.name AS author [3] => parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias [4] => ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count ) [glue:protected] => , ) [delete:protected] => [update:protected] => [insert:protected] => [from:protected] => JDatabaseQueryElement Object ( [name:protected] => FROM [elements:protected] => Array ( [0] => #__content AS a ) [glue:protected] => , ) [join:protected] => Array ( [0] => JDatabaseQueryElement Object ( [name:protected] => LEFT JOIN [elements:protected] => Array ( [0] => #__categories AS c on c.id = a.catid ) [glue:protected] => , ) [1] => JDatabaseQueryElement Object ( [name:protected] => LEFT JOIN [elements:protected] => Array ( [0] => #__users AS u on u.id = a.created_by ) [glue:protected] => , ) [2] => JDatabaseQueryElement Object ( [name:protected] => LEFT JOIN [elements:protected] => Array ( [0] => #__categories as parent ON parent.id = c.parent_id ) [glue:protected] => , ) [3] => JDatabaseQueryElement Object ( [name:protected] => LEFT JOIN [elements:protected] => Array ( [0] => #__content_rating AS v ON a.id = v.content_id ) [glue:protected] => , ) [4] => JDatabaseQueryElement Object ( [name:protected] => LEFT OUTER JOIN [elements:protected] => Array ( [0] => (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id ) [glue:protected] => , ) ) [set:protected] => [where:protected] => JDatabaseQueryElement Object ( [name:protected] => WHERE [elements:protected] => Array ( [0] => a.language in ('en-GB','*') [1] => a.id = 0 [2] => (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-08-24 10:07:55') [3] => (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-08-24 10:07:55') [4] => (a.state = 1 OR a.state =2) ) [glue:protected] => AND ) [group:protected] => [having:protected] => [columns:protected] => [values:protected] => [order:protected] => [autoIncrementField:protected] => [call:protected] => [exec:protected] => [union:protected] => [unionAll:protected] => )