Online
Language School

Array
(
    [filter.access] => 1
    [where_before] => 
)
Array
(
    [filter.access] => 1
    [where_after] => JDatabaseQueryElement Object
        (
            [name:protected] => WHERE
            [elements:protected] => Array
                (
                    [0] => a.access IN (1)
                    [1] => c.access IN (1)
                )

            [glue:protected] =>  AND 
        )

    [user] => JUser Object
        (
            [isRoot:protected] => 
            [id] => 0
            [name] => 
            [username] => 
            [email] => 
            [password] => 
            [password_clear] => 
            [usertype] => 
            [block] => 
            [sendEmail] => 0
            [registerDate] => 
            [lastvisitDate] => 
            [activation] => 
            [params] => 
            [groups] => Array
                (
                )

            [guest] => 1
            [lastResetTime] => 
            [resetCount] => 
            [_params:protected] => JRegistry Object
                (
                    [data:protected] => stdClass Object
                        (
                        )

                )

            [_authGroups:protected] => Array
                (
                    [0] => 1
                    [1] => 9
                )

            [_authLevels:protected] => Array
                (
                    [0] => 1
                    [1] => 1
                    [2] => 4
                )

            [_authActions:protected] => 
            [_errorMsg:protected] => 
            [_errors:protected] => Array
                (
                )

            [aid] => 0
        )

    [groups] => 1
    [group_levels] => Array
        (
            [1] => Array
                (
                    [1] => 1
                )

            [42] => Array
                (
                    [2] => 2
                )

            [6] => Array
                (
                    [2] => 2
                    [3] => 3
                )

            [2] => Array
                (
                    [2] => 2
                )

            [10] => Array
                (
                    [2] => 2
                    [7] => 7
                )

            [8] => Array
                (
                    [2] => 2
                    [3] => 3
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [3] => Array
                (
                    [3] => 3
                )

            [9] => Array
                (
                    [4] => 4
                )

            [19] => Array
                (
                    [5] => 5
                )

            [20] => Array
                (
                    [6] => 6
                )

            [11] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [12] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [15] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [18] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [17] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [13] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [14] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [16] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [22] => Array
                (
                    [9] => 9
                )

            [44] => Array
                (
                    [10] => 10
                )

            [23] => Array
                (
                    [10] => 10
                )

            [45] => Array
                (
                    [11] => 11
                )

            [24] => Array
                (
                    [11] => 11
                )

            [46] => Array
                (
                    [12] => 12
                )

            [25] => Array
                (
                    [12] => 12
                )

            [47] => Array
                (
                    [13] => 13
                )

            [26] => Array
                (
                    [13] => 13
                )

            [43] => Array
                (
                    [15] => 15
                )

            [27] => Array
                (
                    [15] => 15
                )

            [48] => Array
                (
                    [18] => 18
                )

            [49] => Array
                (
                    [19] => 19
                )

            [50] => Array
                (
                    [20] => 20
                )

            [51] => Array
                (
                    [21] => 21
                )

            [52] => Array
                (
                    [22] => 22
                )

        )

    [levels] => Array
        (
            [1] => 1
        )

)
Array
(
    [get_list_query] => JDatabaseQueryMySQL Object
        (
            [db:protected] => JDatabaseMySQL Object
                (
                    [name] => mysql
                    [nameQuote:protected] => `
                    [nullDate:protected] => 0000-00-00 00:00:00
                    [dbMinimum:protected] => 5.0.4
                    [_database:JDatabase:private] => u1369153_shkolaru
                    [connection:protected] => Resource id #30
                    [count:protected] => 0
                    [cursor:protected] => Resource id #191
                    [debug:protected] => 
                    [limit:protected] => 0
                    [log:protected] => Array
                        (
                        )

                    [offset:protected] => 0
                    [sql:protected] => select * from `#__viewlevels`
                    [tablePrefix:protected] => ygfnt_
                    [utf:protected] => 1
                    [errorNum:protected] => 0
                    [errorMsg:protected] => 
                    [hasQuoted:protected] => 
                    [quoted:protected] => Array
                        (
                        )

                )

            [type:protected] => select
            [element:protected] => 
            [select:protected] => JDatabaseQueryElement Object
                (
                    [name:protected] => SELECT
                    [elements:protected] => Array
                        (
                            [0] => a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore
                            [1] => CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state
                            [2] => c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias
                            [3] => CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
                            [4] => ua.email AS author_email
                            [5] => (
SELECT MAX(contact.id) AS id
FROM #__contact_details AS contact
WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('en-GB','*') OR contact.language IS NULL)) as contactid
                            [6] => parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
                            [7] => ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
                            [8] => c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
                        )

                    [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 ua ON ua.id = a.created_by
                                )

                            [glue:protected] => ,
                        )

                    [2] => JDatabaseQueryElement Object
                        (
                            [name:protected] => LEFT JOIN
                            [elements:protected] => Array
                                (
                                    [0] => #__users AS uam ON uam.id = a.modified_by
                                )

                            [glue:protected] => ,
                        )

                    [3] => JDatabaseQueryElement Object
                        (
                            [name:protected] => LEFT JOIN
                            [elements:protected] => Array
                                (
                                    [0] => #__categories as parent ON parent.id = c.parent_id
                                )

                            [glue:protected] => ,
                        )

                    [4] => JDatabaseQueryElement Object
                        (
                            [name:protected] => LEFT JOIN
                            [elements:protected] => Array
                                (
                                    [0] => #__content_rating AS v ON a.id = v.content_id
                                )

                            [glue:protected] => ,
                        )

                    [5] => 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 != 1 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.access IN (1)
                            [1] => c.access IN (1)
                            [2] => CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
                            [3] => (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-02 20:44:44')
                            [4] => (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-02 20:44:44')
                            [5] => a.language in ('en-GB','*')
                        )

                    [glue:protected] =>  AND 
                )

            [group:protected] => 
            [having:protected] => 
            [columns:protected] => 
            [values:protected] => 
            [order:protected] => JDatabaseQueryElement Object
                (
                    [name:protected] => ORDER BY
                    [elements:protected] => Array
                        (
                            [0] => c.lft,  a.ordering,  a.created DESC  
                        )

                    [glue:protected] => ,
                )

            [union:protected] => 
            [autoIncrementField:protected] => 
        )

)
Array
(
    [filter.access] => 1
    [where_before] => 
)
Array
(
    [filter.access] => 1
    [where_after] => JDatabaseQueryElement Object
        (
            [name:protected] => WHERE
            [elements:protected] => Array
                (
                    [0] => a.access IN (1)
                    [1] => c.access IN (1)
                )

            [glue:protected] =>  AND 
        )

    [user] => JUser Object
        (
            [isRoot:protected] => 
            [id] => 0
            [name] => 
            [username] => 
            [email] => 
            [password] => 
            [password_clear] => 
            [usertype] => 
            [block] => 
            [sendEmail] => 0
            [registerDate] => 
            [lastvisitDate] => 
            [activation] => 
            [params] => 
            [groups] => Array
                (
                )

            [guest] => 1
            [lastResetTime] => 
            [resetCount] => 
            [_params:protected] => JRegistry Object
                (
                    [data:protected] => stdClass Object
                        (
                        )

                )

            [_authGroups:protected] => Array
                (
                    [0] => 1
                    [1] => 9
                )

            [_authLevels:protected] => Array
                (
                    [0] => 1
                    [1] => 1
                    [2] => 4
                )

            [_authActions:protected] => 
            [_errorMsg:protected] => 
            [_errors:protected] => Array
                (
                )

            [aid] => 0
        )

    [groups] => 1
    [group_levels] => Array
        (
            [1] => Array
                (
                    [1] => 1
                )

            [42] => Array
                (
                    [2] => 2
                )

            [6] => Array
                (
                    [2] => 2
                    [3] => 3
                )

            [2] => Array
                (
                    [2] => 2
                )

            [10] => Array
                (
                    [2] => 2
                    [7] => 7
                )

            [8] => Array
                (
                    [2] => 2
                    [3] => 3
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [3] => Array
                (
                    [3] => 3
                )

            [9] => Array
                (
                    [4] => 4
                )

            [19] => Array
                (
                    [5] => 5
                )

            [20] => Array
                (
                    [6] => 6
                )

            [11] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [12] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [15] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [18] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [17] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [13] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [12] => 12
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [14] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [16] => Array
                (
                    [7] => 7
                    [10] => 10
                    [11] => 11
                    [13] => 13
                    [15] => 15
                    [18] => 18
                    [19] => 19
                    [20] => 20
                    [21] => 21
                    [22] => 22
                )

            [22] => Array
                (
                    [9] => 9
                )

            [44] => Array
                (
                    [10] => 10
                )

            [23] => Array
                (
                    [10] => 10
                )

            [45] => Array
                (
                    [11] => 11
                )

            [24] => Array
                (
                    [11] => 11
                )

            [46] => Array
                (
                    [12] => 12
                )

            [25] => Array
                (
                    [12] => 12
                )

            [47] => Array
                (
                    [13] => 13
                )

            [26] => Array
                (
                    [13] => 13
                )

            [43] => Array
                (
                    [15] => 15
                )

            [27] => Array
                (
                    [15] => 15
                )

            [48] => Array
                (
                    [18] => 18
                )

            [49] => Array
                (
                    [19] => 19
                )

            [50] => Array
                (
                    [20] => 20
                )

            [51] => Array
                (
                    [21] => 21
                )

            [52] => Array
                (
                    [22] => 22
                )

        )

    [levels] => Array
        (
            [1] => 1
        )

)
Array
(
    [get_list_query] => JDatabaseQueryMySQL Object
        (
            [db:protected] => JDatabaseMySQL Object
                (
                    [name] => mysql
                    [nameQuote:protected] => `
                    [nullDate:protected] => 0000-00-00 00:00:00
                    [dbMinimum:protected] => 5.0.4
                    [_database:JDatabase:private] => u1369153_shkolaru
                    [connection:protected] => Resource id #30
                    [count:protected] => 0
                    [cursor:protected] => Resource id #195
                    [debug:protected] => 
                    [limit:protected] => 0
                    [log:protected] => Array
                        (
                        )

                    [offset:protected] => 0
                    [sql:protected] => select * from `#__viewlevels`
                    [tablePrefix:protected] => ygfnt_
                    [utf:protected] => 1
                    [errorNum:protected] => 0
                    [errorMsg:protected] => 
                    [hasQuoted:protected] => 
                    [quoted:protected] => Array
                        (
                        )

                )

            [type:protected] => select
            [element:protected] => 
            [select:protected] => JDatabaseQueryElement Object
                (
                    [name:protected] => SELECT
                    [elements:protected] => Array
                        (
                            [0] => a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore
                            [1] => CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state
                            [2] => c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias
                            [3] => CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
                            [4] => ua.email AS author_email
                            [5] => (
SELECT MAX(contact.id) AS id
FROM #__contact_details AS contact
WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('en-GB','*') OR contact.language IS NULL)) as contactid
                            [6] => parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
                            [7] => ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
                            [8] => c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
                        )

                    [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 ua ON ua.id = a.created_by
                                )

                            [glue:protected] => ,
                        )

                    [2] => JDatabaseQueryElement Object
                        (
                            [name:protected] => LEFT JOIN
                            [elements:protected] => Array
                                (
                                    [0] => #__users AS uam ON uam.id = a.modified_by
                                )

                            [glue:protected] => ,
                        )

                    [3] => JDatabaseQueryElement Object
                        (
                            [name:protected] => LEFT JOIN
                            [elements:protected] => Array
                                (
                                    [0] => #__categories as parent ON parent.id = c.parent_id
                                )

                            [glue:protected] => ,
                        )

                    [4] => JDatabaseQueryElement Object
                        (
                            [name:protected] => LEFT JOIN
                            [elements:protected] => Array
                                (
                                    [0] => #__content_rating AS v ON a.id = v.content_id
                                )

                            [glue:protected] => ,
                        )

                    [5] => 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 != 1 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.access IN (1)
                            [1] => c.access IN (1)
                            [2] => CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
                            [3] => (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-02 20:44:44')
                            [4] => (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-02 20:44:44')
                            [5] => a.language in ('en-GB','*')
                        )

                    [glue:protected] =>  AND 
                )

            [group:protected] => 
            [having:protected] => 
            [columns:protected] => 
            [values:protected] => 
            [order:protected] => JDatabaseQueryElement Object
                (
                    [name:protected] => ORDER BY
                    [elements:protected] => Array
                        (
                            [0] => c.lft,  a.ordering,  a.created DESC  
                        )

                    [glue:protected] => ,
                )

            [union:protected] => 
            [autoIncrementField:protected] => 
        )

)