×

sportsmanagementModelPredictionResults::getData 192 query
JDatabaseQueryMysqli Object
(
    [offset:protected] => 
    [limit:protected] => 
    [db:protected] => JDatabaseDriverMysqli Object
        (
            [name] => mysqli
            [serverType] => mysql
            [connection:protected] => mysqli Object
                (
                    [affected_rows] => 34
                    [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
                    [client_version] => 50011
                    [connect_errno] => 0
                    [connect_error] => 
                    [errno] => 0
                    [error] => 
                    [error_list] => Array
                        (
                        )

                    [field_count] => 2
                    [host_info] => Localhost via UNIX socket
                    [info] => 
                    [insert_id] => 0
                    [server_info] => 5.6.38-nmm1-log
                    [server_version] => 50638
                    [stat] => Uptime: 1576573  Threads: 7  Questions: 499395779  Slow queries: 167  Opens: 376759  Flush tables: 1  Open tables: 1024  Queries per second avg: 316.760
                    [sqlstate] => 00000
                    [protocol_version] => 10
                    [thread_id] => 34134445
                    [warning_count] => 0
                )

            [nameQuote:protected] => `
            [nullDate:protected] => 0000-00-00 00:00:00
            [_database:JDatabaseDriver:private] => d00b716f
            [count:protected] => 23
            [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] => d00b716f
                    [password] => dp190460
                    [database] => d00b716f
                    [prefix] => j25_
                    [select] => 1
                    [port] => 3306
                    [socket] => 
                )

            [sql:protected] => JDatabaseQueryMysqli Object
                (
                    [offset:protected] => 0
                    [limit:protected] => 0
                    [db:protected] => JDatabaseDriverMysqli Object
 *RECURSION*
                    [sql:protected] => 
                    [type:protected] => select
                    [element:protected] => 
                    [select:protected] => JDatabaseQueryElement Object
                        (
                            [name:protected] => SELECT
                            [elements:protected] => Array
                                (
                                    [0] => CONCAT_WS(':',id,alias) AS value
                                    [1] => name AS text
                                )

                            [glue:protected] => ,
                        )

                    [delete:protected] => 
                    [update:protected] => 
                    [insert:protected] => 
                    [from:protected] => JDatabaseQueryElement Object
                        (
                            [name:protected] => FROM
                            [elements:protected] => Array
                                (
                                    [0] => #__sportsmanagement_round
                                )

                            [glue:protected] => ,
                        )

                    [join:protected] => 
                    [set:protected] => 
                    [where:protected] => JDatabaseQueryElement Object
                        (
                            [name:protected] => WHERE
                            [elements:protected] => Array
                                (
                                    [0] => project_id = 4
                                )

                            [glue:protected] =>  AND 
                        )

                    [group:protected] => 
                    [having:protected] => 
                    [columns:protected] => 
                    [values:protected] => 
                    [order:protected] => JDatabaseQueryElement Object
                        (
                            [name:protected] => ORDER BY
                            [elements:protected] => Array
                                (
                                    [0] => id ASC
                                )

                            [glue:protected] => ,
                        )

                    [autoIncrementField:protected] => 
                    [call:protected] => 
                    [exec:protected] => 
                    [union:protected] => 
                    [unionAll:protected] => 
                    [selectRowNumber:protected] => 
                )

            [tablePrefix:protected] => j25_
            [utf:protected] => 1
            [utf8mb4: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] => pm.id AS pmID,pm.user_id AS user_id,pm.picture AS avatar,pm.show_profile AS show_profile,pm.champ_tipp AS champ_tipp,pm.aliasName as aliasName
                    [1] => u.name AS name
                    [2] => pg.id as pg_group_id,pg.name as pg_group_name
                )

            [glue:protected] => ,
        )

    [delete:protected] => 
    [update:protected] => 
    [insert:protected] => 
    [from:protected] => JDatabaseQueryElement Object
        (
            [name:protected] => FROM
            [elements:protected] => Array
                (
                    [0] => #__sportsmanagement_prediction_member AS pm
                )

            [glue:protected] => ,
        )

    [join:protected] => Array
        (
            [0] => JDatabaseQueryElement Object
                (
                    [name:protected] => INNER JOIN
                    [elements:protected] => Array
                        (
                            [0] => #__users AS u ON u.id = pm.user_id
                        )

                    [glue:protected] => ,
                )

            [1] => JDatabaseQueryElement Object
                (
                    [name:protected] => LEFT JOIN
                    [elements:protected] => Array
                        (
                            [0] => #__sportsmanagement_prediction_groups as pg on pg.id = pm.group_id
                        )

                    [glue:protected] => ,
                )

        )

    [set:protected] => 
    [where:protected] => JDatabaseQueryElement Object
        (
            [name:protected] => WHERE
            [elements:protected] => Array
                (
                    [0] => pm.prediction_id = 4
                )

            [glue:protected] =>  AND 
        )

    [group:protected] => 
    [having:protected] => 
    [columns:protected] => 
    [values:protected] => 
    [order:protected] => JDatabaseQueryElement Object
        (
            [name:protected] => ORDER BY
            [elements:protected] => Array
                (
                    [0] => pm.id ASC
                )

            [glue:protected] => ,
        )

    [autoIncrementField:protected] => 
    [call:protected] => 
    [exec:protected] => 
    [union:protected] => 
    [unionAll:protected] => 
    [selectRowNumber:protected] => 
)
JSM - Tippspiel [ Test 2016/17 ] Tipps für ausgewähltes Tippspiel eingeben Mitgliedsseiten des ausgewählten Tippspiels anzeigen Ergebnisse des ausgewählten Tippspiels anzeigen Platzierungen des ausgewählten Tippspiels anzeigen Regeln des ausgewählten Tippspiels anzeigen

Tippspiel - Spieltag Ergebnisse


Runde   von    Gruppe  

Tippspielergebnisse für diese Runde des Projekts   Ergebnisse des Spieltages anzeigen

Platz Mitglied 1.FSV Mainz 1905 e.V. I 1. Fußball- un
0 : 1
FC Gelsenkirchen-Schalke 04 e.V. I Fußball Club G
Hertha Berliner Sport-Club Hertha Berliner
0 : 0
SC Freiburg Sport Club Frei
Hannoverscher SV 1896 e.V. I Hannoverscher S
1 : 3
Fussballclub Augsburg Fussballclub Au
FC Bayern München AG I Fußball-Club B
6 : 0
Hamburger SV e.V. Hamburger SV e.
TSG 1899 Hoffenheim e.V. TSG 1899 Hoffen
3 : 0
Verein für Leibesübungen Wolfsburg e.V. Verein für Lei
Bayer 04 Leverkusen Bayer 04 Leverk
2 : 0
Borussia VfL 1900 Mönchengladbach e.V. I Borussia Verein
VfB Stuttgart e.V. I Verein für Bew
0 : 0
RasenBallsport Leipzig RasenBallsport
BV Borussia 1909 Dortmund e.V. I Ballspielverein
3 : 2
Sportgemeinde Eintracht Frankfurt Sportgemeinde E
SV Werder Bremen 1899 e. V. I Sport Verein We
3 : 1
1.FC Köln 1901/1907 e.V. I 1. Fußball-Clu
Punkte Ø
1 Günter Reinsch n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00
- Miguel Gonzales-Tounsi n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00
- Thomas n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00
- Dirk n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00
- bluesunny62 n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00
- didditest n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00
- sigal n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00
- diddipoeler Administrator n/vn/vn/vn/vn/vn/vn/vn/vn/v 0 0.00


Eine Komponente für alle Sportarten !
Copyright : © Fussball in Europa
JSM auf Facebook
Version : Version 1.0.63 (diddipoeler)