Web
            Analytics
PSV
53% PSV 1
Haugesund
47% Haugesund
  • Jue 15 Ago 20:30finalizado0
  • 0
Array
(
    [comments_lang] => 
    [date_server] => 2020-08-08 05:19:40
    [numc] => 147
    [comments] => Array
        (
            [0] => Array
                (
                    [id] => 26431744
                    [user_id] => 637136
                    [user_name] => eyesharingan
                    [comment] => Cuidado con el Psv esta temporada, parece que están mal, no poder ganar a este equipo de local, cuidado.
                    [creation_date] => 2019-08-16 05:55:46
                    [last_update] => 2019-08-16 05:55:46
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_20/637136/637136_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [1] => Array
                (
                    [id] => 26429161
                    [user_id] => 2401213
                    [user_name] => luis_6672623
                    [comment] => Jajajajaja perdedoreeees los que le apostaron al psv
                    [creation_date] => 2019-08-15 22:24:37
                    [last_update] => 2019-08-15 22:24:37
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_76/2401213/2401213_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [2] => Array
                (
                    [id] => 26429156
                    [user_id] => 2139640
                    [user_name] => eduardo_4534
                    [comment] => Final
                    [creation_date] => 2019-08-15 22:24:21
                    [last_update] => 2019-08-15 22:24:21
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_67/2139640/2139640_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [3] => Array
                (
                    [id] => 26429151
                    [user_id] => 2407335
                    [user_name] => jerry_287414
                    [comment] => este local no.sirve pa ni.m...a son un asco¡¡¡¡
                    [creation_date] => 2019-08-15 22:24:10
                    [last_update] => 2019-08-15 22:24:10
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_76/2407335/2407335_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [4] => Array
                (
                    [id] => 26429147
                    [user_id] => 2840861
                    [user_name] => moises_47196
                    [comment] => CTM psv
                    [creation_date] => 2019-08-15 22:23:53
                    [last_update] => 2019-08-15 22:23:53
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_89/2840861/2840861_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [5] => Array
                (
                    [id] => 26429142
                    [user_id] => 2401213
                    [user_name] => luis_6672623
                    [comment] => Al 93 dije yo
                    [creation_date] => 2019-08-15 22:23:38
                    [last_update] => 2019-08-15 22:23:38
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_76/2401213/2401213_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [6] => Array
                (
                    [id] => 26429119
                    [user_id] => 1571450
                    [user_name] => nano1983
                    [comment] => De quien de quien
                    [creation_date] => 2019-08-15 22:22:31
                    [last_update] => 2019-08-15 22:23:24
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_50/1571450/1571450_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 26429137
                                    [user_id] => 2743071
                                    [user_name] => toquedegracia
                                    [lang] => es
                                    [comment] => Mio
                                    [creation_date] => 2019-08-15 22:23:24
                                    [last_update] => 2019-08-15 22:23:24
                                    [comment_id] => 26429119
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_86/2743071/2743071_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 1
                )

            [7] => Array
                (
                    [id] => 26429080
                    [user_id] => 2848702
                    [user_name] => deskartex
                    [comment] => Gooooolllll
                    [creation_date] => 2019-08-15 22:19:49
                    [last_update] => 2019-08-15 22:23:03
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_90/2848702/2848702_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 26429131
                                    [user_id] => 2743071
                                    [user_name] => toquedegracia
                                    [lang] => es
                                    [comment] => Jajajaj Jonathan
                                    [creation_date] => 2019-08-15 22:23:03
                                    [last_update] => 2019-08-15 22:23:03
                                    [comment_id] => 26429080
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_86/2743071/2743071_gallery.jpg?size=80x&rand=
                                )

                            [1] => Array
                                (
                                    [id] => 26429125
                                    [user_id] => 2848702
                                    [user_name] => deskartex
                                    [lang] => es
                                    [comment] => Lo anularon a n i m al
                                    [creation_date] => 2019-08-15 22:22:50
                                    [last_update] => 2019-08-15 22:22:50
                                    [comment_id] => 26429080
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_90/2848702/2848702_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 3
                )

            [8] => Array
                (
                    [id] => 26429113
                    [user_id] => 1733173
                    [user_name] => cristopher_e
                    [comment] => Goooooooooooooooooool
                    [creation_date] => 2019-08-15 22:22:05
                    [last_update] => 2019-08-15 22:22:52
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_55/1733173/1733173_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 26429126
                                    [user_id] => 2743071
                                    [user_name] => toquedegracia
                                    [lang] => es
                                    [comment] => Que guay eres crack
                                    [creation_date] => 2019-08-15 22:22:52
                                    [last_update] => 2019-08-15 22:22:52
                                    [comment_id] => 26429113
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_86/2743071/2743071_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 1
                )

            [9] => Array
                (
                    [id] => 26429124
                    [user_id] => 2606560
                    [user_name] => daniel_38222
                    [comment] => Un equipo menos para seguir
                    [creation_date] => 2019-08-15 22:22:50
                    [last_update] => 2019-08-15 22:22:50
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_82/2606560/2606560_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [10] => Array
                (
                    [id] => 26429118
                    [user_id] => 2845136
                    [user_name] => null_2885734
                    [comment] => Una verdadera estafa
                    [creation_date] => 2019-08-15 22:22:25
                    [last_update] => 2019-08-15 22:22:25
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_89/2845136/2845136_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [11] => Array
                (
                    [id] => 26429116
                    [user_id] => 1571450
                    [user_name] => nano1983
                    [comment] => Jajaja
                    [creation_date] => 2019-08-15 22:22:21
                    [last_update] => 2019-08-15 22:22:21
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_50/1571450/1571450_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [12] => Array
                (
                    [id] => 26429108
                    [user_id] => 2274703
                    [user_name] => matias_73431
                    [comment] => Mentiroso ctm
                    [creation_date] => 2019-08-15 22:21:53
                    [last_update] => 2019-08-15 22:21:53
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_72/2274703/2274703_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [13] => Array
                (
                    [id] => 26428935
                    [user_id] => 1853194
                    [user_name] => richi_618974
                    [comment] => Ahora si golllll de penalti holandeses
                    [creation_date] => 2019-08-15 22:08:19
                    [last_update] => 2019-08-15 22:21:13
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_58/1853194/1853194_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 26429067
                                    [user_id] => 2743071
                                    [user_name] => toquedegracia
                                    [lang] => es
                                    [comment] => Hay que reírse crack?
                                    [creation_date] => 2019-08-15 22:18:41
                                    [last_update] => 2019-08-15 22:18:41
                                    [comment_id] => 26428935
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_86/2743071/2743071_gallery.jpg?size=80x&rand=
                                )

                            [1] => Array
                                (
                                    [id] => 26428969
                                    [user_id] => 2898332
                                    [user_name] => joel_9528159
                                    [lang] => es
                                    [comment] => Calla pinche bocazo
                                    [creation_date] => 2019-08-15 22:12:07
                                    [last_update] => 2019-08-15 22:12:07
                                    [comment_id] => 26428935
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_91/2898332/2898332_gallery.jpg?size=80x&rand=
                                )

                            [2] => Array
                                (
                                    [id] => 26428955
                                    [user_id] => 2677968
                                    [user_name] => pollo_719761
                                    [lang] => es
                                    [comment] => Si es mentira.
                                    [creation_date] => 2019-08-15 22:10:52
                                    [last_update] => 2019-08-15 22:10:52
                                    [comment_id] => 26428935
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_84/2677968/2677968_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 5
                )

            [14] => Array
                (
                    [id] => 26429089
                    [user_id] => 2407335
                    [user_name] => jerry_287414
                    [comment] => son unas cagdas los locales¡¡¡
                    [creation_date] => 2019-08-15 22:20:36
                    [last_update] => 2019-08-15 22:20:36
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_76/2407335/2407335_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [15] => Array
                (
                    [id] => 26429088
                    [user_id] => 709031
                    [user_name] => cbartoloroja
                    [comment] => Anulado xD
                    [creation_date] => 2019-08-15 22:20:28
                    [last_update] => 2019-08-15 22:20:28
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_23/709031/709031_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [16] => Array
                (
                    [id] => 26429073
                    [user_id] => 2191918
                    [user_name] => maicol_36323
                    [comment] => Goooooolosinas
                    [creation_date] => 2019-08-15 22:19:09
                    [last_update] => 2019-08-15 22:19:09
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_69/2191918/2191918_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [17] => Array
                (
                    [id] => 26429003
                    [user_id] => 2407335
                    [user_name] => jerry_287414
                    [comment] => psv pechofrios son una reverenda m...a¡¡
                    [creation_date] => 2019-08-15 22:14:06
                    [last_update] => 2019-08-15 22:18:26
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_76/2407335/2407335_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 26429066
                                    [user_id] => 2743071
                                    [user_name] => toquedegracia
                                    [lang] => es
                                    [comment] => Tranki ludo
                                    [creation_date] => 2019-08-15 22:18:26
                                    [last_update] => 2019-08-15 22:18:26
                                    [comment_id] => 26429003
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_86/2743071/2743071_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 1
                )

            [18] => Array
                (
                    [id] => 26428962
                    [user_id] => 2910500
                    [user_name] => wilson_75883
                    [comment] => Gol gol gol gol local
                    [creation_date] => 2019-08-15 22:11:15
                    [last_update] => 2019-08-15 22:18:16
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_91/2910500/2910500_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 26429061
                                    [user_id] => 2743071
                                    [user_name] => toquedegracia
                                    [lang] => es
                                    [comment] => Hay que reírse o cómo lo quieres?
                                    [creation_date] => 2019-08-15 22:18:16
                                    [last_update] => 2019-08-15 22:18:16
                                    [comment_id] => 26428962
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_86/2743071/2743071_gallery.jpg?size=80x&rand=
                                )

                            [1] => Array
                                (
                                    [id] => 26429013
                                    [user_id] => 2613757
                                    [user_name] => hans_9284497
                                    [lang] => es
                                    [comment] => Mamwb0
                                    [creation_date] => 2019-08-15 22:14:51
                                    [last_update] => 2019-08-15 22:14:51
                                    [comment_id] => 26428962
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_82/2613757/2613757_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 3
                )

            [19] => Array
                (
                    [id] => 26429019
                    [user_id] => 655193
                    [user_name] => intek86
                    [comment] => Ese psv no aspira a nada este año
                    [creation_date] => 2019-08-15 22:15:03
                    [last_update] => 2019-08-15 22:17:50
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_21/655193/655193_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 26429056
                                    [user_id] => 2743071
                                    [user_name] => toquedegracia
                                    [lang] => es
                                    [comment] => A la ligueison
                                    [creation_date] => 2019-08-15 22:17:50
                                    [last_update] => 2019-08-15 22:17:50
                                    [comment_id] => 26429019
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_86/2743071/2743071_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 1
                )

        )

)
20
image description

eyesharingan dice

Cuidado con el Psv esta temporada, parece que están mal, no poder ganar a este equipo de local, cuidado.

Hace 11 meses
image description

luis_6672623 dice

Jajajajaja perdedoreeees los que le apostaron al psv

Hace 11 meses
image description

eduardo_4534 dice

Final

Hace 11 meses
image description

jerry_287414 dice

este local no.sirve pa ni.m...a son un asco¡¡¡¡

Hace 11 meses
image description

moises_47196 dice

CTM psv

Hace 11 meses
image description

luis_6672623 dice

Al 93 dije yo

Hace 11 meses
image description

nano1983 dice

De quien de quien

Hace 11 meses

Ver 1 respuestas

image description

toquedegracia dice

Mio

Hace 11 meses
image description

deskartex dice

Gooooolllll

Hace 11 meses

Ver 3 respuestas

image description

toquedegracia dice

Jajajaj Jonathan

Hace 11 meses
image description

deskartex dice

Lo anularon a n i m al

Hace 11 meses
image description

cristopher_e dice

Goooooooooooooooooool

Hace 11 meses

Ver 1 respuestas

image description

toquedegracia dice

Que guay eres crack

Hace 11 meses
image description

daniel_38222 dice

Un equipo menos para seguir

Hace 11 meses
image description

null_2885734 dice

Una verdadera estafa

Hace 11 meses
image description

nano1983 dice

Jajaja

Hace 11 meses
image description

matias_73431 dice

Mentiroso ctm

Hace 11 meses
image description

richi_618974 dice

Ahora si golllll de penalti holandeses

Hace 11 meses

Ver 5 respuestas

image description

toquedegracia dice

Hay que reírse crack?

Hace 11 meses
image description

joel_9528159 dice

Calla pinche bocazo

Hace 11 meses
image description

pollo_719761 dice

Si es mentira.

Hace 11 meses
image description

jerry_287414 dice

son unas cagdas los locales¡¡¡

Hace 11 meses
image description

cbartoloroja dice

Anulado xD

Hace 11 meses
image description

maicol_36323 dice

Goooooolosinas

Hace 11 meses
image description

jerry_287414 dice

psv pechofrios son una reverenda m...a¡¡

Hace 11 meses

Ver 1 respuestas

image description

toquedegracia dice

Tranki ludo

Hace 11 meses
image description

wilson_75883 dice

Gol gol gol gol local

Hace 11 meses

Ver 3 respuestas

image description

toquedegracia dice

Hay que reírse o cómo lo quieres?

Hace 11 meses
image description

hans_9284497 dice

Mamwb0

Hace 11 meses
image description

intek86 dice

Ese psv no aspira a nada este año

Hace 11 meses

Ver 1 respuestas

image description

toquedegracia dice

A la ligueison

Hace 11 meses
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso.
Aceptar Más información y cambio de configuración

  USO DE MEMORIA  
3,796,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Match / Index )  0.0986
Total Execution Time  0.1019
  CADENA URL  
/match/psv/haugesund/comments
  GET DATOS  
$_GET['/match/psv/haugesund/comments']  
$_GET['langf']  
$_GET['lang_comment']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0023   SELECT c.*, 2020 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.stadium, dt1.seats, dt1.size, dt1.yearBuilt,dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, s.team_id as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt FROM calendars2020 AS c INNER JOIN teams as t1 ON c.team1=t1.id INNER JOIN datateams AS dt1 ON t1.teamId=dt1.id INNER JOIN teams as t2 ON c.team2=t2.id INNER JOIN datateams AS dt2 ON t2.teamId=dt2.id LEFT JOIN stadiums AS s ON c.stadium=s.id WHERE c.extra != 1 AND dt1.basealias = 'psv' AND dt2.basealias = 'haugesund'
0.0004  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=141666 AND extraId = 50670 AND type_rel = 4